protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Business.Inventory.BrandMaster objBrandMaster = new Business.Inventory.BrandMaster();
Entity.Inventory.BrandMaster brandMaster = new Entity.Inventory.BrandMaster();
brandMaster.BrandId = BrandId;
brandMaster.BrandName = txtBrandName.Text;
int i = objBrandMaster.Save(brandMaster);
if (i > 0)
{
ClearControls();
LoadBrand();
Message.IsSuccess = true;
Message.Text = "Brand 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 static Entity.Inventory.BrandMaster GetById(int brandId)
{
Entity.Inventory.BrandMaster brandMaster = new Entity.Inventory.BrandMaster();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.AddWithValue("@BrandId", brandId);
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Inventory_Brand_GetById";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr.HasRows)
{
brandMaster.BrandId = brandId;
brandMaster.BrandName = dr["BrandName"].ToString();
}
}
con.Close();
return(brandMaster);
}
}
}
public static int Save(Entity.Inventory.BrandMaster brandMaster)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Inventory_Brand_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BrandId", brandMaster.BrandId);
cmd.Parameters.AddWithValue("@BrandName", brandMaster.BrandName);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
protected void gvBrand_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
Business.Inventory.BrandMaster objBrandMaster = new Business.Inventory.BrandMaster();
Entity.Inventory.BrandMaster brandMaster = new Entity.Inventory.BrandMaster();
if (e.CommandName == "Ed")
{
int brandId = int.Parse(e.CommandArgument.ToString());
brandMaster = objBrandMaster.GetById(brandId);
BrandId = brandMaster.BrandId;
txtBrandName.Text = brandMaster.BrandName;
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public int Save(Entity.Inventory.BrandMaster brandMaster)
{
return(DataAccess.Inventory.BrandMaster.Save(brandMaster));
}
