private void delet_Click(object sender, EventArgs e)
{
if (users.Text != string.Empty)
{
try
{
var I = dataGridView1.CurrentRow.Index;
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
var userdelet = (from c in DBonWork.Users
where c.ID.Equals(users.Text)
select c).FirstOrDefault();
DBonWork.Users.DeleteOnSubmit(userdelet);
DBonWork.SubmitChanges();
dt.RemoveAt(I);
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Erorr");
}
users.Clear();
users_name.Clear();
passward.Clear();
combodegre.Text = null;
}
}
private void add_Click(object sender, EventArgs e)
{
if (users.Text == string.Empty || users_name.Text == string.Empty || passward.Text == string.Empty || combodegre.Text == string.Empty)
{
MessageBox.Show("يجب جميع الحقول", "Error");
users.Focus();
}
else
{
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
DB.User saveuser = new DB.User
{
ID = users.Text,
PassWord = passward.Text,
Name = users_name.Text,
Degre = combodegre.Text
};
DBonWork.Users.InsertOnSubmit(saveuser);
DBonWork.SubmitChanges();
users.Clear();
users_name.Clear();
passward.Clear();
users.Focus();
}
}
private void Save_Click(object sender, EventArgs e)
{
if (CenteralToSave.Text != string.Empty)
{
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
DB.Central SaveCentral = new DB.Central {
CentralName = CenteralToSave.Text.Trim()
};
DBonWork.Centrals.InsertOnSubmit(SaveCentral);
DBonWork.SubmitChanges();
var newcentral = (from c in DBonWork.Centrals
where c.CentralName.Equals(CenteralToSave.Text)
select c).FirstOrDefault();
Program.InfoCentralList.Add(newcentral);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = Program.InfoCentralList;
comboBox1.Items.Add(CenteralToSave.Text);
CenteralToSave.Clear();
CenteralToSave.Focus();
}
else
{
CenteralToSave.Focus();
}
}
private void modifay_Click(object sender, EventArgs e)
{
if (users.Text == string.Empty || users_name.Text == string.Empty || passward.Text == string.Empty || combodegre.Text == string.Empty)
{
MessageBox.Show("يجب ملئ جميع الحقول", "Erorr");
}
else
{
try
{
var I = dataGridView1.CurrentRow.Index;
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
var userupdata = (from c in DBonWork.Users
where c.ID.Equals(users.Text)
select c).FirstOrDefault();
userupdata.Name = users_name.Text;
userupdata.Degre = combodegre.Text;
userupdata.PassWord = passward.Text;
DBonWork.SubmitChanges();
dt.RemoveAt(I);
dataGridView1.DataSource = null;
dt.Add(userupdata);
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Erorr");
}
users.Clear();
users_name.Clear();
passward.Clear();
combodegre.Text = null;
}
}
private void ModifyCabel_Click(object sender, EventArgs e)
{
if (textBox1.ReadOnly == true)
{
var k = dataGridView2.CurrentRow.Index;
string x = textBox2.Text, y = textBox3.Text;
int b = vrify(num.ToString() + dataGridView2.CurrentRow.Cells[0].Value.ToString());
if (dataGridView2.CurrentRow.Cells[1].Value.ToString() != x || dataGridView2.CurrentRow.Cells[2].Value.ToString() != y)
{
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
var UpdatCabel = (from c in DBonWork.Cabels
where c.IDCable.Equals(b)
select c).FirstOrDefault();
UpdatCabel.PunctuationBG = x;
UpdatCabel.PunctuationEN = y;
DBonWork.SubmitChanges();
ListCabel.RemoveAt(k);
dataGridView2.DataSource = null;
ListCabel.Add(UpdatCabel);
dataGridView2.DataSource = ListCabel;
}
groupBox5.Size = new System.Drawing.Size(0, 0);
comboBox2.Text = KIND.Copper.ToString();
textBox1.Clear();
textBox1.ReadOnly = false;
textBox2.Clear();
textBox3.Clear();
}
}
private void SaveBt_Click(object sender, EventArgs e)
{
if (ComboCentral.Text == string.Empty || ComboCabina.Text == string.Empty || DPNumber.Text == string.Empty || AreaDP.Text == string.Empty)
{
if (ComboCentral.Text == string.Empty)
{
MessageBox.Show("اختار السنترال", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (ComboCabina.Text == string.Empty)
{
MessageBox.Show("اختار الكابينة", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (DPNumber.Text == string.Empty)
{
MessageBox.Show("حدد رقم البكس", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (AreaDP.Text == string.Empty)
{
MessageBox.Show("ادخل عنوان البكس", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
try
{
string dpGeneral = Numcent.ToString() + ComboCabina.Text + DPNumber.Text;
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
DB.DP SaveDP = new DB.DP
{
IDcabina = Numcabina,
Area = AreaDP.Text.Trim(),
DPNumber = DPNumber.Text.Trim(),
DPGeneral = dpGeneral
};
DBonWork.DPs.InsertOnSubmit(SaveDP);
DBonWork.SubmitChanges();
MyList.Add(DPNumber.Text.Trim());
AreaDP.Clear();
DPNumber.Clear();
DPNumber.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
try
{
if (button1.Text == "حفظ")
{
if (combocent.Text == string.Empty || ComboType.Text == string.Empty || CabinaCabel.Text == string.Empty || tetarea.Text == string.Empty)
{
MessageBox.Show("يجب ملئ الحقول اولا", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
combocent.Focus();
}
else
{
DB.Cabina SaveCabina = new DB.Cabina
{
IDCable = NumCabel,
CABINA = CabinaCabel.Text,
Area = tetarea.Text.Trim(),
CabinaGeneral = NumCentral.ToString() + CabinaCabel.Text,
ODU = ODU.Text
};
DBonWork.Cabinas.InsertOnSubmit(SaveCabina);
DBonWork.SubmitChanges();
MyList.Add(NumCentral.ToString() + CabinaCabel.Text);
tetarea.Clear();
CabinaCabel.Focus();
CabinaCabel.SelectionStart = 0;
CabinaCabel.SelectionLength = CabinaCabel.Text.Length;
}
}
if (button1.Text == "تحديث")
{
NumCabel = pr.CabelExisting(ComboType.Text);
pr.Update_Cabinas(NumCabina, NumCabel, tetarea.Text, ODU.Text);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Delete_Click(object sender, EventArgs e)
{
try
{
num = pr.GetNumber(CellactCentral.Text);
var k = dataGridView1.CurrentRow.Index;
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
var deletcent = (from c in DBonWork.Centrals
where c.IDcentral.Equals(num)
select c).FirstOrDefault();
DBonWork.Centrals.DeleteOnSubmit(deletcent);
DBonWork.SubmitChanges();
Program.InfoCentralList.RemoveAt(k);
comboBox1.Items.Clear();
foreach (var item in Program.InfoCentralList)
{
comboBox1.Items.Add(item.CentralName);
}
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = Program.InfoCentralList;
}
catch (SqlException ex)
{
if (ex.Number == 547)
{
MessageBox.Show("السنترال يحتوى على بيانات يجب حذفهااولا");
}
else
{
MessageBox.Show(ex.ToString());
}
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString());
}
finally
{
CellactCentral.Clear();
ModifyCentral.Clear();
}
}
private void DeletCabel_Click(object sender, EventArgs e)
{
try
{
if (textBox1.ReadOnly == true)
{
int k = dataGridView2.CurrentRow.Index;
int b = vrify(num.ToString() + dataGridView2.CurrentRow.Cells[0].Value.ToString());
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
var deletcabel = (from c in DBonWork.Cabels
where c.IDCable.Equals(b)
select c).FirstOrDefault();
DBonWork.Cabels.DeleteOnSubmit(deletcabel);
DBonWork.SubmitChanges();
ListCabel.RemoveAt(k);
dataGridView2.DataSource = null;
dataGridView2.DataSource = ListCabel;
groupBox5.Size = new System.Drawing.Size(0, 0);
textBox1.ReadOnly = false;
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
}
}
catch (SqlException ex)
{
if (ex.Number == 547)
{
MessageBox.Show("الكابل يحتوى على بيانات يجب حذفهااولا");
}
else
{
MessageBox.Show(ex.ToString());
}
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
private void initialToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
PublicClass pr = new PublicClass();
var CreatDB = new DB.SmartCentralDB(Properties.Settings.Default.ConctToMaster);
if (!CreatDB.DatabaseExists())
{
CreatDB.CreateDatabase();
var InDB = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
var userdb = from us in InDB.Users
where us.ID == "Admin"
select us;
if (userdb.Count() == 0)
{
DB.User first = new DB.User {
ID = "Admin", PassWord = "******", Name = "Admin", Degre = "مدير"
};
InDB.Users.InsertOnSubmit(first);
InDB.SubmitChanges();
}
foreach (string item in CreateProc.createproctural)
{
pr.InsertQury(item);
}
MessageBox.Show("تم تكوين قاعدة البيانات بنجاح");
}
else
{
MessageBox.Show(" قاعدة البيانات مهيئة بالفعل");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n خطاء اثناء تكوين قاعدة البيانات اضبط اعدادات الاتصال بالخادم ");
}
}
private void SaveCabel_Click(object sender, EventArgs e)
{
if (textBox1.ReadOnly != true)
{
string ID = comboBox2.Text == KIND.Copper.ToString() ? textBox1.Text : ("M" + textBox1.Text);
if (vrify(num.ToString() + ID) == 0)
{
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
DB.Cabel CabelInsert = new DB.Cabel {
IDcentral = num, CableNumber = ID, CabelGenral = num.ToString() + ID, PunctuationBG = textBox2.Text, PunctuationEN = textBox3.Text
};
DBonWork.Cabels.InsertOnSubmit(CabelInsert);
DBonWork.SubmitChanges();
var newcabel = (from c in DBonWork.Cabels
where c.IDcentral == num && c.CableNumber == ID
select c).FirstOrDefault();
ListCabel.Add(newcabel);
groupBox5.Size = new System.Drawing.Size(0, 0);
comboBox2.Text = KIND.Copper.ToString();
dataGridView2.DataSource = null;
dataGridView2.DataSource = ListCabel;
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox1.Focus();
textBox1.SelectionStart = 0;
textBox1.SelectionLength = textBox1.Text.Length;
}
else
{
MessageBox.Show("هذا الكابل من ضمن كابلات السنترال الحالى");
textBox1.Focus();
textBox1.SelectionStart = 0;
textBox1.SelectionLength = textBox1.Text.Length;
}
}
}
private void Modify_Click(object sender, EventArgs e)
{
if (ModifyCentral.Text != string.Empty)
{
try
{
num = pr.GetNumber(CellactCentral.Text);
var k = dataGridView1.CurrentRow.Index;
var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase);
var updatacent = (from c in DBonWork.Centrals
where c.IDcentral.Equals(num)
select c).FirstOrDefault();
updatacent.CentralName = ModifyCentral.Text;
DBonWork.SubmitChanges();
Program.InfoCentralList.RemoveAt(k);
Program.InfoCentralList.Add(updatacent);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = Program.InfoCentralList;
comboBox1.Items.Clear();
foreach (var item in Program.InfoCentralList)
{
comboBox1.Items.Add(item.CentralName);
}
CellactCentral.Clear();
ModifyCentral.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show("ادخل اسم السنترال");
}
}