internal HttpResponseMessage TranslatedTermDetail(HttpRequestMessage request, TranslatedTermDTO cqDTO) { var ur = new TranslatedTermRepository(); var u = new TranslatedTerm(); var data = ur.GetById(int.Parse(cqDTO.TranslationID)); var col = new Collection <Dictionary <string, string> >(); var dic = new Dictionary <string, string>(); dic.Add("TranslationID", data.TranslationID.ToString()); dic.Add("TermTranslated", data.TermTranslated); dic.Add("EnglishTermID", data.EnglishTermID.ToString()); dic.Add("LanguageID", data.LanguageID.ToString()); dic.Add("Term", data.EnglishTerm.Term.ToString()); col.Add(dic); var retVal = new GenericDTO { ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); }
internal HttpResponseMessage DepartmentDates(HttpRequestMessage request, DepartmentTotalDTO 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 DepartmentTotalRepository(); var u = new DepartmentTotal(); if (cqDTO.DTDate != null) { cqDTO.Start_DTDate = DateTime.Parse(cqDTO.DTDate).ToString(); cqDTO.End_DTDate = DateTime.Parse(cqDTO.DTDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_DTDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_DTDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_DTDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_DTDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_DTDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_DTDate = 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); data = data.GroupBy(x => x.DTDate).Select(x => x.First()).OrderBy(x => x.DTDate).ToList(); var col = new Collection <Dictionary <string, string> >(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("DTDate", item.DTDate.ToShortDateString()); col.Add(dic); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(request.CreateResponse(HttpStatusCode.NotFound, message)); }
public static bool logar(string usuario, string senha, out string erro) { try { erro = ""; var json = WebService.downloadJson("/Usuario/recuperar"); GenericDTO dto = JsonConvert.DeserializeObject <GenericDTO>(json); dto.payload = ((JArray)dto.payload).ToObject <List <Usuario> >(); foreach (Usuario user in (List <Usuario>)dto.payload) { if (user.login.Equals(usuario) && user.senha.Equals(senha)) { logado = true; usuarioLogado = user; return(logado); } else { erro = "Login ou Senha Inválidos!"; } } } catch (Exception e) { erro = e.Message; } return(false); }
internal HttpResponseMessage UserDetail(HttpRequestMessage request, UserDTO 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 UserRepository(); var u = new User(); var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection <Dictionary <string, string> >(); string ufarms = ""; string uroles = ""; foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("UserId", item.UserId.ToString()); dic.Add("FirstName", item.FirstName); dic.Add("LastName", item.LastName); dic.Add("EmailAddress", item.EmailAddress); dic.Add("Phone", item.Phone); dic.Add("StatusId", item.StatusId.ToString()); foreach (var farmitem in item.UserFarms) { ufarms = ufarms + farmitem.FarmId.ToString() + ","; } if (ufarms.Length > 0) { //ufarms = ufarms.Remove(uroles.Length - 1); dic.Add("Farms", ufarms); } foreach (var roleitem in item.UserRoles) { uroles = uroles + roleitem.RoleId.ToString() + ","; } if (uroles.Length > 0) { //uroles = uroles.Remove(uroles.Length - 1) ; dic.Add("Roles", uroles); } col.Add(dic); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(request.CreateResponse(HttpStatusCode.NotFound, message)); }
/// <summary> /// Returns the User as a DTO /// </summary> /// <returns>User represented as a DTO</returns> public GenericDTO toDTO() { GenericDTO dto = new GenericDTO("User"); dto.put("1", auth); return(dto); }
internal HttpResponseMessage ShiftEnds(HttpRequestMessage request, ShiftEndDTO 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 ShiftEndRepository(); var u = new ShiftEnd(); if (cqDTO.ShiftDate != null) { cqDTO.Start_ShiftDate = DateTime.Parse(cqDTO.ShiftDate).ToString(); cqDTO.End_ShiftDate = DateTime.Parse(cqDTO.ShiftDate).AddDays(1).ToString(); } var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); data = data.OrderBy(x => x.ShiftDate).ToList(); var col = new Collection <Dictionary <string, string> >(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("ShiftEndID", item.ShiftEndID.ToString()); dic.Add("DayFinishedFreezing", item.DayFinishedFreezing == null ? "" : DateTime.Parse(item.DayFinishedFreezing.ToString()).ToString("HH:mm")); dic.Add("DayShiftFroze", item.DayShiftFroze == null ? "" : item.DayShiftFroze.ToString()); dic.Add("DowntimeMinutes", item.DowntimeMinutes == null ? "" : item.DowntimeMinutes.ToString()); dic.Add("EmployeesOnVacation", item.EmployeesOnVacation == null ? "" : item.EmployeesOnVacation.ToString()); dic.Add("FilletScaleReading", item.FilletScaleReading == null ? "" : item.FilletScaleReading.ToString()); dic.Add("FinishedFillet", item.FinishedFillet == null ? "" : DateTime.Parse(item.FinishedFillet.ToString()).ToString("HH:mm")); dic.Add("FinishedKill", item.FinishedKill == null ? "" : DateTime.Parse(item.FinishedKill.ToString()).ToString("HH:mm")); dic.Add("FinishedSkinning", item.FinishedSkinning == null ? "" : DateTime.Parse(item.FinishedSkinning.ToString()).ToString("HH:mm")); dic.Add("InmateLeftEarly", item.InmateLeftEarly == null ? "" : item.InmateLeftEarly.ToString()); dic.Add("InLateOut", item.InLateOut == null ? "" : item.InLateOut.ToString()); dic.Add("NightFinishedFreezing", item.NightFinishedFreezing == null ? "" : DateTime.Parse(item.NightFinishedFreezing.ToString()).ToString("HH:mm")); dic.Add("NightShiftFroze", item.NightShiftFroze == null ? "" : item.NightShiftFroze.ToString()); dic.Add("RegEmpLate", item.RegEmpLate == null ? "" : item.RegEmpLate.ToString()); dic.Add("RegEmpOut", item.RegEmpOut == null ? "" : item.RegEmpOut.ToString()); dic.Add("RegEmplLeftEarly", item.RegEmplLeftEarly == null ? "" : item.RegEmplLeftEarly.ToString()); dic.Add("ShiftDate", item.ShiftDate == null ? "" : item.ShiftDate.ToString()); dic.Add("TempEmpOut", item.TempEmpOut == null ? "" : item.TempEmpOut.ToString()); 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)); }
public HttpResponseMessage PondMortalityLast7Mortalities([FromBody] PondDTO uDto) { string key; var ur = new AppUserRepository(); var companyId = 0; var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId); AppUserRoleRepository aur = new AppUserRoleRepository(); if (UserId > 0 && aur.IsInRole(UserId, "Chowtime")) { var pr = new PondRepository(); var ponddata = pr.GetById(int.Parse(uDto.PondId)); DateTime startdate = DateTime.Now; int i = 0; int j = 0; int pondDataCount = 0; var col = new Collection <Dictionary <string, string> >(); while (pondDataCount < 7 && j < 10) { var db = new AppEntities(); string datepart = startdate.AddDays(i).ToShortDateString(); DateTime begindate = DateTime.Parse(datepart); DateTime enddate = begindate.AddDays(1); var data = db.Mortalities.Where(x => x.PondId == ponddata.PondId && x.MortalityDate >= begindate && x.MortalityDate < enddate).FirstOrDefault(); if (data != null) { var dic = new Dictionary <string, string>(); dic.Add("PondId", data.PondId.ToString()); dic.Add("MortalityId", data.MortalityId.ToString()); dic.Add("MortalityDate", data.MortalityDate.ToString()); dic.Add("MortalityPounds", data.MortalityPounds.ToString()); col.Add(dic); pondDataCount++; // reset j - haven't hit null territory yet j = 0; } else { j++; } i--; } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
protected static HttpResponseMessage ProcessValidationErrors(HttpRequestMessage request, Collection <Dictionary <string, string> > validationErrors, string key) { var retVal = new GenericDTO { Key = key, ReturnData = validationErrors }; return(request.CreateResponse(HttpStatusCode.BadRequest, retVal)); }
public HttpResponseMessage WeekDataAddOrEdit([FromBody] WeekDataDTO uDto) { string key; var ur = new AppUserRepository(); var AbsenceId = 0; var userId = ur.ValidateUser(uDto.Key, out key, ref AbsenceId); AppUserRoleRepository aur = new AppUserRoleRepository(); if (userId > 0) { var wer = new AD_WeekDataRepository(); var WeekEndDate = DateTime.Parse(uDto.AD_WeekEnd); var data = wer.GetByDate(WeekEndDate); if (data.Count == 0) { var prodData = wer.GetAllProducts(); foreach (var prod in prodData) { var wkData = new AD_WeekData(); wkData.AD_ProductID = prod; wkData.AD_WeekEnd = WeekEndDate; wer.Save(wkData); } data = wer.GetByDate(WeekEndDate); } var col = new Collection <Dictionary <string, string> >(); data = data.OrderBy(x => x.AD_Products.AD_GroupID).ToList(); foreach (var wd in data) { var dic = new Dictionary <string, string>(); dic.Add("AD_ProductID", wd.AD_ProductID.ToString()); dic.Add("ProductName", wd.AD_Products.AD_ProductName); dic.Add("BudgetLbs", wd.AD_BudgetLbs != null ? wd.AD_BudgetLbs.ToString() : "0"); dic.Add("BudgetDollars", wd.AD_BudgetDollars != null ? wd.AD_BudgetDollars.ToString() : "0"); dic.Add("ActualLbs", wd.AD_ActualLbs != null ? wd.AD_ActualLbs.ToString() : "0"); dic.Add("ActualDollars", wd.AD_ActualDollars != null ? wd.AD_ActualDollars.ToString() : "0"); dic.Add("AD_WeekDataID", wd.AD_WeekDataID.ToString()); col.Add(dic); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
public void testToDTO() { Console.WriteLine("toDTO"); Authentication auth1 = new Auth("username", "email", "password"); User u1 = new User(auth1); GenericDTO dto = new GenericDTO("User"); dto.put("1", auth1); Assert.True(dto.get("1").Equals(u1.toDTO().get("1"))); }
public static void AddResearch(GenericDTO dto) { var research = new Research(); research.SetName(dto[NAME_FIELD].ToString()); research.SetTimeToResearch(ToUlong(dto[TIMETORESEARCH_FIELD])); research.SetCostToResearch(ToUlong(dto[COSTTORESEARCH_FIELD])); research.SetPrerequisites(ToList(dto[PREREQUISITES_FIELD])); string key = dto[KEY_FIELD].ToString(); _research[key] = research; }
public HttpResponseMessage PondO2ByDate([FromBody] O2ReadingDTO uDto) { string key; var ur = new AppUserRepository(); var companyId = 0; var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId); //string dayperiod; //if (DateTime.Parse(uDto.ReadingDate).Hour < 12) //{ // dayperiod = DateTime.Parse(uDto.ReadingDate).AddDays(-1).ToShortDateString(); //} //else //{ // dayperiod = DateTime.Parse(uDto.ReadingDate).ToShortDateString(); //} //uDto.DayPeriod = dayperiod; AppUserRoleRepository aur = new AppUserRoleRepository(); if (UserId > 0 && aur.IsInRole(UserId, "Airtime")) { var O2r = new O2ReadingRepository(); var u = new O2Reading(); //var predicate = O2r.GetPredicate(uDto, u, companyId); var data = O2r.GetPondO2ReadingsByDate(int.Parse(uDto.PondId), DateTime.Parse(uDto.ReadingDate)); var col = new Collection <Dictionary <string, string> >(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("PondId", item.PondId.ToString()); dic.Add("ReadingId", item.ReadingId.ToString()); dic.Add("ReadingDate", item.ReadingDate.ToString()); dic.Add("O2Level", item.O2Level.ToString()); dic.Add("StaticCount", item.StaticCount.ToString()); dic.Add("PortableCount", item.PortableCount.ToString()); dic.Add("Note", item.Note); dic.Add("PondStatus", item.Pond.HealthStatus.ToString()); col.Add(dic); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
public ActionResult List() { if (sessao.usuarioLogado != null) { var jsonPastas = WebService.downloadJson("/Pasta/recuperarPorIdUsuario/" + sessao.usuarioLogado.id.ToString()); GenericDTO dto = JsonConvert.DeserializeObject <GenericDTO>(jsonPastas); dto.payload = ((JArray)dto.payload).ToObject <List <Pasta> >(); ViewBag.json_pastas = PastaJsonConverter.pastaConverter(((List <Pasta>)dto.payload)); } ViewBag.tela = 0; return(View()); }
public HttpResponseMessage PondFeedLast7Days([FromBody] PondDTO uDto) { string key; var ur = new AppUserRepository(); var companyId = 0; var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId); AppUserRoleRepository aur = new AppUserRoleRepository(); if (UserId > 0 && aur.IsInRole(UserId, "Chowtime")) { var pr = new PondRepository(); var ponddata = pr.GetById(int.Parse(uDto.PondId)); DateTime startdate = DateTime.Now; int i = 0; var col = new Collection <Dictionary <string, string> >(); while (i > -7) { var fr = new FeedingRepository(); var data = fr.GetPondFeedingsByDate(ponddata.PondId, startdate.AddDays(i)); if (data != null) { var dic = new Dictionary <string, string>(); dic.Add("PondId", data.PondId.ToString()); dic.Add("FeedingId", data.FeedingId.ToString()); dic.Add("FeedDate", data.FeedDate.ToString()); dic.Add("PoundsFed", data.PoundsFed.ToString()); col.Add(dic); } i--; } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
protected static HttpResponseMessage ProcessValidationErrors(HttpRequestMessage request, List <DbValidationError> validationErrors, string key) { var col = new Collection <Dictionary <string, string> >(); foreach (var dic in validationErrors.Select(err => new Dictionary <string, string> { { "FieldWithError", err.PropertyName }, { "Error", err.ErrorMessage } })) { col.Add(dic); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(request.CreateResponse(HttpStatusCode.BadRequest, retVal)); }
internal HttpResponseMessage FarmYieldHeaders(HttpRequestMessage request, FarmYieldHeaderDTO 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 FarmYieldHeaderRepository(); var u = new FarmYieldHeader(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddHours(-1).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddHours(1).ToString(); } var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection <Dictionary <string, string> >(); data = data.OrderBy(x => x.YieldDate).ToList(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("FarmYieldHeaderID", item.FarmYieldHeaderID.ToString()); dic.Add("YieldDate", item.YieldDate.ToShortDateString()); dic.Add("PlantWeight", item.PlantWeight.ToString()); dic.Add("WeighBacks", item.WeighBacks.ToString()); 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)); }
//Metodo de criar public ActionResult Create() { //Recuperar Lista de Topicos //Recuperar Lista de Tipos try { #region WsTopicos String jsonRecebido = WebService.downloadJson("/AtributosNotas/recuperarTopico"); GenericDTO dtoTopico = JsonConvert.DeserializeObject <GenericDTO>(jsonRecebido); dtoTopico.payload = ((JArray)dtoTopico.payload).ToObject <List <Topico> >(); jsonRecebido = WebService.downloadJson("/AtributosNotas/recuperarTipo"); GenericDTO dtoTipo = JsonConvert.DeserializeObject <GenericDTO>(jsonRecebido); dtoTipo.payload = ((JArray)dtoTipo.payload).ToObject <List <Tipo> >(); if (dtoTopico.operacaoSucedida && dtoTipo.operacaoSucedida) { listaTopico = (List <Topico>)dtoTopico.payload; listaTipo = (List <Tipo>)dtoTipo.payload; } else { Response.Write(dtoTopico.mensagemErro); return(new EmptyResult()); } #endregion } catch (Exception e) { Response.Write("Erro!:" + e.Message); return(View()); } ViewBag.ListaTipo = listaTipo; ViewBag.ListaTopico = listaTopico; ViewBag.tela = 1; return(View()); }
public List <GenericDTO> GetAllGeneric(GenericDTO generic) { RepList <GenericDTO> listGenero = new RepList <GenericDTO>(); string query = string.Empty; string whereClause = " WHERE 1 = 1 "; query += "SELECT "; switch (generic.dominio) { case domains.Perfil: query += " idGeneric = idPerfil, descGeneric = descPerfil "; query += " FROM TB_Perfis A "; break; case domains.Genero: query += " idGeneric = idGenero, descGeneric = descGenero "; query += " FROM TB_Generos A "; break; case domains.TipoPessoa: query += " idGeneric = idTipoPessoa, descGeneric = descTipoPessoa "; query += " FROM TB_TipoPessoas A "; break; default: break; } if (generic.flagAtivo == true) { whereClause += " and A.flagAtivo = 1"; } else if (generic.flagAtivo == false) { whereClause += " and A.flagAtivo = 0"; } query += whereClause; return(listGenero.GetDataInDatabase(query)); }
public HttpResponseMessage GetLastPondReading([FromBody] O2ReadingDTO uDto) { string key; var ur = new AppUserRepository(); var companyId = 0; var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId); AppUserRoleRepository aur = new AppUserRoleRepository(); if (UserId > 0 && aur.IsInRole(UserId, "Airtime")) { var O2r = new O2ReadingRepository(); var u = new O2Reading(); //var predicate = O2r.GetPredicate(uDto, u, companyId); var data = O2r.GetLastPondReadingByPond(int.Parse(uDto.PondId)); var col = new Collection <Dictionary <string, string> >(); var dic = new Dictionary <string, string>(); dic.Add("PondId", data.PondId.ToString()); dic.Add("ReadingId", data.ReadingId.ToString()); dic.Add("ReadingDate", data.ReadingDate.ToString()); dic.Add("O2Level", data.O2Level.ToString()); dic.Add("StaticCount", data.StaticCount.ToString()); dic.Add("PortableCount", data.PortableCount.ToString()); dic.Add("Note", data.Note); col.Add(dic); var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
internal HttpResponseMessage Users(HttpRequestMessage request, UserDTO 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 UserRepository(); var u = new User(); cqDTO.CompanyId = companyId.ToString(); var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection <Dictionary <string, string> >(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("UserId", item.UserId.ToString()); dic.Add("FirstName", item.FirstName); dic.Add("LastName", item.LastName); dic.Add("EmailAddress", item.EmailAddress); dic.Add("Phone", item.Phone); dic.Add("StatusId", item.StatusId.ToString()); 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)); }
internal HttpResponseMessage TranslatedTerms(HttpRequestMessage request, TranslatedTermDTO cqDTO) { var ur = new TranslatedTermRepository(); var u = new TranslatedTerm(); var data = ur.GetTranslatedTerms(int.Parse(cqDTO.LanguageID)); var er = new EnglishTermRepository(); var eterms = er.GetEnglishTerms(); var col = new Collection <Dictionary <string, string> >(); foreach (var item in eterms) { var tTerm = data.Where(x => x.EnglishTermID == item.EnglishTermID).FirstOrDefault(); var dic = new Dictionary <string, string>(); dic.Add("EnglishTermID", item.EnglishTermID.ToString()); dic.Add("LanguageID", cqDTO.LanguageID); dic.Add("Term", item.Term.ToString()); if (tTerm == null) { dic.Add("TranslationID", "-1"); dic.Add("TermTranslated", ""); } else { dic.Add("TranslationID", tTerm.TranslationID.ToString()); dic.Add("TermTranslated", tTerm.TermTranslated); } col.Add(dic); } var retVal = new GenericDTO { ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); }
internal HttpResponseMessage EnglishTerms(HttpRequestMessage request, EnglishTermDTO cqDTO) { var ur = new EnglishTermRepository(); var u = new EnglishTerm(); var data = ur.GetEnglishTerms(); var col = new Collection <Dictionary <string, string> >(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("EnglishTermID", item.EnglishTermID.ToString()); dic.Add("Term", item.Term); dic.Add("BeforeOrAfter", item.BeforeOrAfter); col.Add(dic); } var retVal = new GenericDTO { ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); }
internal HttpResponseMessage Languages(HttpRequestMessage request, LanguageDTO cqDTO) { var ur = new LanguageRepository(); var u = new Language(); var data = ur.GetLanguages(); var col = new Collection <Dictionary <string, string> >(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("LanguageId", item.LanguageID.ToString()); dic.Add("LanguageName", item.LanguageName); dic.Add("CSSFileName", item.CssFileName); col.Add(dic); } var retVal = new GenericDTO { ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); }
public HttpResponseMessage AllRoles([FromBody] UserDTO uDto) { string key; var ur = new AppUserRepository(); var companyId = 0; var userId = ur.ValidateUser(uDto.Key, out key, ref companyId); if (userId > 0) { var user = new User(); var errors = ValidateDtoData(uDto, user); if (errors.Any()) { return(ProcessValidationErrors(Request, errors, key)); } var col = new Collection <Dictionary <string, string> >(); var pr = new RoleRepository(); var data = pr.GetRoles(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("RoleId", item.RoleId.ToString()); dic.Add("RoleName", item.RoleName); col.Add(dic); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
public HttpResponseMessage MortalityById([FromBody] MortalityDTO uDto) { string key; var ur = new AppUserRepository(); var companyId = 0; var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId); AppUserRoleRepository aur = new AppUserRoleRepository(); if (UserId > 0 && aur.IsInRole(UserId, "Chowtime")) { var O2r = new AppEntities(); var data = O2r.Mortalities.Find(int.Parse(uDto.MortalityId)); var col = new Collection <Dictionary <string, string> >(); var dic = new Dictionary <string, string>(); dic.Add("PondId", data.PondId.ToString()); dic.Add("MortalityId", data.MortalityId.ToString()); dic.Add("MortalityDate", data.MortalityDate.ToString()); dic.Add("MortalityPoundsd", data.MortalityPounds.ToString()); col.Add(dic); var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
internal HttpResponseMessage DownTimes(HttpRequestMessage request, DownTimeDTO 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 DownTimeRepository(); var u = new DownTime(); if (cqDTO.DownTimeDate != null) { cqDTO.Start_DownTimeDate = DateTime.Parse(cqDTO.DownTimeDate).ToString(); cqDTO.End_DownTimeDate = DateTime.Parse(cqDTO.DownTimeDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_DownTimeDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_DownTimeDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_DownTimeDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_DownTimeDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_DownTimeDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_DownTimeDate = 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.OrderBy(x => x.DownTimeDate).ToList(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("DownTimeID", item.DownTimeID.ToString()); dic.Add("DepartmentID", item.DownTimeType.DepartmentID.ToString()); dic.Add("DepartmentName", item.DownTimeType.Department.DepartmentName); dic.Add("DownTimeDate", item.DownTimeDate.ToShortDateString()); dic.Add("DownTimeTypeID", item.DownTimeTypeID.ToString()); dic.Add("DownTimeType", item.DownTimeType.DownTimeName.ToString()); dic.Add("Minutes", item.Minutes.ToString()); dic.Add("Note", item.DownTimeNote.ToString()); col.Add(dic); var ufdic = new Dictionary <string, string>(); } var dttr = new DownTimeTypeRepository(); var dtts = dttr.GetDownTimeTypesByDept(int.Parse(cqDTO.DepartmentID)); var col2 = new Collection <Dictionary <string, string> >(); foreach (var dtt in dtts) { var dic = new Dictionary <string, string>(); dic.Add("DownTimeTypeID", dtt.DownTimeTypeID.ToString()); dic.Add("DownTypeName", dtt.DownTimeName); col2.Add(dic); } var retVal = new GenericDTO { Key = key, ReturnData = col, ReturnData1 = col2 }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(request.CreateResponse(HttpStatusCode.NotFound, message)); }
internal HttpResponseMessage Emails(HttpRequestMessage request, EmailDTO 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 EmailRepository(); var u = new Email(); var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection <Dictionary <string, string> >(); data = data.OrderBy(x => x.EmailAddress).ToList(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("EmailID", item.EmailID.ToString()); dic.Add("EmailAddress", item.EmailAddress); dic.Add("ReceiveDailyReport", item.ReceiveDailyReport.ToString()); col.Add(dic); var ufdic = new Dictionary <string, string>(); } var ur2 = new EmailListRepository(); var u2 = new EmailList(); var predicate2 = ur2.GetPredicate(cqDTO, u2, companyId); var data2 = ur2.GetByPredicate(predicate); var col2 = new Collection <Dictionary <string, string> >(); data2 = data2.OrderBy(x => x.EmailListName).ToList(); foreach (var item in data2) { var dic = new Dictionary <string, string>(); dic.Add("EmailListId", item.EmailListId.ToString()); dic.Add("EmailListName", item.EmailListName); col2.Add(dic); var ufdic = new Dictionary <string, string>(); } //var ur3 = new ListEmailRepository(); //var u3 = new ListEmail(); //var predicate3 = ur3.GetPredicate(cqDTO, u3, companyId); //var data3 = ur3.GetByPredicate(predicate); //var col3 = new Collection<Dictionary<string, string>>(); //data3 = data3.ToList(); //foreach (var item in data3) //{ // var dic = new Dictionary<string, string>(); // dic.Add("ListId", item.ListId.ToString()); // dic.Add("EmailId", item.EmailId.ToString()); // col3.Add(dic); // var ufdic = new Dictionary<string, string>(); //} var retValList = new List <GenericDTO>(); var retVal = new GenericDTO { Key = key, ReturnData = col }; retValList.Add(retVal); var retVal2 = new GenericDTO { Key = key, ReturnData = col2 }; retValList.Add(retVal2); //var retVal3 = new GenericDTO //{ // Key = key, // ReturnData = col3 //}; //retValList.Add(retVal3); return(Request.CreateResponse(HttpStatusCode.OK, retValList)); } var message = "validation failed"; return(request.CreateResponse(HttpStatusCode.NotFound, message)); }
public HttpResponseMessage ProductionTotals([FromBody] ProductionTotalDTO 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 ProductionTotalRepository(); var u = new ProductionTotal(); if (cqDTO.ProductionDate != null) { cqDTO.Start_ProductionDate = DateTime.Parse(cqDTO.ProductionDate).ToString(); cqDTO.End_ProductionDate = DateTime.Parse(cqDTO.ProductionDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_ProductionDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_ProductionDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_ProductionDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_ProductionDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_ProductionDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_ProductionDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString(); } cqDTO.StartDateMonth = null; cqDTO.StartDateYear = null; } SGApp.DTOs.GenericDTO dto = new GenericDTO(); dto.StartDate = DateTime.Parse(cqDTO.Start_ProductionDate); dto.EndDate = DateTime.Parse(cqDTO.End_ProductionDate); List <DTOs.Sampling> samplingResults = new List <DTOs.Sampling>(); PondRepository pr = new PondRepository(); var client = new HttpClient { //BaseAddress = new Uri("http://323-booth-svr2:3030/") BaseAddress = new Uri("http://64.139.95.243:7846/") //BaseAddress = new Uri(baseAddress) }; try { var response = client.PostAsJsonAsync("api/Remote/GetKeithsData", dto).Result; response.EnsureSuccessStatusCode(); JavaScriptSerializer json_serializer = new JavaScriptSerializer(); //Sampling[] samplingResultsArray = json_serializer.Deserialize<Sampling[]>(response.Content.ReadAsStringAsync().Result); // new List<Sampling>(); //Sampling[] samplingResultsArray = response.Content.ReadAsAsync<Sampling[]>().Result; //samplingResults = samplingResultsArray.ToList(); //JavaScriptSerializer json_serializer = new JavaScriptSerializer(); //Sampling[] samplingResultsArray = json_serializer.Deserialize<Sampling[]>(Constants.testdata); DTOs.Sampling[] samplingResultsArray = json_serializer.Deserialize <DTOs.Sampling[]>(response.Content.ReadAsStringAsync().Result); samplingResults = samplingResultsArray.ToList(); samplingResults = samplingResults.GroupBy(x => x.farmPond).Select(group => group.First()).ToList(); //var result = response.Content.ReadAsStringAsync().Result; //return Request.CreateResponse(HttpStatusCode.OK, result); } catch (Exception e) { throw new HttpException("Error occurred: " + e.Message); } var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection <Dictionary <string, string> >(); data = data.OrderBy(x => x.ProductionDate).ToList(); foreach (DTOs.Sampling sam in samplingResults) { ProductionTotal fy = data.Where(x => x.Pond.InnovaName == sam.farmPond).FirstOrDefault(); Pond pd = pr.GetPondFromInnovaName(sam.farmPond); var dic = new Dictionary <string, string>(); if (fy != null) { var wb = fy.WeighBacks != null ? fy.WeighBacks : 0; dic.Add("ProductionTotalId", fy.ProductionTotalID.ToString()); dic.Add("PondID", fy.PondId.ToString()); dic.Add("PondName", sam.farmPond); dic.Add("FarmID", fy.Pond.FarmId.ToString()); dic.Add("ProductionDate", fy.ProductionDate.ToShortDateString()); dic.Add("PlantWeight", fy.PlantWeight != null ? fy.PlantWeight.ToString() : "---"); dic.Add("PondWeight", fy.PondWeight != null ? fy.PondWeight.ToString() : "---"); dic.Add("WeighBacks", fy.WeighBacks != null ? fy.WeighBacks.ToString() : "---"); dic.Add("AverageYield", fy.AverageYield != null ? fy.AverageYield.ToString() : "---"); dic.Add("HeadedWeight", fy.AverageYield != null && fy.PlantWeight != null ? String.Format("{0:0.00}", ((fy.AverageYield / 100) * (fy.PlantWeight - wb))) : "---"); } else { dic.Add("ProductionTotalId", "-1"); dic.Add("PondID", pd.PondId.ToString() != null ? pd.PondId.ToString() : ""); dic.Add("PondName", sam.farmPond != null ? sam.farmPond : ""); dic.Add("FarmID", pd.FarmId.ToString() != null ? pd.FarmId.ToString() : ""); dic.Add("ProductionDate", cqDTO.ProductionDate); dic.Add("PlantWeight", "---"); dic.Add("PondWeight", "---"); dic.Add("WeighBacks", "---"); dic.Add("AverageYield", "---"); dic.Add("HeadedWeight", "---"); } col.Add(dic); } //foreach (FarmYield fy in data) //{ // Sampling samp = samplingResults.Where(x => x.farmPond == fy.Pond.InnovaName).FirstOrDefault(); // var dic = new Dictionary<string, string>(); // if (samp == null) // { // dic.Add("YieldId", fy.YieldID.ToString()); // dic.Add("PondID", fy.PondID.ToString()); // dic.Add("PondName", fy.Pond.InnovaName != null ? fy.Pond.InnovaName : fy.Pond.PondName); // dic.Add("FarmID", fy.Pond.FarmId.ToString()); // dic.Add("YieldDate", fy.YieldDate.ToShortDateString()); // dic.Add("PoundsYielded", fy.PoundsYielded.ToString()); // dic.Add("PoundsPlant", fy.PoundsPlant.ToString()); // dic.Add("PoundsHeaded", fy.PoundsHeaded.ToString()); // dic.Add("PercentYield", fy.PercentYield.ToString()); // dic.Add("PercentYield2", fy.PercentYield2.ToString()); // col.Add(dic); // } //} var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
internal HttpResponseMessage Absences(HttpRequestMessage request, AbsenceDTO 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 AbsenceRepository(); var u = new Absence(); if (cqDTO.AbsenceDate != null) { cqDTO.Start_AbsenceDate = DateTime.Parse(cqDTO.AbsenceDate).ToString(); cqDTO.End_AbsenceDate = DateTime.Parse(cqDTO.AbsenceDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_AbsenceDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_AbsenceDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_AbsenceDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_AbsenceDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_AbsenceDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_AbsenceDate = 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.OrderBy(x => x.AbsenceDate).ToList(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("AbsenceID", item.AbsenceID.ToString()); dic.Add("DepartmentID", item.DepartmentID.ToString()); dic.Add("DepartmentName", item.Department.DepartmentName); dic.Add("AbsenceDate", item.AbsenceDate.ToShortDateString()); dic.Add("RegEmpLate", item.RegEmpLate.ToString()); dic.Add("RegEmpLeftEarly", item.RegEmpLeftEarly.ToString()); dic.Add("RegEmpOut", item.RegEmpOut.ToString()); dic.Add("TempEmpLate", item.TempEmpLate.ToString()); dic.Add("TempEmpLeftEarly", item.TempEmpLeftEarly.ToString()); dic.Add("TempEmpOut", item.TempEmpOut.ToString()); dic.Add("InmateLeftEarly", item.InmateLeftEarly.ToString()); dic.Add("InmateOut", item.InmateOut.ToString()); dic.Add("EmployeesOnVacation", item.EmployeesOnVacation.ToString()); 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)); }
public List <GenericDTO> GetAllData(GenericDTO generic) { GenericDAL cmd = new GenericDAL(); return(cmd.GetAllGeneric(generic)); }
public static void AddTechnology(GenericDTO dto) { }
internal HttpResponseMessage FarmYields(HttpRequestMessage request, FarmYieldDTO 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 FarmYieldRepository(); var u = new FarmYield(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_YieldDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_YieldDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_YieldDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = 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.OrderBy(x => x.YieldDate).ToList(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("YieldId", item.YieldID.ToString()); dic.Add("PondID", item.PondID.ToString()); dic.Add("PondName", item.Pond.PondName); dic.Add("FarmID", item.Pond.FarmId.ToString()); dic.Add("YieldDate", item.YieldDate.ToShortDateString()); dic.Add("PoundsYielded", item.PoundsYielded.ToString()); dic.Add("PoundsPlant", item.PoundsPlant.ToString()); dic.Add("PoundsHeaded", item.PoundsHeaded.ToString()); dic.Add("PercentYield", item.PercentYield.ToString()); dic.Add("PercentYield2", item.PercentYield2.ToString()); 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)); }