public IEnumerable<Advertisment> GetAdvertisments(bool? isactive, DateTime? enddate) { var list = new List<Advertisment>(); using (var entities = new atmEntities()) { var l = from a in entities.tblAdvertisments select a; if (isactive.HasValue) l = l.Where(a => a.IsActive == isactive); if (enddate.HasValue) l = l.Where(a => a.EndDate <= enddate); if (!l.Any()) return list; foreach (var exist in l) { var adv = new Advertisment { Id = exist.Id, AcquisitionId = exist.AcquisitionId ?? 0, CreatedBy = exist.CreatedBy, ServiceCode = exist.ServiceCd, Description = exist.Description, CreatedDate = DateTime.Now, EndDate = exist.EndDate, IntakeLocationId = exist.IntakeLocationId, InterviewLocationId = exist.InterviewLocationId ?? 0, IsActive = exist.IsActive, ShortDescription = exist.ShortDescription, StartDate = exist.StartDate, Title = exist.Title }; list.Add(adv); } } return list; }
public Advertisment GetById(int id) { if (id == 0) return null; using (var entities = new atmEntities()) { var exist = (from a in entities.tblAdvertisments where a.Id == id select a).SingleOrDefault(); if (null == exist) return null; var adv = new Advertisment { Id = exist.Id, AcquisitionId = exist.AcquisitionId ?? 0, CreatedBy = exist.CreatedBy, ServiceCode = exist.ServiceCd, Description = exist.Description, CreatedDate = DateTime.Now, EndDate = exist.EndDate, IntakeLocationId = exist.IntakeLocationId, InterviewLocationId = exist.InterviewLocationId ?? 0, IsActive = exist.IsActive, ShortDescription = exist.ShortDescription, StartDate = exist.StartDate, Title = exist.Title }; return adv; } }
public int Save(Advertisment advertisment) { if (advertisment.Id != 0) return Update(advertisment); using (var entities = new atmEntities()) { var adv = new tblAdvertisment { AcquisitionId = advertisment.AcquisitionId, CreatedBy = advertisment.CreatedBy, ServiceCd = advertisment.ServiceCode, Description = advertisment.Description, CreatedDate = DateTime.Now, EndDate = advertisment.EndDate, IntakeLocationId = advertisment.IntakeLocationId, InterviewLocationId = advertisment.InterviewLocationId, IsActive = advertisment.IsActive, ShortDescription = advertisment.ShortDescription, StartDate = advertisment.StartDate, Title = advertisment.Title }; entities.tblAdvertisments.Add(adv); if (entities.SaveChanges() > 0) return adv.Id; } return 0; }
public int Update(Advertisment advertisment) { if (advertisment.Id == 0) return 0; using (var entities = new atmEntities()) { var exist = (from a in entities.tblAdvertisments where a.Id == advertisment.Id select a).SingleOrDefault(); if (null == exist) return 0; exist.AcquisitionId = advertisment.AcquisitionId; exist.CreatedBy = advertisment.CreatedBy; exist.ServiceCd = advertisment.ServiceCode; exist.Description = advertisment.Description; exist.CreatedDate = DateTime.Now; exist.EndDate = advertisment.EndDate; exist.IntakeLocationId = advertisment.IntakeLocationId; exist.InterviewLocationId = advertisment.InterviewLocationId; exist.IsActive = advertisment.IsActive; exist.ShortDescription = advertisment.ShortDescription; exist.StartDate = advertisment.StartDate; exist.Title = advertisment.Title; entities.SaveChanges(); return exist.Id; } return 0; }
public int Update(Advertisment advertisment) { throw new NotImplementedException(); }