public List <StoreLocationMapping> EditStoreLocationMapping(int slmappingid)
{
List <StoreLocationMapping> StoreLocationMappingli = new List <StoreLocationMapping>();
using (SqlConnection con = new SqlConnection(connection()))
{
using (SqlCommand cmd = new SqlCommand("Prc_EditStoreLocationMapping", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@slmappingid", slmappingid);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StoreLocationMapping storelocationmapping = new StoreLocationMapping();
storelocationmapping.ID = Convert.ToInt32(dr["STORE_LOCATION_ID"].ToString());
storelocationmapping.storeid = Convert.ToInt32(dr["STORE_ID"].ToString());
storelocationmapping.locationid = Convert.ToInt32(dr["LOCATION_ID"].ToString());
storelocationmapping.bunameid = Convert.ToInt32(dr["BU_ID"].ToString());
storelocationmapping.radius = Convert.ToDouble(dr["RADIUS"].ToString());
storelocationmapping.storelatitude = Convert.ToDouble(dr["LATITUDE"].ToString());
storelocationmapping.storelongitude = Convert.ToDouble(dr["LONGITUDE"].ToString());
storelocationmapping.status = dr["STATUS"].ToString();
StoreLocationMappingli.Add(storelocationmapping);
}
con.Close();
}
}
return(StoreLocationMappingli);
}
public List <StoreLocationMapping> GetStoreLocationMapping()
{
List <StoreLocationMapping> StoreLocationMappingli = new List <StoreLocationMapping>();
using (SqlConnection con = new SqlConnection(connection()))
{
using (SqlCommand cmd = new SqlCommand("Prc_StoreLocationMappingList", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StoreLocationMapping storelocationmapping = new StoreLocationMapping();
storelocationmapping.ID = Convert.ToInt32(dr["STORE_LOCATION_ID"].ToString());
storelocationmapping.storename = dr["storename"].ToString();
storelocationmapping.StoreLocation = dr["StoreLocation"].ToString();
storelocationmapping.BUName = dr["BUName"].ToString();
storelocationmapping.radius = Convert.ToDouble(dr["RADIUS"].ToString());
storelocationmapping.storelatitude = Convert.ToDouble(dr["LATITUDE"].ToString());
storelocationmapping.storelongitude = Convert.ToDouble(dr["LONGITUDE"].ToString());
storelocationmapping.status = dr["STATUS"].ToString();
StoreLocationMappingli.Add(storelocationmapping);
}
con.Close();
}
}
return(StoreLocationMappingli);
}
public string UpdateStoreLocationMapping(StoreLocationMapping slmapping, string Createdby)
{
string res = "";
try
{
using (SqlConnection con = new SqlConnection(connection()))
{
using (SqlCommand cmd = new SqlCommand("Prc_StoreLocationMapping", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@slmappingid", slmapping.ID);
cmd.Parameters.AddWithValue("@storeid", slmapping.storeid);
cmd.Parameters.AddWithValue("@locationid", slmapping.locationid);
cmd.Parameters.AddWithValue("@bunameid", slmapping.bunameid);
cmd.Parameters.AddWithValue("@storelatitude", slmapping.storelatitude);
cmd.Parameters.AddWithValue("@storelongitude", slmapping.storelongitude);
cmd.Parameters.AddWithValue("@radius", slmapping.radius);
cmd.Parameters.AddWithValue("@status", "");
cmd.Parameters.AddWithValue("@createdby", Createdby);
SqlParameter oblogin = new SqlParameter();
oblogin.ParameterName = "@message";
oblogin.SqlDbType = SqlDbType.NVarChar;
oblogin.Size = 50;
oblogin.Direction = ParameterDirection.Output;
cmd.Parameters.Add(oblogin);
con.Open();
cmd.ExecuteNonQuery();
res = Convert.ToString(oblogin.Value);
con.Close();
}
}
return(res);
}
catch (Exception ex)
{
return(ex.Message);
}
}
