public Inv_Production GetInv_ProductionFromReader(IDataReader reader) { try { Inv_Production inv_Production = new Inv_Production ( (int)reader["Inv_ProductionID"], (DateTime)reader["ProductionDate"], reader["IssueIDs"].ToString(), (int)reader["WorkSatationID"], reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString(), reader["ExtraField4"].ToString(), reader["ExtraField5"].ToString(), (int)reader["AddedBy"], (DateTime)reader["AddedDate"], (int)reader["UpdatedBy"], (DateTime)reader["UpdatedDate"], (int)reader["RowStatusID"] ); return(inv_Production); } catch (Exception ex) { return(null); } }
protected void btnUpdate_Click(object sender, EventArgs e) { Inv_Production inv_Production = new Inv_Production(); inv_Production = Inv_ProductionManager.GetInv_ProductionByID(Int32.Parse(Request.QueryString["inv_ProductionID"])); Inv_Production tempInv_Production = new Inv_Production(); tempInv_Production.Inv_ProductionID = inv_Production.Inv_ProductionID; tempInv_Production.ProductionDate = txtProductionDate.Text; tempInv_Production.IssueIDs = Int32.Parse(ddlIssue.SelectedValue); tempInv_Production.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue); tempInv_Production.ExtraField1 = txtExtraField1.Text; tempInv_Production.ExtraField2 = txtExtraField2.Text; tempInv_Production.ExtraField3 = txtExtraField3.Text; tempInv_Production.ExtraField4 = txtExtraField4.Text; tempInv_Production.ExtraField5 = txtExtraField5.Text; tempInv_Production.AddedBy = Int32.Parse(txtAddedBy.Text); tempInv_Production.AddedDate = DateTime.Now; tempInv_Production.UpdatedBy = Int32.Parse(txtUpdatedBy.Text); tempInv_Production.UpdatedDate = txtUpdatedDate.Text; tempInv_Production.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue); bool result = Inv_ProductionManager.UpdateInv_Production(tempInv_Production); Response.Redirect("AdminInv_ProductionDisplay.aspx"); }
public bool UpdateInv_Production(Inv_Production inv_Production) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_UpdateInv_Production", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Inv_ProductionID", SqlDbType.Int).Value = inv_Production.Inv_ProductionID; cmd.Parameters.Add("@ProductionDate", SqlDbType.DateTime).Value = inv_Production.ProductionDate; cmd.Parameters.Add("@IssueIDs", SqlDbType.NVarChar).Value = inv_Production.IssueIDs; cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = inv_Production.WorkSatationID; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_Production.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_Production.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_Production.ExtraField3; cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_Production.ExtraField4; cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_Production.ExtraField5; cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_Production.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_Production.AddedDate; cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_Production.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_Production.UpdatedDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_Production.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public static Inv_Production GetInv_ProductionByID(int id) { Inv_Production inv_Production = new Inv_Production(); SqlInv_ProductionProvider sqlInv_ProductionProvider = new SqlInv_ProductionProvider(); inv_Production = sqlInv_ProductionProvider.GetInv_ProductionByID(id); return inv_Production; }
public static Inv_Production GetInv_ProductionByID(int id) { Inv_Production inv_Production = new Inv_Production(); SqlInv_ProductionProvider sqlInv_ProductionProvider = new SqlInv_ProductionProvider(); inv_Production = sqlInv_ProductionProvider.GetInv_ProductionByID(id); return(inv_Production); }
private void showInv_ProductionData() { Inv_Production inv_Production = new Inv_Production(); inv_Production = Inv_ProductionManager.GetInv_ProductionByID(Int32.Parse(Request.QueryString["inv_ProductionID"])); txtProductionDate.Text = inv_Production.ProductionDate; ddlIssue.SelectedValue = inv_Production.IssueIDs.ToString(); ddlWorkSatation.SelectedValue = inv_Production.WorkSatationID.ToString(); txtExtraField1.Text = inv_Production.ExtraField1; txtExtraField2.Text = inv_Production.ExtraField2; txtExtraField3.Text = inv_Production.ExtraField3; txtExtraField4.Text = inv_Production.ExtraField4; txtExtraField5.Text = inv_Production.ExtraField5; txtAddedBy.Text = inv_Production.AddedBy.ToString(); txtUpdatedBy.Text = inv_Production.UpdatedBy.ToString(); txtUpdatedDate.Text = inv_Production.UpdatedDate; ddlRowStatus.SelectedValue = inv_Production.RowStatusID.ToString(); }
protected void btnAdd_Click(object sender, EventArgs e) { Inv_Production inv_Production = new Inv_Production(); inv_Production.ProductionDate = txtProductionDate.Text; inv_Production.IssueIDs = Int32.Parse(ddlIssue.SelectedValue); inv_Production.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue); inv_Production.ExtraField1 = txtExtraField1.Text; inv_Production.ExtraField2 = txtExtraField2.Text; inv_Production.ExtraField3 = txtExtraField3.Text; inv_Production.ExtraField4 = txtExtraField4.Text; inv_Production.ExtraField5 = txtExtraField5.Text; inv_Production.AddedBy = Int32.Parse(txtAddedBy.Text); inv_Production.AddedDate = DateTime.Now; inv_Production.UpdatedBy = Int32.Parse(txtUpdatedBy.Text); inv_Production.UpdatedDate = txtUpdatedDate.Text; inv_Production.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue); int resutl = Inv_ProductionManager.InsertInv_Production(inv_Production); Response.Redirect("AdminInv_ProductionDisplay.aspx"); }
public static bool UpdateInv_Production(Inv_Production inv_Production) { SqlInv_ProductionProvider sqlInv_ProductionProvider = new SqlInv_ProductionProvider(); return(sqlInv_ProductionProvider.UpdateInv_Production(inv_Production)); }
public static int InsertInv_Production(Inv_Production inv_Production) { SqlInv_ProductionProvider sqlInv_ProductionProvider = new SqlInv_ProductionProvider(); return(sqlInv_ProductionProvider.InsertInv_Production(inv_Production)); }
public static bool UpdateInv_Production(Inv_Production inv_Production) { SqlInv_ProductionProvider sqlInv_ProductionProvider = new SqlInv_ProductionProvider(); return sqlInv_ProductionProvider.UpdateInv_Production(inv_Production); }
public static int InsertInv_Production(Inv_Production inv_Production) { SqlInv_ProductionProvider sqlInv_ProductionProvider = new SqlInv_ProductionProvider(); return sqlInv_ProductionProvider.InsertInv_Production(inv_Production); }