public ActionResult EditSeasonTicket(int id, SeasonTicket seasonTicket) { //try { seasonTicket.idSeasonTicket = id; int idService = db.Service.Where(s => s.name == seasonTicket.Service.name).FirstOrDefault().idService; seasonTicket.idService = idService; int idClient = db.Client.Where(c => c.surname == seasonTicket.Client.surname).FirstOrDefault().idClient; seasonTicket.idClient = idClient; int idCoach = db.Coach.Where(c => c.surname == seasonTicket.Coach.surname).FirstOrDefault().idCoach; seasonTicket.idCoach = idCoach; var st = db.SeasonTicket.Where(c => c.idSeasonTicket == seasonTicket.idSeasonTicket).FirstOrDefault(); seasonTicket.saleAge = st.saleAge; seasonTicket.saleClasses = st.saleClasses; seasonTicket.saleСonstantСlient = st.saleСonstantСlient; seasonTicket.totalCost = st.totalCost; List <Visiting> vis = db.Visiting.Where(v => v.idSeasonTicket == id).ToList(); for (int i = 0; i < seasonTicket.Visitings.Count(); i++) { vis[i].date = seasonTicket.Visitings[i].date; } db.SaveChanges(); //db.Entry(seasonTicket).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("SeasonTicket")); } //catch (Exception) //{ // return View(); //} }
public ActionResult ShowSeasonTicket(int id) { SeasonTicket seasonTicket = db.SeasonTicket.Where(st => st.idSeasonTicket == id).FirstOrDefault(); //var visiting = (from st in db.SeasonTicket // join st in db.SeasonTicket on c.idClient equals st.idClient // join s in db.Service on st.idService equals s.idService // where c.idClient == id // select s.name).ToList(); //ViewBag.TicketsClient = tickets; return(View(seasonTicket)); }
private void button_Click(object sender, EventArgs e) { using (KochkaDBEntities1 ct = new KochkaDBEntities1()) { if (Program.CurrentUser.Group == 1) { if (ButtonText == "Мой абонемент") { SeasonTicket t = ct.SeasonTickets .ToList() .FirstOrDefault(x => x.CardNumber == Program.CurrentUser.Login); Employee em = ct.Employees .ToList() .FirstOrDefault(x => x.ServiceNumber == t.ServiceNumber); UserControlSeasonTicket item = new UserControlSeasonTicket() { ClubNumber = t.NumberOfClub.ToString(), DateEnd = t.DateOfEnd.ToString(), DateBegin = t.DateOfRegistration.ToString(), StillHave = t.VisitsStillHave.ToString(), Employee = em.Name, ContactId = t.ContractId.ToString(), NameCard = t.CardName, ClubCard = t.CardNumber }; f2.ClearLayoutPanel(); panel.Controls.Add(item); } if (ButtonText == "Мой тренер") { CoachContract contract = ct.CoachContracts .ToList() .FirstOrDefault(x => x.CardNumber == Program.CurrentUser.Login); Employee employee = ct.Employees .ToList() .FirstOrDefault(x => x.ServiceNumber == contract.ServiceNumber); UserControlTrainerCoach item = new UserControlTrainerCoach() { ContractId = contract.CoachContractId.ToString(), CoachName = employee.EmplyeeSecondName + ' ' + employee.Name + ' ' + employee.EmplyeeMiddleName, Quanity = contract.QuantityTraining.ToString(), StillHave = contract.StillHaveTraining.ToString(), DateBegin = contract.DateOfConclusion.ToString(), DateEnd = contract.ExpiryDate.ToString(), ClientName = ct.Visitors.ToList().FirstOrDefault(x => x.CardNumber == contract.CardNumber).VisitorSecondName }; f2.ClearLayoutPanel(); panel.Controls.Add(item); } if (ButtonText == "Посещения") { f2.ClearLayoutPanel(); bool Empty = true; foreach (Visit visit in ct.Visits.ToList()) { if (visit.CardNumber == Program.CurrentUser.Login) { UserControlVisits item = new UserControlVisits() { Date = visit.DateOfVisit.ToString(), NumberOfClub = visit.NumberOfClub.ToString(), CardName = visit.CardName.ToString(), ContarctId = visit.ContractId.ToString(), CName = ct.Visitors .ToList() .FirstOrDefault(x => x.CardNumber == Program.CurrentUser.Login).VisitorSecondName }; Empty = false; panel.Controls.Add(item); } } if (Empty) { panel.Controls .Add ( new UserControlGuestVisit() { TextMessage = "Посещений нет", ClearSecondLabel = "" } ); } } } else if (Program.CurrentUser.Group == 2) { if (ButtonText == "Мои контракты") { f2.ClearLayoutPanel(); bool Empty = true; Employee employee = ct.Employees .ToList() .FirstOrDefault(x => x.ServiceNumber.ToString() == Program.CurrentUser.Login); foreach (CoachContract contract in ct.CoachContracts.ToList()) { if (contract.ServiceNumber.ToString() == Program.CurrentUser.Login) { UserControlTrainerCoach item = new UserControlTrainerCoach() { ContractId = contract.CoachContractId.ToString(), CoachName = employee.EmplyeeSecondName + ' ' + employee.Name + ' ' + employee.EmplyeeMiddleName, Quanity = contract.QuantityTraining.ToString(), StillHave = contract.StillHaveTraining.ToString(), DateBegin = contract.DateOfConclusion.ToString(), DateEnd = contract.ExpiryDate.ToString(), ClientName = ct.Visitors.ToList().FirstOrDefault(x => x.CardNumber == contract.CardNumber).VisitorSecondName }; Empty = false; panel.Controls.Add(item); } } if (Empty) { panel.Controls .Add ( new UserControlGuestVisit() { TextMessage = "Контрактов нет", ClearSecondLabel = "" } ); } } } else if (Program.CurrentUser.Group == 3) { if (ButtonText == "Абонементы") { f2.ClearLayoutPanel(); UserControlSeasonTicket it = new UserControlSeasonTicket(); var tick = from seasonTicket in ct.SeasonTickets join employee in ct.Employees on seasonTicket.ServiceNumber equals employee.ServiceNumber join visitor in ct.Visitors on seasonTicket.CardNumber equals visitor.CardNumber select new { NumberOfClub = seasonTicket.NumberOfClub, NameCard = seasonTicket.CardName, CardNumber = seasonTicket.CardNumber, DateBegin = seasonTicket.DateOfRegistration, DateEnd = seasonTicket.DateOfEnd, StillHave = seasonTicket.VisitsStillHave, ContractId = seasonTicket.ContractId, EmployeeName = employee.EmplyeeSecondName, ClientName = visitor.VisitorSecondName }; foreach (var i in tick.ToList()) { UserControlSeasonTicket item = new UserControlSeasonTicket() { ClubNumber = i.NumberOfClub.ToString(), NameCard = i.NameCard, ClubCard = i.CardNumber, DateBegin = i.DateBegin.ToString(), DateEnd = i.DateEnd.ToString(), ContactId = i.ContractId.ToString(), StillHave = i.StillHave.ToString(), Employee = i.EmployeeName, Client = i.ClientName }; panel.Controls.Add(item); } } if (ButtonText == "Клиенты") { f2.ClearLayoutPanel(); foreach (Visitor v in ct.Visitors) { UserControlVisitor item = new UserControlVisitor() { Client = v.VisitorSecondName + ' ' + v.VisitorName, Birth = v.VisitorBDate.ToString(), ClubCard = v.CardNumber, Passport = v.VisitorPassport }; panel.Controls.Add(item); } } if (ButtonText == "Контракты") { f2.ClearLayoutPanel(); bool Empty = true; foreach (CoachContract contract in ct.CoachContracts.ToList()) { UserControlTrainerCoach item = new UserControlTrainerCoach() { ContractId = contract.CoachContractId.ToString(), CoachName = "Табельный номер тренера: " + contract.ServiceNumber.ToString(), Quanity = contract.QuantityTraining.ToString(), StillHave = contract.StillHaveTraining.ToString(), DateBegin = contract.DateOfConclusion.ToString(), DateEnd = contract.ExpiryDate.ToString(), ClientName = ct.Visitors.ToList().FirstOrDefault(x => x.CardNumber == contract.CardNumber).VisitorSecondName }; Empty = false; panel.Controls.Add(item); } if (Empty) { panel.Controls .Add ( new UserControlGuestVisit() { TextMessage = "Контрактов нет", ClearSecondLabel = "" } ); } } if (ButtonText == "Посещения") { f2.ClearLayoutPanel(); bool Empty = true; foreach (Visit visit in ct.Visits.ToList()) { try { UserControlVisits item = new UserControlVisits() { Date = visit.DateOfVisit.ToString(), NumberOfClub = visit.NumberOfClub.ToString(), CardName = visit.CardName.ToString(), ContarctId = visit.ContractId.ToString(), CName = ct.Visitors .ToList() .FirstOrDefault(x => x.CardNumber == visit.CardNumber).VisitorSecondName }; Empty = false; panel.Controls.Add(item); } catch (Exception ex) { throw new NullReferenceException(ex.Message); } } if (Empty) { panel.Controls .Add ( new UserControlGuestVisit() { TextMessage = "Посещений нет", ClearSecondLabel = "" } ); } } if (ButtonText == "Заявки на гостевой визит") { string line; f2.ClearLayoutPanel(); System.IO.StreamReader file = new System.IO.StreamReader("Applications.txt"); while ((line = file.ReadLine()) != null) { UserControlApp app = new UserControlApp() { Date = line.Split(' ')[0] + ' ' + line.Split(' ')[1], Number = line.Split(' ')[2], NameClient = line.Split(' ')[3] + ' ' + line.Split(' ')[4] }; panel.Controls.Add(app); } file.Close(); } } } }
public ActionResult CreateSeasonTicket(SeasonTicket seasonTicket) { try { if (seasonTicket.classesTotal == 0) { ModelState.AddModelError("classesTotal", "Введите кол-во занятий"); } DateTime thisDay = DateTime.Today; if (seasonTicket.dateStart < thisDay) { ModelState.AddModelError("dateStart", "Нельзя вводить прошедшую дату"); } if (seasonTicket.dateEnd < thisDay) { ModelState.AddModelError("dateEnd", "Нельзя вводить прошедшую дату"); } if (seasonTicket.dateEnd < seasonTicket.dateStart) { ModelState.AddModelError("dateEnd", "Дата окончания раньше, чем дата начала"); } //if (seasonTicket.dateEnd == DateTime.Parse("01.01.0001 0:00:00")) //{ // ModelState.AddModelError("dateEnd", "Введите дату окончания"); //} if (seasonTicket.Coach.surname != "нет") { seasonTicket.idCoach = db.Coach.Where(c => c.surname == seasonTicket.Coach.surname).FirstOrDefault().idCoach; } if (seasonTicket.idCoach != null) { List <string> servicesCoach = (from c in db.Coach join a in db.Activity on c.idCoach equals a.idCoach join s in db.Service on a.idService equals s.idService where c.idCoach == seasonTicket.idCoach select s.name).ToList(); int check = 0; foreach (var item in servicesCoach) { if (seasonTicket.Service.name == item) { check = 1; break; } } if (check == 0) { ModelState.AddModelError("Coach.surname", "Тренер не продоставляет выбранную услугу"); ViewBag.ServicesCoach = servicesCoach; } } ModelState.Remove("Client.name"); ModelState.Remove("Client.sex"); ModelState.Remove("Coach.name"); if (ModelState.IsValid) { int idService = db.Service.Where(s => s.name == seasonTicket.Service.name).FirstOrDefault().idService; seasonTicket.idService = idService; int idClient = db.Client.Where(c => c.surname == seasonTicket.Client.surname).FirstOrDefault().idClient; seasonTicket.idClient = idClient; db.SeasonTicket.Add(seasonTicket); db.SaveChanges(); return(RedirectToAction("SeasonTicket")); } else { SelectList services = new SelectList(db.Service, "name", "name"); ViewBag.Services = services; SelectList clients = new SelectList(db.Client, "surname", "surname"); ViewBag.Clients = clients; SelectList coaches = new SelectList(db.Coach, "surname", "surname"); ViewBag.Coaches = coaches; return(View(seasonTicket)); } } catch (Exception) { return(View()); } }