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