public void SaveOrUpdate(WFM_ProjectSector projectSector) { using (LinkManagementEntities entities = new LinkManagementEntities()) { if (projectSector.Id == 0) { entities.WFM_ProjectSector.Add(projectSector); entities.SaveChanges(); } else { entities.Entry(projectSector).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); } } }
public void SaveOrUpdate(WFM_Organization organization) { using (LinkManagementEntities entities = new LinkManagementEntities()) { if (organization.Id == 0) { entities.WFM_Organization.Add(organization); entities.SaveChanges(); } else { entities.Entry(organization).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); } } }
public void SaveOrUpdate(WFM_ProjectType designation) { using (LinkManagementEntities entities = new LinkManagementEntities()) { if (designation.Id == 0) { entities.WFM_ProjectType.Add(designation); entities.SaveChanges(); } else { entities.Entry(designation).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); } } }
public void SaveOrUpdate(WFM_SourcingPartner sourcingPartner) { using (LinkManagementEntities entities = new LinkManagementEntities()) { if (sourcingPartner.Id == 0) { entities.WFM_SourcingPartner.Add(sourcingPartner); entities.SaveChanges(); } else { entities.Entry(sourcingPartner).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); } } }
public void SaveOrUpdate(WFM_Contact contact) { using (LinkManagementEntities entities = new LinkManagementEntities()) { if (contact.Id == 0) { entities.WFM_Contact.Add(contact); entities.SaveChanges(); } else { entities.Entry(contact).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); } } }
public static int SaveDataAudit(DataAudit dataAudit) { using (LinkManagementEntities entities = new LinkManagementEntities()) { entities.DataAudits.Add(dataAudit); entities.SaveChanges(); } return(1); }
public static int SaveLoginAudit(LoginAudit loginAudit) { using (LinkManagementEntities entities = new LinkManagementEntities()) { entities.LoginAudits.Add(loginAudit); entities.SaveChanges(); } return(1); }
public void SaveOrUpdate(WFM_Project project) { bool isNew = true; using (LinkManagementEntities entities = new LinkManagementEntities()) { if (project.Id == 0) { project.CurrentDocumentTabId = 1; entities.WFM_Project.Add(project); } else { isNew = false; entities.Entry(project).State = System.Data.Entity.EntityState.Modified; } entities.SaveChanges(); //if (isNew) //{ // WFM_EmailTemplates wFM_EmailTemplate = emailTemplateService.GetEmailTemplateById(1); // var body = wFM_EmailTemplate.Template.Replace("[CODE]", project.Code).Replace("[NAME]", project.Name).Replace("[SECTOR]", ""); // var message = new MailMessage // { // From = new MailAddress(wFM_EmailTemplate.FromEmail) // }; // string[] ToEmails = wFM_EmailTemplate.ToEmails.Split(','); // foreach(string email in ToEmails) // { // message.To.Add(new MailAddress(email)); // } // message.Subject = wFM_EmailTemplate.Subject.Replace("[Project Code]", project.Code); // message.Body = string.Format(body); // EmailHelper.SendEmail(message); //} } }
public ActionResult SaveOrUpdate(WFM_TenderDocumentType model) { string newData = string.Empty, oldData = string.Empty; using (LinkManagementEntities entities = new LinkManagementEntities()) { try { int id = model.Id; WFM_TenderDocumentType tenderDocumentType = null; WFM_TenderDocumentType oldTenderDocumentType = null; if (model.Id == 0) { tenderDocumentType = new WFM_TenderDocumentType { Name = model.Name, IsActive = true }; entities.WFM_TenderDocumentType.Add(tenderDocumentType); entities.SaveChanges(); oldTenderDocumentType = new WFM_TenderDocumentType(); oldData = new JavaScriptSerializer().Serialize(oldTenderDocumentType); newData = new JavaScriptSerializer().Serialize(tenderDocumentType); } else { tenderDocumentType = entities.WFM_TenderDocumentType.Where(o => o.Id == model.Id).SingleOrDefault(); oldTenderDocumentType = entities.WFM_TenderDocumentType.Where(o => o.Id == model.Id).SingleOrDefault(); oldData = new JavaScriptSerializer().Serialize(new WFM_TenderDocumentType() { Id = oldTenderDocumentType.Id, Name = oldTenderDocumentType.Name, IsActive = oldTenderDocumentType.IsActive }); tenderDocumentType.Name = model.Name; bool Example = Convert.ToBoolean(Request.Form["IsActive.Value"]); tenderDocumentType.IsActive = model.IsActive; newData = new JavaScriptSerializer().Serialize(new WFM_TenderDocumentType() { Id = tenderDocumentType.Id, Name = tenderDocumentType.Name, IsActive = tenderDocumentType.IsActive }); entities.Entry(tenderDocumentType).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); } //CommonService.SaveDataAudit(new DataAudit() //{ // Entity = "WFM_TenderDocumentType", // NewData = newData, // OldData = oldData, // UpdatedOn = DateTime.Now, // UserId = new Guid(User.Identity.GetUserId()) //}); TempData["Message"] = "<div id='flash-success'>Record Saved Successfully.</div>"; } catch (Exception ex) { TempData["Message"] = "<span id='flash-error'>Error.</span>" + ex.InnerException; } } return(RedirectToAction("Index", "WFM_TenderDocumentType")); }