private void BtnSave_Click(object sender, EventArgs e) { using (var context = new musicstudiodbContext()) { try { var abonement = new Abonement(); //abonement.ClientId = client.Id; //abonement.DateEnd = calendarEnd.SelectedDate; //abonement.DateStart = calendarStart.SelectedDate; //abonement.LessonsCount = txtLessonCount.Text == "" ? 0 : int.Parse(txtLessonCount.Text); //abonement.TeacherId = int.Parse(ddlTeacher.SelectedValue); abonement.ClientId = abonementEditor.ClientId; abonement.DateEnd = abonementEditor.DateEnd; abonement.DateStart = abonementEditor.DateStart; abonement.LessonsCount = abonementEditor.LessonsCount; //txtLessonCount.Text == "" ? 0 : int.Parse(txtLessonCount.Text); abonement.TeacherId = abonementEditor.TeacherId; context.Abonements.Add(abonement); //client.CarMakeID = int.Parse(ddlMake.SelectedValue); //client.CarYear = int.Parse(txtYear.Text); //client.Model = txtModel.Text; context.SaveChanges(); } catch (DbUpdateException dbex) { Response.Write("<script>alert('Заполните все поля')</script>"); return; } Response.Redirect("MainPage.aspx"); } }
public ActionResult SaveNewAbonement(AddNewAbonementModel abNew) { Client cli = new Client(abNew.c_name, abNew.c_surname, abNew.c_phone); db.Client.Add(cli); int id = 0; int temp_title = 0; temp_title = int.Parse(abNew.s_title); var servs = db.Service .Where(s => s.s_id == temp_title) .Select(s => s); foreach (Service se in servs) { id = se.s_id; } Abonement ab = new Abonement(cli.c_id, abNew.date_begin, id, abNew.date_end, abNew.a_count); db.Abonement.Add(ab); db.SaveChanges(); return(RedirectToAction("AddNewAbonementView")); }
public void AddAbonement(Abonement abonement) { using (poolDBEntities ent = new poolDBEntities()) { ent.Abonements.Add(abonement); ent.SaveChanges(); } }
/// <summary> /// Получить общую стоимость абонемента /// </summary> /// <param name="accountAbonement"> абонемент</param> /// <returns></returns> public static void SetTotalCost(Abonement accountAbonement) { if (accountAbonement == null) { return; } Assistiant.SetTotalCost(accountAbonement); }
public IActionResult Delete(int id) { Abonement a = db.Abonements.Find(id); int c = a.Id_Client; db.Abonements.Remove(a); db.SaveChanges(); return(RedirectToAction("Info", "Client", new { id = c })); }
/// <summary> /// Продлить абонемент /// </summary> /// <param name="accountAbonement"></param> /// <param name="timeToLong"></param> public void LongAbonement(Abonement accountAbonement, DateTime timeToLong) { if (accountAbonement == null) { return; } accountAbonement.TimeToLong = timeToLong; CreateOrUpdateRecord(accountAbonement); }
public void FreezeAbonement(Abonement accountAbonement) { if (accountAbonement == null) { return; } accountAbonement.AbonmentStatus.StatusName = "Заморожен"; CreateOrUpdateRecord(accountAbonement); }
/// <summary> /// Обновить /// </summary> /// <param name="accountAbonement"></param> public void ActivateAbonement(Abonement accountAbonement) { if (accountAbonement == null) { return; } accountAbonement.AbonmentStatus.StatusName = "Активен"; CreateOrUpdateRecord(accountAbonement); }
public void DeleteAbonementById(int id) { using (poolDBEntities ent = new poolDBEntities()) { Abonement abonEnt = ent.Abonements .Where(a => a.Id == id) .FirstOrDefault(); ent.Abonements.Remove(abonEnt); ent.SaveChanges(); } }
public List <Client> GetClientByAbonementId(int id) { List <Client> c = new List <Client>(); using (poolDBEntities ent = new poolDBEntities()) { Abonement abon = ent .Abonements.Where(a => a.Id == id) .FirstOrDefault(); c.Add(abon.Client); } return(c); }
public IActionResult Remove(int id, int idClient, DateTime when) { // Получить абонемент, добавить посещение // Удалить связь на эту тренировку, бля TrainGroup t = db.TrainGroups.Where(x => x.Id_Client == idClient && x.Id_Training == id).FirstOrDefault(); Training tr = db.Trainings.First(x => x.StartAt.Equals(when)); Abonement a = db.Abonements.Where(x => x.Id_Client == idClient && tr.Id_BasicGroup == x.Id_BasicGroup).FirstOrDefault(); a.CurrentTrainings += 1; db.TrainGroups.Remove(t); db.Abonements.Update(a); db.SaveChanges(); return(RedirectToAction("Index", "Training", new{ when = db.Trainings.Find(id).StartAt })); }
public IActionResult FreezeAbonement(Abonement abonement) { var currentClient = context.Client.Single(x => x.Email == User.Identity.Name); var newAbonement = context.Abonement.Single(x => x.Number == abonement.Number); newAbonement.Capacity -= abonement.IntervalBlock.Value; newAbonement.DateBlock = abonement.DateBlock.Value; newAbonement.IntervalBlock = abonement.IntervalBlock.Value; newAbonement.IsActive = false; context.SaveChanges(); return(RedirectToAction(nameof(AbonementInfo))); }
private void saveAbonementChanges() { if (currClientId == -1) { return; } Abonement abon = new Abonement(); if (!isAddingState) { abon.Id = Convert.ToInt32(abonementsIdComboBox.SelectedItem.ToString()); } abon.VisitTypeId = clientManager.GetVisitTypeIdByName(visitTypeСomboBox.SelectedItem.ToString()); abon.ServiceTypeId = clientManager.GetServiceTypeIdByName(serviceTypeComboBox.SelectedItem.ToString()); int?tgid = clientManager.GetTrainingGroupIdByName(trainingGroupsComboBox.SelectedItem.ToString()); if (tgid != null) { abon.TrainingGroupId = tgid; } DateTime dt = dateEndPicker.Value; abon.DateEnd = dt; //if (DateTime.TryParse(dateEndTextBox.Text, out dt)) // abon.DateEnd = dt; int vc = 0; if (int.TryParse(visitCountTextBox.Text, out vc)) { abon.VisitCount = vc; } abon.ClientId = currClientId; if (isAddingState) { clientManager.AddAbonement(abon); } else { clientManager.EditAbonement(abon); } MessageBox.Show("Сохранено!"); isSaved = true; if (isAddingState) { AbonementIdComboBoxDataSourceUpdate(currClientId); } watchingState(); }
public IActionResult Assign(DateTime when, int id) { Training t = db.Trainings.First(x => x.StartAt.Equals(when)); TrainGroup tg = new TrainGroup { Id_Client = id, Id_Training = t.Id }; Abonement a = db.Abonements.First(x => x.Id_Client == id); a.CurrentTrainings -= 1; db.Abonements.Update(a); db.TrainGroups.Add(tg); db.SaveChanges(); return(RedirectToAction("Index", "Home", when.Date)); }
public IActionResult New(AbonementClient model) { Abonement a = new Abonement { Id_Client = model.ID_Client, StartDate = model.StartAt, EndDate = model.EndAt, Id_BasicGroup = model.Id_BasicGroup, TotalTrainings = model.TotalTrainings, CurrentTrainings = model.TotalTrainings, TotalPayed = model.TotalTrainings * db.BasicGroups.Find(model.Id_BasicGroup).Costs }; db.Abonements.Add(a); db.SaveChanges(); return(RedirectToAction("Info", "Client", new { id = a.Id_Client })); }
public override object Convert(object value, Type targetType, object parameter, CultureInfo culture) { if (value is Account account) { Abonement abonem = account.Abonement; if (parameter as string == "Freeze") { return (abonem as Abonement).AbonmentStatus.StatusName == "Активен"; } return (abonem as Abonement).AbonmentStatus.StatusName != "Активен"; } return false; }
public void EditAbonement(Abonement abonement) { using (poolDBEntities ent = new poolDBEntities()) { Abonement abonEnt = ent.Abonements .Where(a => a.Id == abonement.Id) .FirstOrDefault(); //abonEnt = abonement; abonEnt.VisitTypeId = abonement.VisitTypeId; abonEnt.ServiceTypeId = abonement.ServiceTypeId; abonEnt.TrainingGroupId = abonement.TrainingGroupId; abonEnt.VisitCount = abonement.VisitCount; abonEnt.ClientId = abonement.ClientId; abonEnt.DateEnd = abonement.DateEnd; ent.SaveChanges(); } }
/// <summary> /// Посчитать общую стоимость абонемента /// </summary> /// <param name="accountAbonement">Текущий абонемент</param> public void SetTotalCost(Abonement accountAbonement) { if (accountAbonement == null) { return; } var query = DataBaseFcContext.Abonements.FirstOrDefault(ab => ab.NumberSubscription == accountAbonement.NumberSubscription); if (query != null) { query.AbonementTotalCost = 0; foreach (var buyingTraining in query.ArrServicesInSubscription) { buyingTraining.TotalCost = buyingTraining.SiSTrainingCount * buyingTraining.PriceType.TrainingCurrentCost; query.AbonementTotalCost += Math.Round(buyingTraining.TotalCost, 2); } } DataBaseFcContext.SaveChanges(); }
private void SetCurrAbonement() { int id; if (abonementsIdComboBox.Items.Count < 1) { return; } if (Int32.TryParse(abonementsIdComboBox.SelectedItem.ToString(), out id)) { Abonement a = clientManager.GetAbonementById(id); //if (a.VisitTypeId != null) string typeName = clientManager.GetVisitTypeById(a.VisitTypeId).TypeName; if (typeName != null) { visitTypeСomboBox.SelectedIndex = visitTypeСomboBox.FindString(typeName); } string sTypeName = clientManager.GetServiceTypeById(a.ServiceTypeId).TypeName; if (sTypeName != null) { serviceTypeComboBox.SelectedIndex = serviceTypeComboBox.FindString(sTypeName); } if (a.TrainingGroupId != null) { string grName = clientManager.GetTrainingGroupById((int)a.TrainingGroupId).GroupName; trainingGroupsComboBox.SelectedIndex = trainingGroupsComboBox.FindString(grName); } else { trainingGroupsComboBox.SelectedIndex = trainingGroupsComboBox.Items.Count - 1; } visitCountTextBox.Text = a.VisitCount.ToString(); dateEndPicker.Value = a.DateEnd.Date; //dateEndTextBox.Text = a.DateEnd.Date.ToShortDateString(); } }
public static void SetTotalCost(Abonement accountAbonement) { DbManager.GetInstance().SetTotalCost(accountAbonement); }
private void BtnSave_Click(object sender, EventArgs e) { using (var context = new musicstudiodbContext()) { try { var client = new Client(); try { client.Name = clientEditor.FirstName; client.Surname = clientEditor.Surname; client.SecondName = clientEditor.SecondName; client.PhoneNumber = clientEditor.Phone; } catch (EntityDataSourceValidationException tbErr) { Response.Write(tbErr.Message); return; } try { context.Clients.Add(client); context.SaveChanges(); } catch (DbEntityValidationException ex) { // case of catching errors on saving new data in db String message = ""; #if DEBUG // show full err sequence to devs foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors) { message += "Object: " + validationError.Entry.Entity.ToString() + "\t"; foreach (DbValidationError err in validationError.ValidationErrors) { message += err.ErrorMessage.ToString() + " "; } } #else // do not show extra info to user message = "Server error occured" #endif Response.Write(message); return; } var abonement = new Abonement(); //abonement.ClientId = client.Id; //abonement.DateEnd = calendarEnd.SelectedDate; //abonement.DateStart = calendarStart.SelectedDate; //abonement.LessonsCount = txtLessonCount.Text == "" ? 0 : int.Parse(txtLessonCount.Text); //abonement.TeacherId = int.Parse(ddlTeacher.SelectedValue); abonement.ClientId = client.Id; abonement.DateEnd = abonementEditor.DateEnd; abonement.DateStart = abonementEditor.DateStart; abonement.LessonsCount = abonementEditor.LessonsCount; //txtLessonCount.Text == "" ? 0 : int.Parse(txtLessonCount.Text); abonement.TeacherId = abonementEditor.TeacherId; context.Abonements.Add(abonement); //client.CarMakeID = int.Parse(ddlMake.SelectedValue); //client.CarYear = int.Parse(txtYear.Text); //client.Model = txtModel.Text; context.SaveChanges(); } catch (DbUpdateException dbex) { Response.Write("<script>alert('Заполните все поля')</script>"); return; } Response.Redirect("MainPage.aspx"); } }
public void SetTotalCost(Abonement accountAbonement) { unitOfWork.ServicesInSubscription.SetTotalCost(accountAbonement); }