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