//IPV Report
//public DataTable GetSKUQC()
//{
// dt = new DataTable();
// string query = "select PROCESSOR, fullname, VALIDATED_BY, SKU_NUMBER, DATE_ADDED, CLIENT, TSHEETS_CLIENT_CODE, DATE_FINISHED, VALIDATED_DATETIME, EDI_VAN from sku left join users on VALIDATED_BY = username left join client on CLIENT = CLIENT_NAME where users.group_num >= 50 and users.ACTIVE =1 and VALIDATED_DATETIME BETWEEN CURDATE() - INTERVAL 1 DAY AND CURDATE() order by VALIDATED_DATETIME";
// if (this.OpenConnection() == true)
// {
// MySqlCommand cmd = new MySqlCommand(query, connection);
// cmd.CommandTimeout = int.MaxValue;
// using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
// {
// da.Fill(dt);
// }
// this.CloseConnection();
// }
// return dt;
//}
private void GetPSL_QC()
{
try
{
dt = new DataTable();
//disbling Service***************
WebReference.Service1 objSku = new WebReference.Service1();
dt = objSku.GetQCPSL();
if (dt.Rows.Count > 0)
{
openConnection();
SqlBulkCopy objbulk = new SqlBulkCopy(con);
objbulk.DestinationTableName = "RTM_PSL_QC";
objbulk.ColumnMappings.Add("PKEY", "PKEY");
objbulk.ColumnMappings.Add("IPN", "IPN");
objbulk.ColumnMappings.Add("client", "client");
objbulk.ColumnMappings.Add("TSHEETS_CLIENT_CODE", "TSHEETS_CLIENT_CODE");
objbulk.ColumnMappings.Add("validatedBy", "validatedBy");
objbulk.ColumnMappings.Add("fullname", "fullname");
objbulk.ColumnMappings.Add("validatedDateTime", "validatedDateTime");
objbulk.WriteToServer(dt);
con.Close();
}
}
catch (Exception ex)
{
WriteToErrorLog(ex.Message, ex.StackTrace, "PSL_QC");
}
}
//IPV-Invoices
private void GetData()
{
try
{
dt = new DataTable();
WebReference.Service1 objSku = new WebReference.Service1();
objSku.Timeout = int.MaxValue;
dt = objSku.GetIPSKU();
if (dt.Rows.Count > 0)
{
dt.Rows.Cast <DataRow>().ToList().ForEach(r => r.SetField("VALIDATED_DATETIME", UpdateTime(Convert.ToDateTime(r["VALIDATED_DATETIME"]))));
openConnection();
SqlBulkCopy objbulk = new SqlBulkCopy(con);
//assigning Destination table name
objbulk.DestinationTableName = "RTM_Sku";
//Mapping Table column
objbulk.ColumnMappings.Add("PROCESSOR", "PROCESSOR");
objbulk.ColumnMappings.Add("fullname", "fullname");
objbulk.ColumnMappings.Add("VALIDATED_BY", "VALIDATED_BY");
objbulk.ColumnMappings.Add("SKU_NUMBER", "SKU_NUMBER");
objbulk.ColumnMappings.Add("DATE_ADDED", "DATE_ADDED");
objbulk.ColumnMappings.Add("CLIENT", "CLIENT");
objbulk.ColumnMappings.Add("TSHEETS_CLIENT_CODE", "TSHEETS_CLIENT_CODE");
objbulk.ColumnMappings.Add("DATE_FINISHED", "DATE_FINISHED");
objbulk.ColumnMappings.Add("VALIDATED_DATETIME", "VALIDATED_DATETIME");
objbulk.ColumnMappings.Add("EDI_VAN", "EDI_VAN");
//inserting bulk Records into DataBase
objbulk.WriteToServer(dt);
con.Close();
}
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message);
WriteToErrorLog(ex.Message, ex.StackTrace, "SKU");
}
}
//CMP Invoices
private void GetCMPData()
{
try
{
dt = new DataTable();
WebReference.Service1 objCMP = new WebReference.Service1();
dt = objCMP.GetCMP();
if (dt.Rows.Count > 0)
{
//dt.Rows.Cast<DataRow>().ToList().ForEach(r => r.SetField("validatedDateBackend", UpdateTime(Convert.ToDateTime(r["validatedDateBackend"]))));
//openDevConnection();
openConnection();
SqlBulkCopy objbulk = new SqlBulkCopy(con);
//assigning Destination table name
objbulk.DestinationTableName = "RTM_CMP";
//Mapping Table column
objbulk.ColumnMappings.Add("invoiceSubId", "invoiceSubId");
objbulk.ColumnMappings.Add("assignedTo", "assignedTo");
objbulk.ColumnMappings.Add("validatedBy", "validatedBy");
objbulk.ColumnMappings.Add("batchDate", "batchDate");
objbulk.ColumnMappings.Add("custAbbr", "custAbbr");
objbulk.ColumnMappings.Add("customer", "customer");
objbulk.ColumnMappings.Add("buildDateBackend", "buildDateBackend");
objbulk.ColumnMappings.Add("validatedDateBackend", "validatedDateBackend");
//inserting bulk Records into DataBase
objbulk.WriteToServer(dt);
con.Close();
//devCon.Close();
}
}
catch (Exception ex)
{
WriteToErrorLog(ex.Message, ex.StackTrace, "CMP");
}
}