//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);
}
}
}
}
