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