private void addtoDataTable(forAddEditSupplies addEditSuppliesVals, int frameMaterialsId) //Populating the DataTable { String dimension = addEditSuppliesVals.measureAUsed + " x " + addEditSuppliesVals.measureBUsed; String measure = addEditSuppliesVals.measureAUsed.ToString(); dtSuppliesUsedSaved.Rows.Add(); int indexdtInsert = dtSuppliesUsedSaved.Rows.Count - 1; //frameMaterialsId ==-1 - frameMat doesn't exist. If greater than that, it exists if (frameMaterialsId > -1) { dtSuppliesUsedSaved.Rows[indexdtInsert]["frame_MaterialsID"] = frameMaterialsId; } dtSuppliesUsedSaved.Rows[indexdtInsert]["supply_itemsId"] = addEditSuppliesVals.supplyItemsId; dtSuppliesUsedSaved.Rows[indexdtInsert]["Supply Name"] = addEditSuppliesVals.supplyName; dtSuppliesUsedSaved.Rows[indexdtInsert]["Category"] = addEditSuppliesVals.category; dtSuppliesUsedSaved.Rows[indexdtInsert]["typeOfMeasure"] = addEditSuppliesVals.typeOfMeasure; dtSuppliesUsedSaved.Rows[indexdtInsert]["Unit Measure"] = addEditSuppliesVals.unitMeasureUsed; dtSuppliesUsedSaved.Rows[indexdtInsert]["Base Unit Measure"] = "1 " + addEditSuppliesVals.unitMeasure_OG; dtSuppliesUsedSaved.Rows[indexdtInsert]["OGUnitMeasure"] = addEditSuppliesVals.unitMeasure_OG; dtSuppliesUsedSaved.Rows[indexdtInsert]["OGUnitPrice"] = addEditSuppliesVals.unitPriceOG; dtSuppliesUsedSaved.Rows[indexdtInsert]["measureAOG"] = addEditSuppliesVals.measureA_OG; dtSuppliesUsedSaved.Rows[indexdtInsert]["deductedA"] = addEditSuppliesVals.measureAUsed; if (String.Equals(addEditSuppliesVals.typeOfMeasure, "Area")) { dtSuppliesUsedSaved.Rows[indexdtInsert]["Usage"] = dimension; dtSuppliesUsedSaved.Rows[indexdtInsert]["measureAtoOG"] = measureConverter(addEditSuppliesVals.measureAUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed); dtSuppliesUsedSaved.Rows[indexdtInsert]["measureBOG"] = addEditSuppliesVals.measureB_OG; dtSuppliesUsedSaved.Rows[indexdtInsert]["deductedB"] = addEditSuppliesVals.measureBUsed; dtSuppliesUsedSaved.Rows[indexdtInsert]["measureBtoOG"] = measureConverter(addEditSuppliesVals.measureBUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed); dtSuppliesUsedSaved.Rows[indexdtInsert]["Base Unit Measure"] = "1 " + addEditSuppliesVals.unitMeasure_OG + "²"; } else if (String.Equals(addEditSuppliesVals.typeOfMeasure, "Whole")) ////NOTE: MAJOR BUG UPDATE. PLEASE TELL BEN ABOUT THIS. 3/20/2019 8:35AM { dtSuppliesUsedSaved.Rows[indexdtInsert]["Usage"] = measure; dtSuppliesUsedSaved.Rows[indexdtInsert]["measureAtoOG"] = addEditSuppliesVals.measureAUsed; } else if (String.Equals(addEditSuppliesVals.typeOfMeasure, "Volume")) { dtSuppliesUsedSaved.Rows[indexdtInsert]["Usage"] = measure; dtSuppliesUsedSaved.Rows[indexdtInsert]["measureAtoOG"] = measureConverter(addEditSuppliesVals.measureAUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed, 0); } else { dtSuppliesUsedSaved.Rows[indexdtInsert]["Usage"] = measure; dtSuppliesUsedSaved.Rows[indexdtInsert]["measureAtoOG"] = measureConverter(addEditSuppliesVals.measureAUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed); } int dtSuppliesSavedLastIndex = dtSuppliesUsedSaved.Rows.Count - 1; trueCostCalculationPutDataGrid(addEditSuppliesVals, dtSuppliesSavedLastIndex); }
private void btnEditSupply_Click(object sender, EventArgs e) { if (dataGridSuppliesUsed.Rows.Count == 0) { MessageBox.Show("There's nothing to edit."); return; } forAddEditSupplies addEditSuppliesval = new forAddEditSupplies(); int currRowIndex = dataGridSuppliesUsed.SelectedRows[0].Index; //Get currRowIndex. NOTE: get currRowIndex of datagrid, loop through dtSuppliesUsedSaved and find the same supply_ItemId.Then replace //with edited values addEditSuppliesval.supplyItemsId = Int32.Parse(dataGridSuppliesUsed.Rows[currRowIndex].Cells["supply_itemsId"].Value.ToString()); addEditSuppliesval.unitMeasureUsed = dataGridSuppliesUsed.Rows[currRowIndex].Cells["Unit Measure"].Value.ToString(); addEditSuppliesval.unitMeasure_OG = dataGridSuppliesUsed.Rows[currRowIndex].Cells["OGUnitMeasure"].Value.ToString(); addEditSuppliesval.typeOfMeasure = dataGridSuppliesUsed.Rows[currRowIndex].Cells["typeOfMeasure"].Value.ToString(); addEditSuppliesval.supplyName = dataGridSuppliesUsed.Rows[currRowIndex].Cells["Supply Name"].Value.ToString(); addEditSuppliesval.category = dataGridSuppliesUsed.Rows[currRowIndex].Cells["Category"].Value.ToString(); addEditSuppliesval.unitPriceOG = Double.Parse(dataGridSuppliesUsed.Rows[currRowIndex].Cells["OGUnitPrice"].Value.ToString()); addEditSuppliesval.measureA_OG = Double.Parse(dataGridSuppliesUsed.Rows[currRowIndex].Cells["measureAOG"].Value.ToString()); if (!String.IsNullOrEmpty(dataGridSuppliesUsed.Rows[currRowIndex].Cells["measureBOG"].Value.ToString())) { addEditSuppliesval.measureB_OG = Double.Parse(dataGridSuppliesUsed.Rows[currRowIndex].Cells["measureBOG"].Value.ToString()); } frmFrameEditSuppliesUsed frmEditSupplies = new frmFrameEditSuppliesUsed(addEditSuppliesval, this); frmEditSupplies.ShowDialog(); }
private void suppliesUsed_Loader() { RemovedFrame_MatItemId = new List <int>(); this.dataGridSuppliesUsed.DataSource = null; this.dataGridSuppliesUsed.Rows.Clear(); dtSuppliesUsed = new DataTable(); dtSuppliesUsed.Columns.Add("frame_MaterialsID", typeof(int)); dtSuppliesUsed.Columns.Add("supply_itemsId", typeof(int)); dtSuppliesUsed.Columns.Add("Supply Name", typeof(String)); dtSuppliesUsed.Columns.Add("Category", typeof(String)); dtSuppliesUsed.Columns.Add("typeOfMeasure", typeof(String)); dtSuppliesUsed.Columns.Add("Cost/Base Unit Measure", typeof(double)); dtSuppliesUsed.Columns.Add("Base Unit Measure", typeof(String)); dtSuppliesUsed.Columns.Add("deductedA", typeof(double)); dtSuppliesUsed.Columns.Add("deductedB", typeof(double)); dtSuppliesUsed.Columns.Add("Usage", typeof(String)); dtSuppliesUsed.Columns.Add("Unit Measure", typeof(String)); //Original Measures dtSuppliesUsed.Columns.Add("OGUnitMeasure", typeof(String)); dtSuppliesUsed.Columns.Add("OGUnitPrice", typeof(double)); dtSuppliesUsed.Columns.Add("measureAOG", typeof(double)); dtSuppliesUsed.Columns.Add("measureBOG", typeof(double)); dtSuppliesUsed.Columns.Add("measureAtoOG", typeof(double)); dtSuppliesUsed.Columns.Add("measureBtoOG", typeof(double)); //ADDED Custom Columns dtSuppliesUsed.Columns.Add("Cost/Selected Unit Measure", typeof(double)); dtSuppliesUsed.Columns.Add("Raw Cost", typeof(double)); selectSuppliesLoader(this.frameItemId); dtSuppliesUsed.Merge(dtSelectSuppliesFiltered); dtSuppliesUsedSaved = dtSuppliesUsed.Copy(); dataGridSuppliesUsed.DataSource = dtSuppliesUsedSaved; if (dtSuppliesUsedSaved.Rows.Count > 0) { for (int i = 0; i < dtSuppliesUsedSaved.Rows.Count; i++) { forAddEditSupplies calculateCost = new forAddEditSupplies(); calculateCost.typeOfMeasure = dtSuppliesUsedSaved.Rows[i]["typeOfMeasure"].ToString(); calculateCost.measureAUsed = Double.Parse(dtSuppliesUsedSaved.Rows[i]["deductedA"].ToString()); if (!String.IsNullOrEmpty(dtSuppliesUsedSaved.Rows[i]["deductedB"].ToString())) { calculateCost.measureBUsed = Double.Parse(dtSuppliesUsedSaved.Rows[i]["deductedB"].ToString()); calculateCost.measureB_OG = Double.Parse(dtSuppliesUsedSaved.Rows[i]["measureBOG"].ToString()); } calculateCost.unitMeasureUsed = dtSuppliesUsedSaved.Rows[i]["Unit Measure"].ToString(); calculateCost.unitMeasure_OG = dtSuppliesUsedSaved.Rows[i]["OGUnitMeasure"].ToString(); calculateCost.measureA_OG = Double.Parse(dtSuppliesUsedSaved.Rows[i]["measureAOG"].ToString()); calculateCost.unitPriceOG = Double.Parse(dtSuppliesUsedSaved.Rows[i]["OGUnitPrice"].ToString()); trueCostCalculationPutDataGrid(calculateCost, i); refreshDataGrid(); } } }
public frmFrameEditSuppliesUsed(forAddEditSupplies addEditSuppliesVals, frmJobOrderEdit pFrmJobOrderEdit) { InitializeComponent(); this.addEditSuppliesVals = addEditSuppliesVals; this.pFrmJobOrderEdit = pFrmJobOrderEdit; this.supplyItemsId = addEditSuppliesVals.supplyItemsId; this.measureAOG = addEditSuppliesVals.measureA_OG; this.measureBOG = addEditSuppliesVals.measureB_OG; }
public frmFrameEditSuppliesUsed(forAddEditSupplies addEditSuppliesVals, frmFrameCreate pfrmFrameCreate) { InitializeComponent(); this.addEditSuppliesVals = addEditSuppliesVals; this.pFrmFrameCreate = pfrmFrameCreate; this.supplyItemsId = addEditSuppliesVals.supplyItemsId; this.measureAOG = addEditSuppliesVals.measureA_OG; this.measureBOG = addEditSuppliesVals.measureB_OG; }
//Used by frmFrameEditSuppliesUsed internal void editSuppliesSelected(forAddEditSupplies editSuppliesVal) { int currRowIndexDataGrid = dataGridSuppliesUsed.SelectedRows[0].Index; int currRowIndexDt = -1; if (dtSuppliesUsedSaved.Rows.Count > 0) { for (int i = 0; i < dtSuppliesUsedSaved.Rows.Count; i++) { if (Int32.Parse(dataGridSuppliesUsed.Rows[currRowIndexDataGrid].Cells["supply_itemsId"].Value.ToString()) == Int32.Parse(dtSuppliesUsedSaved.Rows[i]["supply_itemsId"].ToString())) { currRowIndexDt = i; } } } if (currRowIndexDt > -1) { if (String.Equals(editSuppliesVal.typeOfMeasure, "Area")) { String Dimension = editSuppliesVal.measureAUsed + " x " + editSuppliesVal.measureBUsed; dtSuppliesUsedSaved.Rows[currRowIndexDt]["Usage"] = Dimension; dtSuppliesUsedSaved.Rows[currRowIndexDt]["Unit Measure"] = editSuppliesVal.unitMeasureUsed; dtSuppliesUsedSaved.Rows[currRowIndexDt]["deductedA"] = editSuppliesVal.measureAUsed; dtSuppliesUsedSaved.Rows[currRowIndexDt]["deductedB"] = editSuppliesVal.measureBUsed; dtSuppliesUsedSaved.Rows[currRowIndexDt]["measureAtoOG"] = measureConverter(editSuppliesVal.measureAUsed, editSuppliesVal.unitMeasure_OG, editSuppliesVal.unitMeasureUsed); dtSuppliesUsedSaved.Rows[currRowIndexDt]["measureBtoOG"] = measureConverter(editSuppliesVal.measureBUsed, editSuppliesVal.unitMeasure_OG, editSuppliesVal.unitMeasureUsed); } else { dtSuppliesUsedSaved.Rows[currRowIndexDt]["Usage"] = editSuppliesVal.measureAUsed; dtSuppliesUsedSaved.Rows[currRowIndexDt]["Unit Measure"] = editSuppliesVal.unitMeasureUsed; dtSuppliesUsedSaved.Rows[currRowIndexDt]["deductedA"] = editSuppliesVal.measureAUsed; if (String.Equals(editSuppliesVal.typeOfMeasure, "Volume")) { dtSuppliesUsedSaved.Rows[currRowIndexDt]["measureAtoOG"] = measureConverter(editSuppliesVal.measureAUsed, editSuppliesVal.unitMeasure_OG, editSuppliesVal.unitMeasureUsed, 0); } else if (String.Equals(editSuppliesVal.typeOfMeasure, "Whole")) //////NOTE: MAJOR BUG UPDATE. PLEASE TELL BEN ABOUT THIS. 3/20/2019 8:35AM { dtSuppliesUsedSaved.Rows[currRowIndexDt]["measureAtoOG"] = editSuppliesVal.measureAUsed; } else { dtSuppliesUsedSaved.Rows[currRowIndexDt]["measureAtoOG"] = measureConverter(editSuppliesVal.measureAUsed, editSuppliesVal.unitMeasure_OG, editSuppliesVal.unitMeasureUsed); } } trueCostCalculationPutDataGrid(editSuppliesVal, currRowIndexDt); } rawSalesTimesQuantityCalc(); }
internal void checkIfExistsBeforeCalc(forAddEditSupplies addEditSuppliesVals) { bool existsInDataGrid = false; for (int i = 0; i < dtSuppliesUsedSaved.Rows.Count; i++) { //Check if item exists whether it has frame_itemID or not dtSuppliesUsedSaved if (addEditSuppliesVals.supplyItemsId == Int32.Parse(dtSuppliesUsedSaved.Rows[i]["supply_itemsId"].ToString())) { existsInDataGrid = true; } } if (existsInDataGrid) { MessageBox.Show("You've already added the item in the list. \n Please use Remove the Supply button and re-add it again for any changes."); return; } //If confirmed that it doesn't exist, pass to addToDataTable method to put Data in DataTable addtoDataTable(addEditSuppliesVals, -1); }
//Cost/Base Unit Measure(trueUnitPrice) AND RAW COST CALCULATOR, pass data and indexInDataTable internal void trueCostCalculationPutDataGrid(forAddEditSupplies addEditSuppliesVals, int dtSuppliesUsedSavedIndex) { if (String.Equals(addEditSuppliesVals.typeOfMeasure, "Whole")) { double rawCost = addEditSuppliesVals.measureAUsed * addEditSuppliesVals.unitPriceOG; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Selected Unit Measure"] = addEditSuppliesVals.unitPriceOG; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Base Unit Measure"] = addEditSuppliesVals.unitPriceOG; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Raw Cost"] = rawCost; refreshDataGrid(); } else if (String.Equals(addEditSuppliesVals.unitMeasureUsed, addEditSuppliesVals.unitMeasure_OG)) { if (String.Equals(addEditSuppliesVals.typeOfMeasure, "Area")) { double area_OG = addEditSuppliesVals.measureA_OG * addEditSuppliesVals.measureB_OG; double trueUnitPrice = addEditSuppliesVals.unitPriceOG / area_OG; double areaOfUsed = addEditSuppliesVals.measureAUsed * addEditSuppliesVals.measureBUsed; double rawCost = areaOfUsed * trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Selected Unit Measure"] = trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Base Unit Measure"] = trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Raw Cost"] = rawCost; refreshDataGrid(); } else { double trueUnitPrice = addEditSuppliesVals.unitPriceOG / addEditSuppliesVals.measureA_OG; double rawCost = addEditSuppliesVals.measureAUsed * trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Selected Unit Measure"] = trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Base Unit Measure"] = trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Raw Cost"] = rawCost; refreshDataGrid(); } } else { if (String.Equals(addEditSuppliesVals.typeOfMeasure, "Area")) { double area_OG = addEditSuppliesVals.measureA_OG * addEditSuppliesVals.measureB_OG; // Get area of original measures from purchase from Object double trueUnitPrice = addEditSuppliesVals.unitPriceOG / area_OG; // Purchase Unit Price/area_OG to get the true Unit Price of "1" Unit of Measurement double measureAConvertedUse = measureConverter(addEditSuppliesVals.measureAUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed); double measureBConvertedUse = measureConverter(addEditSuppliesVals.measureBUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed); double areaOfUsed = measureAConvertedUse * measureBConvertedUse; //Calculate the area of Use of the used up converted measurements double rawCost = areaOfUsed * trueUnitPrice; //Get the raw cost of the item based on 'Area Usage' multiplied by the true Unit Price double measureAOGConvert = measureConverter(addEditSuppliesVals.measureA_OG, addEditSuppliesVals.unitMeasureUsed, addEditSuppliesVals.unitMeasure_OG); double measureBOGConvert = measureConverter(addEditSuppliesVals.measureB_OG, addEditSuppliesVals.unitMeasureUsed, addEditSuppliesVals.unitMeasure_OG); double area_OGDisplay = measureAOGConvert * measureBOGConvert; double displayPrice = addEditSuppliesVals.unitPriceOG / area_OGDisplay; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Selected Unit Measure"] = displayPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Base Unit Measure"] = trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Raw Cost"] = rawCost; refreshDataGrid(); } else { double trueUnitPrice = addEditSuppliesVals.unitPriceOG / addEditSuppliesVals.measureA_OG; // Purchase Unit Price/area_OG to get the true Unit Price of "1" Unit of Measurement //Get the already converted Measurements in frame_materials table. //The already converted Measurements are calculated and inputted in the database in the FrameCreation and FrameEdited forms double measureAConvertedUse; double displayPrice; if (String.Equals(addEditSuppliesVals.typeOfMeasure, "Volume")) { measureAConvertedUse = measureConverter(addEditSuppliesVals.measureAUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed, 0); displayPrice = addEditSuppliesVals.unitPriceOG / measureConverter(addEditSuppliesVals.measureA_OG, addEditSuppliesVals.unitMeasureUsed, addEditSuppliesVals.unitMeasure_OG, 0); } else { measureAConvertedUse = measureConverter(addEditSuppliesVals.measureAUsed, addEditSuppliesVals.unitMeasure_OG, addEditSuppliesVals.unitMeasureUsed); displayPrice = addEditSuppliesVals.unitPriceOG / measureConverter(addEditSuppliesVals.measureA_OG, addEditSuppliesVals.unitMeasureUsed, addEditSuppliesVals.unitMeasure_OG); } double rawCost = measureAConvertedUse * trueUnitPrice; //Get the raw cost of the item based on 'Area Usage' multiplied by the true Unit Price dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Selected Unit Measure"] = displayPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Cost/Base Unit Measure"] = trueUnitPrice; dtSuppliesUsedSaved.Rows[dtSuppliesUsedSavedIndex]["Raw Cost"] = rawCost; refreshDataGrid(); } } rawCostCalculation(); rawSalesTimesQuantityCalc(); this.txtBoxDiscount.Text = (0).ToString(); this.txtBoxDiscountTotal.Text = ""; this.txtBoxTotalPaid.Text = ""; this.txtBoxChange.Text = ""; }
internal void checkIfExistsBeforeCalc(forAddEditSupplies addEditSuppliesVals) //for adding supply { DataTable dtcheckIfFrame_MatExists = new DataTable(); //Check using frameItemId and supply_ItemsId if it iexist in database try { String stringSuppliesSelect = "SELECT fm.frame_materialsID, fm.frameItemID, fm.supply_itemsID, fm.measureADeduction,fm.measureBDeduction, " + "fm.unitMeasure, fm.active, fm.measureAtoOG, fm.measureBtoOG " + "FROM frame_materials AS fm " + "WHERE fm.frameItemId = @frameItemId AND fm.supply_itemsID = @supplyItemsId; "; MySqlConnection my_conn = new MySqlConnection(connString); MySqlCommand cmdSuppliesSelect = new MySqlCommand(stringSuppliesSelect, my_conn); cmdSuppliesSelect.Parameters.AddWithValue("@frameItemId", frameItemId); cmdSuppliesSelect.Parameters.AddWithValue("@supplyItemsId", addEditSuppliesVals.supplyItemsId); //cmdSuppliesSelect.Parameters.AddWithValue("@DateEnd", DateEnd); MySqlDataAdapter my_adapter = new MySqlDataAdapter(cmdSuppliesSelect); my_adapter.Fill(dtcheckIfFrame_MatExists); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } bool existsInDataGrid = false; //If material added exists in frame_materials table and dtSuppliesUsedSaved if (dtcheckIfFrame_MatExists.Rows.Count > 0) { for (int i = 0; i < dtSuppliesUsedSaved.Rows.Count; i++) { if (!String.IsNullOrEmpty(dtSuppliesUsedSaved.Rows[i]["frame_materialsID"].ToString())) { //check if it's in the datatable; if (Int32.Parse(dtcheckIfFrame_MatExists.Rows[0]["frame_materialsID"].ToString()) == Int32.Parse(dtSuppliesUsedSaved.Rows[i]["frame_materialsID"].ToString())) { existsInDataGrid = true; } } } if (existsInDataGrid) { MessageBox.Show("You've already added the item in the list. \n Please use Edit Supply for any changes."); return; } else if (!existsInDataGrid) { //if it's not in existsInDataGrid, and was removed earlier remove the item in removedList if it exists int removedListindex = -1; for (int i = 0; i < RemovedFrame_MatItemId.Count; i++) { if (RemovedFrame_MatItemId[i] == Int32.Parse(dtcheckIfFrame_MatExists.Rows[0]["frame_materialsID"].ToString())) { removedListindex = i; } } if (removedListindex > -1) { RemovedFrame_MatItemId.RemoveAt(removedListindex); } //send frame_materialsId to in DataTable addtoDataTable(addEditSuppliesVals, Int32.Parse(dtcheckIfFrame_MatExists.Rows[0]["frame_materialsID"].ToString())); } } //Else If not update else { // for (int i = 0; i < dtSuppliesUsedSaved.Rows.Count; i++) { //Check if item exists whether it has frame_itemID or not dtSuppliesUsedSaved if (addEditSuppliesVals.supplyItemsId == Int32.Parse(dtSuppliesUsedSaved.Rows[i]["supply_itemsId"].ToString())) { existsInDataGrid = true; } } if (existsInDataGrid) { MessageBox.Show("You've already added the item in the list. \n Please use Edit Supply for any changes."); return; } addtoDataTable(addEditSuppliesVals, -1); } }
private void sendToParentForm() { //supply_ItemsId, Supply Name, Description, Category, Base Measurements, Base Unit Measure, Cost per Unit, typeOfMeasure, measureAOG, measureBOG int currRowIndex = datagridSuppliesList.SelectedRows[0].Index; int frameItemId = -1; int jobOrderID = -1; int supplyItemsId = Int32.Parse(datagridSuppliesList.Rows[currRowIndex].Cells["supply_ItemsId"].Value.ToString()); double measureAUsed = -1; double measureBUsed = -1; String unitMeasureUsed = datagridSuppliesList.Rows[currRowIndex].Cells["Base Unit Measure"].Value.ToString(); String unitMeasure_OG = datagridSuppliesList.Rows[currRowIndex].Cells["Base Unit Measure"].Value.ToString(); String typeOfMeasure = txtBoxTypeOfM.Text; String supplyName = txtBoxSupplyName.Text; double unitPriceOG = Double.Parse(datagridSuppliesList.Rows[currRowIndex].Cells["Cost per Unit"].Value.ToString()); double measureA_OG = Double.Parse(datagridSuppliesList.Rows[currRowIndex].Cells["measureAOG"].Value.ToString()); double measureB_OG = -1; String category = txtBoxCategory.Text; if (this.frameItemId > -1) { frameItemId = this.frameItemId; } if (this.jobOrderID > -1) { jobOrderID = this.jobOrderID; } if (String.Equals(typeOfMeasure, "Area")) { measureAUsed = Double.Parse(txtBoxAreaLength.Text); measureBUsed = Double.Parse(txtBoxAreaWidth.Text); measureB_OG = Double.Parse(datagridSuppliesList.Rows[currRowIndex].Cells["measureBOG"].Value.ToString()); unitMeasureUsed = cboAreaUnit.Text; } else { if (String.Equals(typeOfMeasure, "Length")) { measureAUsed = Double.Parse(txtBoxLength.Text); measureBUsed = -1; unitMeasureUsed = cboLengthUnit.Text; } else if (String.Equals(typeOfMeasure, "Weight")) { measureAUsed = Double.Parse(txtBoxWeight.Text); measureBUsed = -1; unitMeasureUsed = cboWeightUnit.Text; } else if (String.Equals(typeOfMeasure, "Volume")) { measureAUsed = Double.Parse(txtBoxVolume.Text); measureBUsed = -1; unitMeasureUsed = cboVolumeUnit.Text; } else if (String.Equals(typeOfMeasure, "Whole")) { measureAUsed = Double.Parse(txtBoxWhole.Text); measureBUsed = -1; unitMeasureUsed = cboWholeUnit.Text; } } //public forAddEditSupplies(int frameItemId, int supplyItemsId, double measureAUsed, double measureBUsed, String unitMeasureUsed, String unitMeasure_OG, //String typeOfMeasure, String supplyName, double unitPriceOG, double measureA_OG, double measureB_OG, String category) forAddEditSupplies addEditSuppliesVals = new forAddEditSupplies(frameItemId, supplyItemsId, measureAUsed, measureBUsed, unitMeasureUsed, unitMeasure_OG, typeOfMeasure, supplyName, unitPriceOG, measureA_OG, measureB_OG, category); if (pFrmJobOrderEdit != null || pFrmJobOrderCreate != null) { addEditSuppliesVals = new forAddEditSupplies(jobOrderID, supplyItemsId, measureAUsed, measureBUsed, unitMeasureUsed, unitMeasure_OG, typeOfMeasure, supplyName, unitPriceOG, measureA_OG, measureB_OG, category); } if (pFrmFrameCreate != null) { pFrmFrameCreate.checkIfExistsBeforeCalc(addEditSuppliesVals); } else if (pFrmFrameEdit != null) { pFrmFrameEdit.checkIfExistsBeforeCalc(addEditSuppliesVals); } else if (pFrmJobOrderCreate != null) { pFrmJobOrderCreate.checkIfExistsBeforeCalc(addEditSuppliesVals); } else if (pFrmJobOrderEdit != null) { pFrmJobOrderEdit.checkIfExistsBeforeCalc(addEditSuppliesVals); } this.Close(); }
private void updateSendDet() { forAddEditSupplies addEditSuppliesVals = new forAddEditSupplies(); int supplyItemsId = this.supplyItemsId; addEditSuppliesVals.unitMeasure_OG = lblSupplyBaseUM.Text; String typeOfMeasure = lblSupplyTypeOfM.Text; addEditSuppliesVals.typeOfMeasure = lblSupplyTypeOfM.Text; addEditSuppliesVals.supplyName = lblSupplyName.Text; addEditSuppliesVals.unitPriceOG = Double.Parse(lblSupplyCost.Text); addEditSuppliesVals.measureA_OG = this.measureAOG; String category = txtBoxCategory.Text; if (String.Equals(typeOfMeasure, "Area")) { addEditSuppliesVals.measureAUsed = Double.Parse(txtBoxAreaLength.Text); addEditSuppliesVals.measureBUsed = Double.Parse(txtBoxAreaWidth.Text); addEditSuppliesVals.measureB_OG = this.measureBOG; addEditSuppliesVals.unitMeasureUsed = cboAreaUnit.Text; } else { if (String.Equals(typeOfMeasure, "Length")) { addEditSuppliesVals.measureAUsed = Double.Parse(txtBoxLength.Text); addEditSuppliesVals.measureBUsed = -1; addEditSuppliesVals.unitMeasureUsed = cboLengthUnit.Text; } else if (String.Equals(typeOfMeasure, "Weight")) { addEditSuppliesVals.measureAUsed = Double.Parse(txtBoxWeight.Text); addEditSuppliesVals.measureBUsed = -1; addEditSuppliesVals.unitMeasureUsed = cboWeightUnit.Text; } else if (String.Equals(typeOfMeasure, "Volume")) { addEditSuppliesVals.measureAUsed = Double.Parse(txtBoxVolume.Text); addEditSuppliesVals.measureBUsed = -1; addEditSuppliesVals.unitMeasureUsed = cboVolumeUnit.Text; } else if (String.Equals(typeOfMeasure, "Whole")) { addEditSuppliesVals.measureAUsed = Double.Parse(txtBoxWhole.Text); addEditSuppliesVals.measureBUsed = -1; addEditSuppliesVals.unitMeasureUsed = cboWholeUnit.Text; } } //public forAddEditSupplies(int frameItemId, int supplyItemsId, double measureAUsed, double measureBUsed, String unitMeasureUsed, String unitMeasure_OG, //String typeOfMeasure, String supplyName, double unitPriceOG, double measureA_OG, double measureB_OG, String category) if (pFrmFrameCreate != null) { pFrmFrameCreate.editSuppliesSelected(addEditSuppliesVals); } else if (pFrmFrameEdit != null) { pFrmFrameEdit.editSuppliesSelected(addEditSuppliesVals); } else if (pFrmJobOrderCreate != null) { pFrmJobOrderCreate.editSuppliesSelected(addEditSuppliesVals); } else if (pFrmJobOrderEdit != null) { pFrmJobOrderEdit.editSuppliesSelected(addEditSuppliesVals); } this.Close(); }