private void buttonAdv2_Click(object sender, EventArgs e)
{
PatientDBEntities PDE = new PatientDBEntities();
PatientEntryTable PET = new PatientEntryTable();
CollectionTable CT = new CollectionTable();
if (TreatmentBox.Text != "" && RxBox.Text != "" && FeeBox.Text != "")
{
CT.Date = CurrentDateDisplay.Value.ToString();
CT.Treatment = TreatmentBox.Text;
CT.Rx = RxBox.Text;
CT.id = id;
CT.Fee = int.Parse(FeeBox.Text);
CT.Outstanding = int.Parse(OutStandingBox.Text);
PDE.CollectionTable.Add(CT);
PDE.PatientEntryTable.Add(PET);
PDE.SaveChanges();
ClearBox();
}
else
{
MessageBox.Show("Some Details Are Unfilled", "Alert");
}
}
private void buttonAdv1_Click(object sender, EventArgs e)
{
PatientDBEntities pd = new PatientDBEntities();
PatientEntryTable pe = new PatientEntryTable();
if (NameTextBox.Text != "" && PhoneTextBox.Text != "" && AgeTextBox.Text != "" && HistoryTextBox.Text != "" && AddressTextBox.Text != "")
{
pe.Name = NameTextBox.Text;
pe.PhoneNo = PhoneTextBox.Text;
pe.Age = AgeTextBox.Text;
pe.Gender = "Male";
pe.History = HistoryTextBox.Text;
pe.Address = AddressTextBox.Text;
pd.PatientEntryTable.Add(pe);
pd.SaveChanges();
MessageBox.Show("Saved");
AddPatientsPanel.Visible = false;
var dd = pd.PatientEntryTable.Select(a => new { Name = a.Name, PhoneNo = a.PhoneNo, History = a.History, id = a.id, });
ShowData.DataSource = dd.ToList();
}
else
{
MessageBox.Show("No Data To Save..", "Alert");
}
//LoadRecords();
}
