private double ResultZp(string[] Month, int id, bool check) { if (Month.Length == 0) { TempData["ErrorLack"] = "Вы не выбрали месяц"; return(0); } double dogovor = 0; if (check) { dogovor = _dogovor.Read(null).Where(rec => (rec.data > DateTime.Now.AddYears(-1) && rec.data < DateTime.Now) && (rec.AgentId == id)).Select(rec => rec.Summa).Sum(); zp *= 12; } else { DateTime date = AgentController.PeriodDate(Month[0]); dogovor = _dogovor.Read(null).Where(rec => (rec.data.Month == date.Month) && (rec.AgentId == id)).Select(rec => rec.Summa).Sum(); } zp += dogovor * (comis / 100); return(zp); }
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")); }