public ActionResult Archive() { var name = _agent.Read(null); var zps = _zarplata.Read(null); var old = zps.Where(rec => (rec.data <= DateTime.Now.AddYears(-1))).Select(rec => (rec.Id, rec.Summa, (name.Where(r => r.Id == rec.UserId).Select(r => r.Name).FirstOrDefault()), rec.data)); ViewBag.Zp = old; return(View()); }
public IActionResult Statements(string[] Month, ZarplataModel model) { List <ZarplataModel> inf = new List <ZarplataModel>(); if (Month.Length == 0) { ViewBag.inf = _zarplata.Read(null); return(View()); } var agent = _agent.Read(null).Last(); for (int i = 1; i <= agent.Id; i++) { var ag = _agent.Read(new AgentBindingModel { Id = i }).FirstOrDefault(); if (ag != null) { bool check = false; foreach (var zp in _zarplata.Read(null)) { if (zp.data == AgentController.PeriodDate(Month[0]) && zp.UserId == ag.Id) { check = true; } } var summ = _agent.Read(new AgentBindingModel { Id = i }).FirstOrDefault(); zp = summ.Oklad; var com = _agent.Read(new AgentBindingModel { Id = i }).FirstOrDefault(); comis = com.Comission; inf.Add(new ZarplataModel { Id = i, Name = ag.Name, Summa = ResultZp(Month, i, false) }); if (!check) { _zarplata.CreateOrUpdate(new ZarplataBindingModel { UserId = i, Name = ag.Name, Summa = ResultZp(Month, i, false), data = AgentController.PeriodDate(Month[0]) }); } } } ViewBag.inf = inf; return(View()); }
public IActionResult ReadOfAgent(string[] Month, ReportModel m) { if (Month.Length == 0) { TempData["ErrorLack"] = "Вы не выбрали месяц"; return(RedirectToAction("Report")); } var FileName = m.puth + $"ReportMonth{DateTime.Now.Year}-{DateTime.Now.Month}-{DateTime.Now.Day}.pdf"; List <string> list = new List <string> { "Номер", "Дата", "Агент", "Сумма" }; DateTime date = AgentController.PeriodDate(Month[0]); SaveToPdf.ZpMonth(new Info { FileName = FileName, Title = $"Отчет зп за месяц {DateTime.Now.Month} года {DateTime.Now.Year}", Colon = list, zarplatas = _zarplata.Read(null).Where(rec => rec.data.Month == date.Month).ToList() }, date);; Mail.SendMail(m.SendMail, FileName, $"Отчет за месяц {DateTime.Now.Month} года {DateTime.Now.Year}"); return(RedirectToAction("Report")); }