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