public static Entity.Inventory.StoreMaster GetById(int brandId) { Entity.Inventory.StoreMaster StoreMaster = new Entity.Inventory.StoreMaster(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Parameters.AddWithValue("@StoreId", brandId); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Inventory_StoreMaster_GetById"; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr.HasRows) { StoreMaster.StoreId = brandId; StoreMaster.StoreName = dr["StoreName"].ToString(); StoreMaster.Location = dr["Location"].ToString(); StoreMaster.Phone = dr["Phone"].ToString(); StoreMaster.ContactPerson = Convert.ToInt32(dr["ContactPerson"].ToString()); StoreMaster.IsActive = Convert.ToBoolean(dr["IsActive"].ToString()); } } con.Close(); return(StoreMaster); } } }
public static int Save(Entity.Inventory.StoreMaster storeMaster) { int rowsAffacted = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_Inventory_StoreMaster_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@StoreId", storeMaster.StoreId); cmd.Parameters.AddWithValue("@StoreName", storeMaster.StoreName); cmd.Parameters.AddWithValue("@ContactPerson", storeMaster.ContactPerson); cmd.Parameters.AddWithValue("@Location", storeMaster.Location); cmd.Parameters.AddWithValue("@Phone", storeMaster.Phone); cmd.Parameters.AddWithValue("@IsActive", storeMaster.IsActive); if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted = cmd.ExecuteNonQuery(); con.Close(); } } return(rowsAffacted); }
protected void gvStoreList_RowCommand(object sender, GridViewCommandEventArgs e) { try { Business.Inventory.StoreMaster objStoreMaster = new Business.Inventory.StoreMaster(); Entity.Inventory.StoreMaster storeMaster = new Entity.Inventory.StoreMaster(); if (e.CommandName == "Ed") { int storeId = int.Parse(e.CommandArgument.ToString()); storeMaster = objStoreMaster.GetById(storeId); StoreId = storeMaster.StoreId; txtLocation.Text = storeMaster.Location; txtPhone.Text = storeMaster.Phone; txtStoreName.Text = storeMaster.StoreName; ddlContactPerson.SelectedValue = storeMaster.ContactPerson.ToString(); } else if (e.CommandName == "Del") { int storeId = int.Parse(e.CommandArgument.ToString()); int response = objStoreMaster.Delete(storeId); if (response > 0) { ClearControls(); LoadStore(); Message.IsSuccess = true; Message.Text = "Store deleted successfully..."; } else { Message.IsSuccess = false; Message.Text = "Can not delete!!!"; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
protected void btnSave_Click(object sender, EventArgs e) { try { Business.Inventory.StoreMaster objStoreMaster = new Business.Inventory.StoreMaster(); Entity.Inventory.StoreMaster storeMaster = new Entity.Inventory.StoreMaster(); storeMaster.StoreId = StoreId; storeMaster.StoreName = txtStoreName.Text; storeMaster.Location = txtLocation.Text; storeMaster.Phone = txtPhone.Text; storeMaster.ContactPerson = Convert.ToInt32(ddlContactPerson.SelectedValue); storeMaster.IsActive = true; int response = objStoreMaster.Save(storeMaster); if (response > 0) { ClearControls(); LoadStore(); Message.IsSuccess = true; Message.Text = "Store saved successfully..."; } else { Message.IsSuccess = false; Message.Text = "Can not save!!!"; } Message.Show = true; } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public int Save(Entity.Inventory.StoreMaster storeMaster) { return(DataAccess.Inventory.StoreMaster.Save(storeMaster)); }