//List Of BillofMaterial By Id
public BillofMaterialModel GetAllBillofMaterialById(int id)
{
BillofMaterialModel objBom = new BillofMaterialModel();
string Query = "SELECT * FROM `BillsofMaterial` WHERE Bom_Id=" + id + "";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objBom.Bom_Id = Convert.ToInt32(dr["Bom_Id"].ToString());
objBom.BOMName = dr["BOMName"].ToString();
objBom.Itemtoproduce = dr["Itemtoproduce"].ToString();
objBom.Quantity = Convert.ToDecimal(dr["Quantity"]);
objBom.ItemUnit = dr["ItemUnit"].ToString();
objBom.Expenses = Convert.ToDecimal(dr["Expenses"]);
objBom.SpecifyMCGenerated = Convert.ToBoolean(dr["SpecifyMCGenerated"]);
objBom.SpecifyDefaultMCforItemConsumed = Convert.ToBoolean(dr["SpecifyDefaultMCforItemConsumed"]);
string QueryCon = "SELECT * FROM bom_consumed_details WHERE Bom_Id=" + id;
System.Data.IDataReader drCon = _dbHelper.ExecuteDataReader(QueryCon, _dbHelper.GetConnObject());
objBom.MaterialConsumed = new List <BillsofMaterialDetailsModel>();
BillsofMaterialDetailsModel objMaterial;
while (drCon.Read())
{
objMaterial = new BillsofMaterialDetailsModel();
objMaterial.id = Convert.ToInt32(drCon["Consumed_Id"]);
objMaterial.ParentId = Convert.ToInt32(drCon["Bom_Id"]);
objMaterial.ItemName = drCon["ItemName"].ToString();
objMaterial.Qty = Convert.ToDecimal(drCon["Qty"]);
objMaterial.Unit = drCon["Unit"].ToString();
objBom.MaterialConsumed.Add(objMaterial);
}
string QueryGen = "SELECT * FROM bom_generate_details WHERE Bom_Id=" + id;
System.Data.IDataReader drGen = _dbHelper.ExecuteDataReader(QueryGen, _dbHelper.GetConnObject());
objBom.MaterialGenerated = new List <BillsofMaterialDetailsModel>();
BillsofMaterialDetailsModel objMatGen;
while (drGen.Read())
{
objMatGen = new BillsofMaterialDetailsModel();
objMatGen.id = Convert.ToInt32(drGen["Generate_Id"]);
objMatGen.ParentId = Convert.ToInt32(drGen["Bom_Id"]);
objMatGen.ItemName = drGen["ItemName"].ToString();
objMatGen.Qty = Convert.ToDecimal(drGen["Qty"]);
objMatGen.Unit = drGen["Unit"].ToString();
objBom.MaterialGenerated.Add(objMatGen);
}
}
return(objBom);
}
private void btnSave_Click(object sender, EventArgs e)
{
BillofMaterialModel objBMmodl = new BillofMaterialModel();
objBMmodl.BOMName = tbxBomName.Text.Trim();
objBMmodl.Itemtoproduce = cbxItemproduce.Text.Trim();
objBMmodl.Quantity = Convert.ToDecimal(tbxQuanty.Text.Trim());
objBMmodl.ItemUnit = cbxUnit.SelectedItem.ToString();
objBMmodl.Expenses = Convert.ToDecimal(tbxExpensespcs.Text.Trim());
objBMmodl.SpecifyMCGenerated = Convert.ToBoolean(cbxItemgenerated.SelectedItem.ToString() == "Y"? true : false);
objBMmodl.SpecifyDefaultMCforItemConsumed = Convert.ToBoolean(cbxItemconsumed.SelectedItem.ToString() == "Y"? true : false);
objBMmodl.AppMc = string.Empty;
objBMmodl.ICTotalQty = Convert.ToDecimal(colQty.SummaryItem.SummaryValue);
objBMmodl.IGTotalQty = Convert.ToDecimal(colIgQty.SummaryItem.SummaryValue);
//Item consumed
List <BillsofMaterialDetailsModel> lstItemConsumed = new List <BillsofMaterialDetailsModel>();
BillsofMaterialDetailsModel objConsumed;
for (int i = 0; i < dvgMatConsuDetails.DataRowCount; i++)
{
DataRow row = dvgMatConsuDetails.GetDataRow(i);
objConsumed = new BillsofMaterialDetailsModel();
objConsumed.ItemName = row["ItemName"].ToString() == null?string.Empty: row["ItemName"].ToString();
objConsumed.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty?"0": row["Qty"].ToString());
objConsumed.Unit = row["Unit"].ToString() == string.Empty?string.Empty: row["Unit"].ToString();
lstItemConsumed.Add(objConsumed);
}
objBMmodl.MaterialConsumed = lstItemConsumed;
//Item generated
List <BillsofMaterialDetailsModel> lstItemGenerated = new List <BillsofMaterialDetailsModel>();
BillsofMaterialDetailsModel objGenerated;
for (int i = 0; i < dvgProductGeneratedDet.DataRowCount; i++)
{
DataRow row = dvgProductGeneratedDet.GetDataRow(i);
objGenerated = new BillsofMaterialDetailsModel();
objGenerated.ItemName = row["ItemName"].ToString() == null ? string.Empty : row["ItemName"].ToString();
objGenerated.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty ? "0" : row["Qty"].ToString());
objGenerated.Unit = row["Unit"].ToString() == string.Empty ? string.Empty : row["Unit"].ToString();
lstItemGenerated.Add(objGenerated);
}
objBMmodl.MaterialGenerated = lstItemGenerated;
bool isSuccess = objbal.SaveBOM(objBMmodl);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
ClearControls();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
BillofMaterialModel objBMmodl = new BillofMaterialModel();
if (BMId == 0)
{
tbxBomName.Focus();
return;
}
objBMmodl.BOMName = tbxBomName.Text.Trim();
objBMmodl.Itemtoproduce = cbxItemproduce.Text.Trim();
objBMmodl.Quantity = Convert.ToDecimal(tbxQuanty.Text.Trim());
objBMmodl.ItemUnit = cbxUnit.SelectedItem.ToString();
objBMmodl.Expenses = Convert.ToDecimal(tbxExpensespcs.Text.Trim());
objBMmodl.SpecifyMCGenerated = Convert.ToBoolean(cbxItemgenerated.SelectedItem.ToString() == "Y"? true : false);
// objBMmodl.SourceMC = string.Empty;
objBMmodl.SpecifyDefaultMCforItemConsumed = Convert.ToBoolean(cbxItemconsumed.SelectedItem.ToString() == "Y"? true : false);
objBMmodl.AppMc = string.Empty;
objBMmodl.ICTotalQty = Convert.ToDecimal(colQty.SummaryItem.SummaryValue);
objBMmodl.IGTotalQty = Convert.ToDecimal(colIgQty.SummaryItem.SummaryValue);
//Item consumed
List <BillsofMaterialDetailsModel> lstItemConsumed = new List <BillsofMaterialDetailsModel>();
BillsofMaterialDetailsModel objConsumed;
for (int i = 0; i < dvgMatConsuDetails.DataRowCount; i++)
{
DataRow row = dvgMatConsuDetails.GetDataRow(i);
objConsumed = new BillsofMaterialDetailsModel();
objConsumed.ItemName = row["ItemName"].ToString() == string.Empty?string.Empty: row["ItemName"].ToString();
objConsumed.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty?string.Empty: row["Qty"].ToString());
objConsumed.Unit = row["Unit"].ToString() == string.Empty?string.Empty: row["Unit"].ToString();
objConsumed.id = Convert.ToInt32(row["id"].ToString() == string.Empty?"0": row["id"].ToString());
objConsumed.ParentId = Convert.ToInt32(row["ParentId"].ToString() == string.Empty?"0": row["ParentId"].ToString());
lstItemConsumed.Add(objConsumed);
}
objBMmodl.MaterialConsumed = lstItemConsumed;
//Item generated
List <BillsofMaterialDetailsModel> lstItemGenerated = new List <BillsofMaterialDetailsModel>();
BillsofMaterialDetailsModel objGenerated;
for (int i = 0; i < dvgProductGeneratedDet.DataRowCount; i++)
{
DataRow row = dvgProductGeneratedDet.GetDataRow(i);
objGenerated = new BillsofMaterialDetailsModel();
objGenerated.ItemName = row["ItemName"].ToString() == string.Empty?string.Empty: row["ItemName"].ToString();
objGenerated.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty?string.Empty: row["Qty"].ToString());
objGenerated.Unit = row["Unit"].ToString() == string.Empty? string.Empty: row["Unit"].ToString();
objGenerated.id = Convert.ToInt32(row["id"].ToString() == string.Empty ? "0" : row["id"].ToString());
objGenerated.ParentId = Convert.ToInt32(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString());
lstItemGenerated.Add(objGenerated);
}
objBMmodl.MaterialGenerated = lstItemGenerated;
objBMmodl.id = BMId;
bool isSuccess = objbal.UpdateBOM(objBMmodl);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
BMId = 0;
ClearControls();
Administration.List.BillMaterialList frmList = new Administration.List.BillMaterialList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
tbxBomName.Focus();
FillBOMInfo();
}
}
