//method for saving data to the database private void DeathSavetoolstrip_Click(object sender, EventArgs e) { var deathpopl = new DeathRegestration() { Name = FirstNametextbox.Text, MiddleName = FatherNametextbox.Text, LastName = GrandFathernametextbox.Text, Sex = SexcomboBoxEdit1.Text, Date = dateEdit1.Text, Time = timeEdit1.Text, PhesetianName = Doctornametextbox.Text, DeathCase = DeathCaserichEditControl1.Text }; var DeathregBiz = new DeathRegistrationBiz(); var result = DeathregBiz.Add(deathpopl); if (result.Status) { MessageBox.Show("Successfully saved."); clearDeath(); } else { MessageBox.Show("Save failed. " + result.Message); } }
// method for feaching data from the database public void fechfromdatabase() { if (DeathRegIdtextbox.Text == "") { } else { int ids = Convert.ToInt32(DeathRegIdtextbox.Text); DeathRegestration cm = mo.DeathRegestrations.Create(); var deathpop = from z in mo.DeathRegestrations where z.ID == ids select z; foreach (var p in deathpop) { FirstNametextbox.Text = p.Name; FatherNametextbox.Text = p.MiddleName; GrandFathernametextbox.Text = p.LastName; SexcomboBoxEdit1.Text = p.Sex; AgespinEdit1.Text = p.Age.ToString(); dateEdit1.Text = p.Date; timeEdit1.Text = p.Time; Doctornametextbox.Text = p.PhesetianName; DeathCaserichEditControl1.Text = p.DeathCase; } } }
//method to suggest option from id public void AutoComplet() { DeathRegestration deathre = mo.DeathRegestrations.Create(); var deathreg = mo.DeathRegestrations; foreach (var p in deathreg) { autodata.Add(p.ID.ToString()); } DeathRegIdtextbox.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource; DeathRegIdtextbox.MaskBox.AutoCompleteMode = AutoCompleteMode.Suggest; DeathRegIdtextbox.MaskBox.AutoCompleteCustomSource = autodata; }
// edit data from the the data base private void DeathEdittoolstrip_Click(object sender, EventArgs e) { if (DeathRegIdtextbox.Text == "") { MessageBox.Show("Please Insert DeathReg ID"); } else { var updateDeath = new DeathRegestration() { ID = Convert.ToInt32(DeathRegIdtextbox.Text), Name = FirstNametextbox.Text, MiddleName = FatherNametextbox.Text, LastName = GrandFathernametextbox.Text, Sex = SexcomboBoxEdit1.Text, Date = dateEdit1.Text, Time = timeEdit1.Text, PhesetianName = Doctornametextbox.Text, DeathCase = DeathCaserichEditControl1.Text }; var updeathBiz = new DeathRegistrationBiz(); if (MessageBox.Show("are you sure you want to Edit this file ?", "Confirm Updating", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { var result = updeathBiz.Update(updateDeath); if (result.Status) { MessageBox.Show("Successfuly Updated"); clearDeath(); } else { MessageBox.Show("Update faild." + result.Message); } } } }