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