protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
PRODUCT_CATEGORY theEntity = (PRODUCT_CATEGORY)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCTCATEGORY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_CATEGORY", theEntity.PRODUCTCATEGORY));
}
if (!string.IsNullOrEmpty(theEntity.REMARKS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REMARKS", theEntity.REMARKS));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_CATEGORY_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_CATEGORY_CODE", theEntity.PRODUCT_CATEGORY_CODE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
public IHttpActionResult AddProduct(AddProductViewModel p)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
PRODUCT pro = new PRODUCT();
pro.MODEL = p.Name;
pro.MANUFACTURE_ID = (int)getIdMan(p.NSX, data);
pro.PRICE = p.Price;
pro.QUANTITY = 100;
pro.MODEL_ID = "MSP_01";
pro.DELETED = 0;
data.PRODUCTs.Add(pro);
data.SaveChanges();
PRODUCT_CATEGORY pc = new PRODUCT_CATEGORY();
PRODUCT newPro = data.PRODUCTs.ToList()[data.PRODUCTs.Count() - 1];
pc.PRODUCT_ID = newPro.PRODUCT_ID;
pc.CATEGORY_ID = getIdCat(p.Category, data);
data.PRODUCT_CATEGORY.Add(pc);
data.SaveChanges();
}
return(Ok());
}
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr)
{
PRODUCT_CATEGORY theEntity = new PRODUCT_CATEGORY();
theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty;
theEntity.PRODUCTCATEGORY = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty;
theEntity.REMARKS = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty;
theEntity.PRODUCT_CATEGORY_CODE = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty;
return(theEntity);
}
public IHttpActionResult EditProduct(int id, string name, string cat, string man, double price)
{
using (MobileStoreServiceEntities data = new MobileStoreServiceEntities())
{
PRODUCT pro = data.PRODUCTs.FirstOrDefault(p => p.PRODUCT_ID == id);
pro.MODEL = name;
pro.MANUFACTURE_ID = (int)getIdMan(man, data);
pro.PRICE = price;
int idCat = getIdCat(cat, data);
PRODUCT_CATEGORY pcd = data.PRODUCT_CATEGORY.FirstOrDefault(pcds => pcds.PRODUCT_ID == id);
data.PRODUCT_CATEGORY.Remove(pcd);
PRODUCT_CATEGORY pc = new PRODUCT_CATEGORY();
pc.PRODUCT_ID = id;
pc.CATEGORY_ID = idCat;
data.PRODUCT_CATEGORY.Add(pc);
data.SaveChanges();
}
return(Ok());
}
