private void dataGridView1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 116)
{
string Q = "";
DBMNG.Open_Connection();
string date = "";
string result = "";
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
Q = query;
Q = Q.Replace("%PO", dataGridView1.Rows[i].Cells["order_number"].Value.ToString());
date = Convert.ToDateTime(dataGridView1.Rows[i].Cells["order_due"].Value.ToString()).ToString("MM/dd/yyyy");
Q = Q.Replace("%DATE", date);
Q = Q.Replace("%VENDOR", dataGridView1.Rows[i].Cells["vendor_code"].Value.ToString());
Q = Q.Replace("%ITEM", dataGridView1.Rows[i].Cells["part"].Value.ToString());
Q = Q.Replace("%QTY", dataGridView1.Rows[i].Cells["order_qty"].Value.ToString());
result = DBMNG.Execute_Scalar_Open_Conn(Q).ToString();
if (result == "")
{
dataGridView1.Rows[i].Cells["Exist"].Value = "Not Exist";
}
else
{
dataGridView1.Rows[i].Cells["Exist"].Value = result;
}
this.Text = dataGridView1.Rows.Count.ToString() + " Lines -- Processed Lines: " + i.ToString();
this.Refresh();
}
DBMNG.Close_Open_Connection();
}
}
public void export()
{
summary.reset();
sifAccessCRUD sif_CRUD_Access = new sifAccessCRUD();
sifCRUD sif_CRUD_APQM = new sifCRUD();
sifDetailCRUD sifDetail_CRUD_APQM = new sifDetailCRUD();
customerCRUD customer_CRUD = new customerCRUD();
MarketSectorCRUD marketSector_CRUD = new MarketSectorCRUD();
bomHeaderAccessCRUD bomHeaderAccess = new bomHeaderAccessCRUD();
bomAccessCRUD bomAccessCRUD = new bomAccessCRUD();
bomCRUD bomCRUD = new bomCRUD();
bomDetailCRUD bomDetailCRUD = new bomDetailCRUD();
itemCRUD item_CRUD = new itemCRUD();
List <SIF> sifsInAPQM;
List <Customer> customersList;
List <MarketSector> marketSectorList;
List <Item> itemList;
int progress = 0;
try
{
//sifsInAccess = (List<SIF>)sif_CRUD_Access.readActive();
sifsInAPQM = (List <SIF>)sif_CRUD_APQM.readAll();
customersList = (List <Customer>)customer_CRUD.readAll();
marketSectorList = (List <MarketSector>)marketSector_CRUD.readAll();
itemList = (List <Item>)item_CRUD.readAll();
}
catch (Exception ex)
{
log = "ERROR: " + ex.Message + "\n\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("ERROR: " + ex.Message + "\n");
summary.totalErrors++;
refreshSummary();
return;
}
if (sifsInAccessToExport.Count > 0)
{
ConnectionManager CM = new ConnectionManager();
Data_Base_MNG.SQL DM = CM.getDataManager();
log = "INFO: Attempting to export " + sifsInAccessToExport.Count + " SIFs.\n\n\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: Found " + sifsInAccessToExport.Count + " SIFs to import.\n");
foreach (SIF sif in sifsInAccessToExport)
{
//if (sif.InquiryNumber == "120629702")
// MessageBox.Show("Here");
log = "INFO: Reading an active SIF: " + sif + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: Reading an active SIF: " + sif + "\n");
//Was this SIF imported before?:
if (sif_CRUD_APQM.readBySIF_IN_List(sif, sifsInAPQM) == null)
{
/*Begin Transaction*/
DM.Open_Connection("ImportingSIF");
//Persisting Customer ***********************************************************************************************************
Customer customer = customer_CRUD.readByNameInList(sif.CustomerName, customersList);
if (customer == null) //Customer does not exist
{
customer = new Customer();
customer.CustomerName = sif.CustomerName;
string idGenerated = customer_CRUD.createAndReturnIdGenerated(customer, ref DM);
if (idGenerated == "")
{
summary.totalErrors++;
log = "ERROR: Could not create Customer: " + customer.CustomerName + " for SIF with Inquiry Number: " + sif.InquiryNumber + "\n" +
"Error Description: " + DM.Error_Mjs + "\n\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
continue;
}
else
{
customer.Id = long.Parse(idGenerated);
log = "INFO: Customer created in APQM database: " + customer.CustomerName + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: Customer created in APQM database: " + customer.CustomerName + "\n");
customersList.Add(customer);
}
}
sif.CustomerKey = customer.Id;
//Persisting Market Sector ******************************************************************************************************
MarketSector marketSector = marketSector_CRUD.readByNameInList(sif.MarketSector, marketSectorList);
if (marketSector == null) //Market Sector does not exist
{
marketSector = new MarketSector();
marketSector.Name = sif.MarketSector;
string idGenerated = marketSector_CRUD.createAndReturnIdGenerated(marketSector, ref DM);
if (idGenerated == "")
{
summary.totalErrors++;
log = "ERROR: Could not create Market Sector: " + marketSector.Name + " for SIF with Inquiry Number: " + sif.InquiryNumber + "\n" +
"Error Description: " + DM.Error_Mjs + "\n\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
continue;
}
else
{
marketSector.Id = long.Parse(idGenerated);
log = "INFO: Market Sector created in APQM database: " + marketSector.Name + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
marketSectorList.Add(marketSector);
}
}
sif.MarketSectorID = marketSector.Id;
//Persisting SIF Header *********************************************************************************************************
log = "INFO: Attempting to export SIF: " + sif + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: Attempting to export SIF: " + sif + "\n");
string sifIDGenerated = sif_CRUD_APQM.createAndReturnIdGenerated(sif, ref DM);
if (sifIDGenerated == "")
{
summary.totalErrors++;
log = "ERROR: Could not export SIF: " + sif + "\n" +
"Error Description: " + DM.Error_Mjs + "\n\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
continue;
}
else
{
sif.Id = long.Parse(sifIDGenerated);
//Persisting SIF Detail ****************************************************************************************************
if (sif.SifDetail.Count > 0)
{
log = "INFO: SIF exported, attempting to export its SIF Detail.\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
if (!sifDetail_CRUD_APQM.saveSIFDetailInSIF(sif, ref DM))
{
summary.totalErrors++;
log = "ERROR: Could not export SIF Detail: " + sif.SifDetail + "\n" +
"Error Description: " + DM.Error_Mjs + "\n\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
continue;
}
}
else
{
log = "INFO: There are no SIF Detail items to export.\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
}
log = "INFO: SIF Detail exported, reading its BOMHeader.\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//Persisting BOM Header *****************************************************************************************************
BOMHeaderAccess bomHeaderByActualSIF = bomHeaderAccess.readBySIF(sif);
if (bomHeaderByActualSIF != null)
{
BOM bomAPQM = new BOM();
bomAPQM.SifId = long.Parse(sifIDGenerated);
//bomAPQM.TopPartNumber = "";
bomAPQM.PartDescription = bomHeaderByActualSIF.PartDescription;
//bomAPQM.Revision = "";
log = "INFO: Attempting to export its BOMHeader: " + bomAPQM + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: Attempting to export its BOMHeader: " + bomAPQM + "\n");
string bomIDGenerated = bomCRUD.createAndReturnIdGenerated(bomAPQM, ref DM);
if (bomIDGenerated == "")
{
summary.totalErrors++;
log = "ERROR: Could not export BOMHeader: " + bomAPQM + "\n" +
"Error Description: " + DM.Error_Mjs + "\n\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
continue;
}
else
{
log = "INFO: BOMHeader exported, reading Bom Lines.\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: BOMHeader exported, reading Bom Lines.\n");
List <BOMAccess> bomsByActualSIF = bomAccessCRUD.readBySIF(sif);
if (bomsByActualSIF.Count > 0)
{
log = "INFO: Found: " + bomsByActualSIF.Count + " BOM lines, attempting to export its Item.\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: Found: " + bomsByActualSIF.Count + " BOM lines, attempting to export its Item.\n");
bool errorInBOM = false;
foreach (BOMAccess bom in bomsByActualSIF)
{
if (bom.ImportComment != "")
{
summary.totalErrors++;
log = "ERROR: " + " BOM: " + bom + "\n" +
"Error Description: " + bom.ImportComment + "\n\n";
log += "INFO: Attempting to RollBack..\n";
DM.RollBack();
if (DM.ErrorOccur)
{
log += "...Fail to RollBack.\n" + "Error Description: " + DM.Error_Mjs + "\n\n";
}
else
{
log += "...RollBack done.\n\n";
}
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
errorInBOM = true;
break;
}
else
{
//Persisting Item Master *******************************************************************************
//if (bom.PartNumber == "26-3706-c")
//{
// MessageBox.Show("here");
//}
Item item = readByPartNumberInList(bom, itemList);
if (item == null)
{
item = new Item();
item.PartNumber = bom.PartNumber;
item.Description = bom.AssemblyDescription; //wont be used anymore
item.Cost = bom.PartCost;
item.Um = bom.Um;
item.Material = bom.Material;
item.CommCode = bom.CommCode;
string itemIDGenerated = item_CRUD.createAndReturnIdGenerated(item, ref DM);
if (itemIDGenerated == "")
{
summary.totalErrors++;
log = "ERROR: Could not export Item: " + item + "\n" +
"Error Description: " + DM.Error_Mjs + "\n\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
errorInBOM = true;
break;
}
else
{
item.Id = long.Parse(itemIDGenerated);
log = "INFO: Item exported: " + item + "\n" + "Attempting to export its BOMLine\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
itemList.Add(item);
}
}
else
{
log = "INFO: Item already exists.\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
}
//Persisting BOM Detail ********************************************************************************
log = "INFO: Attempting to export its BOM Line\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
BOMDetail bomDetail = new BOMDetail();
bomDetail.LinePosition = bom.MaterialPosition;
bomDetail.Material = bom.Material;
bomDetail.Description = bom.AssemblyDescription; //Wont be used anymore
bomDetail.SalesStatus = bom.Status;
bomDetail.Cost = bom.PartCost;
bomDetail.Qty = bom.NoRequired;
bomDetail.Um = bom.Um;
bomDetail.PartNumber = bom.PartNumber;
bomDetail.SalesComments = bom.SalesComments; //wont be used anymore
bomDetail.VendorQuoteEst = bom.VendorQuoteEst;
bomDetail.CapComAssm = bom.CapComAssm;
bomDetail.CommCode = bom.CommCode;
bomDetail.Status = "Imported";
bomDetail.BomHeaderKey = long.Parse(bomIDGenerated);
bomDetail.ItemMasterkey = item.Id;
if (!bomDetailCRUD.create(bomDetail, ref DM))
{
summary.totalErrors++;
log = "ERROR: Could not export BOM Line: " + bomDetail.PartNumber + ", " + bomDetail + " Error: " + DM.Error_Mjs + "\n\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
errorInBOM = true;
break;
}
else
{
log = "INFO: BOM Line exported: " + bomDetail.PartNumber + ", " + bomDetail + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: BOM Line exported: " + bomDetail + "\n");
}
}
}
if (errorInBOM)
{
DM.Close_Open_Connection();
continue;
}
}
else
{
log = "INFO: No BOM Line found for SIF: " + sif + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: No BOM Line found for SIF: " + sif + "\n");
}
}
}
else
{
log = "INFO: No BOM Header found for SIF: " + sif + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("ERROR: Could not export BOM of SIF: " + sif + "\n");
//summary.totalErrors++;
}
}
/* End Transaction */
DM.CommitTransaction();
if (DM.ErrorOccur)
{
log = "ERROR: Could not commit transaction for SIF: " + sif + "\n";
}
else
{
log = "SUCCESS: SIF exported: " + sif + "\n";
}
DM.Close_Open_Connection();
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("SUCCESS: SIF exported: " + sif + "\n");
summary.totalSuccess++;
}
else
{
log = "OMITTED: SIF already exported: " + sif + "\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("OMITTED: SIF already exported: " + sif + "\n");
summary.totalOmitted++;
}
log = "\n";
backgroundWorker1.ReportProgress(++progress);
System.Threading.Thread.Sleep(5);
}
}
else
{
log = "INFO: No more SIF to export.\n\n";
backgroundWorker1.ReportProgress(progress);
System.Threading.Thread.Sleep(5);
//txtLog.AppendText("INFO: No more SIF to export.\n\n");
}
}