protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails();
inv_UtilizationDetails = Inv_UtilizationDetailsManager.GetInv_UtilizationDetailsByID(Int32.Parse(Request.QueryString["inv_UtilizationDetailsID"]));
Inv_UtilizationDetails tempInv_UtilizationDetails = new Inv_UtilizationDetails();
tempInv_UtilizationDetails.Inv_UtilizationDetailsID = inv_UtilizationDetails.Inv_UtilizationDetailsID;
tempInv_UtilizationDetails.Pos_SizeID = Int32.Parse(ddlPos_Size.SelectedValue);
tempInv_UtilizationDetails.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_UtilizationDetails.Inv_ItemID = Int32.Parse(ddlInv_Item.SelectedValue);
tempInv_UtilizationDetails.Inv_UtilizationID = Int32.Parse(ddlInv_Utilization.SelectedValue);
tempInv_UtilizationDetails.Inv_ItemTransactionID = Int32.Parse(ddlInv_ItemTransaction.SelectedValue);
tempInv_UtilizationDetails.FabricsCost = Decimal.Parse(txtFabricsCost.Text);
tempInv_UtilizationDetails.AccesoriesCost = Decimal.Parse(txtAccesoriesCost.Text);
tempInv_UtilizationDetails.Overhead = Decimal.Parse(txtOverhead.Text);
tempInv_UtilizationDetails.OthersCost = Decimal.Parse(txtOthersCost.Text);
tempInv_UtilizationDetails.ProductionQuantity = Decimal.Parse(txtProductionQuantity.Text);
tempInv_UtilizationDetails.ProcessedQuantity = Decimal.Parse(txtProcessedQuantity.Text);
tempInv_UtilizationDetails.IsReject = cbIsReject.Checked;
tempInv_UtilizationDetails.ExtraField1 = txtExtraField1.Text;
tempInv_UtilizationDetails.ExtraField2 = txtExtraField2.Text;
tempInv_UtilizationDetails.ExtraField3 = txtExtraField3.Text;
tempInv_UtilizationDetails.ExtraField4 = txtExtraField4.Text;
tempInv_UtilizationDetails.ExtraField5 = txtExtraField5.Text;
tempInv_UtilizationDetails.AddedBy = Int32.Parse(txtAddedBy.Text);
tempInv_UtilizationDetails.AddedDate = DateTime.Now;
tempInv_UtilizationDetails.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempInv_UtilizationDetails.UpdatedDate = txtUpdatedDate.Text;
tempInv_UtilizationDetails.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = Inv_UtilizationDetailsManager.UpdateInv_UtilizationDetails(tempInv_UtilizationDetails);
Response.Redirect("AdminInv_UtilizationDetailsDisplay.aspx");
}
public bool UpdateInv_UtilizationDetails(Inv_UtilizationDetails inv_UtilizationDetails)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_UtilizationDetails", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_UtilizationDetailsID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_UtilizationDetailsID;
cmd.Parameters.Add("@Pos_SizeID", SqlDbType.Int).Value = inv_UtilizationDetails.Pos_SizeID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = inv_UtilizationDetails.ProductID;
cmd.Parameters.Add("@Inv_ItemID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_ItemID;
cmd.Parameters.Add("@Inv_UtilizationID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_UtilizationID;
cmd.Parameters.Add("@Inv_ItemTransactionID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_ItemTransactionID;
cmd.Parameters.Add("@FabricsCost", SqlDbType.Decimal).Value = inv_UtilizationDetails.FabricsCost;
cmd.Parameters.Add("@AccesoriesCost", SqlDbType.Decimal).Value = inv_UtilizationDetails.AccesoriesCost;
cmd.Parameters.Add("@Overhead", SqlDbType.Decimal).Value = inv_UtilizationDetails.Overhead;
cmd.Parameters.Add("@OthersCost", SqlDbType.Decimal).Value = inv_UtilizationDetails.OthersCost;
cmd.Parameters.Add("@ProductionQuantity", SqlDbType.Decimal).Value = inv_UtilizationDetails.ProductionQuantity;
cmd.Parameters.Add("@ProcessedQuantity", SqlDbType.Decimal).Value = inv_UtilizationDetails.ProcessedQuantity;
cmd.Parameters.Add("@IsReject", SqlDbType.Bit).Value = inv_UtilizationDetails.IsReject;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_UtilizationDetails.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_UtilizationDetails.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_UtilizationDetails.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_UtilizationDetails.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_UtilizationDetails.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails();
inv_UtilizationDetails = Inv_UtilizationDetailsManager.GetInv_UtilizationDetailsByID(Int32.Parse(Request.QueryString["inv_UtilizationDetailsID"]));
Inv_UtilizationDetails tempInv_UtilizationDetails = new Inv_UtilizationDetails();
tempInv_UtilizationDetails.Inv_UtilizationDetailsID = inv_UtilizationDetails.Inv_UtilizationDetailsID;
tempInv_UtilizationDetails.Pos_SizeID = Int32.Parse(ddlPos_Size.SelectedValue);
tempInv_UtilizationDetails.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_UtilizationDetails.Inv_ItemID = Int32.Parse(ddlInv_Item.SelectedValue);
tempInv_UtilizationDetails.Inv_UtilizationID = Int32.Parse(ddlInv_Utilization.SelectedValue);
tempInv_UtilizationDetails.Inv_ItemTransactionID = Int32.Parse(ddlInv_ItemTransaction.SelectedValue);
tempInv_UtilizationDetails.FabricsCost = Decimal.Parse(txtFabricsCost.Text);
tempInv_UtilizationDetails.AccesoriesCost = Decimal.Parse(txtAccesoriesCost.Text);
tempInv_UtilizationDetails.Overhead = Decimal.Parse(txtOverhead.Text);
tempInv_UtilizationDetails.OthersCost = Decimal.Parse(txtOthersCost.Text);
tempInv_UtilizationDetails.ProductionQuantity = Decimal.Parse(txtProductionQuantity.Text);
tempInv_UtilizationDetails.ProcessedQuantity = Decimal.Parse(txtProcessedQuantity.Text);
tempInv_UtilizationDetails.IsReject = cbIsReject.Checked;
tempInv_UtilizationDetails.ExtraField1 = txtExtraField1.Text;
tempInv_UtilizationDetails.ExtraField2 = txtExtraField2.Text;
tempInv_UtilizationDetails.ExtraField3 = txtExtraField3.Text;
tempInv_UtilizationDetails.ExtraField4 = txtExtraField4.Text;
tempInv_UtilizationDetails.ExtraField5 = txtExtraField5.Text;
tempInv_UtilizationDetails.AddedBy = Int32.Parse(txtAddedBy.Text);
tempInv_UtilizationDetails.AddedDate = DateTime.Now;
tempInv_UtilizationDetails.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempInv_UtilizationDetails.UpdatedDate = txtUpdatedDate.Text;
tempInv_UtilizationDetails.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = Inv_UtilizationDetailsManager.UpdateInv_UtilizationDetails(tempInv_UtilizationDetails);
Response.Redirect("AdminInv_UtilizationDetailsDisplay.aspx");
}
public static Inv_UtilizationDetails GetInv_UtilizationDetailsByID(int id)
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails();
SqlInv_UtilizationDetailsProvider sqlInv_UtilizationDetailsProvider = new SqlInv_UtilizationDetailsProvider();
inv_UtilizationDetails = sqlInv_UtilizationDetailsProvider.GetInv_UtilizationDetailsByID(id);
return inv_UtilizationDetails;
}
private void showInv_UtilizationDetailsData()
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails();
inv_UtilizationDetails = Inv_UtilizationDetailsManager.GetInv_UtilizationDetailsByID(Int32.Parse(Request.QueryString["inv_UtilizationDetailsID"]));
ddlPos_Size.SelectedValue = inv_UtilizationDetails.Pos_SizeID.ToString();
ddlProduct.SelectedValue = inv_UtilizationDetails.ProductID.ToString();
ddlInv_Item.SelectedValue = inv_UtilizationDetails.Inv_ItemID.ToString();
ddlInv_Utilization.SelectedValue = inv_UtilizationDetails.Inv_UtilizationID.ToString();
ddlInv_ItemTransaction.SelectedValue = inv_UtilizationDetails.Inv_ItemTransactionID.ToString();
txtFabricsCost.Text = inv_UtilizationDetails.FabricsCost.ToString();
txtAccesoriesCost.Text = inv_UtilizationDetails.AccesoriesCost.ToString();
txtOverhead.Text = inv_UtilizationDetails.Overhead.ToString();
txtOthersCost.Text = inv_UtilizationDetails.OthersCost.ToString();
txtProductionQuantity.Text = inv_UtilizationDetails.ProductionQuantity.ToString();
txtProcessedQuantity.Text = inv_UtilizationDetails.ProcessedQuantity.ToString();
cbIsReject.Checked = inv_UtilizationDetails.IsFeature;
txtExtraField1.Text = inv_UtilizationDetails.ExtraField1;
txtExtraField2.Text = inv_UtilizationDetails.ExtraField2;
txtExtraField3.Text = inv_UtilizationDetails.ExtraField3;
txtExtraField4.Text = inv_UtilizationDetails.ExtraField4;
txtExtraField5.Text = inv_UtilizationDetails.ExtraField5;
txtAddedBy.Text = inv_UtilizationDetails.AddedBy.ToString();
txtUpdatedBy.Text = inv_UtilizationDetails.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_UtilizationDetails.UpdatedDate;
ddlRowStatus.SelectedValue = inv_UtilizationDetails.RowStatusID.ToString();
}
public static Inv_UtilizationDetails GetInv_UtilizationDetailsByID(int id)
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails();
SqlInv_UtilizationDetailsProvider sqlInv_UtilizationDetailsProvider = new SqlInv_UtilizationDetailsProvider();
inv_UtilizationDetails = sqlInv_UtilizationDetailsProvider.GetInv_UtilizationDetailsByID(id);
return(inv_UtilizationDetails);
}
public Inv_UtilizationDetails GetInv_UtilizationDetailsFromReader(IDataReader reader)
{
try
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails
(
(int)reader["Inv_UtilizationDetailsID"],
(int)reader["Pos_SizeID"],
(int)reader["ProductID"],
(int)reader["Inv_ItemID"],
(int)reader["Inv_UtilizationID"],
(int)reader["Inv_ItemTransactionID"],
(decimal)reader["FabricsCost"],
(decimal)reader["AccesoriesCost"],
(decimal)reader["Overhead"],
(decimal)reader["OthersCost"],
(decimal)reader["ProductionQuantity"],
(decimal)reader["ProcessedQuantity"],
(bool)reader["IsReject"],
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_UtilizationDetails);
}
catch (Exception ex)
{
return(null);
}
}
private void showInv_UtilizationDetailsData()
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails();
inv_UtilizationDetails = Inv_UtilizationDetailsManager.GetInv_UtilizationDetailsByID(Int32.Parse(Request.QueryString["inv_UtilizationDetailsID"]));
ddlPos_Size.SelectedValue = inv_UtilizationDetails.Pos_SizeID.ToString();
ddlProduct.SelectedValue = inv_UtilizationDetails.ProductID.ToString();
ddlInv_Item.SelectedValue = inv_UtilizationDetails.Inv_ItemID.ToString();
ddlInv_Utilization.SelectedValue = inv_UtilizationDetails.Inv_UtilizationID.ToString();
ddlInv_ItemTransaction.SelectedValue = inv_UtilizationDetails.Inv_ItemTransactionID.ToString();
txtFabricsCost.Text = inv_UtilizationDetails.FabricsCost.ToString();
txtAccesoriesCost.Text = inv_UtilizationDetails.AccesoriesCost.ToString();
txtOverhead.Text = inv_UtilizationDetails.Overhead.ToString();
txtOthersCost.Text = inv_UtilizationDetails.OthersCost.ToString();
txtProductionQuantity.Text = inv_UtilizationDetails.ProductionQuantity.ToString();
txtProcessedQuantity.Text = inv_UtilizationDetails.ProcessedQuantity.ToString();
cbIsReject.Checked = inv_UtilizationDetails.IsFeature;
txtExtraField1.Text = inv_UtilizationDetails.ExtraField1;
txtExtraField2.Text = inv_UtilizationDetails.ExtraField2;
txtExtraField3.Text = inv_UtilizationDetails.ExtraField3;
txtExtraField4.Text = inv_UtilizationDetails.ExtraField4;
txtExtraField5.Text = inv_UtilizationDetails.ExtraField5;
txtAddedBy.Text = inv_UtilizationDetails.AddedBy.ToString();
txtUpdatedBy.Text = inv_UtilizationDetails.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_UtilizationDetails.UpdatedDate;
ddlRowStatus.SelectedValue = inv_UtilizationDetails.RowStatusID.ToString();
}
public static bool UpdateInv_UtilizationDetails(Inv_UtilizationDetails inv_UtilizationDetails)
{
SqlInv_UtilizationDetailsProvider sqlInv_UtilizationDetailsProvider = new SqlInv_UtilizationDetailsProvider();
return sqlInv_UtilizationDetailsProvider.UpdateInv_UtilizationDetails(inv_UtilizationDetails);
}
public static int InsertInv_UtilizationDetails(Inv_UtilizationDetails inv_UtilizationDetails)
{
SqlInv_UtilizationDetailsProvider sqlInv_UtilizationDetailsProvider = new SqlInv_UtilizationDetailsProvider();
return sqlInv_UtilizationDetailsProvider.InsertInv_UtilizationDetails(inv_UtilizationDetails);
}
public Inv_UtilizationDetails GetInv_UtilizationDetailsFromReader(IDataReader reader)
{
try
{
Inv_UtilizationDetails inv_UtilizationDetails = new Inv_UtilizationDetails
(
(int)reader["Inv_UtilizationDetailsID"],
(int)reader["Pos_SizeID"],
(int)reader["ProductID"],
(int)reader["Inv_ItemID"],
(int)reader["Inv_UtilizationID"],
(int)reader["Inv_ItemTransactionID"],
(decimal)reader["FabricsCost"],
(decimal)reader["AccesoriesCost"],
(decimal)reader["Overhead"],
(decimal)reader["OthersCost"],
(decimal)reader["ProductionQuantity"],
(decimal)reader["ProcessedQuantity"],
(bool)reader["IsReject"],
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_UtilizationDetails;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateInv_UtilizationDetails(Inv_UtilizationDetails inv_UtilizationDetails)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_UtilizationDetails", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_UtilizationDetailsID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_UtilizationDetailsID;
cmd.Parameters.Add("@Pos_SizeID", SqlDbType.Int).Value = inv_UtilizationDetails.Pos_SizeID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = inv_UtilizationDetails.ProductID;
cmd.Parameters.Add("@Inv_ItemID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_ItemID;
cmd.Parameters.Add("@Inv_UtilizationID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_UtilizationID;
cmd.Parameters.Add("@Inv_ItemTransactionID", SqlDbType.Int).Value = inv_UtilizationDetails.Inv_ItemTransactionID;
cmd.Parameters.Add("@FabricsCost", SqlDbType.Decimal).Value = inv_UtilizationDetails.FabricsCost;
cmd.Parameters.Add("@AccesoriesCost", SqlDbType.Decimal).Value = inv_UtilizationDetails.AccesoriesCost;
cmd.Parameters.Add("@Overhead", SqlDbType.Decimal).Value = inv_UtilizationDetails.Overhead;
cmd.Parameters.Add("@OthersCost", SqlDbType.Decimal).Value = inv_UtilizationDetails.OthersCost;
cmd.Parameters.Add("@ProductionQuantity", SqlDbType.Decimal).Value = inv_UtilizationDetails.ProductionQuantity;
cmd.Parameters.Add("@ProcessedQuantity", SqlDbType.Decimal).Value = inv_UtilizationDetails.ProcessedQuantity;
cmd.Parameters.Add("@IsReject", SqlDbType.Bit).Value = inv_UtilizationDetails.IsReject;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_UtilizationDetails.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_UtilizationDetails.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_UtilizationDetails.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_UtilizationDetails.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_UtilizationDetails.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_UtilizationDetails.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public static bool UpdateInv_UtilizationDetails(Inv_UtilizationDetails inv_UtilizationDetails)
{
SqlInv_UtilizationDetailsProvider sqlInv_UtilizationDetailsProvider = new SqlInv_UtilizationDetailsProvider();
return(sqlInv_UtilizationDetailsProvider.UpdateInv_UtilizationDetails(inv_UtilizationDetails));
}
public static int InsertInv_UtilizationDetails(Inv_UtilizationDetails inv_UtilizationDetails)
{
SqlInv_UtilizationDetailsProvider sqlInv_UtilizationDetailsProvider = new SqlInv_UtilizationDetailsProvider();
return(sqlInv_UtilizationDetailsProvider.InsertInv_UtilizationDetails(inv_UtilizationDetails));
}
