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