//List public List <eSunSpeedDomain.BillofMaterialModel> GetAllBillofMaterial() { List <eSunSpeedDomain.BillofMaterialModel> lstBom = new List <BillofMaterialModel>(); eSunSpeedDomain.BillofMaterialModel objBom; string Query = "SELECT * FROM BillsofMaterial"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objBom = new BillofMaterialModel(); objBom.BOMName = dr["BOMName"].ToString(); objBom.ItemProduct = dr["ItemProduct"].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.SourceMC = dr["SourceMC"].ToString(); objBom.SpecifyDefaultMCforItemConsumed = Convert.ToBoolean(dr["SpecifyDefaultMCforItemConsumed"]); objBom.AppMc = dr["AppMc"].ToString(); objBom.SNo = Convert.ToInt32(dr["SNo"]); objBom.ItemName = dr["ItemName"].ToString(); objBom.Qty = Convert.ToDecimal(dr["Qty"]); objBom.Unit = Convert.ToDecimal(dr["Unit"]); objBom.TotalofConsumedqtyUnit = Convert.ToDecimal(dr["TotalofConsumedqtyUnit"]); lstBom.Add(objBom); } return(lstBom); }
private void btnSave_Click(object sender, EventArgs e) { BillofMaterialModel objBMmodl = new BillofMaterialModel(); objBMmodl.BOMName = tbxBomName.Text.Trim(); objBMmodl.ItemProduct = cbxItemproduce.Text.Trim(); objBMmodl.Quantity = Convert.ToInt32(tbxQuanty.Text.Trim()); objBMmodl.ItemUnit = cbxUnit.SelectedItem.ToString(); objBMmodl.Expenses = Convert.ToDecimal(tbxExpensespcs.Text.Trim()); objBMmodl.SpecifyMCGenerated = Convert.ToBoolean(cbxItemgenerated.SelectedItem.ToString().Equals("Yes") ? true : false); objBMmodl.SourceMC = string.Empty; objBMmodl.SpecifyDefaultMCforItemConsumed = Convert.ToBoolean(cbxItemconsumed.SelectedItem.ToString().Equals("Yes") ? true : false); objBMmodl.AppMc = string.Empty; //objBMmodl.ItemName = cbxRawItemName.Text.Trim(); //objBMmodl.Qty = Convert.ToInt32(tbxRawQty.Text.Trim()); //objBMmodl.Unit = Convert.ToDecimal(tbxRawUnit.Text.Trim()); bool isSuccess = objbal.SaveBOM(objBMmodl); if (isSuccess) { MessageBox.Show("Saved Successfully!"); //List<BillofMaterialModel> lstBillMat = objBillmat.GetAllBillofMaterial(); //dgvList.DataSource = lstBillMat; //Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!"); //d.ShowDialog(); } }
private void FillBOMInfo() { BillofMaterialModel objBom = objbal.GetAllBillofMaterialById(BMId); if (BMId == 0) { tbxBomName.Focus(); lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; return; } tbxBomName.Text = objBom.BOMName; cbxItemproduce.Text = objBom.Itemtoproduce.ToString(); tbxQuanty.Text = Convert.ToString(objBom.Quantity); cbxUnit.Text = objBom.ItemUnit; tbxExpensespcs.Text = Convert.ToString(objBom.Expenses); cbxItemgenerated.SelectedItem = objBom.SpecifyMCGenerated?"Y":"N"; cbxItemconsumed.SelectedItem = objBom.SpecifyDefaultMCforItemConsumed?"Y":"N"; dtconsumed.Rows.Clear(); DataRow dr; foreach (BillsofMaterialDetailsModel objmod in objBom.MaterialConsumed) { dr = dtconsumed.NewRow(); dr["ItemName"] = objmod.ItemName; dr["Qty"] = objmod.Qty; dr["Unit"] = objmod.Unit; dr["id"] = objmod.id; dr["ParentId"] = objmod.ParentId; dtconsumed.Rows.Add(dr); } dvgMatConsumed.DataSource = dtconsumed; dtgenerate.Rows.Clear(); DataRow drgen; foreach (BillsofMaterialDetailsModel objGen in objBom.MaterialGenerated) { drgen = dtgenerate.NewRow(); drgen["ItemName"] = objGen.ItemName; drgen["Qty"] = objGen.Qty; drgen["Unit"] = objGen.Unit; drgen["id"] = objGen.id; drgen["ParentId"] = objGen.ParentId; dtgenerate.Rows.Add(drgen); } dvgProductGenerate.DataSource = dtgenerate; lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; }
//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(); } }