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();
}
