private void go_service(object sender, RoutedEventArgs e) { WindowAdminService service = new WindowAdminService(); this.Close(); service.Show(); }
private void go_back(object sender, RoutedEventArgs e) { WindowAdminService winadm = new WindowAdminService(); this.Close(); winadm.Show(); }
private void go_add(object sender, RoutedEventArgs e) { string title = title_box.Text.Trim(); string cost = cost_box.Text.Trim(); string time = time_box.Text.Trim(); string skidka = skidka_box.Text.Trim(); //GenderCode DB db = new DB(); SqlCommand command = new SqlCommand("INSERT INTO Service ( Name, Price, Time, Discount, ImagePath)" + "VALUES (@title, @cost, @time, @skidka, @path)", db.getConnection()); command.Parameters.Add("@title", SqlDbType.VarChar).Value = title; command.Parameters.Add("@cost", SqlDbType.VarChar).Value = cost; command.Parameters.Add("@time", SqlDbType.Int).Value = time; command.Parameters.Add("@skidka", SqlDbType.VarChar).Value = skidka; command.Parameters.Add("@path", SqlDbType.VarChar).Value = imagepath; db.openConnection(); if (imagepath.ToString() != "") { if (CheckTextBoxes()) { if (command.ExecuteNonQuery() == 1) { WindowAdminService winadm = new WindowAdminService(); MessageBox.Show("Услуга успешно добавлена!"); this.Close(); winadm.Show(); } else { MessageBox.Show("Проверьте правильность введеных данных"); } } else { MessageBox.Show("Заполните пустые поля"); } } else { MessageBox.Show("Выберите изображение"); } }
private void go_save(object sender, RoutedEventArgs e) { DB db = new DB(); SqlCommand command = new SqlCommand("UPDATE Service SET Name = @title, Price = @cost, Time = @time, Discount = @skidka, ImagePath = @image Where ID = @ids", db.getConnection()); command.Parameters.AddWithValue("@title", title_box.Text); command.Parameters.AddWithValue("@cost", cost_box.Text); command.Parameters.AddWithValue("@time", time_box.Text); command.Parameters.AddWithValue("@skidka", skidka_box.Text); command.Parameters.AddWithValue("@image", Service.MainImagePath); command.Parameters.AddWithValue("@ids", Service.ID); db.openConnection(); if (command.ExecuteNonQuery() == 1) { WindowAdminService winadm = new WindowAdminService(); MessageBox.Show("Услуга успешно отредактирована!"); this.Close(); winadm.Show(); } }