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