public IActionResult DeleteUser(int?id) { User user = _context.Users.Find(id); if (user != null) { _context.Users.Remove(user); _context.SaveChanges(); } return(RedirectToAction("UserTable", "Administration")); }
public bool addAdmin(User user) // đây { if (context.User.Add(user) != null) { user.Role = "ADMIN"; // role này là của Database role của token nó khác nữa context.SaveChanges(); return(true); } ; return(false); }
public void addOrganization(Organization organization) { context.Organization.Add(organization); UserOrganization userOrganization = new UserOrganization(); userOrganization.MemberId = organization.AdminId; userOrganization.StatusMember = "MEMBER"; userOrganization.OrganizationId = organization.Id; userOrganization.CurrentOrganization = false; context.UserOrganization.Add(userOrganization); context.SaveChanges(); }
private void FingerprintClient_OnTouch(FingerPrintClient client, iClockEventArg evt) { try { using (var context = new WorkflowContext()) { var entity = new Domain.Entities.Queue.FingerPrint(); entity.AttState = evt.AttState; entity.EnrolmentNo = evt.EnrollNumber; entity.IP = evt.IP; entity.MachineNo = evt.MachineNo; entity.IsInvalid = evt.IsInValid; entity.MachineDate = evt.CreatedDate; entity.Port = evt.Port; entity.Status = "NOT_QUEUE"; entity.VerifyMethod = evt.VerifyMethod; entity.WorkCode = evt.WorkCode; context.FingerPrints.Add(entity); if (context.ChangeTracker.HasChanges()) { context.SaveChanges(); } SendToRabbitMQ(MessageCommandEnum.PUSH, entity.Id.ToString()); } } catch (Exception ex) { logger.Error(ex.Message, ex); } }
public Checklist addTemplate(Checklist template) { template.TimeCreated = DateTime.UtcNow; _context.Checklist.Add(template); _context.SaveChanges(); return(_context.Checklist.Where(t => t.TimeCreated.Equals(template.TimeCreated) && t.UserId.Equals(template.UserId)).FirstOrDefault()); }
public void AddWorkflow(Workflow workflow) { using(var context = new WorkflowContext()) { context.Workflows.Add(workflow); context.SaveChanges(); } }
public void AddWorkflow(Workflow workflow) { using (var context = new WorkflowContext()) { context.Workflows.Add(workflow); context.SaveChanges(); } }
public T SaveCommit(T entity) { using (var dbContext = new WorkflowContext()) { var repository = dbContext.Set <T>(); repository.Add(entity); dbContext.SaveChanges(); } return(entity); }
public T Update(T entity) { using (var dbContext = new WorkflowContext()) { var repository = dbContext.Set <T>(); repository.Attach(entity); dbContext.Entry(entity).State = EntityState.Modified; dbContext.SaveChanges(); } return(entity); }
private void LogTracks(int workflowRunId, CustomTrackingParticipant tracker) { var tracks = MapTracks(tracker.Records, (t) => { t.WorkflowRunId = workflowRunId; return(t); }); using (WorkflowContext context = new WorkflowContext()) { context.Tracks.AddRange(tracks); context.SaveChanges(); } }
public void inviteMember(int organizationId, string email) { var listMember = getMemberByOrganizationId(organizationId); if (listMember.Where(m => m.Email.Equals(email) && m.Type.Equals("Google")).FirstOrDefault() == null) { var user = context.User.Where(u => u.Email.Equals(email) && u.Type.Equals("Google")).FirstOrDefault(); var userOrganization = new UserOrganization(); userOrganization.CurrentOrganization = false; userOrganization.MemberId = user.Id; userOrganization.StatusMember = "WAITING"; userOrganization.OrganizationId = organizationId; context.UserOrganization.Add(userOrganization); context.SaveChanges(); } }
public void UpdateFingerPrintStatus(string status) { using (var dbContext = new WorkflowContext()) { var fingerPrintMachine = dbContext.FingerPrintMachines.FirstOrDefault(p => p.IP == IP); if (fingerPrintMachine != null) { fingerPrintMachine.LastConnectedDate = DateTime.Now; fingerPrintMachine.Status = status; dbContext.FingerPrintMachines.Attach(fingerPrintMachine); dbContext.Entry(fingerPrintMachine).State = EntityState.Modified; if (dbContext.ChangeTracker.HasChanges()) { dbContext.SaveChanges(); } } } }
public IActionResult DataChange(User user, string newPassword, string confirmPassword) { if (newPassword == null || confirmPassword == null) { _context.Entry(user).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Index", "Home")); } else if (newPassword == confirmPassword && newPassword != null && confirmPassword != null) { user.UPassword = MD5Hash(newPassword); _context.Entry(user).State = EntityState.Modified; _context.SaveChanges(); } return(RedirectToAction("DataChange", "Home")); }
public static void Initialize(WorkflowContext context) { //context.Database.EnsureCreated(); if (context.Campanhas.Any()) { return; } Guid campanhaId = Guid.NewGuid(); Guid workflowId = Guid.NewGuid(); Guid templateId = Guid.NewGuid(); var campanha = new CampanhaWorkflow() { CampanhaId = campanhaId, DataCriacao = DateTime.Now, DataInicio = DateTime.Now, Nome = "Campanha de Teste", Publico = 100, Status = (int)WorkflowStatus.Ready, TemplateId = templateId }; context.Campanhas.AddRange(campanha); if (context.Workflow.Any()) { return; } var workflow = new Workflow() { CampanhaId = campanhaId, Publico = 100, Status = (int)WorkflowStatus.Ready, TemplateId = templateId, WorkflowId = workflowId }; context.Workflow.AddRange(workflow); context.SaveChanges(); }
private void IClockClient_OnConnected() { logger.Info("IClockClient_OnConnected"); IsConnected = true; using (var dbContext = new WorkflowContext()) { var fingerPrintMachine = dbContext.FingerPrintMachines.FirstOrDefault(p => p.IP == IP); if (fingerPrintMachine != null) { fingerPrintMachine.ConnectedDate = DateTime.Now; fingerPrintMachine.Status = STATUS_CONNECTED; dbContext.FingerPrintMachines.Attach(fingerPrintMachine); dbContext.Entry(fingerPrintMachine).State = EntityState.Modified; if (dbContext.ChangeTracker.HasChanges()) { dbContext.SaveChanges(); } } } }
public void addNewTaskItem(TaskItemViewModel taskItem) { var task = new TaskItem(); task.ChecklistId = taskItem.ChecklistId; // task.FormId = taskItem.FormId; task.DueTime = DateTime.ParseExact(taskItem.DueTime, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); //task.DueTime = Convert.ToDateTime(taskItem.DueTime); task.Name = taskItem.Name; task.Priority = taskItem.Priority; task.TaskStatus = taskItem.TaskStatus; // task.FormSubmitted = taskItem.FormSubmitted; // task.FormId = taskItem.FormId; context.TaskItem.Add(task); context.SaveChanges(); }
public TEntity Save(TEntity entity) { DbSet.Add(entity); Db.SaveChanges(); return(entity); }
public IList <TrackingRecord> StartWorkflow(int id, Dictionary <string, object> wfParams) { string fileLocation = null; int workflowRunId = 0; using (var context = new WorkflowContext()) { fileLocation = context.Workflows.First(c => c.Id == id).FileLocation; // Hier kan een NullReferenceException optreden var workflowRun = new WorkflowRun() { WorkflowId = id, StartTime = DateTime.Now }; context.WorkflowRuns.Add(workflowRun); context.SaveChanges(); workflowRunId = workflowRun.WorkflowRunId; } var xamlData = ReadXamlFile(fileLocation); var tracker = new CustomTrackingParticipant(); var wf = ActivityXamlServices.Load(new StringReader(xamlData), new ActivityXamlServicesSettings { CompileExpressions = true }); AutoResetEvent syncEvent = new AutoResetEvent(false); WorkflowApplication wfApp = new WorkflowApplication(wf, wfParams); wfApp.Extensions.Add(tracker); wfApp.Extensions.Add <TextWriter>(() => new StreamWriter(@"C:/XAML/log.txt")); // Handle the desired lifecycle events. Exception exception = null; wfApp.Completed = (e) => syncEvent.Set(); wfApp.OnUnhandledException += (WorkflowApplicationUnhandledExceptionEventArgs e) => { using (WorkflowContext context = new WorkflowContext()) { context.Tracks.Add(new Track() { ActivityName = e.UnhandledException.ToString(), EventTime = DateTime.Now.AddHours(-1), State = "Faulted", WorkflowRunId = workflowRunId, }); context.SaveChanges(); } LogTracks(workflowRunId, tracker); return(UnhandledExceptionAction.Terminate); }; // Start the workflow. wfApp.Run(); syncEvent.WaitOne(); LogTracks(workflowRunId, tracker); return(tracker.Records); }
public IList<TrackingRecord> StartWorkflow(int id, Dictionary<string, object> wfParams) { string fileLocation = null; int workflowRunId = 0; using (var context = new WorkflowContext()) { fileLocation = context.Workflows.First(c => c.Id == id).FileLocation; // Hier kan een NullReferenceException optreden var workflowRun = new WorkflowRun() { WorkflowId = id, StartTime = DateTime.Now }; context.WorkflowRuns.Add(workflowRun); context.SaveChanges(); workflowRunId = workflowRun.WorkflowRunId; } var xamlData = ReadXamlFile(fileLocation); var tracker = new CustomTrackingParticipant(); var wf = ActivityXamlServices.Load(new StringReader(xamlData), new ActivityXamlServicesSettings { CompileExpressions = true }); AutoResetEvent syncEvent = new AutoResetEvent(false); WorkflowApplication wfApp = new WorkflowApplication(wf, wfParams); wfApp.Extensions.Add(tracker); wfApp.Extensions.Add<TextWriter>(() => new StreamWriter(@"C:/XAML/log.txt")); // Handle the desired lifecycle events. Exception exception = null; wfApp.Completed = (e) => syncEvent.Set(); wfApp.OnUnhandledException += (WorkflowApplicationUnhandledExceptionEventArgs e) => { using (WorkflowContext context = new WorkflowContext()) { context.Tracks.Add(new Track() { ActivityName = e.UnhandledException.ToString(), EventTime = DateTime.Now.AddHours(-1), State = "Faulted", WorkflowRunId = workflowRunId, }); context.SaveChanges(); } LogTracks(workflowRunId, tracker); return UnhandledExceptionAction.Terminate; }; // Start the workflow. wfApp.Run(); syncEvent.WaitOne(); LogTracks(workflowRunId, tracker); return tracker.Records; }
private void LogTracks(int workflowRunId, CustomTrackingParticipant tracker) { var tracks = MapTracks(tracker.Records, (t) => { t.WorkflowRunId = workflowRunId; return t; }); using (WorkflowContext context = new WorkflowContext()) { context.Tracks.AddRange(tracks); context.SaveChanges(); } }
/// <summary> /// Save email's data into database /// </summary> /// <param name="item">The email message item</param> /// <returns>The email item</returns> protected EmailItem SaveEmail(EmailMessage item) { if (item == null) { return(null); } using (var context = new WorkflowContext()) { if (context.Database.SqlQuery <int>(string.Format("SELECT TOP 1 1 FROM EMAIL.MAIL_ITEM WHERE UNIQUE_IDENTIFIER = '{0}' COLLATE Latin1_General_CS_AS ", item.Id.UniqueId)).Count() == 0) { var emailitem = new EmailItem(); emailitem.Body = InlineImageUtil.GetHTMLWithInlineImage(item); emailitem.Cc = GetEmailName(item.CcRecipients); emailitem.Originator = item.From.Address; emailitem.Subject = string.IsNullOrEmpty(item.Subject) ? "No Subject" : item.Subject; emailitem.UniqueIdentifier = item.Id.UniqueId; emailitem.Status = EMAIL_STATUS; emailitem.CreatedDate = DateTime.Now; emailitem.Receipient = GetEmailName(item.ToRecipients); emailitem.FileAttachements = new List <FileAttachement>(); if (item.HasAttachments) { foreach (var att in item.Attachments) { att.Load(); if (att.IsInline) { continue; } FileAttachment fileAtt = att as FileAttachment; if (fileAtt != null) { MemoryStream memoryStream = new MemoryStream(); var fileAttachement = new FileAttachement(); fileAttachement.FileName = att.Name; fileAttachement.Ext = Path.GetExtension(att.Name).Replace(".", ""); fileAttachement.CreatedDate = DateTime.Now; fileAtt.Load(memoryStream); fileAttachement.DataContent = memoryStream != null?memoryStream.ToArray() : null; emailitem.FileAttachements.Add(fileAttachement); } } } if (emailitem.FileAttachements.Count == 0) { emailitem.FileAttachements = null; } context.EmailItems.Add(emailitem); if (context.ChangeTracker.HasChanges()) { context.SaveChanges(); } _Logger.Info(emailitem); return(emailitem); } } item.IsRead = true; item.Update(ConflictResolutionMode.AlwaysOverwrite); return(null); }