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 ComboCentral_SelectedIndexChanged(object sender, EventArgs e) { Numcent = pr.GetNumber(ComboCentral.Text); if (ComboCentral.Text != CentralName) { ComboCabina.Items.Clear(); CentralName = ComboCentral.Text; Main.CabinaInfo.Clear(); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var SelecCabel = (from D in DBonWork.Cabels where D.IDcentral == Numcent from c in DBonWork.Cabels where c.IDcentral == D.IDcentral from P in DBonWork.Cabinas where P.IDCable == c.IDCable select new { P.IDcabina, P.CABINA }); if (SelecCabel.Count() > 0) { foreach (var X in SelecCabel.Distinct()) { ComboCabina.Items.Add(X.CABINA); Main.CabinaInfo.Add(X.IDcabina, X.CABINA); } } } }
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 SerchAsArea_Click(object sender, EventArgs e) { if (ComboCentral.Text == string.Empty || Street.Text == string.Empty) { if (ComboCentral.Text == string.Empty) { MessageBox.Show("اختار السنترال", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Street.Text == string.Empty) { MessageBox.Show("ادخل عنوان للبحث", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { Numcent = pr.GetNumber(ComboCentral.Text); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var selectdata = from p in DBonWork.Centrals where p.IDcentral == Numcent from d in DBonWork.Cabels where d.IDcentral == p.IDcentral from c in DBonWork.Cabinas where c.IDCable == d.IDCable && c.Area.Contains(Street.Text) select new { p.CentralName, d.CableNumber, c.ODU, c.CABINA, c.Area, d.PunctuationBG, d.PunctuationEN }; this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = selectdata; } Street.Clear(); }
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 SerchAsCabina_Click(object sender, EventArgs e) { if (ComboCentral.Text == string.Empty || ComboCabina.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 { var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var selectdata = from c in DBonWork.Cabinas where c.IDcabina == IDcabina from d in DBonWork.Cabels where d.IDCable == c.IDCable from p in DBonWork.Centrals where p.IDcentral == d.IDcentral select new { p.CentralName, d.CableNumber, c.ODU, c.CABINA, c.Area, d.PunctuationBG, d.PunctuationEN }; this.dataGridView1.DataSource = selectdata; } }
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 Insert_Click(object sender, EventArgs e) { var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var SelecUser = (from user in DBonWork.Users where user.ID == ID.Text select user.Degre).Take(1); if (SelecUser.Count() == 0) { MessageBox.Show("اسم المستخدم او كلمة السر غير صحيحة"); return;//يقوم بالعودة الى نفس الفورم الحالى عندما يكون شرط الدالة صحيح ولايكمل باقى الكود } else { if (SelecUser.Contains("مدير")) { Program.UserDgre = true; this.Close(); //يقوم بالخروج عند تسجيل بيانات صحيحة } else { Program.UserDgre = false; this.Close(); } } }
private void ComboCentral_SelectedIndexChanged(object sender, EventArgs e) { num = pr.GetNumber(ComboCentral.Text); ComboCabina.Items.Clear(); Main.CabinaInfo.Clear(); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var selectdata = (from p in DBonWork.Centrals where p.IDcentral == num from d in DBonWork.Cabels where d.IDcentral == p.IDcentral from c in DBonWork.Cabinas where c.IDCable == d.IDCable select new { c.IDcabina, c.CABINA, c.CabinaGeneral }).Distinct(); var i = from c in selectdata orderby c.CABINA ascending select c; if (i.Count() > 0) { foreach (var X in i) { Main.CabinaInfo.Add(X.IDcabina, X.CabinaGeneral); ComboCabina.Items.Add(X.CABINA); } } Street.Focus(); }
private void SerchAsStreet_Click(object sender, EventArgs e) { Main.SpareDPInfo.Clear(); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var selectdata = from p in DBonWork.Centrals where p.IDcentral == num from d in DBonWork.Cabels where d.IDcentral == p.IDcentral from c in DBonWork.Cabinas where c.IDCable == d.IDCable from T in DBonWork.DPs where T.IDcabina == c.IDcabina && T.Area.Contains(Street.Text) select new { p.CentralName, d.CableNumber, c.ODU, c.CABINA, d.PunctuationBG, d.PunctuationEN, T.Area, T.DPNumber, T.IDdp, T.DPGeneral }; this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = selectdata; if (Main.SpareDPInfo.Count > 0) { Main.SpareDPInfo.Clear(); } foreach (var item in selectdata) { Main.SpareDPInfo.Add(item.IDdp, item.DPGeneral); } }
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 ButSave_Click(object sender, EventArgs e) { try { if (WindowsAuttentication.Checked == true) { Properties.Settings.Default.ConctToMaster = " Data Source='" + ServerName.Text + "';Integrated Security=True;"; Properties.Settings.Default.ConctToDataBase = "Data Source='" + ServerName.Text + "';Initial Catalog=SmartCentralDB;Integrated Security=True;"; var CreatDB = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); LogIn frm = new LogIn(); frm.ShowDialog(); if (Program.UserDgre == true) { Properties.Settings.Default.Save(); ProcessStartInfo startInfo = new ProcessStartInfo(); startInfo.FileName = @"E:\لغات برمجه\Codes\C#\Applications\Contracts\Contracts\bin\Debug\Contracts.exe"; startInfo.Arguments = "SmartCentralDB_Modify WindowsAuttent " + ServerName.Text; Process.Start(startInfo); } else { MessageBox.Show("المستخدم الذى ادخلته لايملك صلاحية تغير اعدادات الاتصال بالسيرفر"); } } else { Properties.Settings.Default.ConctToMaster = " Data Source='" + ServerName.Text.Trim() + "'Integrated Security= false;Uesr ID=" + UserNameAutt.Text.Trim() + "';Password='******';"; Properties.Settings.Default.ConctToDataBase = "Data Source='" + ServerName.Text + "';Initial Catalog=SmartCentralDB;Integrated Security= false;Uesr ID=" + UserNameAutt.Text.Trim() + "';Password='******';"; var CreatDB = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); LogIn frm = new LogIn(); frm.ShowDialog(); if (Program.UserDgre == true) { Properties.Settings.Default.Save(); ProcessStartInfo startInfo = new ProcessStartInfo(); startInfo.FileName = @"E:\لغات برمجه\Codes\C#\Applications\Contracts\Contracts\bin\Debug\Contracts.exe"; startInfo.Arguments = "SmartCentralDB_Modify SQLServerAuttent " + ServerName.Text + " " + UserNameAutt.Text + " " + PassWordAutt; Process.Start(startInfo); } else { MessageBox.Show("المستخدم الذى ادخلته لايملك صلاحية تغير اعدادات الاتصال بالسيرفر"); } } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Erorr"); } ServerName.Clear(); UserNameAutt.Clear(); PassWordAutt.Clear(); }
private void users_Validated(object sender, EventArgs e) { var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var verify = from c in DBonWork.Users where c.ID == users.Text.Trim() select c; if (verify.Count() > 0) { MessageBox.Show("هذا المستخدم موجود بالفعل", "Error"); users.Focus(); } }
public UserBesines() { InitializeComponent(); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var userinf = from c in DBonWork.Users select c; foreach (var x in userinf) { dt.Add(x); } dataGridView1.DataSource = dt; }
public void fillinfocentral() { try { var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var SelectCentral = from c in DBonWork.Centrals select c; foreach (var item in SelectCentral) { Program.InfoCentralList.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void SerchAsDP_Click(object sender, EventArgs e) { int ID = pr.DPExisting(num.ToString() + ComboCabina.Text + ComboDP.Text); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var selectdata = from p in DBonWork.DPs where p.IDdp == ID from B in DBonWork.Cabinas where B.IDcabina == p.IDcabina from D in DBonWork.Cabels where D.IDCable == B.IDCable from c in DBonWork.Centrals where c.IDcentral == D.IDcentral select new { c.CentralName, D.CableNumber, B.ODU, B.CABINA, p.DPNumber, p.Area, D.PunctuationBG, D.PunctuationEN }; this.dataGridView1.DataSource = selectdata; }
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 ComboCabina_SelectedIndexChanged(object sender, EventArgs e) { Numcabina = pr.CabinaExisting(ComboCabina.Text); MyList.Clear(); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var SelecDP = (from D in DBonWork.DPs where D.IDcabina == Numcabina select D.DPNumber).Distinct(); if (SelecDP.Count() > 0) { foreach (var item in SelecDP) { MyList.Add(item); } } DPNumber.Focus(); }
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 users_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var verify = from c in DBonWork.Users where c.ID == users.Text.Trim() select c; if (verify.Count() > 0) { MessageBox.Show("هذا المستخدم موجود بالفعل", "Error"); users.Focus(); } else { users_name.Focus(); } } }
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 comboBox1_SelectedIndexChanged(object sender, EventArgs e) { num = pr.GetNumber(comboBox1.Text); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); ListCabel.Clear(); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var SelectCabl = (from c in DBonWork.Cabels where c.IDcentral == num select c).Distinct(); foreach (var x in SelectCabl) { ListCabel.Add(x); } dataGridView2.DataSource = null; dataGridView2.DataSource = ListCabel; textBox1.Focus(); }
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 ComboCabina_SelectedIndexChanged(object sender, EventArgs e) { ComboDP.Items.Clear(); Main.DPInfo.Clear(); int j = pr.CabinaExisting(num.ToString() + ComboCabina.Text); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var SelecDP = from D in DBonWork.DPs where D.IDcabina == j select new { D.IDdp, D.DPGeneral, D.DPNumber }; var i = from c in SelecDP orderby c.DPNumber ascending select c; if (i.Count() > 0) { foreach (var item in SelecDP) { ComboDP.Items.Add(item.DPNumber); Main.DPInfo.Add(item.IDdp, item.DPGeneral); } } var selectdata = from p in DBonWork.DPs where p.IDcabina == j from B in DBonWork.Cabinas where B.IDcabina == p.IDcabina from D in DBonWork.Cabels where D.IDCable == B.IDCable from c in DBonWork.Centrals where c.IDcentral == D.IDcentral select new { c.CentralName, D.CableNumber, B.ODU, B.CABINA, p.DPNumber, p.Area, D.PunctuationBG, D.PunctuationEN }; var t = from c in selectdata orderby c.DPNumber ascending select c; this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = t; ComboDP.Focus(); }
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 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 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("ادخل اسم السنترال"); } }
private void combocent_SelectedIndexChanged(object sender, EventArgs e) { NumCentral = pr.GetNumber(combocent.Text); if (combocent.Text != CentrlName) { CentrlName = combocent.Text; Main.CabelInfo.Clear(); ComboType.Items.Clear(); MyList.Clear(); var DBonWork = new DB.SmartCentralDB(Properties.Settings.Default.ConctToDataBase); var SelectAllCabel = (from c in DBonWork.Cabels where c.IDcentral == NumCentral select new { c.IDCable, c.CableNumber }); foreach (var item in SelectAllCabel) { Main.CabelInfo.Add(item.IDCable, item.CableNumber); ComboType.Items.Add(item.CableNumber); } var j = from c in DBonWork.Cabels where c.IDcentral == NumCentral from p in DBonWork.Cabinas where p.IDCable == c.IDCable select p.CabinaGeneral; foreach (var item in j) { MyList.Add(item); } } if (button1.Text == "حفظ") { CabinaCabel.Clear(); } label6.Text = ""; ODU.Clear(); ComboType.Focus(); }