private void ButtonDelUser_Click(object sender, RoutedEventArgs e) { int id_del; string usrnm_del; int grpid_del; string lgn_del; string pass_del; //===========Selecting ID of current user in selected row in the DataGrid FuncUsers_Result row = (FuncUsers_Result)DataGridUsers.SelectedItems[0]; // !!! id_del = (int)row.Id; usrnm_del = row.Usr; lgn_del = row.Lgin; pass_del = row.Pass; string nameGroup = row.NameGrp.ToString(); //========================Searching the id of group, by name CarRentalCenterDBEntities context = new CarRentalCenterDBEntities(); var row2 = (from c in context.TableGroups where c.NameGrp == nameGroup select c).First(); //select from table (LINQ) grpid_del = row2.Id; // //context.TableUsers.Find(id_del); //TableUsers user_del = new TableUsers() { Id = id_del, GroupsID = grpid_del, Lgin = lgn_del, Pass = pass_del, Usr = usrnm_del }; context.TableUsers.Remove(context.TableUsers.Find(id_del)); context.SaveChanges(); RefreshWindow(); }
private void ButtonOK_Click(object sender, RoutedEventArgs e) { TableCars selectedCar = new TableCars(); selectedCar = (TableCars)(from c in context.TableCars where c.VIN == selectedCarVIN select c).First(); TableStatus selectedStatus = new TableStatus(); selectedStatus = (TableStatus)(from c in context.TableStatus where c.Status == this.ComboBoxStatus.Text select c).First(); TableOrders newRow = new TableOrders(); newRow.idCar = selectedCar.Id; newRow.idPerson = selectedPersonID; newRow.Date = this.DatePickerBirth.SelectedDate; newRow.Amount = Convert.ToDecimal(this.TextBoxAmount.Text); //!!! newRow.StatusID = selectedStatus.Id; context.TableOrders.Add(newRow); context.SaveChanges(); this.Close(); }
private void ButtonDel_Click(object sender, RoutedEventArgs e) { TablePersons row = new TablePersons(); row = (TablePersons)this.DataGridPersons.SelectedItems[0]; int id_del = row.Id; context.TablePersons.Remove(context.TablePersons.Find(id_del)); context.SaveChanges(); RefreshWindow(); }
private void RemoveOrder_Click(object sender, RoutedEventArgs e) { FuncOrders1_Result selectedRow = new FuncOrders1_Result(); selectedRow = (FuncOrders1_Result)this.DataGridOrders.SelectedItems[0]; TableOrders rowForDel = new TableOrders(); rowForDel = (from c in context.TableOrders where c.Id == selectedRow.id select c).First(); context.TableOrders.Remove(rowForDel); context.SaveChanges(); RefreshWindow(); }
private void ButtonOK_Click(object sender, RoutedEventArgs e) { try { row.FirstName = this.TextBoxFNameNew.Text; row.LastName = this.TextBoxLNameNew.Text; row.DateOfBirth = this.DatePikerNew.DisplayDate; row.Address = this.TextBoxAddressNew.Text; row.Phone = this.TextBoxPhoneNew.Text; row.E_mail = this.TextBoxEmailNew.Text; context.SaveChanges(); this.Close(); } catch (Exception exp) { MessageBox.Show(exp.Message); } }
private void ButtonOK_Click(object sender, RoutedEventArgs e) { TableOrders editedOrder = new TableOrders(); editedOrder = (TableOrders)(from c in context.TableOrders where c.Id == selectedRow.id select c).First(); editedOrder.idPerson = editedPersonID; editedOrder.idCar = editedCarID; editedOrder.Date = this.DatePickedDateEdited.SelectedDate; editedOrder.Amount = Convert.ToDecimal(this.TextBoxAmountEdited.Text); TableStatus editedStatus = new TableStatus(); editedStatus = (from c in context.TableStatus where c.Status == this.ComboBoxEditStatus.Text select c).First(); editedOrder.StatusID = editedStatus.Id; context.SaveChanges(); this.Close(); }
private void ButtonAdd_Click(object sender, RoutedEventArgs e) { string username = this.TextBoxUsername.Text.ToString(); string login = this.TextBoxLogin.Text.ToString(); string password = this.TextBoxPassword.Text.ToString(); string grup = this.ComboBoxGroup.Text.ToString(); //========================Searching id by the name of user group in the tabe TabeGroups CarRentalCenterDBEntities context = new CarRentalCenterDBEntities(); var row = (from c in context.TableGroups where c.NameGrp == grup select c).First(); // !!!! int idGroup = row.Id; // //==========================Adding new user context.TableUsers.Add(new TableUsers() { Usr = username, GroupsID = idGroup, Lgin = login, Pass = password }); context.SaveChanges(); this.Close(); }
private void ButtonAdd_Click(object sender, RoutedEventArgs e) { TableCars newCar = new TableCars(); var row1 = (TableMakers)(from c in context.TableMakers where c.Maker == this.ComboBoxMaker.Text select c).First(); newCar.MakerID = (int)row1.Id; var row2 = (TableModels)(from c in context.TableModels where c.Model == this.ComboBoxModel.Text select c).First(); newCar.ModelID = (int)row2.Id; newCar.Year = this.DatePicketYear.SelectedDate; newCar.VIN = this.TextBoxVIN.Text; context.TableCars.Add(newCar); context.SaveChanges(); this.Close(); }
private void ButtonAdd_Click(object sender, RoutedEventArgs e) { try { CarRentalCenterDBEntities context = new CarRentalCenterDBEntities(); context.TablePersons.Add( new TablePersons() { FirstName = this.TextBoxFName.Text, LastName = this.TextBoxLname.Text, DateOfBirth = this.DatePicked.SelectedDate, Address = this.TextBoxAddress.Text, Phone = this.TextBoxPhone.Text, E_mail = this.TextBoxEmail.Text }); context.SaveChanges(); this.Close(); } catch (Exception exp) { MessageBox.Show(exp.Message); } }