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