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