public void UpdMu()
{
reader = connection.GetDBData("select * from mu where prof_id='" + prof_id.ToString() + "';");
int i = 0;
while (reader.Read())
{
string comment = reader["comment"].ToString();
int course_id = Convert.ToInt32(reader["course_id"]);
int classes_id = Convert.ToInt32(reader["classes_id"]);
string[] stroke = reader["date"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string link = reader["link"].ToString();
DB_connect cn = new DB_connect(ip, db, user, pass);
MySqlDataReader reader2 = cn.GetDBData("select * from course where id='" + course_id.ToString() + "';");
reader2.Read();
string name = reader2["name"].ToString();
reader2.Close();
reader2 = cn.GetDBData("select * from classes where id='" + classes_id + "';");
reader2.Read();
string classes_type_name = reader2["classes_type_name"].ToString();
string num = reader2["number"].ToString();
string[] stroke2 = reader2["date"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
reader2.Close();
reader2 = cn.GetDBData("select * from capacity where prof_id='" + prof_id + "' and course_id='" + course_id + "' and classes_id='" + classes_id + "';");
string group_name = "";
if (reader2.Read())
{
group_name = reader2["groups_name"].ToString();
}
reader2.Close();
dataGridView1.Rows.Add(name, group_name, classes_type_name, num, stroke2[0], comment, link, stroke[0]);
dataGridView1.Rows[i].Height = 80;
i++;
}
}
private void button1_Click(object sender, EventArgs e)
{
int k = comboBox1.SelectedIndex;
DB_connect con = new DB_connect(txt[k][1], txt[k][3], txt[k][4], txt[k][5]);
if (con.CheckLogPass(textBox1.Text, textBox2.Text))
{
if (con.CheckRole(textBox1.Text) == "prof")
{
this.Hide();
MainForm mf = new MainForm(textBox1.Text, txt[k][1], txt[k][3], txt[k][4], txt[k][5]);
mf.Show();
}
if (con.CheckRole(textBox1.Text) == "stud")
{
this.Hide();
StudForm st = new StudForm(textBox1.Text, txt[k][1], txt[k][3], txt[k][4], txt[k][5]);
st.Show();
}
}
else
{
MessageBox.Show("Неверные логин или пароль!");
}
}
private void DataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
DataGridViewCell cell = dataGridView1.CurrentCell;
if (!(cell.Value == null) && !(cell.Value.ToString() == "") && (cell.ColumnIndex > 0))
{
//MessageBox.Show(cell.Value.ToString());
String[] stroke = cell.Value.ToString().Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
// stroke[0] = дисциплина, stroke[1] = группа
string group_name = stroke[1];
string course_name = stroke[0];
ini_func ini = new ini_func();
DB_connect connection = new DB_connect(ip, db, user, pass);
MySqlDataReader reader = connection.GetDBData("select * from course where name='" + course_name + "';");
int course_id = 0;
if (reader.Read())
{
course_id = Convert.ToInt32(reader["id"]);
}
reader.Close();
if (!(group_name == "") && !(course_id == 0))
{
Progress pr = new Progress(group_name, course_id, ip, db, user, pass);
if (ini.FormOpened(pr))
{
Application.OpenForms[pr.Name].Focus();
}
else
{
pr.Show();
}
}
}
}
public StudForm(string login, string ip, string db, string user, string pass)
{
InitializeComponent();
this.login = login;
this.ip = ip;
this.db = db;
this.user = user;
this.pass = pass;
connection = new DB_connect(ip, db, user, pass);
}
private void Add_ad_Shown(object sender, EventArgs e)
{
DB_connect con = new DB_connect(ip, db, user, pass);
MySqlDataReader reader = con.GetDBData("select * from capacity where prof_id='" + prof_id + "' group by groups_name;");
while (reader.Read())
{
string group_name = reader["groups_name"].ToString();
checkedListBox1.Items.Add(group_name);
}
reader.Close();
}
public MainForm(string login, string ip, string db, string user, string pass)
{
InitializeComponent();
this.MaximizeBox = false;
this.FormBorderStyle = FormBorderStyle.FixedDialog;
this.login = login;
this.ip = ip;
this.db = db;
this.user = user;
this.pass = pass;
connection = new DB_connect(ip, db, user, pass);
this.dataGridView1.CellClick += DataGridView1_CellClick;
}
public choose_pr(int prof_id, string ip, string db, string user, string pass)
{
InitializeComponent();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.FormBorderStyle = FormBorderStyle.FixedDialog;
this.ip = ip;
this.db = db;
this.user = user;
this.pass = pass;
this.prof_id = prof_id;
con = new DB_connect(ip, db, user, pass);
}
public StudSched(string name, string group_name, string ip, string db, string user, string pass)
{
InitializeComponent();
this.group_name = group_name;
this.ip = ip;
this.db = db;
this.user = user;
this.pass = pass;
con = new DB_connect(ip, db, user, pass);
string today = DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day;
reader = con.GetDBData("select * from week where date_start<='" + today + "' and date_finish>='" + today + "';");
reader.Read();
week = Convert.ToInt32(reader["week_no"]);
reader.Close();
}
public Progress(string groups_name, int course_id, string ip, string db, string user, string pass)
{
InitializeComponent();
this.MaximizeBox = false;
this.FormBorderStyle = FormBorderStyle.FixedDialog;
this.groups_name = groups_name;
this.course_id = course_id;
this.ip = ip;
this.db = db;
this.user = user;
this.pass = pass;
con = new DB_connect(ip, db, user, pass);
this.listBox1.MouseDoubleClick += listBox1_MouseDoubleClick;
this.dataGridView2.CellEndEdit += dataGridView2_labs;
this.dataGridView3.CellEndEdit += dataGridView3_rk;
this.dataGridView4.CellEndEdit += dataGridView4_dz;
}
public Prepsched(string login, string ip, string db, string user, string pass)
{
InitializeComponent();
this.MaximizeBox = false;
this.FormBorderStyle = FormBorderStyle.FixedDialog;
this.ip = ip;
this.db = db;
this.user = user;
this.pass = pass;
this.login = login;
con = new DB_connect(ip, db, user, pass);
string today = DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day;
reader = con.GetDBData("select * from week where date_start<='" + today + "' and date_finish>='" + today + "';");
reader.Read();
week = Convert.ToInt32(reader["week_no"]);
reader.Close();
this.dataGridView1.CellClick += DataGridView1_CellClick;
}
public Ads(int prof_id, string ip, string db, string user, string pass)
{
InitializeComponent();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.FormBorderStyle = FormBorderStyle.FixedDialog;
this.prof_id = prof_id;
this.ip = ip;
this.db = db;
this.user = user;
this.pass = pass;
this.prof_id = prof_id;
con = new DB_connect(ip, db, user, pass);
reader = con.GetDBData("select name from professor where id='" + prof_id + "';");
reader.Read();
prof_name = reader["name"].ToString();
reader.Close();
label1.Text = prof_name;
}
private void choose_pr_Load(object sender, EventArgs e)
{
reader = con.GetDBData("select * from capacity where prof_id='" + prof_id + "' group by groups_name;");
while (reader.Read())
{
comboBox1.Items.Add(reader["groups_name"]);
}
reader.Close();
reader = con.GetDBData("select * from capacity where prof_id='" + prof_id + "' group by course_id;");
while (reader.Read())
{
int id = Convert.ToInt32(reader["course_id"]);
DB_connect con2 = new DB_connect(ip, db, user, pass);
MySqlDataReader reader2 = con2.GetDBData("select * from course where id='" + id + "'");
reader2.Read();
comboBox2.Items.Add(reader2["name"]);
reader2.Close();
}
reader.Close();
}
private void updMu()
{
reader = connection.GetDBData("select * from mu;");
while (reader.Read())
{
int course_id = Convert.ToInt32(reader["course_id"]);
int classes_id = Convert.ToInt32(reader["classes_id"]);
int prof_id = Convert.ToInt32(reader["prof_id"]);
string comment = reader["comment"].ToString();
string link = reader["link"].ToString();
DateTime dt = DateTime.Parse(reader["date"].ToString());
DateTime dt_cl = new DateTime();
string crs_name = "";
string prf_name = "";
string classes_type_name = "";
DB_connect con = new DB_connect(ip, db, user, pass);
MySqlDataReader reader2 = con.GetDBData("select * from course where id='" + course_id + "';");
if (reader2.Read())
{
crs_name = reader2["name"].ToString();
}
reader2.Close();
reader2 = con.GetDBData("select * from professor where id='" + prof_id + "';");
if (reader2.Read())
{
prf_name = reader2["name"].ToString();
}
reader2.Close();
reader2 = con.GetDBData("select * from classes where id='" + classes_id + "' and course_id='" + course_id + "';");
if (reader2.Read())
{
classes_type_name = reader2["classes_type_name"].ToString();
dt_cl = DateTime.Parse(reader["date"].ToString());
}
reader2.Close();
dataGridView1.Rows.Add(crs_name, prf_name, classes_type_name, "", String.Format("{0:dd.MM.yyyy}", dt_cl), comment, link, String.Format("{0:dd.MM.yyyy}", dt));
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Height = 75;
}
}
private void dataGridView2_labs(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView2.Columns[e.ColumnIndex].Name == "mark")
{
DataGridViewRow row = dataGridView2.CurrentRow;
//MessageBox.Show("Hello " + row.Cells[3].Value.ToString());
DB_connect cn = new DB_connect(ip, db, user, pass);
DateTime dt = DateTime.Parse(row.Cells[1].Value.ToString());
MySqlDataReader reader2 = cn.GetDBData("select * from classes where date='" + String.Format("{0:yyyy-MM-dd}", dt) + "' and course_id='" + course_id + "';");
int class_id = -1;
if (reader2.Read())
{
class_id = Convert.ToInt32(reader2["id"]);
DB_connect cn2 = new DB_connect(ip, db, user, pass);
MySqlDataReader rc = cn2.GetDBData("UPDATE classes_progress SET mark='" + row.Cells[3].Value.ToString() + "' WHERE st_zk_no='" + zk + "' and course_id='" + course_id + "' and classes_id='" + class_id + "';");
rc.Read();
MessageBox.Show("Значение обновлено!");
rc.Close();
}
reader2.Close();
}
}
private void Upd()
{
// Очистка всех таблиц --------------------------------------------------
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView2.Rows.Clear();
dataGridView3.Rows.Clear();
dataGridView4.Rows.Clear();
dataGridView5.Rows.Clear();
//Заполняем таблицу на первой вкладке ------------------------------------
//Создаем колонки
reader = con.GetDBData("select * from classes where classes_type_name='Семинар' AND course_id='" + course_id + "';");
int days = 0;
dataGridView1.Columns.Add("student", "Студент");
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[0].Resizable = DataGridViewTriState.False;
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[0].Width = 150;
String[] stroke;
int i = 1;
while (reader.Read())
{
stroke = reader["date"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
dataGridView1.Columns.Add(stroke[0], stroke[0].ToString());
dataGridView1.Columns[i].Width = 65;
dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[i].Resizable = DataGridViewTriState.False;
string today = DateTime.Today.ToString(); //.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day;
string date = reader["date"].ToString();
if (!(date == today))
{
dataGridView1.Columns[i].ReadOnly = true;
dataGridView1.Columns[i].DefaultCellStyle.ForeColor = DefaultForeColor;
}
else
{
dataGridView1.Columns[i].ReadOnly = false;
dataGridView1.Columns[i].DefaultCellStyle.BackColor = Color.LightGreen;
}
i++;
}
days = i - 1;
reader.Close();
dataGridView1.Columns.Add("late", "Опозданий");
dataGridView1.Columns[i].Width = 80;
dataGridView1.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[i].Resizable = DataGridViewTriState.False;
dataGridView1.Columns[i].ReadOnly = true;
dataGridView1.Columns.Add("work", "Работа на семинарах");
dataGridView1.Columns[i + 1].Width = 90;
dataGridView1.Columns[i + 1].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[i + 1].Resizable = DataGridViewTriState.False;
dataGridView1.Columns[i + 1].ReadOnly = true;
//Заполняем данными
reader = con.GetDBData("select * from students where groups_name='" + groups_name + "';");
i = 0;
while (reader.Read())
{
string name = reader["name"].ToString();
string zk = reader["zk"].ToString();
dataGridView1.Rows.Add(name);
try
{
DB_connect con2 = new DB_connect(ip, db, user, pass);
MySqlDataReader reader2 = con2.GetDBData("select * from attendance where st_zk_no='" + zk + "' and course_id='" + course_id + "';");
int sum_late = 0;
int sum_answer = 0;
int k = 0;
for (int j = 1; j <= days; j++)
{
reader2.Read();
//MessageBox.Show(reader2["attend"].ToString());
dataGridView1.Rows[i].Cells[j].Value = "";
var attend = reader2["attend"].ToString();
var lateness = reader2["lateness"].ToString();
var answer = reader2["answer"].ToString();
string str = "";
if (attend == "True")
{
str += "+";
}
if (lateness == "True")
{
str += "о";
sum_late += 1;
}
if (answer == "True")
{
str += "д";
sum_answer += 1;
}
dataGridView1.Rows[i].Cells[j].Value = str;
k = j;
}
if (!(sum_late == 0))
{
dataGridView1.Rows[i].Cells[k + 1].Value = sum_late.ToString() + "/" + days;
}
if (!(sum_answer == 0))
{
dataGridView1.Rows[i].Cells[k + 2].Value = sum_answer.ToString() + "/" + days;
}
i++;
}
catch (Exception ex) {
MessageBox.Show(ex.ToString());
}
}
reader.Close();
// Вторая вкладка ---------------------------------
// listbox
listBox1.Items.Clear();
DB_connect connect = new DB_connect(ip, db, user, pass);
MySqlDataReader newread = connect.GetDBData("select * from students where groups_name='" + groups_name + "';");
while (newread.Read())
{
listBox1.Items.Add(newread["name"].ToString());
}
newread.Close();
connect.Close();
// заполнение по щелчку dataGridView2, 3 и 4 (лб, рк, дз) отдельной функцией ниже
}
private void Lab_Upd(string name)
{
// Очистка датагридвью
dataGridView2.Rows.Clear();
dataGridView3.Rows.Clear();
dataGridView4.Rows.Clear();
//dataGridView2 --------------------------------------------
DB_connect connect = new DB_connect(ip, db, user, pass);
MySqlDataReader newread = connect.GetDBData("select * from students where name='" + name + "';");
if (newread.Read())
{
zk = newread["zk"].ToString();
}
newread.Close();
newread = connect.GetDBData("select * from classes where course_id='" + course_id + "' and classes_type_name='Лабораторная работа';");
int[] lab_no = null;
int[] lab_id = null;
int i = 0;
while (newread.Read())
{
Array.Resize(ref lab_no, i + 1);
lab_no[i] = Convert.ToInt32(newread["number"]);
Array.Resize(ref lab_id, i + 1);
lab_id[i] = Convert.ToInt32(newread["id"]);
dataGridView2.Rows.Add(lab_no[i].ToString());
string[] stroke = newread["date"].ToString().Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
string s = stroke[0];
dataGridView2.Rows[i].Cells[1].Value = stroke[0];
DB_connect connect2 = new DB_connect(ip, db, user, pass);
MySqlDataReader newread2 = connect2.GetDBData("select * from attendance where st_zk_no='" + zk + "' and course_id='" + course_id + "' and classes_id='" + lab_id[i] + "';");
if (newread2.Read())
{
bool attend = Convert.ToBoolean(newread2["attend"]);
if (attend)
{
dataGridView2.Rows[i].Cells[2].Value = "+";
}
DateTime late_date = DateTime.Parse(stroke[0]);
late_date = late_date.AddDays(7);
TimeSpan ts = DateTime.Today - late_date;
int days_left = ts.Days;
if (days_left > 7)
{
dataGridView2.Rows[i].Cells[4].Value = "+";
}
}
newread2.Close();
newread2 = connect2.GetDBData("select * from classes_progress where st_zk_no='" + zk + "' and course_id='" + course_id + "' and classes_id='" + lab_id[i] + "';");
if (newread2.Read())
{
int mark = Convert.ToInt32(newread2["mark"]);
dataGridView2.Rows[i].Cells[3].Value = mark;
}
newread2.Close();
i++;
}
newread.Close();
//dataGridView3 ------------------------------------------
//string zk;
newread = connect.GetDBData("select * from students where name='" + name + "';");
if (newread.Read())
{
zk = newread["zk"].ToString();
}
newread.Close();
newread = connect.GetDBData("select * from classes where course_id='" + course_id + "' and classes_type_name='Рубежный контроль';");
lab_no = null;
lab_id = null;
i = 0;
while (newread.Read())
{
Array.Resize(ref lab_no, i + 1);
lab_no[i] = Convert.ToInt32(newread["number"]);
Array.Resize(ref lab_id, i + 1);
lab_id[i] = Convert.ToInt32(newread["id"]);
dataGridView3.Rows.Add(lab_no[i].ToString());
string[] stroke = newread["date"].ToString().Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
string s = stroke[0];
dataGridView3.Rows[i].Cells[1].Value = stroke[0];
DB_connect connect2 = new DB_connect(ip, db, user, pass);
MySqlDataReader newread2 = connect2.GetDBData("select * from attendance where st_zk_no='" + zk + "' and course_id='" + course_id + "' and classes_id='" + lab_id[i] + "';");
if (newread2.Read())
{
bool attend = Convert.ToBoolean(newread2["attend"]);
if (attend)
{
dataGridView3.Rows[i].Cells[2].Value = "+";
}
DateTime late_date = DateTime.Parse(stroke[0]);
late_date = late_date.AddDays(7);
TimeSpan ts = DateTime.Today - late_date;
int days_left = ts.Days;
if (days_left > 7)
{
dataGridView3.Rows[i].Cells[4].Value = "+";
}
}
newread2.Close();
newread2 = connect2.GetDBData("select * from classes_progress where st_zk_no='" + zk + "' and course_id='" + course_id + "' and classes_id='" + lab_id[i] + "';");
if (newread2.Read())
{
int mark = Convert.ToInt32(newread2["mark"]);
dataGridView3.Rows[i].Cells[3].Value = mark;
}
newread2.Close();
i++;
}
newread.Close();
// dataGridView4 ---------------------------------------------------
//string zk;
newread = connect.GetDBData("select * from students where name='" + name + "';");
if (newread.Read())
{
zk = newread["zk"].ToString();
}
newread.Close();
newread = connect.GetDBData("select * from classes where course_id='" + course_id + "' and classes_type_name='Домашнее задание';");
lab_no = null;
lab_id = null;
i = 0;
while (newread.Read())
{
Array.Resize(ref lab_no, i + 1);
lab_no[i] = Convert.ToInt32(newread["number"]);
Array.Resize(ref lab_id, i + 1);
lab_id[i] = Convert.ToInt32(newread["id"]);
dataGridView4.Rows.Add(lab_no[i].ToString());
string[] stroke = newread["date"].ToString().Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
string s = stroke[0];
dataGridView4.Rows[i].Cells[1].Value = stroke[0];
DB_connect connect2 = new DB_connect(ip, db, user, pass);
MySqlDataReader newread2 = connect2.GetDBData("select * from attendance where st_zk_no='" + zk + "' and course_id='" + course_id + "' and classes_id='" + lab_id[i] + "';");
if (newread2.Read())
{
bool attend = Convert.ToBoolean(newread2["attend"]);
if (attend)
{
dataGridView4.Rows[i].Cells[2].Value = "+";
}
DateTime late_date = DateTime.Parse(stroke[0]);
late_date = late_date.AddDays(7);
TimeSpan ts = DateTime.Today - late_date;
int days_left = ts.Days;
if (days_left > 7)
{
dataGridView4.Rows[i].Cells[4].Value = "+";
}
}
newread2.Close();
newread2 = connect2.GetDBData("select * from classes_progress where st_zk_no='" + zk + "' and course_id='" + course_id + "' and classes_id='" + lab_id[i] + "';");
if (newread2.Read())
{
int mark = Convert.ToInt32(newread2["mark"]);
dataGridView4.Rows[i].Cells[3].Value = mark;
}
newread2.Close();
i++;
}
newread.Close();
}
// А тут обновляем последнюю вкладку с экзаменом.
public void exam_tab_update()
{
//Очищаем, снова.
dataGridView5.Rows.Clear();
//dataGridView5.Columns.Clear();
DB_connect con = new DB_connect(ip, db, user, pass);
/*MySqlDataReader newread = con.GetDBData("select * from modules where course_id='" + course_id + "';");
* int i = 2;
* while (newread.Read())
* {
* int mdl_id = Convert.ToInt32(newread["id"]);
* DataGridViewColumn module2 = new DataGridViewColumn();
* module2.Name = "in_time_" + i;
* module2.HeaderText = "В срок";
* dataGridView5.Columns.Insert(i, module2);
* DataGridViewColumn module1 = new DataGridViewColumn();
* module1.Name = "module" + i;
* module1.HeaderText = "Модуль " + i/2;
* dataGridView5.Columns.Insert(i, module1);
* i += 2;
* }
* newread.Close(); */
MySqlDataReader newread = con.GetDBData("select * from students where groups_name='" + groups_name + "';");
int j = 1;
int i = 0;
string zk2 = "";
while (newread.Read())
{
string st = newread["name"].ToString();
dataGridView5.Rows.Add(st);
zk2 = newread["zk"].ToString();
DB_connect con2 = new DB_connect(ip, db, user, pass);
MySqlDataReader newreader2 = con2.GetDBData("select * from classes_progress where st_zk_no='" + zk2 + "' and course_id='" + course_id + "';");
int sum_mark = 0;
while (newreader2.Read())
{
sum_mark += Convert.ToInt32(newreader2["mark"]);
}
dataGridView5.Rows[i].Cells[j + 5].Value = sum_mark;
newreader2.Close();
newreader2 = con2.GetDBData("select * from attendance where st_zk_no='" + zk2 + "' and course_id='" + course_id + "';");
int sum_late = 0;
int sum_act = 0;
int num = 0;
while (newreader2.Read())
{
string late = newreader2["attend"].ToString();
string act = newreader2["answer"].ToString();
if (late == "True")
{
sum_late++;
}
if (act == "True")
{
sum_act++;
}
num++;
}
dataGridView5.Rows[i].Cells[j + 2].Value = sum_late + "/" + num;
dataGridView5.Rows[i].Cells[j + 3].Value = sum_late + "/" + num;
newreader2.Close();
newreader2 = con2.GetDBData("select * from classes where classes_type_name='Экзамен' and course_id='" + course_id + "';");
int ekz_cl_id = 0;
if (newreader2.Read())
{
ekz_cl_id = Convert.ToInt32(newreader2["id"]);
}
newreader2.Close();
newreader2 = con2.GetDBData("select * from classes_progress where st_zk_no='" + zk2 + "' and classes_id='" + ekz_cl_id + "' and course_id='" + course_id + "';");
if (newreader2.Read())
{
int mark = Convert.ToInt32(newreader2["mark"]);
dataGridView5.Rows[i].Cells[j + 4].Value = mark;
}
newreader2.Close();
i++;
}
newread.Close();
newread = con.GetDBData("select * from modules where course_id='" + course_id + "';");
i = 2;
while (newread.Read())
{
int mod_id = Convert.ToInt32(newread["id"]);
int mdl_id = Convert.ToInt32(newread["id"]);
dataGridView5.Columns.Add("in_time" + (i / 2).ToString(), "В срок");
dataGridView5.Columns["in_time" + (i / 2).ToString()].DisplayIndex = i;
dataGridView5.Columns.Add("moudule" + (i / 2).ToString(), "Модуль " + (i / 2).ToString());
dataGridView5.Columns["moudule" + (i / 2).ToString()].DisplayIndex = i;
int col_id = dataGridView5.Columns["moudule" + (i / 2).ToString()].Index;
for (int k = 0; k < dataGridView5.RowCount; k++)
{
int mod_mark = 0;
DB_connect con3 = new DB_connect(ip, db, user, pass);
string st_n = dataGridView5.Rows[k].Cells[0].Value.ToString();
MySqlDataReader newreader2 = con3.GetDBData("select * from students where name='" + st_n + "';");
string zk = "";
if (newreader2.Read())
{
zk = newreader2["zk"].ToString();
}
newreader2.Close();
newreader2 = con3.GetDBData("select * from module_progress where course_id='" + course_id + "' and st_zk_no='" + zk + "' and module_id='" + mod_id + "';");
if (newreader2.Read())
{
mod_mark = Convert.ToInt32(newreader2["summ_mark"]);
}
newreader2.Close();
if (!(mod_mark == 0))
{
dataGridView5.Rows[k].Cells[col_id].Value = mod_mark.ToString();
}
newreader2.Close();
}
i += 2;
}
newread.Close();
}
private void StudForm_Shown(object sender, EventArgs e)
{
//Смотрим, что за студент
connection = new DB_connect(ip, db, user, pass);
MySqlDataReader reader = connection.GetDBData("SELECT * FROM students WHERE login='******';");
reader.Read();
label1.Text = reader["name"].ToString();
group_name = reader["groups_name"].ToString();
zk = reader["zk"].ToString();
reader.Close();
//Достаем расписание
string today = DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day;
reader = connection.GetDBData("select * from week where date_start<='" + today + "' and date_finish>='" + today + "';");
string d_s;
string d_f;
int week_no = -1;
if (reader.Read())
{
d_s = reader["date_start"].ToString();
d_f = reader["date_finish"].ToString();
week_no = Convert.ToInt32(reader["week_no"]);
}
reader.Close();
int nechet;
if (!(week_no == -1) && (week_no % 2 == 0))
{
nechet = 0; //знаменатель
}
else
{
nechet = 1; //числитель
}
// А также день недели
reader = connection.GetDBData("select * from day_of_week where name='" + DateTime.Today.DayOfWeek.ToString() + "';");
int day_of_week = 0;
if (reader.Read())
{
day_of_week = Convert.ToInt32(reader["no"]);
}
reader.Close();
reader = connection.GetDBData("select * from pairs");
while (reader.Read())
{
dataGridView1.Rows.Add(reader["pair_no"] + ": " + reader["time_start"] + "-" + reader["time_finish"], "");
}
reader.Close();
// Вытягиваем все занятия и заполняем DataGridView
if (!(day_of_week == 0))
{
reader = connection.GetDBData("select * from schedule_on_week where parity='" + nechet + "' AND day_of_week='" + day_of_week + "' AND groups_name='" + group_name + "';");
while (reader.Read())
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Index == Convert.ToInt32(reader["pair_no"]))
{
row.Cells[1].Value = "";
//Приходится еще раз подключаться в виду некоторых ограничений
DB_connect connection2 = new DB_connect(ip, db, user, pass);
// Дисциплина
MySqlDataReader reader2 = connection2.GetDBData("select * from course where id='" + reader["course_id"] + "';");
reader2.Read();
row.Cells[1].Value += reader2["name"] + "\r\n";
reader2.Close();
// Преподаватель
reader2 = connection2.GetDBData("select * from professor where id='" + reader["prof_id"] + "';");
reader2.Read();
row.Cells[1].Value += reader2["name"] + "\r\n";
reader2.Close();
// Тип
row.Cells[1].Value += reader2["name"] + "\r\n";
// Аудитория уже есть.
row.Cells[1].Value += reader["auditory_no"].ToString();
row.Height = 65;
}
}
}
}
reader.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedItem == null)
{
MessageBox.Show("Вы не заполнили поле \"Дисциплина\"!");
return;
}
string course_name = comboBox1.SelectedItem.ToString();
if (comboBox2.SelectedItem == null)
{
MessageBox.Show("Вы не заполнили поле \"Группа\"!");
return;
}
string group_name = comboBox2.SelectedItem.ToString();
if (comboBox3.SelectedItem == null)
{
MessageBox.Show("Вы не заполнили поле \"Тип занятия\"!");
return;
}
string cl_type = comboBox3.SelectedItem.ToString();
if (textBox1.Text == "")
{
MessageBox.Show("Вы не заполнили поле \"Номер занятия\"!");
return;
}
int cl_id = Convert.ToInt32(textBox1.Text);
string comment = textBox2.Text;
string link = textBox3.Text;
DB_connect con2 = new DB_connect(ip, db, user, pass);
MySqlDataReader reader2 = con2.GetDBData("select * from course where name='" + course_name + "';");
int course_id = 0;
if (reader2.Read())
{
course_id = Convert.ToInt32(reader2["id"]);
}
reader2.Close();
reader2 = con2.GetDBData("select * from classes where id='" + cl_id + "' and course_id='" + course_id + "';");
if (reader2.Read())
{
DB_connect con3 = new DB_connect(ip, db, user, pass);
MySqlDataReader reader3;
if (id == 0)
{
reader3 = con3.GetDBData("insert into mu (classes_id, course_id, prof_id, comment, link, date) values ('" + cl_id + "', '" + course_id + "', '" + prof_id + "', '" + comment + "', '" + link + "', '" + String.Format("{0:yyyy-MM-dd}", DateTime.Today) + "');");
while (reader3.Read())
{
}
MessageBox.Show("МУ успешно добавлено!", "Успех!");
}
else
{
reader3 = con3.GetDBData("update mu set comment='" + comment + "', link='" + link + "' where id='" + id + "';");
while (reader3.Read())
{
}
MessageBox.Show("МУ успешно обновлено!", "Успех!");
}
this.Close();
Mu mu = Application.OpenForms["Mu"] as Mu;
mu.UpdMu();
}
else
{
MessageBox.Show("Такого урока не существует!", "Ошибка.");
}
}
public void UpdMu(int id)
{
DB_connect cn = new DB_connect(ip, db, user, pass);
MySqlDataReader reader;
if (id == 0)
{
reader = cn.GetDBData("select * from capacity where prof_id='" + prof_id + "';");
while (reader.Read())
{
int course_id = Convert.ToInt32(reader["course_id"]);
int classes_id = Convert.ToInt32(reader["classes_id"]);
string groups_name = reader["groups_name"].ToString();
string course_name;
DB_connect con = new DB_connect(ip, db, user, pass);
MySqlDataReader reader2 = con.GetDBData("select * from course where id='" + course_id + "';");
if (reader2.Read())
{
course_name = reader2["name"].ToString();
if (comboBox1.FindString(course_name) == -1)
{
comboBox1.Items.Add(course_name);
}
}
reader2.Close();
if (comboBox2.FindString(groups_name) == -1)
{
comboBox2.Items.Add(groups_name);
}
reader2 = con.GetDBData("select * from classes_type;");
while (reader2.Read())
{
string cl_name = reader2["name"].ToString();
if (comboBox3.FindString(cl_name) == -1)
{
comboBox3.Items.Add(cl_name);
}
}
reader2.Close();
}
reader.Close();
}
else
{
reader = cn.GetDBData("select * from mu where id='" + id + "';");
reader.Read();
int course_id = Convert.ToInt32(reader["course_id"]);
int classes_id = Convert.ToInt32(reader["classes_id"]);
string comment = reader["comment"].ToString();
string link = reader["link"].ToString();
DateTime date = DateTime.Parse(reader["date"].ToString());
reader.Close();
// ----
reader = cn.GetDBData("select name from course where id='" + course_id + "';");
reader.Read();
string course_name = reader["name"].ToString();
reader.Close();
reader = cn.GetDBData("select * from classes where id='" + classes_id + "' and course_id='" + course_id + "';");
reader.Read();
string cl_t_n = reader["classes_type_name"].ToString();
int c_number = Convert.ToInt32(reader["number"]);
reader.Close();
comboBox1.Items.Add(course_name);
comboBox1.SelectedItem = course_name;
comboBox2.Items.Add(group_name);
comboBox2.SelectedItem = group_name;
comboBox3.Items.Add(cl_t_n);
comboBox3.SelectedItem = cl_t_n;
textBox1.Text = c_number.ToString();
textBox2.Text = comment;
textBox3.Text = link;
}
}
private void MainForm_Shown(object sender, EventArgs e)
{
//MessageBox.Show("Hello!");
MySqlDataReader reader = connection.GetDBData("SELECT * FROM professor WHERE login='******';");
//label1.Text = "";
reader.Read();
label1.Text = reader["name"].ToString();
prof_id = Convert.ToInt32(reader["id"]);
reader.Close();
//Высчитать, какие сегодня пары
//Для этого мы должны узнать, какая четность недели
string today = DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day;
reader = connection.GetDBData("select * from week where date_start<='" + today + "' and date_finish>='" + today + "';");
string d_s;
string d_f;
int week_no = -1;
if (reader.Read())
{
d_s = reader["date_start"].ToString();
d_f = reader["date_finish"].ToString();
week_no = Convert.ToInt32(reader["week_no"]);
}
reader.Close();
int nechet;
if (!(week_no == -1) && (week_no % 2 == 0))
{
nechet = 1; //числитель
}
else
{
nechet = 2; //знаменатель
}
// А также день недели
reader = connection.GetDBData("select * from day_of_week where name='" + DateTime.Today.DayOfWeek.ToString() + "';");
int day_of_week = 0;
if (reader.Read())
{
day_of_week = Convert.ToInt32(reader["no"]);
}
reader.Close();
// И ID преподавателя
reader = connection.GetDBData("select * from professor where login='******';");
if (reader.Read())
{
prof_id = Convert.ToInt32(reader["id"]);
}
reader.Close();
// Вытягиваем время занятий
reader = connection.GetDBData("select * from pairs");
while (reader.Read())
{
dataGridView1.Rows.Add(reader["pair_no"] + ": " + reader["time_start"] + "-" + reader["time_finish"], "");
}
reader.Close();
// Вытягиваем все занятия и заполняем DataGridView
if (!(day_of_week == 0))
{
reader = connection.GetDBData("select * from schedule_on_week where (parity='" + nechet + "' or parity='0') AND day_of_week='" + day_of_week + "' AND prof_id='" + prof_id + "';");
while (reader.Read())
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Index == Convert.ToInt32(reader["pair_no"]))
{
row.Cells[1].Value = "";
//Приходится еще раз подключаться в виду некоторых ограничений
DB_connect connection2 = new DB_connect(ip, db, user, pass);
// Дисциплина
MySqlDataReader reader2 = connection2.GetDBData("select * from course where id='" + reader["course_id"] + "';");
reader2.Read();
row.Cells[1].Value += reader2["name"] + "\r\n";
reader2.Close();
// Группа
reader2 = connection2.GetDBData("select * from groups where name='" + reader["groups_name"] + "';");
reader2.Read();
row.Cells[1].Value += reader2["name"] + "\r\n";
reader2.Close();
// Тип
row.Cells[1].Value += reader["classes_type_name"].ToString() + "\r\n";
// Аудитория уже есть.
row.Cells[1].Value += reader["auditory_no"].ToString();
row.Height = 65;
}
}
}
}
reader.Close();
}
private void Upd(int week_no)
{
// Очистка таблицы
dataGridView1.Rows.Clear();
//Заполнение
reader = con.GetDBData("SELECT * FROM professor WHERE login='******';");
reader.Read();
label1.Text = reader["name"].ToString();
int prof_id = Convert.ToInt32(reader["id"]);
reader.Close();
// Выбранная неделя
reader = con.GetDBData("select * from week where week_no='" + week_no + "';");
reader.Read();
string[] d_s = reader["date_start"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string[] d_f = reader["date_finish"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
textBox1.Text = d_s[0];
textBox2.Text = d_f[0];
reader.Close();
int nechet;
if (week_no % 2 == 0)
{
nechet = 2;
}
else
{
nechet = 1;
}
reader = con.GetDBData("select * from pairs");
while (reader.Read())
{
dataGridView1.Rows.Add(reader["pair_no"] + ": " + reader["time_start"] + "-" + reader["time_finish"]);
}
string group_name = "";
for (int i = 1; i < 7; i++)
{
DB_connect con2 = new DB_connect(ip, db, user, pass);
MySqlDataReader reader2 = con2.GetDBData("select * from schedule_on_week where (parity='" + nechet + "' or parity='0') and day_of_week='" + i + "' and prof_id='" + prof_id + "';");
while (reader2.Read())
{
int pair_no = Convert.ToInt32(reader2["pair_no"]);
group_name = reader2["groups_name"].ToString();
string classes_type_name = reader2["classes_type_name"].ToString();
int course_id = Convert.ToInt32(reader2["course_id"]);
int auditory = Convert.ToInt32(reader2["auditory_no"]);
DB_connect con3 = new DB_connect(ip, db, user, pass);
MySqlDataReader reader3 = con3.GetDBData("select * from course where id='" + course_id + "';");
reader3.Read();
string course_name = reader3["name"].ToString();
reader3.Close();
string str = course_name + "\r\n" + group_name + "\r\n" + classes_type_name + "\r\n" + auditory;
dataGridView1.Rows[pair_no - 1].Cells[i].Value = str;
dataGridView1.Rows[pair_no - 1].Height = 65;
}
}
reader.Close();
}
