private void addConfiguration()
{
if (txtConfigPerProductRequiredQuantity.Text != "0")
{
Inv_Item itemSelected = Inv_ItemManager.GetInv_ItemByID(int.Parse(ddlItem.SelectedValue));
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_ProductionConfiguration.QualityValue = itemSelected.QualityValue;
inv_ProductionConfiguration.QualityUnitID = itemSelected.QualityUnitID;
inv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtConfigPerProductRequiredQuantity.Text);
inv_ProductionConfiguration.QuantityUnitID = itemSelected.QuantityUnitID;
inv_ProductionConfiguration.RawMaterialID = itemSelected.RawMaterialID;
inv_ProductionConfiguration.ExtraField1 = "";
inv_ProductionConfiguration.ExtraField2 = "";
inv_ProductionConfiguration.ExtraField3 = "";
inv_ProductionConfiguration.ExtraField4 = "";
inv_ProductionConfiguration.ExtraField5 = "";
inv_ProductionConfiguration.AddedBy = getLogin().LoginID;
inv_ProductionConfiguration.AddedDate = DateTime.Now;
inv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
inv_ProductionConfiguration.UpdatedDate = DateTime.Now;
inv_ProductionConfiguration.RowStatusID = 1;
int resutl = Inv_ProductionConfigurationManager.InsertInv_ProductionConfiguration(inv_ProductionConfiguration);
trConfigPerProductRequiredQuantity.Visible = false;
}
}
public Inv_ProductionConfiguration GetInv_ProductionConfigurationFromReader(IDataReader reader)
{
try
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration
(
(int)reader["Inv_ProductionConfigurationID"],
(int)reader["ProductID"],
(decimal)reader["QualityValue"],
(int)reader["QualityUnitID"],
(decimal)reader["QuantityValue"],
(int)reader["QuantityUnitID"],
(int)reader["RawMaterialID"],
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_ProductionConfiguration);
}
catch (Exception ex)
{
return(null);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
btnUpdate.Visible = false;
btnAdd.Visible = true;
Inv_ProductionConfiguration tempInv_ProductionConfiguration = new Inv_ProductionConfiguration();
tempInv_ProductionConfiguration.Inv_ProductionConfigurationID = int.Parse(hfConfigID.Value);
tempInv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_ProductionConfiguration.QualityValue = Decimal.Parse(txtQualityValue.Text);
tempInv_ProductionConfiguration.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
tempInv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtQuantityValue.Text);
tempInv_ProductionConfiguration.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
tempInv_ProductionConfiguration.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
tempInv_ProductionConfiguration.ExtraField1 = "";
tempInv_ProductionConfiguration.ExtraField2 = "";
tempInv_ProductionConfiguration.ExtraField3 = "";
tempInv_ProductionConfiguration.ExtraField4 = "";
tempInv_ProductionConfiguration.ExtraField5 = "";
tempInv_ProductionConfiguration.AddedBy = getLogin().LoginID;
tempInv_ProductionConfiguration.AddedDate = DateTime.Now;
tempInv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
tempInv_ProductionConfiguration.UpdatedDate = DateTime.Now;
tempInv_ProductionConfiguration.RowStatusID = 1;
bool result = Inv_ProductionConfigurationManager.UpdateInv_ProductionConfiguration(tempInv_ProductionConfiguration);
showInv_ProductionConfigurationGrid();
btnClear_Click(this, new EventArgs());
}
public static Inv_ProductionConfiguration GetInv_ProductionConfigurationByID(int id)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
SqlInv_ProductionConfigurationProvider sqlInv_ProductionConfigurationProvider = new SqlInv_ProductionConfigurationProvider();
inv_ProductionConfiguration = sqlInv_ProductionConfigurationProvider.GetInv_ProductionConfigurationByID(id);
return inv_ProductionConfiguration;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_ProductionConfiguration.QualityValue = Decimal.Parse(txtQualityValue.Text);
inv_ProductionConfiguration.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
inv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtQuantityValue.Text);
inv_ProductionConfiguration.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
inv_ProductionConfiguration.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
inv_ProductionConfiguration.ExtraField1 = "";
inv_ProductionConfiguration.ExtraField2 = "";
inv_ProductionConfiguration.ExtraField3 = "";
inv_ProductionConfiguration.ExtraField4 = "";
inv_ProductionConfiguration.ExtraField5 = "";
inv_ProductionConfiguration.AddedBy = getLogin().LoginID;
inv_ProductionConfiguration.AddedDate = DateTime.Now;
inv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
inv_ProductionConfiguration.UpdatedDate = DateTime.Now;
inv_ProductionConfiguration.RowStatusID = 1;
int resutl = Inv_ProductionConfigurationManager.InsertInv_ProductionConfiguration(inv_ProductionConfiguration);
//Response.Redirect("AdminInv_ProductionConfigurationDisplay.aspx");
showInv_ProductionConfigurationGrid();
btnClear_Click(this, new EventArgs());
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(Int32.Parse(Request.QueryString["inv_ProductionConfigurationID"]));
Inv_ProductionConfiguration tempInv_ProductionConfiguration = new Inv_ProductionConfiguration();
tempInv_ProductionConfiguration.Inv_ProductionConfigurationID = inv_ProductionConfiguration.Inv_ProductionConfigurationID;
tempInv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_ProductionConfiguration.QualityValue = Decimal.Parse(txtQualityValue.Text);
tempInv_ProductionConfiguration.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
tempInv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtQuantityValue.Text);
tempInv_ProductionConfiguration.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
tempInv_ProductionConfiguration.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
tempInv_ProductionConfiguration.ExtraField1 = "";
tempInv_ProductionConfiguration.ExtraField2 = "";
tempInv_ProductionConfiguration.ExtraField3 = "";
tempInv_ProductionConfiguration.ExtraField4 = "";
tempInv_ProductionConfiguration.ExtraField5 = "";
tempInv_ProductionConfiguration.AddedBy = getLogin().LoginID;
tempInv_ProductionConfiguration.AddedDate = DateTime.Now;
tempInv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
tempInv_ProductionConfiguration.UpdatedDate = DateTime.Now;
tempInv_ProductionConfiguration.RowStatusID = 1;
bool result = Inv_ProductionConfigurationManager.UpdateInv_ProductionConfiguration(tempInv_ProductionConfiguration);
Response.Redirect("AdminInv_ProductionConfigurationDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_ProductionConfiguration.QualityValue = Decimal.Parse(txtQualityValue.Text);
inv_ProductionConfiguration.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
inv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtQuantityValue.Text);
inv_ProductionConfiguration.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
inv_ProductionConfiguration.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
inv_ProductionConfiguration.ExtraField1 = "";
inv_ProductionConfiguration.ExtraField2 = "";
inv_ProductionConfiguration.ExtraField3 = "";
inv_ProductionConfiguration.ExtraField4 = "";
inv_ProductionConfiguration.ExtraField5 = "";
inv_ProductionConfiguration.AddedBy = getLogin().LoginID;
inv_ProductionConfiguration.AddedDate = DateTime.Now;
inv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
inv_ProductionConfiguration.UpdatedDate = DateTime.Now;
inv_ProductionConfiguration.RowStatusID = 1;
int resutl = Inv_ProductionConfigurationManager.InsertInv_ProductionConfiguration(inv_ProductionConfiguration);
//Response.Redirect("AdminInv_ProductionConfigurationDisplay.aspx");
showInv_ProductionConfigurationGrid();
btnClear_Click(this, new EventArgs());
}
public bool UpdateInv_ProductionConfiguration(Inv_ProductionConfiguration inv_ProductionConfiguration)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_ProductionConfiguration", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_ProductionConfigurationID", SqlDbType.Int).Value = inv_ProductionConfiguration.Inv_ProductionConfigurationID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = inv_ProductionConfiguration.ProductID;
cmd.Parameters.Add("@QualityValue", SqlDbType.Decimal).Value = inv_ProductionConfiguration.QualityValue;
cmd.Parameters.Add("@QualityUnitID", SqlDbType.Int).Value = inv_ProductionConfiguration.QualityUnitID;
cmd.Parameters.Add("@QuantityValue", SqlDbType.Decimal).Value = inv_ProductionConfiguration.QuantityValue;
cmd.Parameters.Add("@QuantityUnitID", SqlDbType.Int).Value = inv_ProductionConfiguration.QuantityUnitID;
cmd.Parameters.Add("@RawMaterialID", SqlDbType.Int).Value = inv_ProductionConfiguration.RawMaterialID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_ProductionConfiguration.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_ProductionConfiguration.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_ProductionConfiguration.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_ProductionConfiguration.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_ProductionConfiguration.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(Int32.Parse(Request.QueryString["inv_ProductionConfigurationID"]));
Inv_ProductionConfiguration tempInv_ProductionConfiguration = new Inv_ProductionConfiguration();
tempInv_ProductionConfiguration.Inv_ProductionConfigurationID = inv_ProductionConfiguration.Inv_ProductionConfigurationID;
tempInv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_ProductionConfiguration.QualityValue = Decimal.Parse(txtQualityValue.Text);
tempInv_ProductionConfiguration.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
tempInv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtQuantityValue.Text);
tempInv_ProductionConfiguration.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
tempInv_ProductionConfiguration.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
tempInv_ProductionConfiguration.ExtraField1 = "";
tempInv_ProductionConfiguration.ExtraField2 = "";
tempInv_ProductionConfiguration.ExtraField3 = "";
tempInv_ProductionConfiguration.ExtraField4 = "";
tempInv_ProductionConfiguration.ExtraField5 = "";
tempInv_ProductionConfiguration.AddedBy =getLogin().LoginID;
tempInv_ProductionConfiguration.AddedDate = DateTime.Now;
tempInv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
tempInv_ProductionConfiguration.UpdatedDate = DateTime.Now;
tempInv_ProductionConfiguration.RowStatusID = 1;
bool result = Inv_ProductionConfigurationManager.UpdateInv_ProductionConfiguration(tempInv_ProductionConfiguration);
Response.Redirect("AdminInv_ProductionConfigurationDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
btnUpdate.Visible = false;
btnAdd.Visible = true;
Inv_ProductionConfiguration tempInv_ProductionConfiguration = new Inv_ProductionConfiguration();
tempInv_ProductionConfiguration.Inv_ProductionConfigurationID = int.Parse(hfConfigID.Value);
tempInv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempInv_ProductionConfiguration.QualityValue = Decimal.Parse(txtQualityValue.Text);
tempInv_ProductionConfiguration.QualityUnitID = Int32.Parse(ddlQualityUnit.SelectedValue);
tempInv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtQuantityValue.Text);
tempInv_ProductionConfiguration.QuantityUnitID = Int32.Parse(ddlQuantityUnit.SelectedValue);
tempInv_ProductionConfiguration.RawMaterialID = Int32.Parse(ddlRawMaterial.SelectedValue);
tempInv_ProductionConfiguration.ExtraField1 = "";
tempInv_ProductionConfiguration.ExtraField2 = "";
tempInv_ProductionConfiguration.ExtraField3 = "";
tempInv_ProductionConfiguration.ExtraField4 = "";
tempInv_ProductionConfiguration.ExtraField5 = "";
tempInv_ProductionConfiguration.AddedBy = getLogin().LoginID;
tempInv_ProductionConfiguration.AddedDate = DateTime.Now;
tempInv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
tempInv_ProductionConfiguration.UpdatedDate = DateTime.Now;
tempInv_ProductionConfiguration.RowStatusID = 1;
bool result = Inv_ProductionConfigurationManager.UpdateInv_ProductionConfiguration(tempInv_ProductionConfiguration);
showInv_ProductionConfigurationGrid();
btnClear_Click(this, new EventArgs());
}
public static Inv_ProductionConfiguration GetInv_ProductionConfigurationByID(int id)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
SqlInv_ProductionConfigurationProvider sqlInv_ProductionConfigurationProvider = new SqlInv_ProductionConfigurationProvider();
inv_ProductionConfiguration = sqlInv_ProductionConfigurationProvider.GetInv_ProductionConfigurationByID(id);
return(inv_ProductionConfiguration);
}
private void showInv_ProductionConfigurationData()
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(Int32.Parse(Request.QueryString["inv_ProductionConfigurationID"]));
ddlProduct.SelectedValue = inv_ProductionConfiguration.ProductID.ToString();
txtQualityValue.Text = inv_ProductionConfiguration.QualityValue.ToString();
ddlQualityUnit.SelectedValue = inv_ProductionConfiguration.QualityUnitID.ToString();
txtQuantityValue.Text = inv_ProductionConfiguration.QuantityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_ProductionConfiguration.QuantityUnitID.ToString();
ddlRawMaterial.SelectedValue = inv_ProductionConfiguration.RawMaterialID.ToString();
}
private void showInv_ProductionConfigurationData(int id)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(id);
ddlProduct.SelectedValue = inv_ProductionConfiguration.ProductID.ToString();
txtQualityValue.Text = inv_ProductionConfiguration.QualityValue.ToString();
ddlQualityUnit.SelectedValue = inv_ProductionConfiguration.QualityUnitID.ToString();
txtQuantityValue.Text = inv_ProductionConfiguration.QuantityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_ProductionConfiguration.QuantityUnitID.ToString();
ddlRawMaterial.SelectedValue = inv_ProductionConfiguration.RawMaterialID.ToString();
}
private void showInv_ProductionConfigurationData()
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(Int32.Parse(Request.QueryString["inv_ProductionConfigurationID"]));
ddlProduct.SelectedValue = inv_ProductionConfiguration.ProductID.ToString();
txtQualityValue.Text = inv_ProductionConfiguration.QualityValue.ToString();
ddlQualityUnit.SelectedValue = inv_ProductionConfiguration.QualityUnitID.ToString();
txtQuantityValue.Text = inv_ProductionConfiguration.QuantityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_ProductionConfiguration.QuantityUnitID.ToString();
ddlRawMaterial.SelectedValue = inv_ProductionConfiguration.RawMaterialID.ToString();
txtExtraField1.Text = inv_ProductionConfiguration.ExtraField1;
txtExtraField2.Text = inv_ProductionConfiguration.ExtraField2;
txtExtraField3.Text = inv_ProductionConfiguration.ExtraField3;
txtExtraField4.Text = inv_ProductionConfiguration.ExtraField4;
txtExtraField5.Text = inv_ProductionConfiguration.ExtraField5;
txtAddedBy.Text = inv_ProductionConfiguration.AddedBy.ToString();
txtUpdatedBy.Text = inv_ProductionConfiguration.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_ProductionConfiguration.UpdatedDate;
ddlRowStatus.SelectedValue = inv_ProductionConfiguration.RowStatusID.ToString();
}
private void addConfiguration()
{
if (txtConfigPerProductRequiredQuantity.Text != "0")
{
Inv_Item itemSelected = Inv_ItemManager.GetInv_ItemByID(int.Parse(ddlItem.SelectedValue));
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration.ProductID = Int32.Parse(ddlProduct.SelectedValue);
inv_ProductionConfiguration.QualityValue = itemSelected.QualityValue;
inv_ProductionConfiguration.QualityUnitID = itemSelected.QualityUnitID;
inv_ProductionConfiguration.QuantityValue = Decimal.Parse(txtConfigPerProductRequiredQuantity.Text);
inv_ProductionConfiguration.QuantityUnitID = itemSelected.QuantityUnitID;
inv_ProductionConfiguration.RawMaterialID = itemSelected.RawMaterialID;
inv_ProductionConfiguration.ExtraField1 = "";
inv_ProductionConfiguration.ExtraField2 = "";
inv_ProductionConfiguration.ExtraField3 = "";
inv_ProductionConfiguration.ExtraField4 = "";
inv_ProductionConfiguration.ExtraField5 = "";
inv_ProductionConfiguration.AddedBy = getLogin().LoginID;
inv_ProductionConfiguration.AddedDate = DateTime.Now;
inv_ProductionConfiguration.UpdatedBy = getLogin().LoginID;
inv_ProductionConfiguration.UpdatedDate = DateTime.Now;
inv_ProductionConfiguration.RowStatusID = 1;
int resutl = Inv_ProductionConfigurationManager.InsertInv_ProductionConfiguration(inv_ProductionConfiguration);
trConfigPerProductRequiredQuantity.Visible = false;
}
}
public static bool UpdateInv_ProductionConfiguration(Inv_ProductionConfiguration inv_ProductionConfiguration)
{
SqlInv_ProductionConfigurationProvider sqlInv_ProductionConfigurationProvider = new SqlInv_ProductionConfigurationProvider();
return sqlInv_ProductionConfigurationProvider.UpdateInv_ProductionConfiguration(inv_ProductionConfiguration);
}
public Inv_ProductionConfiguration GetInv_ProductionConfigurationFromReader(IDataReader reader)
{
try
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration
(
(int)reader["Inv_ProductionConfigurationID"],
(int)reader["ProductID"],
(decimal)reader["QualityValue"],
(int)reader["QualityUnitID"],
(decimal)reader["QuantityValue"],
(int)reader["QuantityUnitID"],
(int)reader["RawMaterialID"],
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_ProductionConfiguration;
}
catch(Exception ex)
{
return null;
}
}
private void showInv_ProductionConfigurationData(int id)
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(id);
ddlProduct.SelectedValue = inv_ProductionConfiguration.ProductID.ToString();
txtQualityValue.Text = inv_ProductionConfiguration.QualityValue.ToString();
ddlQualityUnit.SelectedValue = inv_ProductionConfiguration.QualityUnitID.ToString();
txtQuantityValue.Text = inv_ProductionConfiguration.QuantityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_ProductionConfiguration.QuantityUnitID.ToString();
ddlRawMaterial.SelectedValue = inv_ProductionConfiguration.RawMaterialID.ToString();
}
private void showInv_ProductionConfigurationData()
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(Int32.Parse(Request.QueryString["inv_ProductionConfigurationID"]));
ddlProduct.SelectedValue = inv_ProductionConfiguration.ProductID.ToString();
txtQualityValue.Text = inv_ProductionConfiguration.QualityValue.ToString();
ddlQualityUnit.SelectedValue = inv_ProductionConfiguration.QualityUnitID.ToString();
txtQuantityValue.Text = inv_ProductionConfiguration.QuantityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_ProductionConfiguration.QuantityUnitID.ToString();
ddlRawMaterial.SelectedValue = inv_ProductionConfiguration.RawMaterialID.ToString();
}
public static int InsertInv_ProductionConfiguration(Inv_ProductionConfiguration inv_ProductionConfiguration)
{
SqlInv_ProductionConfigurationProvider sqlInv_ProductionConfigurationProvider = new SqlInv_ProductionConfigurationProvider();
return(sqlInv_ProductionConfigurationProvider.InsertInv_ProductionConfiguration(inv_ProductionConfiguration));
}
public static bool UpdateInv_ProductionConfiguration(Inv_ProductionConfiguration inv_ProductionConfiguration)
{
SqlInv_ProductionConfigurationProvider sqlInv_ProductionConfigurationProvider = new SqlInv_ProductionConfigurationProvider();
return(sqlInv_ProductionConfigurationProvider.UpdateInv_ProductionConfiguration(inv_ProductionConfiguration));
}
public static int InsertInv_ProductionConfiguration(Inv_ProductionConfiguration inv_ProductionConfiguration)
{
SqlInv_ProductionConfigurationProvider sqlInv_ProductionConfigurationProvider = new SqlInv_ProductionConfigurationProvider();
return sqlInv_ProductionConfigurationProvider.InsertInv_ProductionConfiguration(inv_ProductionConfiguration);
}
public bool UpdateInv_ProductionConfiguration(Inv_ProductionConfiguration inv_ProductionConfiguration)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_ProductionConfiguration", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_ProductionConfigurationID", SqlDbType.Int).Value = inv_ProductionConfiguration.Inv_ProductionConfigurationID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = inv_ProductionConfiguration.ProductID;
cmd.Parameters.Add("@QualityValue", SqlDbType.Decimal).Value = inv_ProductionConfiguration.QualityValue;
cmd.Parameters.Add("@QualityUnitID", SqlDbType.Int).Value = inv_ProductionConfiguration.QualityUnitID;
cmd.Parameters.Add("@QuantityValue", SqlDbType.Decimal).Value = inv_ProductionConfiguration.QuantityValue;
cmd.Parameters.Add("@QuantityUnitID", SqlDbType.Int).Value = inv_ProductionConfiguration.QuantityUnitID;
cmd.Parameters.Add("@RawMaterialID", SqlDbType.Int).Value = inv_ProductionConfiguration.RawMaterialID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = inv_ProductionConfiguration.ExtraField5;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = inv_ProductionConfiguration.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = inv_ProductionConfiguration.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = inv_ProductionConfiguration.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = inv_ProductionConfiguration.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_ProductionConfiguration.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
private void showInv_ProductionConfigurationData()
{
Inv_ProductionConfiguration inv_ProductionConfiguration = new Inv_ProductionConfiguration();
inv_ProductionConfiguration = Inv_ProductionConfigurationManager.GetInv_ProductionConfigurationByID(Int32.Parse(Request.QueryString["inv_ProductionConfigurationID"]));
ddlProduct.SelectedValue = inv_ProductionConfiguration.ProductID.ToString();
txtQualityValue.Text = inv_ProductionConfiguration.QualityValue.ToString();
ddlQualityUnit.SelectedValue = inv_ProductionConfiguration.QualityUnitID.ToString();
txtQuantityValue.Text = inv_ProductionConfiguration.QuantityValue.ToString();
ddlQuantityUnit.SelectedValue = inv_ProductionConfiguration.QuantityUnitID.ToString();
ddlRawMaterial.SelectedValue = inv_ProductionConfiguration.RawMaterialID.ToString();
txtExtraField1.Text = inv_ProductionConfiguration.ExtraField1;
txtExtraField2.Text = inv_ProductionConfiguration.ExtraField2;
txtExtraField3.Text = inv_ProductionConfiguration.ExtraField3;
txtExtraField4.Text = inv_ProductionConfiguration.ExtraField4;
txtExtraField5.Text = inv_ProductionConfiguration.ExtraField5;
txtAddedBy.Text = inv_ProductionConfiguration.AddedBy.ToString();
txtUpdatedBy.Text = inv_ProductionConfiguration.UpdatedBy.ToString();
txtUpdatedDate.Text = inv_ProductionConfiguration.UpdatedDate;
ddlRowStatus.SelectedValue = inv_ProductionConfiguration.RowStatusID.ToString();
}
