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;
}
}
