internal HttpResponseMessage FinishDateTimes(HttpRequestMessage request, FinishTimeDTO cqDTO) { string key; var aur = new AppUserRepository(); var companyId = 0; var userId = aur.ValidateUser(cqDTO.Key, out key, ref companyId); if (userId > 0) { var ur = new FinishTimeRepository(); var u = new FinishTime(); if (cqDTO.FinishDateTime != null) { cqDTO.Start_FinishDateTime = DateTime.Parse(cqDTO.FinishDateTime).ToString(); cqDTO.End_FinishDateTime = DateTime.Parse(cqDTO.FinishDateTime).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_FinishDateTime = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_FinishDateTime = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_FinishDateTime = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_FinishDateTime = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_FinishDateTime = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_FinishDateTime = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString(); } cqDTO.StartDateMonth = null; cqDTO.StartDateYear = null; } var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection<Dictionary<string, string>>(); data = data.GroupBy(x => x.FinishDateTime).Select(x => x.First()).OrderBy(x => x.FinishDateTime).ToList(); foreach (var item in data) { var dic = new Dictionary<string, string>(); dic.Add("FinishDateTime", item.FinishDateTime.ToShortDateString()); col.Add(dic); var ufdic = new Dictionary<string, string>(); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return Request.CreateResponse(HttpStatusCode.OK, retVal); } var message = "validation failed"; return request.CreateResponse(HttpStatusCode.NotFound, message); }
private void UpdateDepartmentTotalFinishTime(FinishTimeDTO uDto) { var pr = new DepartmentTotalRepository(); var prod = new DepartmentTotal(); var prodexists = pr.GetByDateAndDepartment(DateTime.Parse(DateTime.Parse(uDto.FinishDateTime).ToShortDateString()), int.Parse(uDto.DepartmentID)); DateTime fdt = DateTime.Parse(uDto.FinishDateTime); if (prodexists == null) { prod.DepartmentID = int.Parse(uDto.DepartmentID); prod.DTDate = DateTime.Parse(DateTime.Parse(uDto.FinishDateTime).ToShortDateString()); prod.FinishTime = fdt; pr.Save(prod); } else { prod = prodexists; var wbr = new FinishTimeRepository(); List<FinishTime> wbl = wbr.GetByDateAndDepartment(DateTime.Parse(DateTime.Parse(uDto.FinishDateTime).ToShortDateString()), int.Parse(uDto.DepartmentID)); fdt = wbl.Select(x => x.FinishDateTime).FirstOrDefault(); prod.FinishTime = fdt; pr.Save(prod); } }
private HttpResponseMessage ProcessExistingFinishTimeRecord(HttpRequestMessage request, FinishTimeDTO cqDto, int contactId, string key, int FinishTimeId, int userId) { var ur = new FinishTimeRepository(); var user = new FinishTime(); user = ur.GetById(contactId); var validationErrors = GetValidationErrors(ur, user, cqDto, FinishTimeId, userId); if (validationErrors.Any()) { return ProcessValidationErrors(request, validationErrors, key); } //if (cqDto.Remove != null && int.Parse(cqDto.Remove) == 1) //{ // ur.Delete(user); //} else { ur.Save(user); } UpdateDepartmentTotalFinishTime(cqDto); cqDto.Key = key; return request.CreateResponse(HttpStatusCode.Accepted, cqDto); }
private HttpResponseMessage ProcessNewFinishTimeRecord(HttpRequestMessage request, FinishTimeDTO uDto, string key, int FinishTimeId, int userId) { var ur = new FinishTimeRepository(); var user = new FinishTime(); var validationErrors = GetValidationErrors(ur, user, uDto, FinishTimeId, userId); if (validationErrors.Any()) { return ProcessValidationErrors(request, validationErrors, key); } user = ur.Save(user); UpdateDepartmentTotalFinishTime(uDto); uDto.Key = key; uDto.FinishTimeID = user.FinishTimeID.ToString(); var response = request.CreateResponse(HttpStatusCode.Created, uDto); response.Headers.Location = new Uri(Url.Link("Default", new { id = user.FinishTimeID })); return response; }
private List<DbValidationError> GetValidationErrors(FinishTimeRepository pr, FinishTime contact, FinishTimeDTO cqDto, int YieldID, int userId) { contact.ProcessRecord(cqDto); return pr.Validate(contact); }