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