public void AddEmployee(String ADGUID, String Email, String FirstName, String LastName, String Username, String IsManager, String ManagerID, String EmpNum, int AuditUserID) { Employee emp = new Employee { ADGUID = new Guid(ADGUID), Email = Email, FirstName = FirstName, EmpNum = EmpNum, LastName = LastName, Username = Username, IsManager = Convert.ToBoolean(IsManager) }; if (!String.IsNullOrEmpty(ManagerID) && ManagerID != "0") { emp.ReportsTo = Convert.ToInt32(ManagerID); } db.Employees.Add(emp); db.SaveChanges(); Employees_Log log = new Employees_Log { ADGUID = new Guid(ADGUID), Email = Email, FirstName = FirstName, EmpNum = "", LastName = LastName, Username = Username, IsManager = Convert.ToBoolean(IsManager), EmpID = emp.EmpID, ChangeDate = DateTime.Now, ChangedBy = AuditUserID, ChangeType = "Insert" }; if (!String.IsNullOrEmpty(ManagerID) && ManagerID != "0") { log.ReportsTo = Convert.ToInt32(ManagerID); } db.Employees_Log.Add(log); db.SaveChanges(); }
public void WriteLogonCookie(User user) { FormsAuthenticationTicket tkt; string cookiestr; HttpCookie ck; tkt = new FormsAuthenticationTicket(1, user.Username, DateTime.Now, DateTime.Now.AddMinutes((int)FormsAuthentication.Timeout.TotalMinutes), true, user.Username); cookiestr = FormsAuthentication.Encrypt(tkt); ck = new HttpCookie(FormsAuthentication.FormsCookieName, cookiestr); ck.Path = FormsAuthentication.FormsCookiePath; Response.Cookies.Add(ck); Login login = new Login { LoginDate = DateTime.Now, UserID = user.UserID }; db.Logins.Add(login); db.SaveChanges(); }
public void WriteErrorToLog(String URL, Exception ex, String AdditionalMessage) { try { DataLayer.EPSEntities db = new DataLayer.EPSEntities(); User CurrentUser = (User)System.Web.HttpContext.Current.Session["CurrentUser"]; string ErrorText = string.Format("{2}Error Message: {0}, Inner Exception Message: {1}, Trace Data: {3}", ex.Message, ex.InnerException == null ? "None." : ex.InnerException.Message, AdditionalMessage == "" ? "" : AdditionalMessage + " - ", ex.StackTrace); ErrorLog error = new ErrorLog { ErrorMessage = URL + " - " + ErrorText, Username = CurrentUser == null ? "Not Logged In" : CurrentUser.Username, ErrorDate = DateTime.Now }; db.ErrorLogs.Add(error); db.SaveChanges(); } catch (Exception ex1) { string dummy = ex1.Message; } }
public void RunWorkflow() { WorkflowResult finalResult = new WorkflowResult(); String LastItemRun = ""; int LastRunResultID = 0; try { RunWorkflow run = db.RunWorkflows.Where(r => r.RunID == RunID).FirstOrDefault(); run.StartTime = DateTime.Now; db.SaveChanges(); List <vwRunItem> items = db.vwRunItems.Where(i => i.RunID == RunID).OrderBy(i => i.RunOrder).ToList(); RunPayload pl = run.RunPayloads.FirstOrDefault(); foreach (vwRunItem item in items) { DateTime StartTime = DateTime.Now; LibraryItem li = db.LibraryItems.Where(l => l.ItemID == item.ItemID).FirstOrDefault(); if (!String.IsNullOrEmpty(item.HtmlAnswers)) { pl = util.SetPayload(RunID, li.ItemID, item.HtmlAnswers); } LastItemRun = li.ItemName; WorkflowItem wfi = db.WorkflowItems.Where(w => w.ItemID == item.ItemID).FirstOrDefault(); RunResult rr = new RunResult { ResultString = "", RunID = RunID, ResultID = 1, TimeStarted = DateTime.Now, WFItemID = wfi.WFItemID }; db.RunResults.Add(rr); db.SaveChanges(); LastRunResultID = rr.RunResultID; Assembly assembly = Assembly.LoadFrom(li.LibraryPath); Type type = assembly.GetType("ItemToRun.RunWorkflowItem"); object instanceOfMyType = Activator.CreateInstance(type); var result = type.InvokeMember("RunItem", BindingFlags.Default | BindingFlags.InvokeMethod, null, instanceOfMyType, new Object[] { run.EmpID, pl == null ? new RunPayload() : pl }); IEnumerable <PropertyInfo> props = result.GetType().GetRuntimeProperties(); int ResultID = Convert.ToInt32(props.ElementAt(0).GetValue(result, null)); String ResultText = props.ElementAt(1).GetValue(result, null).ToString(); DateTime TimeDone = Convert.ToDateTime(props.ElementAt(2).GetValue(result, null)); RunResult rrDone = db.RunResults.Where(r => r.RunResultID == rr.RunResultID).FirstOrDefault(); rrDone.TimeCompleted = DateTime.Now; rrDone.ResultID = ResultID; rrDone.ResultString = ResultText; db.SaveChanges(); finalResult = new WorkflowResult { Success = true, ResultString = "" }; } } catch (Exception ex) { finalResult = new WorkflowResult { Success = false, ResultString = String.Format("There was an error during the run in the {0} item.", LastItemRun), FullError = ex }; RunResult rrError = db.RunResults.Where(r => r.RunResultID == LastRunResultID).FirstOrDefault(); rrError.ResultID = 4; rrError.ResultString = String.Format("Error: {0}", ex.Message); rrError.TimeCompleted = DateTime.Now; db.SaveChanges(); } }