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