public static Entity.Inventory.SpareMaster GetById(int SpareMasterId)
{
Entity.Inventory.SpareMaster spareMaster = new Entity.Inventory.SpareMaster();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Inventory_SpareMaster_GetBySpareId";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SpareId", SpareMasterId);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
spareMaster.SpareId = SpareMasterId;
spareMaster.SpareName = (dr["SpareName"] == DBNull.Value) ? string.Empty : dr["SpareName"].ToString();
spareMaster.SpareType = (dr["SpareType"] == DBNull.Value) ? 0 : int.Parse(dr["SpareType"].ToString());
spareMaster.Description = (dr["Description"] == DBNull.Value) ? string.Empty : dr["Description"].ToString();
spareMaster.Yield = (dr["Yield"] == DBNull.Value) ? 0 : int.Parse(dr["Yield"].ToString());
spareMaster.isTonner = (dr["IsTonner"] == DBNull.Value) ? false : bool.Parse(dr["IsTonner"].ToString());
}
}
con.Close();
}
}
return(spareMaster);
}
public static DataTable GetAll(Entity.Inventory.SpareMaster spareMaster)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Inventory_SpareMaster_GetAll";
cmd.CommandType = CommandType.StoredProcedure;
if (spareMaster.SpareName == "")
{
cmd.Parameters.AddWithValue("@SpareName", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@SpareName", spareMaster.SpareName);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public static int Save(Entity.Inventory.SpareMaster spareMaster)
{
int i = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Inventory_SpareMaster_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SpareId", spareMaster.SpareId);
cmd.Parameters.AddWithValue("@SpareName", spareMaster.SpareName);
cmd.Parameters.AddWithValue("@SpareType", spareMaster.SpareType);
cmd.Parameters.AddWithValue("@Description", spareMaster.Description);
cmd.Parameters.AddWithValue("@Yield", spareMaster.Yield);
cmd.Parameters.AddWithValue("@IsTonner", spareMaster.isTonner);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
i = cmd.ExecuteNonQuery();
con.Close();
}
}
return(i);
}
private void PopulateSpare()
{
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
Entity.Inventory.SpareMaster spareMaster = new Entity.Inventory.SpareMaster();
spareMaster = objSpareMaster.GetById(SpareId);
txtSpareName.Text = spareMaster.SpareName;
txtYield.Text = Convert.ToString(spareMaster.Yield);
txtDescription.Text = spareMaster.Description;
chkIsTonner.Checked = spareMaster.isTonner;
}
private void LoadSpare()
{
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
Entity.Inventory.SpareMaster spareMaster = new Entity.Inventory.SpareMaster();
DataTable dt = objSpareMaster.GetAll(spareMaster);
if (dt != null)
{
gvSpare.DataSource = dt;
gvSpare.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
Entity.Inventory.SpareMaster spareMaster = new Entity.Inventory.SpareMaster();
spareMaster.SpareId = SpareId;
spareMaster.SpareName = txtSpareName.Text;
spareMaster.Yield = int.Parse(txtYield.Text);
spareMaster.Description = txtDescription.Text;
spareMaster.isTonner = chkIsTonner.Checked;
int i = objSpareMaster.Save(spareMaster);
if (i > 0)
{
ClearControls();
LoadSpare();
Message.IsSuccess = true;
Message.Text = "Spare saved successfully...";
}
else
{
Message.IsSuccess = false;
Message.Text = "Spare can not save!!!";
}
Message.Show = true;
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public DataTable GetAll(Entity.Inventory.SpareMaster spareMaster)
{
return(DataAccess.Inventory.SpareMaster.GetAll(spareMaster));
}
public int Save(Entity.Inventory.SpareMaster spareMaster)
{
return(DataAccess.Inventory.SpareMaster.Save(spareMaster));
}
