protected void AddNewDrug_ClickG(object sender, EventArgs e) { if (IsValid) { TableAddDrugG.Visible = false; int iddoctor = Convert.ToInt32(DoctorID.Text); DateTime dat = DateTime.Parse(date.Text); var drug = new Prescription() { DoctorID = iddoctor, Date = dat }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.Prescriptions.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrugG.DataBind(); ViewState["state"] = "load"; } }
protected void AddNewDrug_ClickG(object sender, EventArgs e) { if (IsValid) { TableAddDrugG.Visible = false; String name = DrugNameG.Text; var drug = new ICDChapter() { Name = name }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.ICDChapters.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrugG.DataBind(); } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; int quantity = Convert.ToInt32(Quantity.Text); int dose = Convert.ToInt32(Dose.Text); int idpre = Convert.ToInt32(PresID.Text); int iddrug = Convert.ToInt32(DrugID.Text); String intruc = Instruction.Text; var drug = new PrescriptionDetail() { PrescripID = idpre, DrugID = iddrug, Dose = dose, Quantity = quantity, Instruction = intruc }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.PrescriptionDetails.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrug.DataBind(); } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; String name = DrugName.Text; int price = Convert.ToInt32(Price.Text); int idgrup = Convert.ToInt32(GroupID.Text); var drug = new MedicalService() { Name = name, Price = price, MedicalGroupID = idgrup }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.MedicalServices.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrug.DataBind(); } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; System.Threading.Thread.Sleep(2000); String name = DrugName.Text; String code = GenName.Text; int idgrup = Convert.ToInt32(GroupID.Text); var drug = new ICD() { Name = name, Code = code, ICDChapter = idgrup }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.ICDs.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrug.DataBind(); } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; String name = DrugName.Text; int gender = Convert.ToInt32(GenderDrop.SelectedValue); String address = Unit.Text; DateTime dob = DateTime.Parse(Price.Text); String license = GroupID.Text; var drug = new Doctor() { Name = name, Gender = gender, Address = address, DoB = dob, License = license }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.Doctors.InsertOnSubmit(drug); dataAll.SubmitChanges(); ViewState["state"] = "load"; GridDrug.DataBind(); TableAddDrug.Visible = false; GridDrug.Visible = true; } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; String quantity = Quantity.Text; int idpre = Convert.ToInt32(PresID.Text); int iddrug = Convert.ToInt32(DrugID.Text); var drug = new LabOrderDetail() { LabOrderID = idpre, MedicalServiceID = iddrug, Result = quantity }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.LabOrderDetails.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrug.DataBind(); } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; DateTime dob = DateTime.Parse(Price.Text); String outcome = OutCome.Text; int hospitalID = Convert.ToInt32(IDHospital.Text); int doctorID = Convert.ToInt32(IDDoctor.Text); int patientID = Convert.ToInt32(IDPatient.Text); int ICDId = Convert.ToInt32(IDICD.Text); int labID = Convert.ToInt32(IDLabOrder.Text); int preID = Convert.ToInt32(IDPrescription.Text); if (IDEdit.Text == null || IDEdit.Text.Equals("")) { var drug = new Visit() { Date = dob, DoctorID = doctorID, PatientID = patientID, HospitalID = hospitalID, ICDID = ICDId, LabID = labID, PrescripID = preID, Outcome = outcome }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.Visits.InsertOnSubmit(drug); dataAll.SubmitChanges(); ViewState["state"] = "load"; GridDrug.DataBind(); TableAddDrug.Visible = false; GridDrug.Visible = true; } else { var drug = new Visit() { ID = Convert.ToInt32(IDEdit.Text), Date = dob, DoctorID = doctorID, PatientID = patientID, HospitalID = hospitalID, ICDID = ICDId, LabID = labID, PrescripID = preID, Outcome = outcome }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); var old = (from p in dataAll.Visits where p.ID == Convert.ToInt32(IDEdit.Text) select p).Single(); old.Date = drug.Date; old.DoctorID = drug.DoctorID; old.PatientID = drug.PatientID; old.HospitalID = drug.HospitalID; old.ICDID = drug.ICDID; old.LabID = drug.LabID; old.PrescripID = drug.PrescripID; old.Outcome = drug.Outcome; dataAll.SubmitChanges(); ViewState["state"] = "load"; GridDrug.DataBind(); TableAddDrug.Visible = false; GridDrug.Visible = true; } } Session["editVisitID"] = ""; }
protected void AddPreToData_Click(object sender, EventArgs e) { PreAddnew.Visible = false; int iddoctor = Convert.ToInt32(DoctorIDpre.Text); DateTime dat = DateTime.Parse(datePro.Text); var drug = new Prescription() { DoctorID = iddoctor, Date = dat }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.Prescriptions.InsertOnSubmit(drug); dataAll.SubmitChanges(); AddPrescriptionGrid.DataBind(); }
protected void AddLabOrderToData_Click(object sender, EventArgs e) { AddLabDiv.Visible = false; int iddoctor = Convert.ToInt32(DoctorNameLab.Text); DateTime dat = DateTime.Parse(DateLab.Text); var drug = new LabOrder() { DoctorID = iddoctor, Date = dat }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.LabOrders.InsertOnSubmit(drug); dataAll.SubmitChanges(); AddLabOrderGrid.DataBind(); }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; String name = DrugName.Text; int gender = Convert.ToInt32(GenderDrop.SelectedValue); String address = Unit.Text; var drug = new User() { UserAcc = name, Role = gender, Password = address}; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.Users.InsertOnSubmit(drug); dataAll.SubmitChanges(); ViewState["state"] = "load"; GridDrug.DataBind(); TableAddDrug.Visible = false; GridDrug.Visible = true; } }
protected void AddNewDrug_ClickG(object sender, EventArgs e) { if (IsValid) { TableAddDrugG.Visible = false; System.Threading.Thread.Sleep(2000); String name = DrugNameG.Text; var drug = new DrugGroup() { Name = name}; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.DrugGroups.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrugG.DataBind(); } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; System.Threading.Thread.Sleep(2000); String name = DrugName.Text; String genname = GenName.Text; int price = Convert.ToInt32(Price.Text); String unit = Unit.Text; int idgrup = Convert.ToInt32(GroupID.Text); var drug = new Drug() { DrugName = name, GenericName = genname, Unit = unit, Price = price, drugGroup = idgrup }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.Drugs.InsertOnSubmit(drug); dataAll.SubmitChanges(); GridDrug.DataBind(); } }
protected void AddNewDrug_Click(object sender, EventArgs e) { if (IsValid) { TableAddDrug.Visible = false; String name = DrugName.Text; String address = Unit.Text; String license = GroupID.Text; var drug = new Hospital() { Name = name, Address = address, License = license }; DataBaseAllDataContext dataAll = new DataBaseAllDataContext(); dataAll.Hospitals.InsertOnSubmit(drug); dataAll.SubmitChanges(); ViewState["state"] = "load"; GridDrug.DataBind(); TableAddDrug.Visible = false; GridDrug.Visible = true; } }