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());
}
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());
}
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;
}
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = Inv_ProductionConfigurationManager.DeleteInv_ProductionConfiguration(Convert.ToInt32(linkButton.CommandArgument));
showInv_ProductionConfigurationGrid();
}
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();
}
protected void btnClaculateApproximateQuantity_Click(object sender, EventArgs e)
{
List <Inv_ProductionConfiguration> inv_ProductionConfigurations = Inv_ProductionConfigurationManager.GetAllInv_ProductionConfigurationsByProductIDnItemID(int.Parse(ddlProduct.SelectedValue), int.Parse(ddlItem.SelectedValue));
bool IsfoundConfig = false;
foreach (Inv_ProductionConfiguration item in inv_ProductionConfigurations)
{
if (
item.QualityValue.ToString("0.00")
== ddlItem.SelectedItem.Text.Split('{')[1].Split('}')[0].Split(' ')[0].Trim()
&&
item.ExtraField4
== ddlItem.SelectedItem.Text.Split('{')[1].Split('}')[0].Split(' ')[1].Trim()
&&
item.ExtraField3
== ddlItem.SelectedItem.Text.Split('[')[1].Split(']')[0].Split(' ')[1].Trim()
)
{
IsfoundConfig = true;
txtApproximateQuantity.Text = (decimal.Parse(txtQuantity.Text) / item.QuantityValue).ToString("0,0");
break;
}
}
if (!IsfoundConfig)
{
trConfigPerProductRequiredQuantity.Visible = true;
trClaculateApproximateQuantity.Visible = true;
lblApproximateQuantity.ForeColor = System.Drawing.Color.Red;
}
else
{
trClaculateApproximateQuantity.Visible = false;
lblApproximateQuantity.ForeColor = System.Drawing.Color.Black;
}
}
private bool checking()
{
bool returnValue = true;
List <Inv_ProductionConfiguration> inv_ProductionConfigurations = Inv_ProductionConfigurationManager.GetAllInv_ProductionConfigurations();
foreach (GridViewRow gvr in gvInv_Item.Rows)
{
HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID");
Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID");
Label lblQualityValue = (Label)gvr.FindControl("lblQualityValue");
HiddenField hfQualityUnitID = (HiddenField)gvr.FindControl("hfQualityUnitID");
HiddenField hfRawMaterialID = (HiddenField)gvr.FindControl("hfRawMaterialID");
TextBox txtIssueQuantity = (TextBox)gvr.FindControl("txtIssueQuantity");
HiddenField hfQuantityUnitID = (HiddenField)gvr.FindControl("hfQuantityUnitID");
TextBox txtApproximateQuantity = (TextBox)gvr.FindControl("txtApproximateQuantity");
DropDownList ddlProduct = (DropDownList)gvr.FindControl("ddlProduct");
HiddenField hfRawMaterialTypeID = (HiddenField)gvr.FindControl("hfRawMaterialTypeID");
Label lblAvailableInstock = (Label)gvr.FindControl("lblExtraFieldQuantity1");
Label lblItemCode = (Label)gvr.FindControl("lblItemCode");
if (hfRawMaterialTypeID.Value != "2" ||
(txtApproximateQuantity.Text != "" && txtApproximateQuantity.Text != "0"))
{
continue;
}
if (ddlProduct.SelectedValue == "0" &&
txtApproximateQuantity.Text == "0")
{
continue;
}
if (txtIssueQuantity.Text == "" || txtIssueQuantity.Text == "0")
{
continue;
}
if (decimal.Parse(txtIssueQuantity.Text) > decimal.Parse(lblAvailableInstock.Text))
{
showAlartMessage("Issue is not permited more than stock for " + lblItemCode.Text);
returnValue = false;
continue;
}
if (ddlProduct.SelectedValue == "0")
{
showAlartMessage("Please Select the product for " + lblItemCode.Text);
returnValue = false;
continue;
}
bool found = false;
if (txtApproximateQuantity.Text != "0")
{
foreach (Inv_ProductionConfiguration confi in inv_ProductionConfigurations)
{
if (confi.ProductID.ToString() == ddlProduct.SelectedValue &&
confi.QualityUnitID.ToString() == hfQualityUnitID.Value &&
confi.QuantityUnitID.ToString() == hfQuantityUnitID.Value &&
confi.QualityValue == decimal.Parse(lblQualityValue.Text) &&
confi.RawMaterialID.ToString() == hfRawMaterialID.Value
)
{
txtApproximateQuantity.Text = (decimal.Parse(txtIssueQuantity.Text) / confi.QuantityValue).ToString("0");
found = true;
break;
}
}
}
else
{
found = true;
}
if (!found)
{
showAlartMessage("Configuration missing for " + lblItemCode.Text);
returnValue = false;
}
}
return(returnValue);
}
private void showInv_ProductionConfigurationGrid()
{
gvInv_ProductionConfiguration.DataSource = Inv_ProductionConfigurationManager.GetAllInv_ProductionConfigurations();
gvInv_ProductionConfiguration.DataBind();
}
