private void SaveB_Click(object sender, EventArgs e)
{
if (Lgn.Text != "" && NewPass.Text != "")
{
string pass = NewPass.Text;
string ps = "";
for (int i = 0; i < pass.Length; i++)
{
ps += (char)(pass[i] ^ 'k');
}
if (Lgn.Text != "" && NewPass.Text != "")
{
switch (Lgn.Text)
{
case "Начальник отдела":
{
Admins.Rows[1][2] = ps;
}
break;
case "Администратор":
{
Admins.Rows[0][2] = ps;
}
break;
}
SLDataDB.SaveData(queryOrd, Admins);
NewPass.Text = "Сохранено";
}
}
}
private void SaveOrd_Click(object sender, EventArgs e)
{
if (OrdStat.Text != "")
{
switch (OrdStat.Text)
{
case "Получен":
{
Orders.Rows[Convert.ToInt32(OrdN.Text)][4] = 1;
}
break;
case "Выполняется":
{
Orders.Rows[Convert.ToInt32(OrdN.Text)][4] = 2;
}
break;
case "Завершен":
{
Orders.Rows[Convert.ToInt32(OrdN.Text)][4] = 3;
}
break;
}
SLDataDB.SaveData(query, Orders);
Description.Text = "Изменения сохранены.";
}
}
private void DelB_Click(object sender, EventArgs e)
{
if (MangrN.Text != "")
{
MngrsIsh.Rows[Convert.ToInt32(MangrN.Text)].Delete();
SLDataDB.SaveData(queryMng, MngrsIsh);
MangrN.Text = "Удалено";
}
}
private void DelSvcB_Click(object sender, EventArgs e)
{
if (IdSvc.Text != "")
{
Svcs.Rows[Convert.ToInt32(IdSvc.Text) - 1].Delete();
SLDataDB.SaveData(queryClnt, Svcs);
IdSvc.Text = "Удалено";
}
}
private void DiscountChngB_Click(object sender, EventArgs e)
{
if (IDClient.Text != "" && DiscChng.Text != "")
{
for (int i = 0; i < Clnts.Rows.Count; i++)
{
if (Convert.ToInt32(Clnts.Rows[i][0]) == Convert.ToInt32(IDClient.Text))
{
Clnts.Rows[i][6] = DiscChng.Text;
break;
}
}
SLDataDB.SaveData(queryClnt, Clnts);
}
}
private void Add_Click(object sender, EventArgs e)
{
if (Nam.Text != "")
{
DataRow row;
row = Svcs.NewRow();
row["Id"] = Svcs.Rows.Count + 1;
row["Название"] = Nam.Text;
row["Стоимость"] = Price.Text;
row["Описание"] = Description.Text;
Svcs.Rows.Add(row);
SLDataDB.SaveData(queryClnt, Svcs);
Description.Text = "Cохранено.";
Nam.Text = "";
Price.Text = "";
}
}
private void SendTArchive_Click(object sender, EventArgs e)
{
if (OrdNArh.Text != "")
{
for (int i = 0; i < Orders.Rows.Count; i++)
{
if (Convert.ToInt32(OrdNArh.Text) == Convert.ToInt32(Orders.Rows[i][0]))
{
DataRow row;
row = Archive.NewRow();
row["Id"] = Orders.Rows[i][0];
row["Название заказа"] = Orders.Rows[i][1];
row["Описание"] = Orders.Rows[i][2];
row["Стоимость"] = Orders.Rows[i][8];
for (int k = 0; k < Clients.Rows.Count; k++)
{
if (Convert.ToInt32(Orders.Rows[i][7]) == Convert.ToInt32(Clients.Rows[k][0]))
{
row["Фамилия"] = Clients.Rows[k][1];
row["Имя"] = Clients.Rows[k][2];
row["Номер телефона"] = Clients.Rows[k][4];
}
}
for (int k = 0; k < Managers.Rows.Count; k++)
{
if (Convert.ToInt32(Orders.Rows[i][5]) == Convert.ToInt32(Managers.Rows[k][0]))
{
row["Фамилия менеджера"] = Managers.Rows[k][1];
row["Имя менеджера"] = Managers.Rows[k][2];
}
}
Archive.Rows.Add(row);
Orders.Rows[i].Delete();
break;
}
}
SLDataDB.SaveData(queryArchive, Archive);
SLDataDB.SaveData(queryOrd, Orders);
OrdNArh.Text = "Сохранено";
}
}
private void Add_Click(object sender, EventArgs e)
{
if (PhoneN.Text != "" && Add.Text != "")
{
DataRow row;
row = Clnts.NewRow();
row["Id"] = Clnts.Rows.Count + 1;
row["Фамилия"] = Srnam.Text;
row["Имя"] = Nam.Text;
row["Отчество"] = Patrn.Text;
row["Номер телефона"] = PhoneN.Text;
row["Адрес"] = Adress.Text;
row["Скидка, %"] = Discount.Text;
Clnts.Rows.Add(row);
SLDataDB.SaveData(queryClnt, Clnts);
Srnam.Text = "Cохранено.";
Nam.Text = "";
Patrn.Text = "";
PhoneN.Text = "";
Adress.Text = "";
Discount.Text = "";
}
}
private void AddB_Click(object sender, EventArgs e)
{
if (SrNam.Text != "" && Nam.Text != "" && Pass.Text != "")
{
DataRow row;
string pass = "";
row = MngrsIsh.NewRow();
row["Id"] = MngrsIsh.Rows.Count + 1;
row["Surname"] = SrNam.Text;
row["Name"] = Nm.Text;
for (int i = 0; i < Pass.Text.Length; i++)
{
pass += (char)(Pass.Text[i] ^ 'k');
}
row["Pass"] = pass;
MngrsIsh.Rows.Add(row);
SLDataDB.SaveData(queryMng, MngrsIsh);
SrNam.Text = "Cохранено.";
Nm.Text = "";
Pass.Text = "";
Mng = MngrsIsh.Copy();
UnXor();
}
}
private void AddNwOrd_Click(object sender, EventArgs e)
{
if (NamOrd.Text != "" && DateSt.Text != "" && ClientsBx.Text != "" && ManagerBx.Text != "")
{
DataRow row;
row = Orders.NewRow();
row["Id"] = Orders.Rows.Count + 1;
row["Name"] = NamOrd.Text;
row["Description"] = Description.Text;
row["Order_stage"] = 0;
row["Deadline"] = DeadLn.Text;
row["Date"] = DateSt.Text;
row["Price"] = Convert.ToInt32(Price.Text);
for (int i = 0; i < Managers.Rows.Count; i++)
{
bool chk = false;
for (int k = 0; k < ManagerBx.Text.Length; k++)
{
string a = Convert.ToString(Managers.Rows[i][1]);
if (a[k] == ManagerBx.Text[k])
{
chk = true;
}
else
{
chk = false;
break;
}
}
if (chk)
{
row["ManagerID"] = Managers.Rows[i][0];
}
}
for (int i = 0; i < Clients.Rows.Count; i++)
{
bool chk = false;
for (int k = 0; k < ClientsBx.Text.Length; k++)
{
string a = Convert.ToString(Clients.Rows[i][1]);
if (a[k] == ClientsBx.Text[k])
{
chk = true;
}
else
{
chk = false;
break;
}
}
if (chk)
{
row["ClientID"] = Clients.Rows[i][0];
}
}
Orders.Rows.Add(row);
SLDataDB.SaveData(queryOrd, Orders);
NamOrd.Text = "";
DeadLn.Text = "";
DateSt.Text = "";
ClientsBx.Text = "";
Description.Text = "Заказ добавлен.";
ManagerBx.Text = "";
Price.Text = "";
}
}