/// <summary>
/// Cleans the temp table.
/// </summary>
public void CleanTempTable()
{
try
{
using (var dataContext = new PCSDataContext(Utils.Instance.ConnectionString))
{
// get list of table need to be clean up by current user
var strSql = new StringBuilder();
var listCmd = string.Format(
"SELECT name FROM dbo.sysobjects WHERE xtype = 'U' AND name LIKE 'PRO_IssueMaterialDetail{0}%' AND crdate >= '2010-01-01'",
SystemProperty.UserName);
var tableNames = dataContext.ExecuteQuery <string>(listCmd);
foreach (var tableName in tableNames)
{
strSql.AppendLine(string.Format("DROP TABLE {0};", tableName));
}
if (strSql.Length > 0)
{
dataContext.ExecuteCommand(strSql.ToString());
}
}
}
catch (Exception ex)
{
_logger.Info(string.Format("Could not delete temp table: {0}", ex.Message), ex);
}
}