public string DisableRemark(ComplainRemarkDTO complainRemark) { if (complainRemark == null) { return(GenericMessages.ObjectIsNull); } string stat; var iDbContext = DbContextUtil.GetDbContextInstance(); try { _complainRemarkRepository.Update(complainRemark); _unitOfWork.Commit(); stat = string.Empty; } catch (Exception exception) { stat = exception.Message; } finally { iDbContext.Dispose(); } return(stat); }
public ActionResult AddRemark(string compId) { int complainId = EncryptionUtility.Hash64Decode(compId); var complainRemarkDTO = new ComplainRemarkDTO { AgencyId = Singleton.Agency.Id, Complain = new ComplainDTO() }; if (complainId != 0) { var complainDTO = new ComplainService(true) .GetAll() .ToList() .FirstOrDefault(v => v.Id == complainId); if (complainDTO != null) { complainRemarkDTO.Complain = complainDTO; complainRemarkDTO.ComplainId = complainDTO.Id; complainRemarkDTO.Complain.Remarks = complainDTO.Remarks.OrderByDescending(c => c.RemarkDate).ToList(); complainRemarkDTO.RemarkDate = DateTime.Now; } else { return(RedirectToAction("Index")); } } return(View(complainRemarkDTO)); }
public string InsertOrUpdateRemark(ComplainRemarkDTO complainRemark) { try { var validate = ValidateRemark(complainRemark); if (!string.IsNullOrEmpty(validate)) { return(validate); } if (RemarkObjectExists(complainRemark)) { return(GenericMessages.DatabaseErrorRecordAlreadyExists); } complainRemark.Synced = false; _complainRemarkRepository.InsertUpdate(complainRemark); _unitOfWork.Commit(); return(string.Empty); } catch (Exception exception) { return(exception.Message); } }
public bool DeleteComplainRemarkes(IUnitOfWork sourceUnitOfWork, IUnitOfWork destinationUnitOfWork) { List <ComplainRemarkDTO> addressDtos = sourceUnitOfWork.Repository <ComplainRemarkDTO>() .Query() .Get(-1) .ToList(); foreach (ComplainRemarkDTO source in addressDtos) { ComplainRemarkDTO adr1 = source; var destination = destinationUnitOfWork.Repository <ComplainRemarkDTO>() .Query() .Filter(i => i.RowGuid == adr1.RowGuid) .Get(-1)//don't use .Get() to make sure both sides of data are disabled .FirstOrDefault(); if (destination != null) { sourceUnitOfWork.Repository <ComplainRemarkDTO>().Delete(source.Id); destinationUnitOfWork.Repository <ComplainRemarkDTO>().Delete(destination.Id); sourceUnitOfWork.Commit(); destinationUnitOfWork.Commit(); } } return(true); }
private void ExecuteAddNewComplainViewCommand() { SelectedComplain = new ComplainDTO { AgencyId = Singleton.Agency.Id, ComplainDate = DateTime.Now, Priority = ComplainProrityTypes.Medium, Type = ComplainTypes.DidNotCall, Complain = EnumUtil.GetEnumDesc(ComplainTypes.DidNotCall), Status = ComplainStatusTypes.Opened }; SelectedComplainRemark = new ComplainRemarkDTO { AgencyId = Singleton.Agency.Id, Complain = SelectedComplain }; }
public string ValidateRemark(ComplainRemarkDTO complainRemark) { if (null == complainRemark) { return(GenericMessages.ObjectIsNull); } if (String.IsNullOrEmpty(complainRemark.Remark)) { return(complainRemark.Remark + " " + GenericMessages.StringIsNullOrEmpty); } if (complainRemark.Remark.Length > 255) { return(complainRemark.Remark + " can not be more than 255 characters "); } return(string.Empty); }
public bool RemarkObjectExists(ComplainRemarkDTO complainRemark) { //var objectExists = false; //var iDbContext = DbContextUtil.GetDbContextInstance(); //try //{ // var catRepository = new Repository<ComplainRemarkDTO>(iDbContext); // var catExists = catRepository.Query() // .Filter(bp => bp.FirstName == complainRemark.FirstName && bp.Id != complainRemark.Id && bp.Type == complainRemark.Type) // .Get() // .FirstOrDefault(); // if (catExists != null) // objectExists = true; //} //finally //{ // iDbContext.Dispose(); //} //return objectExists; return(false); }
private void ExcuteSaveRemarkViewCommand(object obj) { try { if (!SaveComplain()) { return; } SelectedComplainRemark.Complain = SelectedComplain; _complainService.InsertOrUpdateRemark(SelectedComplainRemark); GetLiveComplainRemarks(); SelectedComplainRemark = new ComplainRemarkDTO { RemarkDate = DateTime.Now }; } catch { MessageBox.Show("Can't Save Remark"); } }
public ActionResult AddRemark(ComplainRemarkDTO complainRemarkDTO) { try { var complainService = new ComplainService(false); var compDTO = complainService.Find(complainRemarkDTO.ComplainId.ToString()); var complainRemarkDTO2 = new ComplainRemarkDTO { Complain = compDTO, AgencyId = Singleton.Agency.Id, RemarkDate = complainRemarkDTO.RemarkDate, Remark = complainRemarkDTO.Remark }; complainService.InsertOrUpdateRemark(complainRemarkDTO2); return(RedirectToAction("Index")); } catch { return(View()); } }
public bool SyncComplainRemarks(IUnitOfWork sourceUnitOfWork, IUnitOfWork destinationUnitOfWork) { Expression <Func <ComplainRemarkDTO, bool> > filter = a => !a.Synced && a.DateLastModified > LastServerSyncDate; if (!ToServerSyncing) { Expression <Func <ComplainRemarkDTO, bool> > filter2 = a => a.Agency != null && a.Agency.RowGuid == Singleton.Agency.RowGuid; filter = filter.And(filter2); } var sourceList = sourceUnitOfWork.Repository <ComplainRemarkDTO>().Query() .Include(a => a.Complain, a => a.Agency) .Filter(filter) .Get(1) .ToList(); var destLocalAgencies = destinationUnitOfWork.Repository <AgencyDTO>().Query() .Filter(a => a.Id == Singleton.Agency.Id) .Get(1) .ToList(); if (sourceList.Any()) { _updatesFound = true; var destEmployees = destinationUnitOfWork.Repository <ComplainDTO>().Query() .Filter(a => a.AgencyId == Singleton.Agency.Id) .Get(1) .ToList(); var destList = destinationUnitOfWork.Repository <ComplainRemarkDTO>().Query() .Filter(a => a.AgencyId == Singleton.Agency.Id) .Include(a => a.Complain) .Get(1) .ToList(); foreach (var source in sourceList) { var destination = destList.FirstOrDefault(i => i.RowGuid == source.RowGuid); //To Prevent ServerData Overriding if (destination == null) { destination = new ComplainRemarkDTO(); } else if (ToServerSyncing && !destination.Synced) { continue; } try { Mapper.Reset(); Mapper.CreateMap <ComplainRemarkDTO, ComplainRemarkDTO>() .ForMember("Agency", option => option.Ignore()) .ForMember("AgencyId", option => option.Ignore()) .ForMember("Id", option => option.Ignore()) .ForMember("Complain", option => option.Ignore()) .ForMember("Synced", option => option.Ignore()); destination = Mapper.Map(source, destination); destination.CreatedByUserId = GetDestCreatedModifiedByUserId(source.CreatedByUserId, sourceUnitOfWork, destinationUnitOfWork); destination.ModifiedByUserId = GetDestCreatedModifiedByUserId(source.ModifiedByUserId, sourceUnitOfWork, destinationUnitOfWork); } catch (Exception ex) { LogUtil.LogError(ErrorSeverity.Critical, "SyncComplainRemarks Mapping", ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency); } try { #region Foreign Keys var agencyDTO = destLocalAgencies.FirstOrDefault( c => source.Agency != null && c.RowGuid == source.Agency.RowGuid); { destination.Agency = agencyDTO; destination.AgencyId = agencyDTO != null ? agencyDTO.Id : (int?)null; } var employeeDto = destEmployees.FirstOrDefault( c => source.Complain != null && c.RowGuid == source.Complain.RowGuid); { destination.Complain = employeeDto; destination.ComplainId = employeeDto != null ? employeeDto.Id : 1; } #endregion destination.Synced = true; destinationUnitOfWork.Repository <ComplainRemarkDTO>() .InsertUpdate(destination); } catch { _errorsFound = true; LogUtil.LogError(ErrorSeverity.Critical, "SyncComplainRemarks Crud", "Problem On SyncComplainRemarks Crud Method", UserName, Agency); return(false); } } var changes = destinationUnitOfWork.Commit(); if (changes < 0) { _errorsFound = true; LogUtil.LogError(ErrorSeverity.Critical, "SyncComplainRemarks Commit", "Problem Commiting SyncComplainRemarks Method", UserName, Agency); return(false); } } return(true); }