C# Class Connectster.Server.Database.ConnectsterDatabase

Show file Open project: shopster/NconnectSter Class Usage Examples

Public Methods

Method	Description
ConnectsterDatabase ( ) : System
CreateProductMapping ( int shopsterProductId, int shopifyProductId ) : bool
DeleteConnectsterProductMapping ( int shopsterId, int shopifyId ) : bool
InsertProductForUser ( ConnectsterUser user, InventoryItemType shopsterProduct, ShopifyProduct shopifyProduct ) : bool
InsertProductForUser ( ConnectsterUser user, int shopsterItemId, System.DateTime shopsterVersionDate, int shopifyItemId, System.DateTime shopifyVersionDate ) : bool
SelectAllUsers ( ) : List
SelectConnectsterUser ( ApiContext apiContext, ShopifyStoreAuth shopifyAuth ) : ConnectsterUser
SelectProductForUser ( ConnectsterUser user ) : List
SelectProductForUser ( int shopsterUser, string shopifyUser ) : List	Retrieves all ConnectsterProducts for a user.
SelectShopifyUserDetails ( ConnectsterUser user ) : ShopifyStoreAuth
SelectShopsterUserDetails ( ConnectsterUser user ) : ShopsterUser
UpdateConnectsterUsers ( List userList, System.DateTime newTime ) : int
UpdateShopsterProductTimeStamp ( InventoryItemType shopsterItem, System.DateTime timestamp ) : bool

Private Methods

Method	Description
CreateOrderMapping ( ConnectsterUser user, ShopifyOrder shopifyOrder, int shopsterOrderId ) : bool	Create and order mapping, also updates on duplicate keys.
SelectOrderMappingsForUser ( ConnectsterUser user ) : int>.Dictionary	Gets a dictionary of ordermappings for this connectster user from the database.
UpdateShopifyProductTimeStamp ( ShopifyProduct item, System.DateTime timestamp ) : bool
UpdateShopsterProductTimeStamps ( List shopsterList, System.DateTime dateTime ) : void	Calls UpdateShopsterProductTimeStamp for each item in given list.

Method Details

ConnectsterDatabase() public method

public ConnectsterDatabase ( ) : System
return	System

CreateProductMapping() public method

public CreateProductMapping ( int shopsterProductId, int shopifyProductId ) : bool
shopsterProductId	int
shopifyProductId	int
return	bool

DeleteConnectsterProductMapping() public method

public DeleteConnectsterProductMapping ( int shopsterId, int shopifyId ) : bool
shopsterId	int
shopifyId	int
return	bool

InsertProductForUser() public method

public InsertProductForUser ( ConnectsterUser user, InventoryItemType shopsterProduct, ShopifyProduct shopifyProduct ) : bool
user	ConnectsterUser
shopsterProduct	InventoryItemType
shopifyProduct	Connectster.Shopify.ShopifyProduct
return	bool

InsertProductForUser() public method

public InsertProductForUser ( ConnectsterUser user, int shopsterItemId, System.DateTime shopsterVersionDate, int shopifyItemId, System.DateTime shopifyVersionDate ) : bool
user	ConnectsterUser
shopsterItemId	int
shopsterVersionDate	System.DateTime
shopifyItemId	int
shopifyVersionDate	System.DateTime
return	bool

SelectAllUsers() public method

public SelectAllUsers ( ) : List
return	List

SelectConnectsterUser() public method

public SelectConnectsterUser ( ApiContext apiContext, ShopifyStoreAuth shopifyAuth ) : ConnectsterUser
apiContext	ApiContext
shopifyAuth	Connectster.Shopify.ShopifyStoreAuth
return	ConnectsterUser

SelectProductForUser() public method

public SelectProductForUser ( ConnectsterUser user ) : List
user	ConnectsterUser
return	List

SelectProductForUser() public method

Retrieves all ConnectsterProducts for a user.

public SelectProductForUser ( int shopsterUser, string shopifyUser ) : List
shopsterUser	int
shopifyUser	string
return	List

SelectShopifyUserDetails() public method

public SelectShopifyUserDetails ( ConnectsterUser user ) : ShopifyStoreAuth
user	ConnectsterUser
return	Connectster.Shopify.ShopifyStoreAuth

SelectShopsterUserDetails() public method

public SelectShopsterUserDetails ( ConnectsterUser user ) : ShopsterUser
user	ConnectsterUser
return	Connectster.Shopster.ShopsterUser

UpdateConnectsterUsers() public method

public UpdateConnectsterUsers ( List userList, System.DateTime newTime ) : int
userList	List
newTime	System.DateTime
return	int

UpdateShopsterProductTimeStamp() public method

public UpdateShopsterProductTimeStamp ( InventoryItemType shopsterItem, System.DateTime timestamp ) : bool
shopsterItem	InventoryItemType
timestamp	System.DateTime
return	bool