public void DeleteComplaint(int id) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModel = new ComplaintModel(); Complaint complaint = new Complaint(); complaint = repo.GetAll().Where(x => x.ComplaintId == id).SingleOrDefault(); repo.Delete(x => x.ComplaintId == complaint.ComplaintId); //unitOfWork.Commit(); }
public ComplaintModel GetComplaintByComplaintId(int complaintId) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModel = new ComplaintModel(); Complaint complaint = new Complaint(); complaint = repo.GetAll().Where(x => x.ComplaintId == complaintId).FirstOrDefault(); //unitOfWork.Commit(); AutoMapper.Mapper.Map(complaint, complaintModel); return complaintModel; }
public void DeleteComplaintbyEmployeeId(string id) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModel = new ComplaintModel(); List<Complaint> complaints = new List<Complaint>(); complaints = repo.GetAll().Where(x => x.EmployeeId == id).ToList(); complaints.ForEach(x => { repo.Delete(y => y.ComplaintId == x.ComplaintId); }); //unitOfWork.Commit(); }
public ComplaintModel UpdateComplaint(ComplaintModel model) { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); ComplaintModel complaintModel = new ComplaintModel(); Complaint complaint = new Complaint(); complaint = repo.GetAll().Where(x => x.ComplaintId == model.ComplaintId).FirstOrDefault(); AutoMapper.Mapper.Map(model, complaint); repo.Update(complaint); //unitOfWork.Commit(); return complaintModel; }
public List<ComplaintModel> GetComplaints() { //unitOfWork.StartTransaction(); ComplaintRepository repo = new ComplaintRepository(unitOfWork); List<ComplaintModel> complaintModel = new List<ComplaintModel>(); List<Complaint> complaint = new List<Complaint>(); complaint = repo.GetAll().ToList(); AutoMapper.Mapper.Map(complaint, complaintModel); //var complaints = (from data in db.Complaint // join e in db.Employee on data.EmployeeId equals e.EmployeeId into es // from e in es.DefaultIfEmpty() // join cl in db.Client on data.ClientId equals cl.ClientId into cls // from cl in cls.DefaultIfEmpty() // join ul in db.UserLocation on cl.ClientId equals ul.UserId into uls // from ul in uls.DefaultIfEmpty() // join u in db.Users on cl.ClientId equals u.Id into us // from u in us.DefaultIfEmpty() // join sp in db.ServiceProvider on data.ServiceProviderId equals sp.ServiceProviderId into sps // from sp in sps.DefaultIfEmpty() // join j in db.Job on data.JobId equals j.JobId into js // from j in js.DefaultIfEmpty() // select new // { // ComplainId = data.ComplaintId, // Description = data.Description, // ServiceProviderId = data.ServiceProviderId, // EmployeeName = e.FirstName, // ClientName = cl.FirstName, // ServiceProviderName = sp.CompanyName, // Status = data.Status, // jobDescription = j.Description, // ClientAddress = ul.Address, // JobAddress = j.JobAddress, // ClientPhoneNumber = u.PhoneNumber, // }).OrderByDescending(x=>x.ComplainId).ToList(); //foreach (var item in complaints) //{ // ComplaintModel model = new ComplaintModel(); // model.ComplaintId = item.ComplainId; // model.Description = item.Description; // model.EmployeeName = item.EmployeeName; // model.ClientName = item.ClientName; // model.ServiceProviderName = item.ServiceProviderName; // model.Status = item.Status; // model.JobDescription = item.jobDescription; // model.JobAddress = item.JobAddress; // model.ClientAddress = item.ClientAddress; // model.ClientPhoneNumber = item.ClientPhoneNumber; // complaintModel.Add(model); //} //unitOfWork.Commit(); return complaintModel; }