public string SaveShop(Models.shopDetails emp) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { var para = new DynamicParameters(); para.Add("@SpType", 4); para.Add("@ShopNameE", emp.ShopNameE); para.Add("@ShopNameH", emp.ShopNameH); para.Add("@distcode", emp.distCode); para.Add("@shopType", emp.ShopType); para.Add("@ThanaCode", emp.Tcode); para.Add("@TehsilCode", emp.TehsilCodeCensus); para.Add("@Circle", emp.CircleType); para.Add("@Sector", emp.SectorType); para.Add("@Location", emp.AreaType); para.Add("@MGQ_BL", emp.MGQ_Basic_Fees); // para.AdTehsilCoded("@ShopAddress", emp.ShopAddress); try { return(con.Query <Models.shopDetails>("ProcShopList", para, null, true, 0, commandType: CommandType.StoredProcedure).ToString()); } catch (Exception ex) { throw; } } }
public IEnumerable <Models.shopDetails> ShopList(Models.shopDetails emp, string districtCode) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { var para = new DynamicParameters(); para.Add("@SpType", 1); para.Add("@distcode", districtCode); para.Add("@shopType", emp.ShopType); try { return(con.Query <Models.shopDetails>("ProcShopList", para, null, true, 0, commandType: CommandType.StoredProcedure)); } catch (Exception ex) { throw; } } }
public List <SelectListItem> GetThanaNameByDistrict(Models.shopDetails emp) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { DataTable objDt = new DataTable(); SqlCommand cmd = new SqlCommand("ProcShopList", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SpType", 6); cmd.Parameters.AddWithValue("@distcode", emp.distCode); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(objDt); if (objDt.Rows.Count > 0) { List <SelectListItem> objLst = new List <SelectListItem>(); SelectListItem Items; Items = new SelectListItem(); Items.Text = "--SELECT--"; Items.Value = "0"; objLst.Add(Items); for (int i = 0; i < objDt.Rows.Count; i++) { Items = new SelectListItem(); Items.Text = objDt.Rows[i]["tnameHindi"].ToString(); Items.Value = objDt.Rows[i]["Tcode"].ToString(); objLst.Add(Items); } return(objLst); } else { List <SelectListItem> objLst = new List <SelectListItem>(); SelectListItem Items; Items = new SelectListItem(); Items.Text = "--None--"; Items.Value = "0"; objLst.Add(Items); return(objLst); } } }
public IEnumerable <Models.shopDetails> GetShopDetails(Models.shopDetails obj) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { var para = new DynamicParameters(); para.Add("@SpType", 1); para.Add("@DisttCode", obj.distCode); para.Add("@shopType", obj.ShopType); para.Add("@ThanaCode", obj.Tcode); para.Add("@TehsilCode", obj.TehsilCodeCensus); para.Add("@CircleType", obj.CircleType); para.Add("@SectorType", obj.SectorType); para.Add("@AreaType", obj.AreaType); try { return(con.Query <Models.shopDetails>("proc_displayShopToPublic", para, null, true, 0, commandType: CommandType.StoredProcedure)); } catch (Exception ex) { throw; } } }