public string ShopPriority_Select(Shop_ItemNamePriorityModel shopModel)
{
BaseDL bdl = new BaseDL();
shopModel.Sqlprms = new SqlParameter[1];
shopModel.Sqlprms[0] = new SqlParameter("@ShopID", SqlDbType.VarChar)
{
Value = shopModel.ShopID
};
return(bdl.SelectJson("ShopPriority_Select", shopModel.Sqlprms));
}
public ActionResult Shop_ItemNamePriorityEntry(Shop_ItemNamePriorityModel shopitmNamePriModel)
{
Shop_itemPriorityBL bl = new Shop_itemPriorityBL();
if (string.IsNullOrEmpty(shopitmNamePriModel.ShopID))
{
shopitmNamePriModel = new Shop_ItemNamePriorityModel();
}
shopitmNamePriModel = bl.ShopPriorityModel_Select(shopitmNamePriModel);
return(View(shopitmNamePriModel));
}
public string ShopItemNamePriority_Update(Shop_ItemNamePriorityModel model)
{
BaseDL bdl = new BaseDL();
model.Sqlprms = new SqlParameter[3];
model.Sqlprms[0] = new SqlParameter("@ShopID", SqlDbType.VarChar)
{
Value = model.ShopID
};
model.Sqlprms[1] = new SqlParameter("@PriorityValue", SqlDbType.VarChar)
{
Value = model.PriorityValue
};
model.Sqlprms[2] = new SqlParameter("@PriorityValueID", SqlDbType.VarChar)
{
Value = model.PriorityValueID
};
return(bdl.InsertUpdateDeleteData("ShopItemNamePriority_Update", model.Sqlprms));
}
public Shop_ItemNamePriorityModel ShopPriorityModel_Select(Shop_ItemNamePriorityModel model)
{
BaseDL bdl = new BaseDL();
model.Sqlprms = new SqlParameter[1];
model.Sqlprms[0] = new SqlParameter("@ShopID", SqlDbType.VarChar)
{
Value = model.ShopID
};
DataTable dt = bdl.SelectDatatable("ShopPriority_Select", model.Sqlprms);
foreach (DataRow dr in dt.Rows)
{
model.ShopID = dr["ShopID"].ToString();
model.ShopName = dr["ShopName"].ToString();
model.PriorityValue = dr["PriorityValue"].ToString();
model.PriorityValueID = dr["PriorityValueID"].ToString();
model.MallID = dr["MallID"].ToString();
}
return(model);
}
public string ShopPriority_Select(Shop_ItemNamePriorityModel shopModel)
{
BaseDL bdl = new BaseDL();
return(bdl.SelectJson("ShopPriority_Select", null));
}
public IHttpActionResult ShopItemNamePriority_Save([FromBody] Shop_ItemNamePriorityModel model)
{
Shop_itemPriorityBL bl = new Shop_itemPriorityBL();
return(Ok(bl.ShopItemNamePriority_Update(model)));
}
public IHttpActionResult ShopPriority_Select([FromBody] Shop_ItemNamePriorityModel shopModel)
{
Shop_itemPriorityBL pp = new Shop_itemPriorityBL();
return(Ok(pp.ShopPriority_Select(shopModel)));
}
