public StoreProduct Get(int nStoreID, int nProductID, int nUserID)
{
Connection.Open();
Command.CommandText = StoreProductDA.Get(nStoreID, nProductID, nUserID);
SqlDataReader reader = Command.ExecuteReader();
StoreProduct _oStoreProduct = new StoreProduct();
if (reader.HasRows)
{
_oStoreProduct = MakeObject(reader);
}
reader.Close();
Connection.Close();
return(_oStoreProduct);
}
public List <StoreProduct> GetsByStoreID(int nStoreID, int nUserID)
{
Connection.Open();
Command.CommandText = StoreProductDA.GetsByStoreID(nStoreID, nUserID);
SqlDataReader reader = Command.ExecuteReader();
StoreProduct _oStoreProduct = new StoreProduct();
List <StoreProduct> _oStoreProducts = new List <StoreProduct>();
if (reader.HasRows)
{
_oStoreProducts = MakeObjects(reader);
}
reader.Close();
Connection.Close();
return(_oStoreProducts);
}
public string Delete(StoreProduct oStoreProduct, int nUserID)
{
string sReturnMessage = "";
Connection.Open();
Command.CommandText = StoreProductDA.IUD(oStoreProduct, EnumDBOperation.Delete, nUserID);
try
{
Command.ExecuteNonQuery();
}
catch (Exception e)
{
sReturnMessage = e.Message.Split('~')[0];
}
Connection.Close();
return(sReturnMessage);
}
public StoreProduct SellProduct(StoreProduct oStoreProduct, int nUserID)
{
Connection.Open();
if (oStoreProduct.StoreProductID > 0)
{
Command.CommandText = StoreProductDA.IUD(oStoreProduct, EnumDBOperation.Custom_1, nUserID);
}
SqlDataReader reader = Command.ExecuteReader();
StoreProduct _oStoreProduct = new StoreProduct();
if (reader.HasRows)
{
_oStoreProduct = MakeObject(reader);
}
reader.Close();
Connection.Close();
return(_oStoreProduct);
}
