public async Task updatePublicationDetails(int ReleaseID, int CPID, string FileName) { try { int count = 0; DAL.Models.Employee publishEmp; using (IEmployeeRepository dbEmp = new EmployeeRepository()) { publishEmp = dbEmp.Where(e => e.UserName == User.Identity.Name.Replace("NTNET\\", "")).FirstOrDefault(); } using (IReleaseCPRepository db = new ReleaseCPRepository()) { var publishCP = db.Where(rcp => rcp.ReleaseID == ReleaseID & rcp.CPID == CPID).FirstOrDefault(); if (publishCP != null) { publishCP.PublicationMailDate = DateTime.Now; publishCP.PublicationMail = FileName; publishCP.SendByID = publishEmp.EmployeeID; publishCP.SendByName = publishEmp.FirstName + " " + publishEmp.LastName; publishCP.PublicationCount++; count += await db.SaveAsync((WindowsPrincipal)User); } } } catch (Exception ex) { throw; } }
public async Task <int> AddCPs(int ReleaseID) { IEnumerable <CP> CPs = null; int count = 0; using (ICPRepository db = new CPRepository()) { CPs = db.Get().Where(cp => cp.EffectiveDate <DateTime.Today.Date && cp.ExpirationDate> DateTime.Today.Date && cp.IsDeleted == false); } using (IReleaseCPRepository db = new ReleaseCPRepository()) { IList <ReleaseCP> ReleaseCP = new List <ReleaseCP>(); CPs.ToList().ForEach(cp => ReleaseCP.Add(new ReleaseCP() { CPID = cp.CPID, ReleaseID = ReleaseID, ExceptionIndicator = false, IsDeleted = false })); db.AddRange(ReleaseCP); count += await db.SaveAsync((WindowsPrincipal)User); } return(count); }