public void CreateClinicDate(clinicDate obj)
{
using (var dataContext = new FinalAppWebEntities())
{
dataContext.clinicDates.Add(obj);
dataContext.SaveChanges();
}
}
public void updateClinicDate(clinicDate obj)
{
using (var dataContext = new FinalAppWebEntities())
{
var trs = from t in dataContext.clinicDates
where t.id == obj.id
select t;
clinicDate transaction = trs.FirstOrDefault();
//Update field by field
transaction.status = obj.status;
dataContext.SaveChanges();
}
}
public void deleteCLnicDate(clinicDate obj)
{
using (var dataContext = new FinalAppWebEntities())
{
//Load customer object
var cust = from c in dataContext.clinicDates
where c.id == obj.id
select c;
clinicDate objCustomer = cust.FirstOrDefault();
//Remove
dataContext.clinicDates.Remove(objCustomer);
//Save
dataContext.SaveChanges();
}
}
private void btnCreateDeate_Click(object sender, EventArgs e)
{
clinicDate clinicDate = new clinicDate();
clinicDate.clinicHistorytId = IDclinicHistoy;
clinicDate.doctorId = Convert.ToInt32(cbDoctor.SelectedValue);
clinicDate.nurseId = IDnurseLogOn;
clinicDate.dateOfRequest = DateTime.Today.Date;
clinicDate.dateOfAppointment = dtDate4Date.Value;
clinicDate.description = txtDescription.Text;
clinicDate.status = false;
clinicDate.weight = Convert.ToDecimal(txtWiegth.Text);
clinicDate.height = Convert.ToDecimal(txtHeigth.Text);
clinicDate.alergies = allergy;
clinicDateService.CreateClinicDate(clinicDate);
this.load();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.
Columns[e.ColumnIndex].
HeaderText.
ToLower() == "delete")
{
if (MessageBox.Show
("Are you sure you want to delete this date?",
"Confirm",
MessageBoxButtons.YesNo)
== DialogResult.Yes)
{
clinicDate objCustomer =
(clinicDate)dataGridView1.
Rows[e.RowIndex].
DataBoundItem;
this.clinicDateService.deleteCLnicDate(objCustomer);
this.load();
}
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.
Columns[e.ColumnIndex].
HeaderText.
ToLower() == "confirm")
{
if (MessageBox.Show
("Confirm?",
"Confirm",
MessageBoxButtons.YesNo)
== DialogResult.Yes)
{
clinicDate objCustomer =
(clinicDate)dataGridView1.
Rows[e.RowIndex].
DataBoundItem;
frmDoc frm = (frmDoc)this.MdiParent;
objCustomer.status = true;
clinicDateService.updateClinicDate(objCustomer);
frm.clinicDateid = objCustomer.id;
this.SendToBack();
}
}
else if (dataGridView1.
Columns[e.ColumnIndex].
HeaderText.
ToLower() == "view alergies")
{
clinicDate objClinicdate =
(clinicDate)dataGridView1.
Rows[e.RowIndex].
DataBoundItem;
frmAlergies frm = new frmAlergies(objClinicdate.clinicHistorytId);
frm.Show();
}
}
public void updateClinicDate(clinicDate obj)
{
IClinicDateRepository repo = new ClinicDateRepository();
repo.updateClinicDate(obj);
}
public void deleteCLnicDate(clinicDate obj)
{
IClinicDateRepository repo = new ClinicDateRepository();
repo.deleteCLnicDate(obj);
}
