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