public void DeleteCase(CaseEntityModel caseentitymodel) { var casedata = _unitOfWork.Repository <Case>().Table().FirstOrDefault(c => c.CaseId == caseentitymodel.CaseId); if (casedata == null) { throw new Exception("Case not found"); } casedata.CaseStatus = caseentitymodel.CaseStatus; casedata.CaseDelete = caseentitymodel.CaseDelete; casedata.CaseLastModifiedBy = caseentitymodel.CaseLastModifiedBy; casedata.CaseLastModifiedDate = DateTime.Now; _unitOfWork.Repository <Case>().Update(casedata); _unitOfWork.Save(); }
public string GetIncrementedGlobalNo(CaseEntityModel model) { var globalno = _unitOfWork.Repository <Case>().Table().OrderByDescending(p => p.CaseId).Select(p => p.CaseGlobalNo).First(); return(globalno); }
public string GetIncrementedCaseNo(CaseEntityModel model) { var lastno = _unitOfWork.Repository <Case>().Table().Where(p => p.CaseUserID == model.CaseUserId).OrderByDescending(p => p.CaseId).Select(p => p.CaseNo).First(); return(lastno); }
public List <Case> GetCasesByUserIdandStatus(CaseEntityModel model) { return(_unitOfWork.Repository <Case>().Table().Where(row => row.CaseUserID == model.CaseUserId && row.CaseStatus == model.CaseStatus).ToList()); }
/// <summary> /// Gets all users. /// </summary> /// <returns></returns> public List <Case> GetAllCasaes(CaseEntityModel model) { return(_unitOfWork.Repository <Case>().Table().Where(c => c.CaseStatus == model.CaseStatus).ToList()); }
public void AddOrUpdateCase(CaseEntityModel caseentitymodel) { if (caseentitymodel.CaseId > 0) { // update var casedata = _unitOfWork.Repository <Case>().Table().FirstOrDefault(c => c.CaseId == caseentitymodel.CaseId); if (casedata == null) { throw new Exception("Case not found"); } casedata.CaseNo = caseentitymodel.CaseNo ?? casedata.CaseNo; casedata.CaseGlobalNo = caseentitymodel.CaseGlobalNo ?? casedata.CaseGlobalNo; casedata.CaseAssignedTo = caseentitymodel.CaseAssignedTo ?? casedata.CaseAssignedTo; casedata.CaseClient = caseentitymodel.CaseClient ?? casedata.CaseClient; casedata.CaseName = caseentitymodel.CaseName ?? casedata.CaseName; casedata.CaseNotes = caseentitymodel.CaseNotes ?? casedata.CaseNotes; casedata.CaseSubjectOfLawsuit = caseentitymodel.CaseSubjectOfLawsuit ?? casedata.CaseSubjectOfLawsuit; casedata.CaseTypeID = caseentitymodel.CaseTypeID ?? casedata.CaseTypeID; casedata.CasePrimaryStatusID = caseentitymodel.CasePrimaryStatusID ?? casedata.CasePrimaryStatusID; casedata.CaseAppealStatusID = caseentitymodel.CaseAppealStatusID ?? casedata.CaseAppealStatusID; casedata.CaseDiscriminationStatusID = caseentitymodel.CaseDiscriminationStatusID ?? casedata.CaseDiscriminationStatusID; casedata.CaseCourtID = caseentitymodel.CaseCourtID ?? casedata.CaseCourtID; casedata.CaseGovNo = caseentitymodel.CaseGovNo ?? casedata.CaseGovNo; casedata.CaseOneNo = caseentitymodel.CaseOneNo ?? casedata.CaseOneNo; casedata.CaseAppealNo = caseentitymodel.CaseAppealNo ?? casedata.CaseAppealNo; casedata.CaseLastNo = caseentitymodel.CaseLastNo ?? casedata.CaseLastNo; casedata.CaseFloorNo = caseentitymodel.CaseFloorNo ?? casedata.CaseFloorNo; casedata.CaseHallNo = caseentitymodel.CaseHallNo ?? casedata.CaseHallNo; casedata.CaseStatus = caseentitymodel.CaseStatus ?? casedata.CaseStatus; casedata.CaseActiveStatus = caseentitymodel.CaseActiveStatus.ToString() ?? casedata.CaseActiveStatus; casedata.CaseDelete = caseentitymodel.CaseDelete ?? casedata.CaseDelete; casedata.CaseLastModifiedDate = DateTime.Now; casedata.CaseLastModifiedBy = 1; _unitOfWork.Repository <Case>().Update(casedata); _unitOfWork.Save(); } else { //insert Mapper.CreateMap <CaseEntityModel, Case>(); var CaseDetails = Mapper.Map <CaseEntityModel, Case>(caseentitymodel); CaseDetails.CaseNo = caseentitymodel.CaseNo; CaseDetails.CaseGlobalNo = caseentitymodel.CaseGlobalNo; CaseDetails.CaseAssignedTo = (long)caseentitymodel.CaseAssignedTo; CaseDetails.CaseClient = caseentitymodel.CaseClient; CaseDetails.CaseName = caseentitymodel.CaseName; CaseDetails.CaseNotes = caseentitymodel.CaseNotes; CaseDetails.CaseSubjectOfLawsuit = caseentitymodel.CaseSubjectOfLawsuit; CaseDetails.CaseTypeID = caseentitymodel.CaseTypeID; CaseDetails.CasePrimaryStatusID = caseentitymodel.CasePrimaryStatusID; CaseDetails.CaseAppealStatusID = caseentitymodel.CaseAppealStatusID; CaseDetails.CaseDiscriminationStatusID = caseentitymodel.CaseDiscriminationStatusID; CaseDetails.CaseCourtID = caseentitymodel.CaseCourtID; CaseDetails.CaseGovNo = caseentitymodel.CaseGovNo; CaseDetails.CaseOneNo = caseentitymodel.CaseOneNo; CaseDetails.CaseAppealNo = caseentitymodel.CaseAppealNo; CaseDetails.CaseLastNo = caseentitymodel.CaseLastNo; CaseDetails.CaseFloorNo = caseentitymodel.CaseFloorNo; CaseDetails.CaseHallNo = caseentitymodel.CaseHallNo; CaseDetails.CaseStatus = caseentitymodel.CaseStatus; CaseDetails.CaseDelete = caseentitymodel.CaseDelete; CaseDetails.CaseActiveStatus = caseentitymodel.CaseActiveStatus.ToString(); CaseDetails.CaseCreatedBy = caseentitymodel.CaseCreatedBy; CaseDetails.CaseCreatedDate = DateTime.Now; _unitOfWork.Repository <Case>().Add(CaseDetails); _unitOfWork.Save(); } }