public static string[] getAutoList(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (Doctor dg in ctx.Doctors)
{
if (dg.Name.Contains(prefixText))
{
result.Add(dg.Name + "---Name Field");
}
}
foreach (Doctor dg in ctx.Doctors)
{
if (dg.Address.Contains(prefixText))
{
result.Add(dg.Address + "---Address Field");
}
}
foreach (Doctor dg in ctx.Doctors)
{
if (dg.License.Contains(prefixText))
{
result.Add(dg.License + "---License Field");
}
}
foreach (Doctor dg in ctx.Doctors)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString() + "---ID Field");
}
}
return result.ToArray();
}
public static string[] getAutoList(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (LabOrderDetail dg in ctx.LabOrderDetails)
{
if (dg.LabOrderID.ToString().Contains(prefixText))
{
result.Add(dg.LabOrderID.ToString() + "---LabOrder ID Field");
}
}
foreach (LabOrderDetail dg in ctx.LabOrderDetails)
{
if (dg.MedicalServiceID.ToString().Contains(prefixText))
{
result.Add(dg.MedicalServiceID.ToString() + "---MedicalServiceID Field");
}
}
foreach (LabOrderDetail dg in ctx.LabOrderDetails)
{
if (dg.Result.ToString().Contains(prefixText))
{
result.Add(dg.Result.ToString() + "---Result Field");
}
}
return result.ToArray();
}
public static string[] getAutoList(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (User dg in ctx.Users)
{
if (dg.UserAcc.Contains(prefixText))
{
result.Add(dg.UserAcc + "---UserAcc Field");
}
}
foreach (User dg in ctx.Users)
{
if (dg.Password.Contains(prefixText))
{
result.Add(dg.Password + "---Password Field");
}
}
foreach (User dg in ctx.Users)
{
if (dg.Role.ToString().Contains(prefixText))
{
result.Add(dg.Role.ToString() + "---Role Field");
}
}
foreach (User dg in ctx.Users)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString() + "---ID Field");
}
}
return result.ToArray();
}
protected bool LogIn(String username , String password)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
var checkUser = dataAll.Users.SingleOrDefault(c=> c.UserAcc == username);
//IEnumerable<User> user = from p in dataAll.Users
// where p.UserAcc == username
// && p.Password == password
// select p;
if (checkUser != null)
{
if (checkUser.Password == password) {
return true;
}
LoginID.FailureText = "Your password is not correct !!";
return false;
}
else
{
LoginID.FailureText = "Your username is not correct !!";
return false;
}
}
public static string[] getAutoListHos(string prefixText)
{
var ctx = new DataBaseAllDataContext();
IEnumerable<String> Drug1 = from p in ctx.Visits
join h in ctx.Hospitals on p.HospitalID equals h.ID
where h.Name.Contains(prefixText)
select h.Name;
return Drug1.ToArray();
}
public static string[] getAutoList(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (Drug dg in ctx.Drugs)
{
if (dg.DrugName.Contains(prefixText))
{
result.Add(dg.DrugName + "---Name Field");
}
}
foreach (Drug dg in ctx.Drugs)
{
if (dg.GenericName.Contains(prefixText))
{
result.Add(dg.GenericName + "---Generic Name Field");
}
}
foreach (Drug dg in ctx.Drugs)
{
if (dg.Unit.Contains(prefixText))
{
result.Add(dg.Unit + "---Unit Field");
}
}
foreach (Drug dg in ctx.Drugs)
{
if (dg.Price.ToString().Contains(prefixText))
{
result.Add(dg.Price.ToString() + "---Price Field");
}
}
foreach (Drug dg in ctx.Drugs)
{
if (dg.drugGroup.ToString().Contains(prefixText))
{
result.Add(dg.drugGroup.ToString() + "---Group Field");
}
}
foreach (Drug dg in ctx.Drugs)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString() + "---ID Field");
}
}
return result.ToArray();
}
public static string[] getAutoList(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (PrescriptionDetail dg in ctx.PrescriptionDetails)
{
if (dg.PrescripID.ToString().Contains(prefixText))
{
result.Add(dg.PrescripID.ToString() + "---Presciption ID Field");
}
}
foreach (PrescriptionDetail dg in ctx.PrescriptionDetails)
{
if (dg.DrugID.ToString().Contains(prefixText))
{
result.Add(dg.DrugID.ToString() + "---Drug ID Field");
}
}
foreach (PrescriptionDetail dg in ctx.PrescriptionDetails)
{
if (dg.Quantity.ToString().Contains(prefixText))
{
result.Add(dg.Quantity.ToString() + "---Quantity Field");
}
}
foreach (PrescriptionDetail dg in ctx.PrescriptionDetails)
{
if (dg.Dose.ToString().Contains(prefixText))
{
result.Add(dg.Dose.ToString() + "---Dose Field");
}
}
foreach (PrescriptionDetail dg in ctx.PrescriptionDetails)
{
if (dg.Instruction.ToString().Contains(prefixText))
{
result.Add(dg.Instruction.ToString() + "---Instruction Field");
}
}
return result.ToArray();
}
public MyHospital[] reutrnHos()
{
DataBaseAllDataContext db = new DataBaseAllDataContext();
var hospitalList = db.Hospitals.ToArray();
MyHospital[] mh = new MyHospital[hospitalList.Length];
for (int i = 0; i < hospitalList.Length; i++)
{
mh[i] = new MyHospital();
mh[i].ID = hospitalList[i].ID;
mh[i].Name = hospitalList[i].Name;
mh[i].Address = hospitalList[i].Address;
mh[i].License = hospitalList[i].License;
}
return mh;
}
public MyDoctor[] reutrnDoc()
{
DataBaseAllDataContext db = new DataBaseAllDataContext();
var doctorList = db.Doctors.ToArray();
MyDoctor[] mh = new MyDoctor[doctorList.Length];
for (int i = 0; i < doctorList.Length; i++)
{
mh[i] = new MyDoctor();
mh[i].ID = doctorList[i].ID;
mh[i].Name = doctorList[i].Name;
mh[i].Address = doctorList[i].Address;
mh[i].License = doctorList[i].License;
mh[i].date = doctorList[i].DoB;
mh[i].Gender = doctorList[i].Gender;
}
return mh;
}
public static string[] getAutoList(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (ICD dg in ctx.ICDs)
{
if (dg.Name.Contains(prefixText))
{
result.Add(dg.Name + "---Name Field");
}
}
foreach (ICD dg in ctx.ICDs)
{
if (dg.Code.Contains(prefixText))
{
result.Add(dg.Code + "---Code Field");
}
}
foreach (ICD dg in ctx.ICDs)
{
if (dg.ICDChapter.ToString().Contains(prefixText))
{
result.Add(dg.ICDChapter.ToString() + "---ICD Chapter Field");
}
}
foreach (ICD dg in ctx.ICDs)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString() + "---ID Field");
}
}
return result.ToArray();
}
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);
var drug = new Patient() { Name = name, Gender = gender, Address = address, DoB = dob};
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
dataAll.Patients.InsertOnSubmit(drug);
dataAll.SubmitChanges();
ViewState["state"] = "load";
GridDrug.DataBind();
TableAddDrug.Visible = false;
GridDrug.Visible = true;
}
}
protected bool LogIn(String username, String password)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
var checkUser = dataAll.Users.SingleOrDefault(c => c.UserAcc == username);
if (checkUser != null)
{
if (checkUser.Password == password)
{
return true;
}
LoginID.FailureText = "Your password is not correct !!";
return false;
}
else
{
LoginID.FailureText = "Your username is not correct !!";
return false;
}
}
public static string[] getAutoList(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (MedicalService dg in ctx.MedicalServices)
{
if (dg.Name.Contains(prefixText))
{
result.Add(dg.Name + "---Name Field");
}
}
foreach (MedicalService dg in ctx.MedicalServices)
{
if (dg.Price.ToString().Contains(prefixText))
{
result.Add(dg.Price.ToString() + "---Price Field");
}
}
foreach (MedicalService dg in ctx.MedicalServices)
{
if (dg.MedicalGroupID.ToString().Contains(prefixText))
{
result.Add(dg.MedicalGroupID.ToString() + "---Group Field");
}
}
foreach (MedicalService dg in ctx.MedicalServices)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString() + "---ID Field");
}
}
return result.ToArray();
}
public static string[] getAutoListG(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (Prescription dg in ctx.Prescriptions)
{
if (dg.DoctorID.ToString().Contains(prefixText))
{
result.Add(dg.DoctorID.ToString() + "---Doctor ID Field");
}
}
foreach (Prescription dg in ctx.Prescriptions)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString() + "---ID Field");
}
}
return result.ToArray();
}
protected void LinqDataSourceDrug_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
String searchCate = DropSearch.SelectedValue;
String searchString = "";
if (SearchText.Text != null || !SearchText.Text.Equals(""))
{
String[] lines = Regex.Split(SearchText.Text, "---");
searchString = lines[0];
}
if (searchCate.Equals("DrugName"))
{
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.Name.Contains(searchString)
select p;
e.Result = Drug;
}
else if (searchCate.Equals("ID"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
int id = Convert.ToInt32(searchString);
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.ID == id
select p;
e.Result = Drug;
}
}
else if (searchCate.Equals("Price"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
if (Equavalance.SelectedValue.Equals("1"))
{
int price = Convert.ToInt32(searchString);
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.Price == price
select p;
e.Result = Drug;
}
else if (Equavalance.SelectedValue.Equals("2"))
{
int price = Convert.ToInt32(searchString);
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.Price < price
select p;
e.Result = Drug;
}
else if (Equavalance.SelectedValue.Equals("3"))
{
int price = Convert.ToInt32(searchString);
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.Price <= price
select p;
e.Result = Drug;
}
else if (Equavalance.SelectedValue.Equals("4"))
{
int price = Convert.ToInt32(searchString);
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.Price > price
select p;
e.Result = Drug;
}
else if (Equavalance.SelectedValue.Equals("5"))
{
int price = Convert.ToInt32(searchString);
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.Price >= price
select p;
e.Result = Drug;
}
}
}
else if (searchCate.Equals("Group ID"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
int text = Convert.ToInt32(searchString);
IEnumerable<MedicalService> Drug = from p in dataAll.MedicalServices
where p.MedicalGroupID == text
select p;
e.Result = Drug;
}
}
}
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_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();
}
}
public static string[] getPreIDlist(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (Prescription dg in ctx.Prescriptions)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString());
}
}
return result.ToArray();
}
public static string[] getGroupIDlist(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (Doctor dg in ctx.Doctors)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString());
}
}
return result.ToArray();
}
protected void LinqDataSourceDrug_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
String searchCate = DropSearch.SelectedValue;
String searchString = "";
if (SearchText.Text != null || !SearchText.Text.Equals(""))
{
String[] lines = Regex.Split(SearchText.Text, "---");
searchString = lines[0];
}
if (searchCate.Equals("DrugName"))
{
IEnumerable<ICD> Drug = from p in dataAll.ICDs
where p.Name.Contains(searchString)
select p;
e.Result = Drug;
}
else if (searchCate.Equals("ID"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
int id = Convert.ToInt32(searchString);
IEnumerable<ICD> Drug = from p in dataAll.ICDs
where p.ID == id
select p;
e.Result = Drug;
}
}
else if (searchCate.Equals("Unit"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
IEnumerable<ICD> Drug = from p in dataAll.ICDs
where p.Code.Contains(searchString)
select p;
e.Result = Drug;
}
}
else if (searchCate.Equals("Group ID"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
int text = Convert.ToInt32(searchString);
IEnumerable<ICD> Drug = from p in dataAll.ICDs
where p.ICDChapter == text
select p;
e.Result = Drug;
}
}
}
protected void Login_Authenticate(object sender, AuthenticateEventArgs e)
{
String username = LoginID.UserName;
String password = LoginID.Password;
if (LogIn(username, password))
{
e.Authenticated = true;
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
var checkUser = dataAll.Users.SingleOrDefault(c => c.UserAcc == username);
Session["Username"] = username;
Session["role"] = checkUser.Role;
Debug.WriteLine(Session["Username"]);
Debug.WriteLine(Session["role"]);
}
}
protected void LinqDataSourcePre_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
String searchString = "";
if (SearchPrescription.Text != null || !SearchPrescription.Text.Equals(""))
{
String[] lines = Regex.Split(SearchPrescription.Text, "---");
searchString = lines[0];
}
IEnumerable<Prescription> Drug = from p in dataAll.Prescriptions
where p.ID.ToString().Contains(searchString)
select p;
e.Result = Drug;
}
protected void LinqDataSourceDrug_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
String searchCate = DropSearch.SelectedValue;
String searchString = "";
if (SearchText.Text != null || !SearchText.Text.Equals(""))
{
String[] lines = Regex.Split(SearchText.Text, "---");
searchString = lines[0];
}
if (searchCate.Equals("DrugName"))
{
int id = Convert.ToInt32(searchString);
IEnumerable<PrescriptionDetail> Drug = from p in dataAll.PrescriptionDetails
where p.PrescripID == id
select p;
e.Result = Drug;
}
else if (searchCate.Equals("GenericName"))
{
int id = Convert.ToInt32(searchString);
IEnumerable<PrescriptionDetail> Drug = from p in dataAll.PrescriptionDetails
where p.DrugID == id
select p;
e.Result = Drug;
}
else if (searchCate.Equals("ID"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
int id = Convert.ToInt32(searchString);
IEnumerable<PrescriptionDetail> Drug = from p in dataAll.PrescriptionDetails
where p.ID == id
select p;
e.Result = Drug;
}
}
else if (searchCate.Equals("Unit"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
int id = Convert.ToInt32(searchString);
IEnumerable<PrescriptionDetail> Drug = from p in dataAll.PrescriptionDetails
where p.Dose == id
select p;
e.Result = Drug;
}
}
else if (searchCate.Equals("Price"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
int id = Convert.ToInt32(searchString);
IEnumerable<PrescriptionDetail> Drug = from p in dataAll.PrescriptionDetails
where p.Quantity == id
select p;
e.Result = Drug;
}
}
else if (searchCate.Equals("Group ID"))
{
if (SearchText.Text == null || SearchText.Text.Equals(""))
{
}
else
{
IEnumerable<PrescriptionDetail> Drug = from p in dataAll.PrescriptionDetails
where p.Instruction.Contains(searchString)
select p;
e.Result = Drug;
}
}
}
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;
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();
}
}
public static string[] getDrugIDlist(string prefixText)
{
List<string> result = new List<string>();
var ctx = new DataBaseAllDataContext();
foreach (MedicalService dg in ctx.MedicalServices)
{
if (dg.ID.ToString().Contains(prefixText))
{
result.Add(dg.ID.ToString());
}
}
return result.ToArray();
}
protected void LinqDataSourceDrug_SelectingG(object sender, LinqDataSourceSelectEventArgs e)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
String searchCate = DropSearchG.SelectedValue;
String searchString = "";
if (SearchText.Text != null || !SearchText.Text.Equals(""))
{
String[] lines = Regex.Split(SearchTextG.Text, "---");
searchString = lines[0];
}
if (searchCate.Equals("ID"))
{
if (SearchTextG.Text == null || SearchTextG.Text.Equals(""))
{
}
else
{
int seach = Convert.ToInt32(searchString);
IEnumerable<Prescription> Drug = from p in dataAll.Prescriptions
where p.ID == seach
select p;
e.Result = Drug;
}
}
else if (searchCate.Equals("DrugGroupName"))
{
int seach = Convert.ToInt32(searchString);
IEnumerable<Prescription> Drug = from p in dataAll.Prescriptions
where p.DoctorID == seach
select p;
e.Result = Drug;
}
}
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_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 LinqDataSourcePre10_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataBaseAllDataContext dataAll = new DataBaseAllDataContext();
IEnumerable<PrescriptionDetail> Drug = from p in dataAll.PrescriptionDetails
where p.PrescripID == Convert.ToInt32(PrescriptionDetailID1.Text)
select p;
e.Result = Drug;
}
