public void LogToDatabase()
{
//MMD_spLogAutoUpload
SqlService sql = new SqlService(_connection);
sql.AddParameter("@pMessage", System.Data.SqlDbType.VarChar, Message);
try
{
sql.ExecuteSP("MMD_spLogAutoUpload");
}
catch (Exception ex)
{
throw new Exception("AutoUploadLog.LogToDatabase: " + ex.Message);
}
}
/// <summary>
/// MMD_spLogPlanningOfficerMessage
/// </summary>
public void LogMessage()
{
SqlService sql = new SqlService(_connectionString);
sql.AddParameter("@pMessage", System.Data.SqlDbType.VarChar, Message);
sql.AddParameter("@pCustomerMobile", System.Data.SqlDbType.BigInt, CustomerMobile);
sql.AddParameter("@pDateSent", System.Data.SqlDbType.DateTime, DateSent);
try
{
sql.ExecuteSP("MMD_spLogPlanningOfficerMessage");
}
catch (Exception ex)
{
throw new Exception("PlanningOfficerMessage.LogMessage: " + ex.Message + Environment.NewLine + sql.SqlQuery);
}
}
/// <summary>
/// MMD_spUpdateTTReportTime
/// </summary>
/// <param name="connectionString"></param>
public void UpdateOutletReportTime()
{
SqlService sql = new SqlService(_connectionString);
//int timeLen = TTReportTime.Length;
//int insertLen = timeLen - 2;
TTReportTime = TTReportTime.Insert(TTReportTime.Length - 2, ":");
sql.AddParameter("@pOrdIdent", System.Data.SqlDbType.VarChar, TTId.Trim());
sql.AddParameter("@pOutletReported", System.Data.SqlDbType.Time, TTReportTime);
try
{
sql.ExecuteSP("MMD_spUpdateTTReportTime");
}
catch (Exception ex)
{
//Logging.AutoUploadLog log = new Logging.AutoUploadLog(
}
}
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 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 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);
}
}