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