static public void InsideOpis(int n_delo) { bool b = WorkWithDB.ProverkaForTitleList(n_delo); if (b == true) { var app = new word.Application(); app.Visible = false; var doc = app.Documents.Open(InsideOpise); doc.Activate(); doc.Bookmarks["worker"].Range.Text = WorkWithDB.fio; // doc.Bookmarks["datanow"].Range.Text = DateTime.Now.ToShortDateString(); doc.Bookmarks["datadog"].Range.Text = WorkWithDB.DataDogForDoc(n_delo); doc.Bookmarks["kolvodoc"].Range.Text = WorkWithDB.KolvoDocForDog(n_delo); doc.Bookmarks["kolvolistovdela"].Range.Text = WorkWithDB.KolVoListovDelaForDoc(n_delo); doc.Bookmarks["listn_liste"].Range.Text = WorkWithDB.DiapDelaForDoc(n_delo); doc.Bookmarks["naim_kontragent"].Range.Text = WorkWithDB.KlientForDoc(n_delo); doc.Bookmarks["nomdog"].Range.Text = WorkWithDB.NomDogForDoc(n_delo); doc.Saved = true; doc.SaveAs2(InsideOpis1); doc.Close(); System.Windows.Forms.MessageBox.Show("Внутренняя опись сформированна"); } else { System.Windows.Forms.MessageBox.Show("В выбранном Вами деле еще нет документов"); } }
public StatisticOfUser() { InitializeComponent(); workDB = new WorkWithDB(); listOfTrainings.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; listOfTrainings.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; listOfExercises.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; listOfExercises.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; chart1.Legends.Add("График ошибок и скоростей"); chart1.Legends[0].Title = "График ошибок и скоростей"; chart1.Series.Add("Скорость"); chart1.Series[0].ChartType = SeriesChartType.Spline; chart1.Series[0].IsValueShownAsLabel = true; chart1.Series[0].LabelBackColor = Color.Wheat; chart1.Series[0].IsXValueIndexed = true; chart1.Series.Add("Ошибки"); chart1.Series[1].ChartType = SeriesChartType.Spline; chart1.Series[1].IsValueShownAsLabel = true; chart1.Series[1].LabelBackColor = Color.Wheat; chart1.Series[1].IsXValueIndexed = true; chart1.ChartAreas[0].AxisX.IntervalType = DateTimeIntervalType.Days; //chart1.ChartAreas[0].AxisX.Interval = 12; chart1.Series[0].XValueType = ChartValueType.DateTime; chart1.ChartAreas[0].AxisX.LabelStyle.Format = "dd-MM HH:mm"; chart1.Series[0].Points.AddXY(DateTime.Now.ToOADate(), 0); }
static public void TitleListPrint(int n_delo) { bool b = WorkWithDB.ProverkaForTitleList(n_delo); if (b == true) { string x = Interaction.InputBox("Введите номер тома, который будет отображаться на титульном листе", "Номер тома", "", 10, 10); if (x != "") { var app = new word.Application(); app.Visible = false; var doc = app.Documents.Open(title_list); // открыли файл Word, который является как бы doc.Activate(); doc.Bookmarks["nom_dela"].Range.Text = WorkWithDB.NaimDela(n_delo); doc.Bookmarks["dt1"].Range.Text = WorkWithDB.SearchDt1(n_delo.ToString());// заполнили закладки, созданные в Wordе doc.Bookmarks["dt2"].Range.Text = WorkWithDB.SearchDt2(n_delo.ToString()); doc.Bookmarks["kolvo_listov"].Range.Text = WorkWithDB.KolVoListov(n_delo); doc.Bookmarks["n_toma"].Range.Text = x; doc.Bookmarks["zag_dela"].Range.Text = WorkWithDB.ZagolovokDela(n_delo.ToString()); doc.Bookmarks["pref"].Range.Text = WorkWithDB.PrefDela(n_delo.ToString()); doc.Saved = true; doc.SaveAs2(ttl); // сохранили файл со вставками в закладки под новым именем System.Windows.Forms.MessageBox.Show("Титульный лист сохранен"); doc.Close(); } else { System.Windows.Forms.MessageBox.Show("Вы не ввели номер тома"); } } }
private void ModCityBut_Click(object sender, EventArgs e) { if (CityBox.Text != "" && DisctrictCB.Text != "") { if (CityBox.Text == namec && DisctrictCB.Text == disc) { MessageBox.Show("Не произошло изменений"); } else { bool b = WorkWithDB.ModCity(Convert.ToInt32(idc), CityBox.Text, DisctrictCB.SelectedValue.ToString()); if (b == true) { MessageBox.Show("Запись изменена"); } else { MessageBox.Show("Запись не изменена"); } } } else { MessageBox.Show("Не все поля заполнены"); } }
public User(string login, string password, bool isAdmin) { _login = login; _password = password; _isAdmin = isAdmin; _db = new WorkWithDB(); }
private void button1_Click(object sender, EventArgs e) { if (LoginBox.Text != "" && PasBox.Text != "" && FioBox.Text != "" && TelBox.Text != "" && PostBox.Text != "" && DolzhnostBox.Text != "" && RoleCB.Text != "" && LoginBox.Text != Authorization.Administrator) { if (TelBox.Text.Contains(' ')) { MessageBox.Show("Не все поля заполнены"); } { string pasword = WorkWithDB.GetHashString(PasBox.Text); bool a = WorkWithDB.EmailProverka(PostBox.Text); if (a == true) { bool b = WorkWithDB.ModWorker(ViewWorkers.id, LoginBox.Text, pasword, RoleCB.Text, TelBox.Text, PostBox.Text, DolzhnostBox.Text, FioBox.Text); if (b == true) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } } } } else { MessageBox.Show("Не все поля заполнены"); } }
private void button23_Click(object sender, EventArgs e) { if (DisctrictBox.Text != "") { if (DisctrictBox.Text != a) { bool b = WorkWithDB.ModDisctrict(DistrictGrid.CurrentRow.Cells[0].Value.ToString(), DisctrictBox.Text); if (b == true) { MessageBox.Show("Запись изменена"); } else { MessageBox.Show("Запись не изменена"); } WorkWithDB.DistrictVivod(); DistrictGrid.DataSource = WorkWithDB.VivodDistrict; } else { MessageBox.Show("Новые данные не были введены."); } } else { MessageBox.Show("Вы ничего не ввели"); } }
public Level(int numberOfLevel, List<Row> usingRowList) { _numberOfLevel = numberOfLevel; _usingRowList = usingRowList; _exercises = new List<Exercise>(10); _db = new WorkWithDB(); }
private void RefuseMethod() { _dialogWindow.Close(); WorkWithDB.Update_Product_Async((DataContext as DialogWithOrderInfoViewModel).Product, StatusOfProduct.Completed); (DataContext as DialogWithOrderInfoViewModel).Product.Status = StatusOfProduct.Completed; IoC.UserView.Set_Orders(); }
private void ViewWorkers_Load(object sender, EventArgs e) { WorkWithDB.VivodWorkers(); WorkersGrid.DataSource = WorkWithDB.VivodWorkerInTable; WorkersGrid.Columns[0].Visible = false; WorkersGrid.Columns[3].Visible = false; }
public StatisticsOfExercise(int exerciseNumber, int trainingId) { // Конструктор для извлечения данных по номеру упр-ния и id тренировки _exerciseNumber = exerciseNumber; _trainingId = trainingId; _db = new WorkWithDB(); }
public void Update(CP entity) { using (var _connection = new SQLiteConnection(connectionString)) using (var cmd = new SQLiteCommand(_connection)) { _connection.Open(); if (entity != null) { var _idGroup = this.GetIdGroupForCP(entity.GroupName); cmd.Parameters.AddWithValue("@Id", WorkWithDB.GetIdCp(entity.Name, _idGroup, entity.NameDiscipline, entity.TermName)); cmd.Parameters.AddWithValue("@Name", entity.Name); cmd.Parameters.AddWithValue("@From", entity.From); cmd.Parameters.AddWithValue("@To", entity.To); cmd.Parameters.AddWithValue("@TermId", entity.TermId); cmd.Parameters.AddWithValue("@WeightKT", entity.WeightKT); cmd.Parameters.AddWithValue("@WeightLab", entity.WeightLab); cmd.Parameters.AddWithValue("@WeightLek", entity.WeightLek); cmd.Parameters.AddWithValue("@WeightPrac", entity.WeightPrac); cmd.Parameters.AddWithValue("@WeightMore", entity.WeightMore); cmd.Parameters.AddWithValue("@GroupId", this.GetIdGroupForCP(entity.GroupName)); cmd.Parameters.AddWithValue("@CountLek", entity.CountLek); cmd.Parameters.AddWithValue("@CountLab", entity.CountLab); cmd.Parameters.AddWithValue("@CountPrac", entity.CountPrac); cmd.CommandText = "UPDATE CP SET weight_lab = @WeightLab, weight_lek = @WeightLek, " + "weight_prac = @WeightPrac, weight_more = @WeightMore, weight_kt = @WeightKT, " + "countLek = @CountLek, countLab = @CountLab, countPrac = @CountPrac WHERE id = @Id"; cmd.ExecuteNonQuery(); } } }
public void Add(CP entity) { _databaseStub.Add(entity); using (var _connection = new SQLiteConnection(connectionString)) using (var cmd = new SQLiteCommand(_connection)) { _connection.Open(); foreach (var item in _databaseStub) { cmd.Parameters.AddWithValue("@Name", item.Name); cmd.Parameters.AddWithValue("@TermId", WorkWithDB.GetIdTermForCp(item.TermName)); cmd.Parameters.AddWithValue("@WeightKT", item.WeightKT); cmd.Parameters.AddWithValue("@WeightLab", item.WeightLab); cmd.Parameters.AddWithValue("@WeightLek", item.WeightLek); cmd.Parameters.AddWithValue("@WeightPrac", item.WeightPrac); cmd.Parameters.AddWithValue("@WeightMore", item.WeightMore); cmd.Parameters.AddWithValue("@GroupId", this.GetIdGroupForCP(item.GroupName)); cmd.Parameters.AddWithValue("@CountLek", entity.CountLek); cmd.Parameters.AddWithValue("@CountLab", entity.CountLab); cmd.Parameters.AddWithValue("@CountPrac", entity.CountPrac); cmd.Parameters.AddWithValue("@IdDiscipline", WorkWithDB.GetDisciplineId(entity.NameDiscipline)); cmd.CommandText = "insert or replace into CP (name, " + "term_id, weight_lab, weight_lek, weight_prac, weight_more, weight_kt, group_id, countLek, countLab, countPrac, discipline_id) VALUES" + " (@Name, @TermId, @WeightLab, @WeightLek, @WeightPrac, @WeightMore, @WeightKT, @GroupId, @CountLek, @CountLab, @CountPrac, @IdDiscipline)"; cmd.ExecuteNonQuery(); } } _databaseStub.Clear(); }
private void AcceptMethod() { _dialogWindow.Close(); WorkWithDB.Update_Product_Async((DataContext as DialogWithOrderInfoViewModel).Product, StatusOfProduct.HoldDispetcherToDriverAccept); (DataContext as DialogWithOrderInfoViewModel).Product.Status = StatusOfProduct.HoldDispetcherToDriverAccept; IoC.UserView.Set_Orders(); }
private void AddingClient_Load(object sender, EventArgs e) { WorkWithDB.DistrictVivodCB(); DisctrictCB.DataSource = WorkWithDB.VivodDistrictCB; DisctrictCB.DisplayMember = "disctrict"; DisctrictCB.ValueMember = "id_disctrict"; }
private void ModificationDocument_Load(object sender, EventArgs e) { NaimDocTB.Text = StartPage.namedoc; KlientCB.Text = StartPage.naim_org; WorkerCB.Text = StartPage.fio; dateTimePicker1.Value = StartPage.d1; dateTimePicker2.Value = StartPage.d2; DeloIDTB.Text = StartPage.n_delo; FPTB.Text = StartPage.lnach; LPTP.Text = StartPage.lend; TypeDocCB.Text = StartPage.nametype; routetofile = StartPage.route; Pref = StartPage.pref; textBox1.Text = StartPage.pref; WorkWithDB.KlientVivodCB(); KlientCB.DataSource = WorkWithDB.VivodKlientCB; KlientCB.DisplayMember = "naim_org"; KlientCB.ValueMember = "id_klient"; WorkWithDB.SotrudnikiVivodCB(); WorkerCB.DataSource = WorkWithDB.VivodSotrudnikiCB; WorkerCB.DisplayMember = "fio"; WorkerCB.ValueMember = "id_sotrud"; WorkWithDB.TypeVivodCB(); TypeDocCB.DataSource = WorkWithDB.VivodTypeCB; TypeDocCB.DisplayMember = "naim_doc"; TypeDocCB.ValueMember = "id_vid_doc"; WorkWithDB.SotrudnikiVivodCB(); comboBox1.DataSource = WorkWithDB.VivodSotrudnikiCB; comboBox1.DisplayMember = "fio"; comboBox1.ValueMember = "id_sotrud"; }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { WorkWithDB.UslVivod1(Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString())); dataGridView2.DataSource = WorkWithDB.ZapPoUsl1; WorkWithDB.UslVivod2(Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString())); dataGridView3.DataSource = WorkWithDB.ZapPoUsl2; }
public StatisticsOfExercise(int exerciseNumber, int trainingId, DateTime dataAndTime) { // Создаем класс статистики при начале прохождения упражнения, т.к указывается время начала _exerciseNumber = exerciseNumber; _trainingId = trainingId; _dataAndTime = dataAndTime; _db = new WorkWithDB(); }
private void PrefTable_Load(object sender, EventArgs e) { AddDocument.Pref = ""; AddDocument.IndPref = ""; WorkWithDB.SprPrefVivod1(); PrefDopTable.DataSource = WorkWithDB.VivodPrefDocVivod1; PrefDopTable.Columns[0].Visible = false; }
private void AddButton_Click(object sender, EventArgs e) { if ((OrganizationBox.Text != "") && (CityCB.Text != "") && (InnBox.Text != "") && (AdresBox.Text != "") && (EmailBox.Text != "")) { if (radioButton1.Checked == true) { if (((InnBox.Text).Length) == 10) { bool bl = WorkWithDB.AddClient(OrganizationBox.Text, Convert.ToInt32(CityCB.SelectedValue), InnBox.Text, AdresBox.Text, EmailBox.Text); if (bl == true) { MessageBox.Show("Запись добавлена."); OrganizationBox.Text = ""; CityCB.Text = ""; InnBox.Text = ""; AdresBox.Text = ""; EmailBox.Text = ""; } else { MessageBox.Show("Запись не добавлена."); } } else { MessageBox.Show("Количество символов ИНН для юр.лица-10. Проверьте данные"); } } else { if (((InnBox.Text).Length) == 12) { bool bl = WorkWithDB.AddClient(OrganizationBox.Text, Convert.ToInt32(CityCB.SelectedValue), InnBox.Text, AdresBox.Text, EmailBox.Text);; if (bl == true) { MessageBox.Show("Запись добавлена."); OrganizationBox.Text = ""; CityCB.Text = ""; InnBox.Text = ""; AdresBox.Text = ""; EmailBox.Text = ""; } else { MessageBox.Show("Запись не добавлена."); } } else { MessageBox.Show("Количество символов ИНН для физ.лица-12. Проверьте данные"); } } } else { MessageBox.Show("Не все поля заполнены"); } }
private void btnAddCp_Click(object sender, EventArgs e) { int sum = 0; try { sum = Convert.ToInt32(tbWeghtMore.Text) + Convert.ToInt32(tbWeightLab.Text) + Convert.ToInt32(tbWeightLek.Text) + Convert.ToInt32(tbWeightPrac.Text); } catch { } var listTextBoxes = new List <TextBox> { tbCountLab, tbCountLek, tbCountPrac }; var emptyIsListTextBoxes = listTextBoxes.AsParallel().Any(t => t.Text == String.Empty); var listCpForGroup = from cp in reposCP.GetAll() where cp.DisciplineId == WorkWithDB.GetDisciplineId(DisciplineName) where cp.GroupId == WorkWithDB.GetIdGroupDisciplineGroup(reposGroup, GroupName) where cp.TermId == WorkWithDB.GetIdTermForCp(TermName) select cp; var sumCp = listCpForGroup.ToList().Sum(t => t.WeightKT); if (emptyIsListTextBoxes || sum > 100 || sum <= 0 || sum < 100 || sumCp + Convert.ToInt32(tbWeightPoint.Text) > 100) { MessageBox.Show("Проверьте введенные данные."); tbCountLek.BackColor = Color.Red; tbCountLab.BackColor = Color.Red; tbCountPrac.BackColor = Color.Red; tbWeightLek.BackColor = Color.Red; tbWeightLab.BackColor = Color.Red; tbWeightPrac.BackColor = Color.Red; tbWeghtMore.BackColor = Color.Red; } else { try { //var _idTerm = WorkWithDB.GetIdTermForCp(TermName); reposCP.Add(new CP(CpName, TermName, GroupName, Convert.ToInt32(tbWeightPoint.Text), Convert.ToInt32(tbWeightLab.Text), Convert.ToInt32(tbWeightLek.Text), Convert.ToInt32(tbWeightPrac.Text), Convert.ToInt32(tbWeghtMore.Text), Convert.ToInt32(tbCountLek.Text), Convert.ToInt32(tbCountLab.Text), Convert.ToInt32(tbCountPrac.Text), DisciplineName)); MessageBox.Show("Точка успешно добавлена"); lstBCp.DataSource = listCpForGroupAndDiscipline; } catch { MessageBox.Show("Ошибка при добавлении контрольной точки!\nПроверьте введенные данные!"); } } listCpForGroup = null; sumCp = default(int); sum = default(int); }
private void DisctrictCB_SelectedIndexChanged(object sender, EventArgs e) { string a = DisctrictCB.Text; WorkWithDB.VivodCityUsl(a); CityCB.DataSource = WorkWithDB.CityPoUsl; CityCB.DisplayMember = "city"; CityCB.ValueMember = "id_city"; }
public Exercise(string zones, int numberOfLevel, string text, string usingSymbols) { _number = accordZoneWithExercise(zones); _numberOfLevel = numberOfLevel; _text = text; _allowedMistakes = Convert.ToInt32(text.Length * 0.1); // 10% от длины упражнения _usingSymbols = usingSymbols; _db = new WorkWithDB(); }
private async void Update_Real_Data() { await Task.Run(() => { Update_Client_Data(); IoC.UserView.PersonalAreaVM.Update_User_PA(); WorkWithDB.UpdateUserInfo(IoC.Application_Work.Current_User, UpdateClientData); }); }
private void DistrictGrid_CellClick(object sender, DataGridViewCellEventArgs e) { WorkWithDB.UslVivod3(Convert.ToInt32(DistrictGrid.CurrentRow.Cells[0].Value.ToString())); CityGrid.DataSource = WorkWithDB.ZapPoUsl3; DisctrictBox.Text = DistrictGrid.CurrentRow.Cells[1].Value.ToString(); a = DistrictGrid.CurrentRow.Cells[0].Value.ToString(); CityGrid.Columns[0].Visible = false; CityGrid.Columns[3].Visible = false; }
private void tabControl4_SelectedIndexChanged(object sender, EventArgs e) { if (tabControl4.SelectedIndex == 1) { WorkWithDB.CountDocInDelo(); WorkWithDB.VivodDeloYc(); DocsForYC.DataSource = WorkWithDB.VivodDelYc; DocsForYC.Columns[0].Visible = false; } }
public StatisticsOfExercise(int exerciseNumber, int trainingId, DateTime dataAndTime, int amountOfMistakes, int speed) { _exerciseNumber = exerciseNumber; _trainingId = trainingId; _dataAndTime = dataAndTime; _amountOfMistakes = amountOfMistakes; _speed = speed; _db = new WorkWithDB(); }
public UTraining (string login,int numberOfLevel, int fontSize, bool backliteKeyBoard, int numberOfCurrentExercise) // пока без параметров { _login=login; _numberOfLevel = numberOfLevel; _fontSize = fontSize; _backliteKeyBoard = backliteKeyBoard; _numberOfCurrentExercise = numberOfCurrentExercise; _db = new WorkWithDB(); }
static void Main(string[] args) { List <Customer> customers = new List <Customer>(); List <Order> orders = new List <Order>(); List <Shipment> shipments = new List <Shipment>(); customers = WorkWithDB.ReadCustomers(); orders = WorkWithDB.ReadOrders(); shipments = WorkWithDB.ReadShipments(); UserMenu userMenu = new UserMenu(customers, orders, shipments); }
private async void Button3_Click(object sender, EventArgs e) { _logger.Info("Нажата кнопка '{0}'", button3.Text); try { await Task.Factory.StartNew(() => { InvokeUI(() => { listStatementLine.Clear(); var reposStudent = RepositoryFactory <Student> .Create(); this.comboBoxListGroups.SelectedIndexChanged += new EventHandler(ComboboxListGroup_SelectedIndexChanged); var _idGroup = reposStudent.GetIdGroupForStudent(GroupName); var _idCp = WorkWithDB.GetIdCp(CpName, _idGroup, DisciplineName, TermName); var _cp = reposCP.Get(_idCp); if (_idCp != 0 && _cp.DisciplineId == WorkWithDB.GetDisciplineId(DisciplineName)) { foreach (var item in StatementLine.GetListStatementLine(_idCp, WorkWithDB.GetDisciplineId(DisciplineName), Convert.ToInt32(reposGroup.GetIdGroupDisciplineGroup(GroupName)), WorkWithDB.GetIdTermForCp(TermName)).AsParallel()) { listStatementLine.Add(item); } var repCp = reposCP.Get(_idCp); tbCountLek.Text = Convert.ToString(repCp.CountLek); tbCountLab.Text = Convert.ToString(repCp.CountLab); tbCountPrac.Text = Convert.ToString(repCp.CountPrac); ShowInformationAboutCp(_idCp); _logger.Info("Информация загружена."); } else if (_idCp == 0) { _logger.Debug("Не удалось получить id контрольной точки!"); } else { MessageBox.Show($"Для данной группы отсутствует '{CpName}' точка!"); _logger.Info("Данные не были загружены, так как у группы {0} отсутствует {1} точка по дисциплине {2} в семестре {3}", GroupName, CpName, DisciplineName, TermName); } }); }); } catch (Exception ex) { _logger.Error("Произошла ошибка ({0}) при загрузке записей", ex.Message); } }
private void SendMethod() { if (!int.TryParse((DataContext as DialogWithOrderInfoViewModel).DeliveryCost, out _deliveryCost)) { return; } _dialogWindow.Close(); WorkWithDB.Update_Product_Async((DataContext as DialogWithOrderInfoViewModel).Product, StatusOfProduct.HoldUserAccept); WorkWithDB.Update_Route_Async((DataContext as DialogWithOrderInfoViewModel).Product.Route, _deliveryCost); (DataContext as DialogWithOrderInfoViewModel).Product.Status = StatusOfProduct.HoldUserAccept; IoC.DispatcherView.Reload_Orders(); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { try { WorkWithDB.UslVivod1(Convert.ToInt32(ClientGrid.CurrentRow.Cells[0].Value.ToString())); DovGrid.DataSource = WorkWithDB.ZapPoUsl1; WorkWithDB.UslVivod2(Convert.ToInt32(ClientGrid.CurrentRow.Cells[0].Value.ToString())); DocGrid.DataSource = WorkWithDB.ZapPoUsl2; } catch { } }
private void ComboboxListTerm_SelectedIndexChanged(object sender, EventArgs e) { listCpForGroupAndDiscipline.Clear(); TermName = cmbTerm.Items[cmbTerm.SelectedIndex].ToString(); var list = WorkWithDB.GetAllCpForGroupAndDiscipline(GroupName, DisciplineName, TermName); foreach (var cp in list) { listCpForGroupAndDiscipline.Add(cp); } lstBCp.DataSource = listCpForGroupAndDiscipline; }
private void CreateNewCarMethod() { try { var carWeight = int.Parse(this.CarWeight); var lifCap = int.Parse(this.LifCap); if (lifCap > carWeight / 2 && carWeight > 2000) { throw new Exception("Too match LiftingCapacity of the car!!"); } else if (CarNumber == string.Empty || LifCap == string.Empty || CarWeight == string.Empty || CarBrand == string.Empty) { throw new Exception("Fill in all cells!!"); } else if (!CheckCarNumber()) { throw new Exception("Incorrect car number!!"); } var car = new Car { CarBrand = this.CarBrand, CarNumber = this.CarNumber, CarWeight = carWeight, LiftingCapacity = lifCap }; foreach (var c in IoC.Application_Work.All_Cars) { if (c.CarNumber == car.CarNumber) { throw new Exception("There is a car with the same number!!"); } } WorkWithDB.Set_Car_Async(car); CarBrand = ""; CarNumber = ""; CarWeight = ""; LifCap = ""; IoC.UI.CommunicationDialog(new MessageBoxDialogViewModel { Message = "Car was added", Title = "Congratulations" }); } catch (Exception ex) { IoC.UI.CommunicationDialog(new MessageBoxDialogViewModel { Message = ex.Message, Title = "Error" }); } }
private void AppointMethod() { if ((DataContext as DialogWithOrderInfoViewModel).CompanyCars.FirstOrDefault(c => c.SelectColor == "8a8a8a") != null && (DataContext as DialogWithOrderInfoViewModel).CompanyCars.FirstOrDefault(c => c.SelectColor == "8a8a8a").CarStatus == "Free") { _dialogWindow.Close(); var car = (DataContext as DialogWithOrderInfoViewModel).CompanyCars.FirstOrDefault(c => c.SelectColor == "8a8a8a").Car; var route = IoC.Application_Work.All_Routes.First(r => r.Product.Id == (DataContext as DialogWithOrderInfoViewModel).Product.Id); WorkWithDB.Update_Car_Async(car, route); WorkWithDB.Update_Product_Async((DataContext as DialogWithOrderInfoViewModel).Product, StatusOfProduct.HoldDriverAccept); (DataContext as DialogWithOrderInfoViewModel).Product.Status = StatusOfProduct.HoldDriverAccept; IoC.DispatcherView.Reload_Orders(); } }
public StatisticsOnExercises() { InitializeComponent(); workDB = new WorkWithDB(); int code = workDB.openConnection(); if (code == 1) { scon = workDB.SqLiteConnection; } else { MessageBox.Show("Не возможно подключиться к БД"); } fillDefault(); }
private void button22_Click(object sender, EventArgs e) { DialogResult rez = MessageBox.Show("Вы точно хотите удалить выбранную запись?", "Удаление записи из таблицы", MessageBoxButtons.YesNo, MessageBoxIcon.Error); if (rez == DialogResult.Yes) { bool b = WorkWithDB.DropDisctrict(Convert.ToInt32(DistrictGrid.CurrentRow.Cells[0].Value.ToString())); if (b == true) { MessageBox.Show("Запись удалена"); } WorkWithDB.DistrictVivod(); DistrictGrid.DataSource = WorkWithDB.VivodDistrict; } }
private void button8_Click(object sender, EventArgs e) { bool b = WorkWithDB.IzmSprDoc(NaimDocBox.Text, Convert.ToInt32(SprNameDocGrid.CurrentRow.Cells[0].Value.ToString())); if (b == true) { MessageBox.Show("Запись изменена"); WorkWithDB.NaimDocVivod(); SprNameDocGrid.DataSource = WorkWithDB.VivodNaimDocVivod; } else { MessageBox.Show("Запись не изменена"); } }
private void button1_Click(object sender, EventArgs e) { if (dateTimePicker1.Value <= dateTimePicker2.Value) { bool b = WorkWithDB.ModDov(dateTimePicker1.Value, dateTimePicker2.Value); if (b == true) { MessageBox.Show("Запись добавлена"); } } else { MessageBox.Show("Некорректно введены даты"); } }
public Exercise(int number, int numberOfLevel) { _number = number; _numberOfLevel = numberOfLevel; _db = new WorkWithDB(); }
public void fillPieChartMistakes() { WorkWithDB workDB = new WorkWithDB(); int code = workDB.openConnection(); if (code == 1) { SQLiteConnection scon = workDB.SqLiteConnection; SQLiteCommand command = new SQLiteCommand( string.Format("SELECT u.login, SUM(st.amountOfMistakes) FROM " + "User u JOIN Training tr ON u.login=tr.login " + "JOIN StatisticsOfExercises AS st ON tr.id_training=st.id_training " + "WHERE st.number={0} AND tr.numberOfLevel={1} " + "GROUP BY u.login;", exerBox.Text, levelBox.Text), scon); DataTable dt = null; SQLiteDataAdapter da = new SQLiteDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; if (dt == null) { MessageBox.Show("БД пуста или запрос не вернул данных"); } else { int amount = dt.Rows.Count; int[] mas = new int[amount]; //Получаем распределение числа пройденных упражнений по пользователям //каждая ячейка относится к одному пользователю for (int i = 0; i < amount; i++) { mas[i] = Convert.ToInt32(dt.Rows[i][1].ToString()); } //сортируем массив Array.Sort(mas); forMistakesChart(mas); } workDB.closeConnection(); } }
public void fillPieChartSpeed() { //запрос должен суммировать число упражнений пройденных каждым пользователем и //группировать по пользователю //потом беру полученные чиселки и получаю из них свои стат данные //смотрю сколько упражнений прошел каждый пользователь //а суммирую пользователей, //на диаграмме будут пользователи WorkWithDB workDB = new WorkWithDB(); int code = workDB.openConnection(); if (code == 1) { SQLiteConnection scon = workDB.SqLiteConnection; SQLiteCommand command = new SQLiteCommand( string.Format("SELECT u.login, AVG(st.speed) FROM " + "User u JOIN Training tr ON u.login=tr.login " + "JOIN StatisticsOfExercises AS st ON tr.id_training=st.id_training " + "WHERE st.number={0} AND tr.numberOfLevel={1} " + "GROUP BY u.login;", exerBox.Text, levelBox.Text), scon); DataTable dt = null; SQLiteDataAdapter da = new SQLiteDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; if (dt == null) { MessageBox.Show("БД пуста или запрос не вернул данных"); } else { int amount = dt.Rows.Count; int[] mas = new int[amount]; //Получаем распределение числа пройденных упражнений по пользователям //каждая ячейка относится к одному пользователю for (int i = 0; i < amount; i++) { mas[i] = (int)(Convert.ToDouble(dt.Rows[i][1].ToString())); } //сортируем массив Array.Sort(mas); forSpeedChart(mas); } workDB.closeConnection(); } }
public void fillDataGreed() { WorkWithDB workDB = new WorkWithDB(); int code = workDB.openConnection(); if (code == 1) { SQLiteConnection scon = workDB.SqLiteConnection; SQLiteCommand command = new SQLiteCommand( string.Format("SELECT tr.login, tr.dataTimeOfTraining, st.speed, st.amountOfMistakes " + "FROM Training tr JOIN StatisticsOfExercises st ON tr.id_training=st.id_training " + "WHERE tr.numberOfLevel = {0} AND st.number= {1} ;", levelBox.Text, exerBox.Text), scon); DataTable dt = null; SQLiteDataAdapter da = new SQLiteDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; if (dt == null) { MessageBox.Show("БД пуста или запрос не вернул данных"); } else { listOfExercisesStat.DataSource = dt; listOfExercisesStat.Columns[0].HeaderText = "Логин"; listOfExercisesStat.Columns[1].HeaderText = "Дата/время тренировки"; listOfExercisesStat.Columns[2].HeaderText = "v, симв./мин"; listOfExercisesStat.Columns[3].HeaderText = "Количество\n\r ошибок"; } } else { MessageBox.Show("Ошибка при соединении с БД"); } workDB.closeConnection(); }
public int existLogin(string checkLogin) { if (_db == null) _db = new WorkWithDB(); int code = _db.openConnection(); if (code == 1) { SQLiteConnection scon = _db.SqLiteConnection; try { DataTable dt = null; SQLiteCommand command = new SQLiteCommand(string.Format("SELECT login" + " from 'User' where login = '******';", checkLogin), scon); SQLiteDataReader data = command.ExecuteReader(); int num = data.StepCount; data.Close(); return num; } catch { return -1; } finally { if (scon != null) _db.closeConnection(); } } else { return code; } }
public int getLastNumberOfEx() { if (_db == null) _db = new WorkWithDB(); int code = _db.openConnection(); if (code == 1) { SQLiteConnection scon = _db.SqLiteConnection; try { DataTable dt = null; SQLiteCommand command = new SQLiteCommand(string.Format("SELECT MAX(st.number)" + " from User as u JOIN Training as tr ON tr.login=u.login JOIN StatisticsOfExercises as st ON" + " st.id_training=tr.id_training where u.login = '******' AND tr.id_training=(SELECT MAX(id_training) FROM Training WHERE login = '******');", _login), scon); SQLiteDataReader data = command.ExecuteReader(); int num=0; if (data.HasRows) { if (!data.IsDBNull(0)) { data.Read(); num = data.GetInt32(0); } } data.Close(); return num; } catch { return -1; } finally { if (scon != null) _db.closeConnection(); } } else { return code; } }
/// <summary> /// Удаляет упражнение из системы и связанные с ней тренировки. /// </summary> /// <param name="number"></param> /// <param name="numberOfLevel"></param> private void deleteExercise(int number, int numberOfLevel) { WorkWithDB wdb = new WorkWithDB(); wdb.openConnection(); try { SQLiteConnection scon = wdb.SqLiteConnection; SQLiteCommand command = new SQLiteCommand( string.Format("DELETE FROM Exercise WHERE number={0} AND numberOfLevel={1};", number, numberOfLevel), scon); int num = command.ExecuteNonQuery(); command = new SQLiteCommand(string.Format ("SELECT id_training FROM Training WHERE numberOfLevel={0};", numberOfLevel), scon); string ids = ""; DataTable dt = null; SQLiteDataAdapter da = new SQLiteDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; if (dt == null) { MessageBox.Show("БД пуста или запрос не вернул данных"); } else { int rows = dt.Rows.Count; for (int i = 0; i < rows; i++) ids += dt.Rows[i][0].ToString() + ","; } ids = ids.Substring(0, ids.Length - 1); command = new SQLiteCommand(string.Format("DELETE FROM StatisticsOfExercises WHERE id_training IN ({0}) AND number={1};", ids, number), scon); command.ExecuteNonQuery(); } catch { } finally { wdb.closeConnection(); } }
private void fillTextBoxes() { WorkWithDB workDB = new WorkWithDB(); int code = workDB.openConnection(); if (code == 1) { SQLiteConnection scon = workDB.SqLiteConnection; SQLiteCommand command = new SQLiteCommand( string.Format("SELECT COUNT(login) FROM User;"), scon); amoutOfUsersBox.Text = doRequest(command); command = new SQLiteCommand( string.Format("SELECT COUNT(id_training) FROM Training;"), scon); amountOfTrainBox.Text = doRequest(command); command = new SQLiteCommand( string.Format("SELECT COUNT(number) FROM Exercise;"), scon); amountOfExBox.Text = doRequest(command); workDB.closeConnection(); } else { MessageBox.Show("Не возможно подключиться к БД"); } }