public IHttpActionResult GetShop() { var All = (from products in shop.Products select products).ToList(); List <PrdModel> PrdData = new List <PrdModel>(); foreach (var item in All) { PrdModel stDatas = new PrdModel(); stDatas.ID = item.ID; stDatas.Name = item.Name; stDatas.Images = item.Images; stDatas.Height = item.Height; stDatas.Weight = item.Weight; stDatas.Width = item.Width; stDatas.Depth = item.Depth; stDatas.Price = item.Price; stDatas.Quantity = item.Quantity; stDatas.Description = item.Description; Catagory query = (from products in shop.Catagories where products.ID == item.CategoryID select products).FirstOrDefault(); stDatas.cate_id = query.ID; stDatas.cate_name = query.Name; PrdData.Add(stDatas); } return(Ok(PrdData)); }
//2 protected override void OnInitialized() { try { Prd = _PrdBO.Obt(PrdId); } catch (Exception ex) { (Msg, MsgCls) = Util.Msg_Set(ex.Message, "alert-danger"); } }
public void Grd(PrdModel prd) { try { PrdDM.Prd_Grd(prd); } catch (Exception ex) { throw ex; } }
public PrdModel Obt(string prd) { try { PrdModel lxPrd = PrdDM.Prd_Obt(prd); return(lxPrd); } catch (Exception ex) { throw ex; } }
public async Task <int> Cre(PrdModel prd) { try { var lxRows = await PrdDM.Prd_Cre(prd); return(lxRows); } catch (Exception ex) { throw ex; } }
// 1 protected override void OnParametersSet() { EsEdt = !(PrdId == null || PrdId == ""); if (EsEdt) { PagTit = L["Edit Product"]; } else { PagTit = L["New Product"]; Prd = new PrdModel(); } }
public void Prd_Grd(PrdModel prd) { string lxQry = "UPDATE [Prd] " + " SET Dsc = @Dsc, St = @St, Prc = @Prc, Mon = @Mon " + " WHERE Prd = @Prd"; try { using (IDbConnection cnx = SqlCnx) { cnx.Open(); cnx.Query(lxQry, prd); } } catch (Exception ex) { throw ex; } }
public async Task <int> Prd_Cre(PrdModel prd) { string lxQry = "INSERT INTO [Prd] " + "(Prd, Dsc, St, Prc, Mon) " + "OUTPUT Inserted.Prd " + "VALUES " + "(@Prd, @Dsc, @St, @Prc, @Mon) "; try { using (IDbConnection cnx = SqlCnx) { cnx.Open(); var lxRtrnVal = await cnx.ExecuteAsync(lxQry, prd); return((int)lxRtrnVal); } } catch (Exception ex) { throw ex; } }