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("Не возможно подключиться к БД");
}
}
