public ActionResult Save(shopDetails emp)
{
ViewBag.DisLst = TempData["dist"];
emp.distCode = Convert.ToInt32(TempData.Peek("distcode"));
emp.ShopType = TempData.Peek("shopType").ToString();
ViewBag.ShopTYPE = TempData.Peek("shopType").ToString();
TempData["TehsilCode"] = emp.TehsilCodeCensus;
emp.ShopNameE = emp.ShopNameE.ToUpper();
bool status = false;
if (ModelState.IsValid)
{
if (Convert.ToInt32(emp.ShopID) > 0)
{
objShop.UpdateShop(emp);
}
else
{
objShop.SaveShop(emp);
}
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public bool DeleteShop(shopDetails obj)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
try
{
SqlCommand cmd = new SqlCommand("ProcShopList", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SpType", 7);
cmd.Parameters.AddWithValue("@Shopid", obj.ShopID);
con.Open();
//cmd.ExecuteNonQuery(); //Close
return(true);
}
catch (Exception ex)
{
throw;
}
finally
{
con.Close();
}
}
}
//public ActionResult GetShops()
//{
// shopDetails obj = new shopDetails();
// obj.distCode = 0;
// //IEnumerable<shopDetails> products = objShop.ShopList(obj, UserSession.LoggedInUserDistictId.ToString());
// IEnumerable<shopDetails> products = objShop.ShopList(obj, "163");
// var Shop = products.OrderBy(a => a.ShopNameH).ToList();
// return Json(new { data = Shop }, JsonRequestBehavior.AllowGet);
//}
public JsonResult GetShops()
{
shopDetails obj = new shopDetails();
obj.distCode = Convert.ToInt32(TempData.Peek("distcode"));
obj.ShopType = Convert.ToString(TempData.Peek("shopType"));
//IEnumerable<shopDetails> products = objShop.ShopList(obj, UserSession.LoggedInUserDistictId.ToString());
IEnumerable <shopDetails> products = objShop.ShopList(obj, "163");
ViewBag.GetTehsilName = objShop.GetTehsilNameByDistrict(obj);
ViewBag.GetThanaName = objShop.GetThanaNameByDistrict(obj);
var Shop = products.OrderBy(a => a.ShopNameH).ToList();
return(Json(new { data = Shop }, JsonRequestBehavior.AllowGet));
}
public ActionResult Save(int id)
{
shopDetails obj = new shopDetails();
obj.distCode = Convert.ToInt32(TempData.Peek("distcode"));
obj.ShopType = Convert.ToString(TempData.Peek("shopType"));
ViewBag.distName = TempData.Peek("distName").ToString();
ViewBag.shopName = TempData.Peek("shopName").ToString();
ViewBag.GetTehsilName = objShop.GetTehsilNameByDistrict(obj);
ViewBag.GetThanaName = objShop.GetThanaNameByDistrict(obj);
ViewBag.ShopTYPE = TempData.Peek("shopType").ToString();
//var Shop = objShop.ShopList(obj, UserSession.LoggedInUserDistictId.ToString()).Where(a => Convert.ToInt32(a.ShopID) == id).FirstOrDefault();
var Shop = objShop.ShopList(obj, "163").Where(a => Convert.ToInt32(a.ShopID) == id).FirstOrDefault();
return(View(Shop));
}
