public ResponseOneCDto GetClientResumeWeek(string updatetable, string id) { ResponseOneCDto responseOneC = new ResponseOneCDto(); try { if ((updatetable != null && updatetable != "") && (id != null && id != "")) { if (updatetable == "CRM_Contragents") { ReloadClients(id); } responseOneC.Description = "OK"; } else { responseOneC.Description = "Parameters are not valid"; } responseOneC.Status = "OK"; } catch (Exception e) { responseOneC.Status = e.Message; } return(responseOneC); }
public ResponseOneCDto GetClientResumeWeek(string idClient, string year, string monthe) { ResponseOneCDto responseOneC = new ResponseOneCDto(); List <ClientResumeWeekDto> clientResumeWeeks = _context.Set <ClientResumeWeek>().Where(c => c.Resume != null && c.Resume != "") .Select(x => new ClientResumeWeekDto() { ClientId = _context.Set <ClientInfo>().FirstOrDefault(c => c.OneCId.ToString() == idClient).OneCId.ToString(), Date = x.Date, Resume = x.Resume }).ToList(); if (idClient != null && idClient != "") { clientResumeWeeks = clientResumeWeeks.Where(c => c.ClientId.ToString() == idClient).ToList(); } int yearNumber; int monthNumber; if (int.TryParse(year, out yearNumber) && int.TryParse(monthe, out monthNumber)) { clientResumeWeeks = clientResumeWeeks.Where(c => DateTime.Parse(c.Date).Year == yearNumber && DateTime.Parse(c.Date).Month == monthNumber).ToList(); } responseOneC.Result = clientResumeWeeks; responseOneC.Command = "GetResume"; responseOneC.Status = "OK"; return(responseOneC); }