private void btnAdd_Click(object sender, EventArgs e) { if (!ValidControl()) { return; } else { using (IDbConnection dbConnection = new SQLiteConnection($@"Data Source={ConnectionString()}; Version = 3")) { string name = txtName.Text; bool exist = dbConnection.ExecuteScalar <bool>("select count(1) from Schools where name = @name", new { name }); if (exist) { MessageBox.Show("المدرسة موجودة بالفعل"); return; } string insert = "INSERT INTO Schools values(@Id,@name,@address,@Manager,@ManagerPhone,@SchoolPhone,0)"; School school = new School(); school.FillData(Convert.ToInt32(txtId.Text), Regex.Replace(txtName.Text, @"\s+", " "), Regex.Replace(txtAddress.Text, @"\s+", " "), Regex.Replace(txtNameManager.Text, @"\s+", " "), txtNumberOfManager.Text, txtNumberOfSchool.Text); dbConnection.Execute(insert, school); } string namemessage = txtName.Text; btnReset.PerformClick(); Filldgv(GetSchools(), dgv); MemberForm frm = new MemberForm(); Filldgv(frm.LoadMemberForm(), frm.dgv); frm.LoadComboBox(); MessageBox.Show($"تم إضافة مدرسة {namemessage} "); } }
private void btnEdit_Click(object sender, EventArgs e) { if (!ValidControl()) { return; } else { txtId.ReadOnly = false; btnAdd.Enabled = true; SQLiteConnection connection = new SQLiteConnection($@"Data Source={ConnectionString()}; Version = 3"); try { string UpdateCommand = "UPDATE Schools SET name=@name ,address=@address,manager=@manager,managerPhone=@managerPhone,schoolPhone=@schoolPhone WHERE Id=@Id"; SQLiteCommand cmd = new SQLiteCommand(UpdateCommand, connection); cmd.Parameters.AddWithValue("@name", txtName.Text); cmd.Parameters.AddWithValue("@address", txtAddress.Text); cmd.Parameters.AddWithValue("@manager", txtNameManager.Text); cmd.Parameters.AddWithValue("@managerPhone", txtNumberOfManager.Text); cmd.Parameters.AddWithValue("@schoolPhone", txtNumberOfSchool.Text); cmd.Parameters.AddWithValue("@id", txtId.Text); connection.Open(); cmd.ExecuteNonQuery(); Filldgv(GetSchools(), dgv); MemberForm frm = new MemberForm(); Filldgv(frm.LoadMemberForm(), frm.dgv); frm.LoadComboBox(); btnReset.PerformClick(); MessageBox.Show("تم إجراء التعديل بنجاح", "نجاح", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { connection.Close(); } } }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("هل تريد حذف هذا السجل", "حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { SQLiteConnection connection = new SQLiteConnection($@"Data Source={ConnectionString()}; Version = 3"); string DeleteCommand = "DELETE FROM [Schools] WHERE Id = @Id"; SQLiteCommand cmd = new SQLiteCommand(DeleteCommand, connection); cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(txtId.Text)); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); Filldgv(GetSchools(), dgv); MemberForm frm = new MemberForm(); Filldgv(frm.LoadMemberForm(), frm.dgv); frm.LoadComboBox(); btnReset.PerformClick(); MessageBox.Show("تمت عملية الحذف بنجاح", "نجاح", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { btnReset.PerformClick(); } }