private void BtnSentSTG_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
DataTable dtSTG = (DataTable)dataGridSTG.DataSource;
dt = dtSTG.Copy();
try
{
ListToDT.GenerateExcelShipped(dt);
String message = @"File exported in Path: C:\STG_Excel_Exports\ShippedData_" + DateTime.Now.ToString("MMddyyyy_HH_mm_ss") + ".xlsx";
String caption = "Export Successful";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
catch (Exception ex)
{
String message = "File Generation failed. Message: " + ex.Message;
String caption = "Export Failed";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
}
private System.Data.DataTable JoinTables(System.Data.DataTable daPH, System.Data.DataTable daGP)
{
//System.Data.DataTable daFinal = new System.Data.DataTable();
var joinResults = (from p in daPH.AsEnumerable()
join t in daGP.AsEnumerable()
on p.Field <String>("item_id") equals t.Field <String>("ITEMNMBR")
select new
{
OrderId = p.Field <string>("order_id"),
ItemNumber = p.Field <string>("item_id"),
b_company = p.Field <string>("b_company"),
b_address1 = p.Field <string>("b_address1"),
b_address2 = p.Field <string>("b_address2"),
b_address3 = p.Field <string>("b_address3"),
b_city = p.Field <string>("b_city"),
b_state = p.Field <string>("b_state"),
b_zip = p.Field <string>("b_zip"),
b_country = p.Field <string>("b_country"),
b_contact = p.Field <string>("b_contact"),
b_phone = p.Field <string>("b_phone"),
s_company = p.Field <string>("s_company"),
po_num = p.Field <string>("po_num"),
date_ordered = p.Field <string>("date_ordered"),
cust_id = p.Field <string>("cust_id"),
//pieces_hard = p.Field<string>("pieces_hard"),
store_id = p.Field <string>("store_id"),
ITEMDESC = t.Field <string>("ITEMDESC"),
ITMSHNAM = t.Field <int>("ITMSHNAM")
}).ToList();
return(ListToDT.ToDataTable(joinResults));
}
private static bool GenerateCSV(DataTable dt, string csvFileName)
{
StringBuilder sb = new StringBuilder();
dt = ListToDT.ReadyDataTableForExport(dt);
try
{
if (dt != null)
{
IEnumerable <string> columnNames = dt.Columns.Cast <DataColumn>().
Select(column => column.ColumnName);
sb.AppendLine(string.Join(",", columnNames));
foreach (DataRow row in dt.Rows)
{
IEnumerable <string> fields = row.ItemArray.Select(field => field.ToString().Trim());
sb.AppendLine(string.Join(",", fields));
}
File.WriteAllText(@"C:\3PL_Excel_Exports\CSV\" + csvFileName.Trim(), sb.ToString());
}
else
{
TextHelper.WriteLine("Empty Table Return from GenerateCSV");
return(false);
}
} catch (Exception ex)
{
TextHelper.WriteLine("CSV generation failed with error : " + ex.Message);
}
return(true);
}
private void ProcessInputFile(String FileName)
{
DataTable dt = ListToDT.CSVtoDatatable(FileName);
DgImportInbound.DataSource = dt;
dtImportFile = dt.Copy();
dt.Dispose();
}
//To process input file
private void ProcessInputFile(String FileName)
{
DataTable dt = ListToDT.CSVtoDatatable(FileName);
dtImport = dt.Copy();
//dt = CompareData(dt.Copy());
//HideUneccessaryColumns(dt);
}
//To process input file
private void ProcessInputFile(String FileName)
{
DataTable dt = ListToDT.CSVtoDatatable(FileName);
dtImport = dt.Copy();
DataSet ds = CompareData(dt.Copy());
if (ds.Tables.Contains("Duplicate") && ds.Tables["Duplicate"].Rows.Count > 0)
{
DuplicateData(ds.Tables["Duplicate"]);
String message = @"Duplicate Records Found";
String caption = "Import Successful";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
else
{
String message = @"No Duplicate Rows Found";
String caption = "Import Successful";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
if (ds.Tables.Contains("Result") && ds.Tables["Result"].Rows.Count > 0)
{
HideUneccessaryColumns(ds.Tables["Result"]);
var rows = ds.Tables["Result"].Rows.OfType <DataRow>();
var columnTotal = rows.Sum(r => Convert.ToInt32((r["Shipped"].ToString() == "") ? 0 : int.Parse(r["Shipped"].ToString())));
if (columnTotal == 0)
{
String message = @"No New Records Found";
String caption = "Import Successful";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
else
{
String message = @"New Records Found";
String caption = "Import Successful";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
}
else
{
String message = @"No Records Found";
String caption = "Import Successful";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
}
private void SqlDataLoad_Click(object sender, EventArgs e)
{
try
{
TextHelper.WriteLine("Log Path : " + TextHelper.GetTempPath());
dataGridGP.DataSource = null;
dataGridGP.Update();
dataGridGP.Refresh();
DataTable daPowerhouse = new DataTable();
DataTable daGP = new DataTable();
DataTable daSTG = new DataTable();
DataTable dafinal = new DataTable();
DataTable dtItems = new DataTable();
daPowerhouse = BuildPHQuery();
TextHelper.WriteLine("Data received from Powerhouse");
//Removed 09/20/21. Bringing data in the original Query.
//var itemIds = daPowerhouse.AsEnumerable().Select(r => r.Field<String>("StrItemId")).ToList();
//daGP = BuildGPQuery(itemIds);
//TextHelper.WriteLine("Data received from GP Inventory");
List <StgOrdersCSV> ListOfObjects = daPowerhouse.DataTableToList <StgOrdersCSV>();
//Removed 09/20/21. Bringing data in the original Query.
//ListOfObjects = ListToDT.AddGPDatatoObjects(ListOfObjects, daGP, "Inventory");
var ordernNumber = daPowerhouse.AsEnumerable().Select(r => r.Field <String>("StrCustOrdNumber")).ToList();
daGP = BuildGPSalesQuery(ordernNumber);
TextHelper.WriteLine("Data received from GP Sales ");
ListOfObjects = ListToDT.AddGPDatatoObjects(ListOfObjects, daGP, "Order");
//Add Custom Vendor Numbers============================================================
STGComm sTGComm = new STGComm();
dtItems = sTGComm.GetItemsWithVendorNumber();
ListOfObjects = ListToDT.AddSTGVendorNumberDatatoObjects(ListOfObjects, dtItems, "BBBVendorNumber");
//End adding custom vendor numbres======================================================
// START DATA FILTERATION PROCESS BASED ON STG DB
//Get STG data to filter out old waves
daSTG = GetSTGQuery(ordernNumber);
TextHelper.WriteLine("Data received from STG");
LoadDataTable(daSTG, "Shipped");
//dataGridSTG.Columns.Clear();
//dataGridSTG.DataSource = daSTG;
ListOfObjects = ListToDT.FilterDataFromSTG(ListOfObjects, daSTG);
// END FILTERATION PROCESS
TextHelper.WriteLine("Final Table Loaded");
if (ListOfObjects != null && ListOfObjects.Count > 0)
{
dafinal = ListToDT.ToDataTable <StgOrdersCSV>(ListOfObjects);
LoadDataTable(dafinal, "Orders For Ship");
String message = "Data Loading Completed. Showing New Wave Found in PowerHouse";
String caption = "Loading Successfull";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
else
{
String message = "No New Waves found in Powerhouse";
String caption = "Loading Successfull";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
}
catch (Exception ex)
{
String message = "Error while Getting Data from Powerhouse. Message: " + ex.Message;
String caption = "Data Loading Failed";
MessageBoxButtons buttons = MessageBoxButtons.OK;
MessageBox.Show(message, caption, buttons);
}
//dataGridGP.Columns.Clear();
//dataGridGP.DataSource = dafinal;
}