public void UploadNotAllocated()
{
string sqlNotAllocated = "SELECT [Indent NO], [For Date], [Dealer], [Dlr#], [MSE], [MSEP], [HSDE], [HSDET], [MS], [MSP], [HSD],";
sqlNotAllocated += "[HSDT],[MSEF], [MSEFP], [HSDEF], [HSDEFT], [SKO], [SKOH], [Indent Date], [PAYMENT] ";
BulkLoad load = new BulkLoad(_datasheetPath, WorksheetName.NotAllocated[0], WorksheetName.NotAllocated[1], _connectionString, sqlNotAllocated);
SqlService sql = new SqlService(_connectionString);
try
{
sql.ExecuteSP("MMD_spProcessTmpNotAllocatedOrders");
}
catch (Exception ex)
{
throw new Exception("UploadNotAllocated: " + ex.Message + Environment.NewLine + sql.SqlQuery);
}
}
public void UploadTTIn()
{
BulkLoad load = new BulkLoad(_datasheetPath, WorksheetName.TTIn[0], WorksheetName.TTIn[1], _connectionString, null);
SqlService sql = new SqlService(_connectionString);
try
{
sql.ExecuteSP("MMD_spProcessTTIn");
}
catch (Exception ex)
{
throw new Exception("UploadTTIn: " + ex.Message + Environment.NewLine + sql.SqlQuery);
}
}
public void UploadAllocated()
{
string sqlAllocated = "SELECT [Indent No#], [For Date & Indent Date], [Truck No], [Dealer], [Invoice No], [MSE], [MSEP], [HSDE], [HSDET], [MS], [MSP], [HSD],";
sqlAllocated += "[HSDT],[MSEF], [MSEFP], [HSDEF], [HSDEFT], [SKO], [SKOH] ";
BulkLoad load = new BulkLoad(_datasheetPath, WorksheetName.Allocated[0], WorksheetName.Allocated[1], _connectionString, sqlAllocated);
//run sproc to process temp table into new orders
//MMD_spProcessTmpAllocatedOrders
SqlService sql = new SqlService(_connectionString);
try
{
sql.ExecuteSP("MMD_spProcessTmpAllocatedOrders");
}
catch (Exception ex)
{
throw new Exception("UploadAllocated: " + ex.Message + Environment.NewLine + sql.SqlQuery);
}
}