public static void updatePatternAndProcessFile(int PATTERNID, string FILENAME)
{
DateTime now = DateTime.Now;
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
string[] newFileAndPath = TransportHelperFunctions.ProcessFileAndData(FILENAME, "PATTERN");
if (2 == newFileAndPath.Length)
{
using (var scope = new TransactionScope())
{
string sqlCmdText;
//sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
string filepath = ConfigurationManager.AppSettings["fileUploadPath"];
string newFilePath = string.Empty;
newFilePath = filepath + ConfigurationManager.AppSettings["PATTERNPATH"];
newFilePath = newFilePath.Replace("~/", "").Replace('/', '\\');
ChangeLog cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "Patterns", "FileNameOld", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, FILENAME.ToString(), null, "PatternID", PATTERNID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "Patterns", "FileNameNew", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, newFileAndPath[1].ToString(), null, "PatternID", PATTERNID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "Patterns", "FilePath", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, newFileAndPath[0].ToString(), null, "PatternID", PATTERNID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.Patterns " +
"SET FileNameOld = @FileNameOld, FileNameNew = @FileNameNew, FilePath = @FilePath " +
"WHERE PatternID = @PatternID";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@FileNameOld", FILENAME),
new SqlParameter("@FileNameNew", newFileAndPath[1]),
new SqlParameter("@FilePath", newFileAndPath[0]),
new SqlParameter("@PatternID", PATTERNID));
scope.Complete();
}
}
else
{
throw new Exception("renameAndMoveFile returned null or empty string");
}
}
catch (Exception ex)
{
string strErr = " Exception Error in Admin_Patterns updatePatternAndProcessFile(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
throw ex;
}
}
public static string[] ProcessFileAndData(string filename, string strUploadType)
{
try
{
string[] newFileAndPath = TransportHelperFunctions.ProcessFileAndData(filename, strUploadType);
return(newFileAndPath);
}
catch (Exception ex)
{
string strErr = " Exception Error in Admin_Patterns ProcessFileAndData(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
}
return(null);
}
public static Object setNewPatternAndProcessFile(string PATTERNNAME, string FILENAME)
{
Int32 patternID = 0;
List <string> data = new List <string>();
Int32 rowCount;
DateTime now = DateTime.Now;
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
string[] newFileAndPath = TransportHelperFunctions.ProcessFileAndData(FILENAME, "PATTERN");
if (2 == newFileAndPath.Length)
{
using (var scope = new TransactionScope())
{
string sqlCmdText;
//sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT COUNT (*) FROM dbo.Patterns " +
"WHERE PatternName = @PatternName AND isHidden = 'false'";
rowCount = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@PatternName", PATTERNNAME)));
if (rowCount <= 0)
{
sqlCmdText = "INSERT INTO dbo.Patterns (FileNameOld, FileNameNew, FilePath, PatternName, isHidden) VALUES (@FileNameOld, @FileNameNew, @FilePath, @PatternName, 'false'); " +
"SELECT CAST(scope_identity() AS int)";
patternID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@FileNameOld", FILENAME),
new SqlParameter("@FileNameNew", newFileAndPath[1]),
new SqlParameter("@FilePath", newFileAndPath[0]),
new SqlParameter("@PatternName", PATTERNNAME)));
ChangeLog cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "Patterns", "isHidden", now, zxpUD._uid, ChangeLog.ChangeLogDataType.BIT, "'false'", null, "PatternID", patternID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "Patterns", "FileNameOld", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, FILENAME.ToString(), null, "PatternID", patternID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "Patterns", "FileNameNew", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, newFileAndPath[1].ToString(), null, "PatternID", patternID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "Patterns", "PatternName", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, PATTERNNAME.ToString(), null, "PatternID", patternID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "Patterns", "FilePath", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, PATTERNNAME.ToString(), null, "PatternID", patternID.ToString());
cl.CreateChangeLogEntryIfChanged();
data.Add(patternID.ToString());
data.Add(newFileAndPath[0]);
data.Add(newFileAndPath[1]);
}
else
{
throw new Exception("Pattern name already exist");
}
scope.Complete();
}
}
else
{
throw new Exception("renameAndMoveFile returned null or empty string");
}
}
catch (Exception ex)
{
string strErr = " Exception Error in Admin_Patterns setNewPatternAndProcessFile(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
throw ex;
}
return(data);
}
