/// <summary> /// get a list of all payment data /// </summary> /// <param name="data"></param> /// <returns></returns> public List<Data> list(Data data) { String query = @"SELECT * FROM history H, GeneralPayment G WHERE G.ID = H.payId AND H.patientId = @patientId AND H.payState = 0 AND G.ID > 0 ORDER BY H.date"; String medicineQuery = @"SELECT *, (M.Quantity * G.Price) AS T_Price FROM Medicine M, GeneralPayment G, history H WHERE G.ID = M.ItemId AND M.historyId = H.historyId AND H.patientId = @patientId AND M.state = 0 ORDER BY H.date"; String insuranceQuery = "SELECT * FROM Insurance I, Users U WHERE I.insuranceId = U.InsuranceId AND U.UserID = @patientId"; List<Data> result = new List<Data>(); dbc = new DBC(); dbc.open(); result.Add(dbc.select(query, data)); result.Add(dbc.select(medicineQuery, data)); result.Add(dbc.select(insuranceQuery, data)); dbc.close(); return result; }
/// <summary> /// create a new patient /// </summary> /// <param name="data"></param> /// <returns></returns> public bool createPatient(Data data) { int result = 0; String query = @"INSERT INTO Users (UserID, UserFirstName, UserMiddleName, UserSurName, TitleID, GenderID, Occupation, MaritalID, Address, DOB, StateCode, PostCode, Nationality, PhoneNumber, Email, JobCode, PatientMotherLastName, PatientMotherFirstName, PatientFatherLastName, PatientFatherFirstName, insuranceId) VALUES (@UserID, @UserFirstName, @UserMiddleName, @UserSurName, @TitleID, @GenderID, @Occupation, @MaritalID, @Address, @DOB, @StateCode, @PostCode, @Nationality, @PhoneNumber, @Email, @JobCode, @PatientMotherLastName, @PatientMotherFirstName, @PatientFatherLastName, @PatientFatherFirstName, @insuranceId)"; dbc = new DBC(); dbc.open(); result = dbc.update(query, data); result = dbc.update("INSERT INTO UsersLogIn (UserID, Password) VALUES (@UserID, @Password)", data); dbc.close(); dbc = null; return result != 0 ? true : false; }
protected override void Fire(object sender, EventArgs e) { if (!UserInfo.isDoctor(Session)) { alertAndGoback("you are not a doctor. Please login"); return; } DBC dbc = new DBC(); //dbc.open(); Data data = new Data(); data.add("doctorId", UserInfo.getId(Session)); data.add("orderId", Param.get("orderId")); OrderBiz doctor = new OrderBiz(); Data result = doctor.view(data); //result = dbc.select("SELECT * FROM DoctorsOrder A, Users B WHERE A.UserID = B.UserID AND A.orderId = @orderId", data); //dbc.close(); userNameLabel.Text = result.getString("UserID"); UserOD.Text = result.getString("UserOD"); UsermedCheck.SelectedValue = result.getString("UsermedCheck"); Usermed.Text = result.getString("Usermed"); Usernas.SelectedValue = result.getString("Usernas"); Userdosage.Text = result.getString("Userdosage"); Userside.Text = result.getString("Userside"); UserNAA.SelectedValue = result.getString("UserNAA"); Memo.Text = result.getString("Memo"); UserID.Text = result.getString("UserID"); OrderID.Text = result.getString("orderId"); }
protected override void Fire(object sender, EventArgs e) { if (!UserInfo.isDoctor(Session)) { alertAndGoback("you are not a doctor. Please login"); return; } DBC dbc = new DBC(); Data data = new Data(); data.add("doctorId", UserInfo.getId(Session)); data.add("surgeryId", Param.get("surgeryId")); /*dbc.open(); result = dbc.select("SELECT * FROM DoctorsSurgery A, Users B WHERE A.UserID = B.UserID AND A.SurgeryID = @surgeryId", data); dbc.close();*/ SurgeryBiz biz = new SurgeryBiz(); Data result = biz.view(data); type.DataSource = biz.getType(data).Source; type.DataBind(); userNameLabel.Text = result.getString("UserSurName") + "," + result.getString("UserFirstName") + ",ID:" + result.getString("UserID"); ROS.Text = result.getString("UserROS"); DOS.Text = result.getString("UserDOS"); surgery_description.Text = result.getString("UserSD"); surgeryse.Text = result.getString("UserSSE"); Memo.Text = result.getString("Memo"); UserID.Text = result.getString("UserID"); SurgeryID.Text = result.getString("SurgeryID"); type.SelectedValue = result.getString("type"); ROS.SelectedValue = result.getString("ROS"); }
protected override void Fire(object sender, EventArgs e) { if (!UserInfo.isDoctor(Session)) { alertAndGoback("you are not a doctor. Please login"); return; } String today = DateTime.Now.Date.ToString().Substring(0, 10); DOS.Text = today; UserID.Text = Param.getString("pId"); Data result = new Data(); DBC dbc = new DBC(); Data data = new Data(); /*dbc.open(); data.add("pID", Param.get("pId")); result = dbc.select("SELECT * FROM Users WHERE UserID = @pId", data); dbc.close();*/ SurgeryBiz biz = new SurgeryBiz(); biz.view(data); userNameLabel.Text = Param.getString("pId"); type.DataSource = biz.getType(data).Source; type.DataBind(); }
protected void Update(Object sender, EventArgs e) { DBC dbc = new DBC(); Data data = Param; TestResultBiz biz = new TestResultBiz(); biz.update(data); go("~/aspx/doctor/history/list.aspx?pId=" + Param.getString("UserID")); }
protected void Delete(Object sender, EventArgs e) { Data data = Param; DBC dbc = new DBC(); OrderBiz biz = new OrderBiz(); biz.delete(data); go("~/aspx/doctor/history/list.aspx?pId=" + Param.getString("UserID")); }
/// <summary> /// delete patient's data /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Delete(Object sender, EventArgs e) { Data data = Param; DBC dbc = new DBC(); ObservationBiz nurse = new ObservationBiz(); nurse.delete(data); go("~/aspx/nurse/patients/list.aspx"); }
protected void onSubmit(object sender, EventArgs e) { DBC dbc = new DBC(); Data data = Param; data.add("DoctorID", UserInfo.getId(Session)); SurgeryBiz biz = new SurgeryBiz(); biz.create(data); go("~/aspx/doctor/history/list.aspx?pId=" + Param.getString("UserID")); }
/// <summary> /// get data with paging /// </summary> /// <param name="query"></param> /// <param name="data"></param> /// <param name="index"></param> /// <returns></returns> protected Data page(String query, Data data, String index) { dbc = new DBC(); dbc.open(); result = dbc.page(query, data, index); dbc.close(); dbc = null; return result; }
/// <summary> /// get data with paging using stored procedure /// </summary> /// <param name="query"></param> /// <param name="data"></param> /// <param name="index"></param> /// <returns></returns> protected Data pageSP(String spName, String spCount, Data data) { dbc = new DBC(); dbc.open(); result = dbc.pageSP(spName, spCount, data); dbc.close(); dbc = null; return result; }
/// <summary> /// get data from database /// </summary> /// <param name="query"></param> /// <param name="data"></param> /// <returns></returns> protected Data select(String query, Data data) { dbc = new DBC(); dbc.open(); result = dbc.select(query, data); dbc.close(); dbc = null; return result; }
/// <summary> /// update a room data /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool update(Data data) { DBC dbc = new DBC(); dbc.open(); dbc.update(@"UPDATE Room SET Type = @RoomType, UserId = @RoomOwner, Beds = @Beds WHERE RoomID = @RoomID", data); dbc.close(); return true; }
/// <summary> /// update an item /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool update(Data data) { dbc = new DBC(); dbc.open(); dbc.update(@"UPDATE GeneralPayment SET Item = @ItemTextBox, Type = @TypeDropDownList, Price = @PriceTextBox, insuranceState = @InsuranceStateTextBox WHERE ID = @itemID", data); dbc.close(); return true; }
/// <summary> /// update a sergery data /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool update(Data data) { dbc = new DBC(); dbc.open(); dbc.update(@"UPDATE DoctorsSurgery SET UserDOS = convert(datetime, @DOS, 103), Memo = @Memo, UserROS = @ROS, UserSD = @surgery_description, UserSSE = @surgeryse WHERE SurgeryID = @SurgeryID", data); dbc.update(@"UPDATE history SET Memo = @Memo WHERE type = 2 AND cntId = @SurgeryID", data); dbc.close(); return true; }
/// <summary> /// delete a surgery data /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool delete(Data data) { dbc = new DBC(); dbc.open(); dbc.update(@"UPDATE DoctorsOrder SET state = '9' WHERE SurgeryID = @SurgeryID", data); dbc.update(@"UPDATE history SET status = '9' WHERE type = 2 AND cntId = @SurgeryID", data); dbc.close(); return true; }
/// <summary> /// delete a patient from a room /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool delete(Data data) { String today = DateTime.Now.Date.ToString().Substring(0, 10); data.add("today", today); String query = "UPDATE PatientRoom SET EndDate = convert(datetime, @today, 103) WHERE Room = @RoomID AND PatientID = @PatientID"; DBC dbc = new DBC(); dbc.open(); dbc.update(query, data); //dbc.update(@"DELETE From PatientRoom WHERE PatientID = @PatientID", data); dbc.close(); return true; }
protected void Delete(Object sender, EventArgs e) { DBC dbc = new DBC(); Data data = Param; /*dbc.open(); dbc.update(@"UPDATE history SET status = '9' WHERE cntId = @SurgeryID",Param); dbc.close();*/ SurgeryBiz biz = new SurgeryBiz(); biz.delete(data); go("~/aspx/doctor/history/list.aspx?pId=" + Param.getString("UserID")); }
/// <summary> /// create a new X-ray data /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool create(Data data) { String getId = "SELECT COUNT(*) + 1 AS NEW_ID FROM XRay"; String query = "INSERT INTO XRay (XRayID, TestResultID, name, path) VALUES (@XRayID, @TestResultID, @name, @path)"; dbc = new DBC(); dbc.open(); String id = dbc.select(getId, new Data()).getString("NEW_ID"); data.add("XRayID", id); dbc.update(query, data); dbc.close(); return true; }
/// <summary> /// delete data from nurse form /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool delete(Data data) { dbc = new DBC(); dbc.open(); dbc.update(@"UPDATE history SET status = '9' WHERE cntId = @ObservationID AND type = 3", data); //dbc.update("UPDATE NursesForm SET state = '9' WHERE id = @ObservationID", data); dbc.update("UPDATE NursesForm SET state = '9' WHERE date = convert(datetime, @date, 103) AND UserID = @UserID", data); dbc.close(); return true; }
/// <summary> /// update nurse form /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool update(Data data) { dbc = new DBC(); dbc.open(); dbc.update(@"UPDATE NursesForm SET head = @head, ear = @ear, drum = @drum, nose = @nose, sinus = @sinus, mouth = @mouth, eye = @eye, opthal = @opthal, pupil = @pupil, ocular = @ocular, lung = @lung, heart = @heart, vascular = @vascular, abdomen = @abdomen ,memo = @memo WHERE id = @ObservationID", data); dbc.update(@"UPDATE history SET memo = @memo WHERE type = 3 AND cntId = @ObservationID", data); dbc.close(); return true; }
/// <summary> /// get a patients data /// </summary> /// <param name="data"></param> /// <returns></returns> public override Data view(Data data) { string getCntId = ("SELECT cntId FROM history WHERE historyId = @historyId"); string query = "SELECT * FROM DoctorsOrder A, Users B WHERE A.UserID = B.UserID AND A.orderId = @cntId"; dbc = new DBC(); dbc.open(); string cntId = dbc.select(getCntId, data).getString("cntId"); data.add("cntId", cntId); Data result = dbc.select(query, data); dbc.close(); return result; }
/// <summary> /// update a test data /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool update(Data data) { dbc = new DBC(); dbc.open(); dbc.update(@"UPDATE DoctorsTestResult SET UserOR1 = @OR1, UserOR2 = @OR2, UserOR3 =@OR3, UserOR4 = @OR4, UserOR5 = @OR5, UserOR6 = @OR6, Memo = @Memo, DOT = CONVERT(datetime, @DOT, 103), UserORT1 = @ORT1,UserORT2 = @ORT2, UserORT3 = @ORT3, UserORT4 = @ORT4, UserORT5 = @ORT5, UserORT6 = @ORT6,other_abnormalities = @other_abnormalities WHERE TestResultID = @TestResultID", data); dbc.update(@"UPDATE history SET Memo = @Memo WHERE type = 1 AND cntId = @TestResultID", data); dbc.close(); return true; }
/// <summary> /// create a medicine data /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool create(Data data) { String getId = "SELECT COUNT(*) + 1 AS NEW_ID FROM Medicine "; String query = @"INSERT INTO Medicine (medicineId, UserID, historyId, Quantity, itemId) VALUES (@medicineId, @UserID, @historyId, @Quantity, @itemId)"; dbc = new DBC(); dbc.open(); Object id = dbc.select(getId, new Data()).get("NEW_ID"); data.add("medicineId", id); dbc.update(query, data); dbc.close(); return true; }
protected override void Fire(object sender, EventArgs e) { if (!UserInfo.IsSysAdmin(Session)) { alertAndGoback("you are not a system administrator. Please login"); return; } DBC dbc = new DBC(); data.add("insuranceId", Param.get("insuranceId")); Data result = insurance.view(data); insuranceName.Text = result.getString("insuranceName"); rate.Text = result.getString("rate"); insuranceId.Text = result.getString("insuranceId"); }
/// <summary> /// create a new insurance data /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool create(Data data) { String getId = "SELECT MAX(insuranceId) + 1 AS NEW_ID FROM Insurance"; String query = @"INSERT INTO Insurance (insuranceId, insuranceName, rate, state) VALUES (@insuranceId, @insuranceName, @rate, 0)"; dbc = new DBC(); dbc.open(); Object id = dbc.select(getId, new Data()).get("NEW_ID"); data.add("insuranceId", id); dbc.update(query, data); dbc.close(); return true; }
protected void submit(object sender, EventArgs e) { if ("".Equals(Param.getString("EndDate"))) { alertAndGoback("Please, insert the end date"); } DBC dbc = new DBC(); Data data = Param; data.add("CaptID", UserInfo.getId(Session)); AssignBiz assign = new AssignBiz(); assign.create(data); go("~/aspx/nurse/patientroom/list.aspx"); }
/// <summary> /// create a new item /// </summary> /// <param name="data"></param> /// <returns></returns> public override bool create(Data data) { String getId = "SELECT MAX(ID) + 1 AS NEW_ID FROM GeneralPayment"; String query = @"INSERT INTO GeneralPayment (ID, Item, Type, Price) VALUES (@NEW_ID, @ItemTextBox, @TypeDropDownList, @PriceTextBox)"; dbc = new DBC(); dbc.open(); Object id = dbc.select(getId, new Data()).get("NEW_ID"); data.add("NEW_ID", id); dbc.update(query, data); dbc.close(); return true; }
protected void Add_Click(object sender, EventArgs e) { DBC dbc = new DBC(); Data data = Param; data.add("historyId", historyId.Value); data.add("UserID", UserInfo.getId(Session)); data.add("Quantity", Quantity.Text); data.add("itemId", Param.getString("MedicineDroplist")); MedicineBiz biz = new MedicineBiz(); biz.create(data); Data medicineResult = biz.view(data); Medicinelist.DataSource = medicineResult.Source; Medicinelist.DataBind(); //go("~/aspx/Pharmarcist/View.aspx?pId=" + Param.getString("UserID")); }
protected override void Fire(object sender, EventArgs e) { if (!UserInfo.IsSysAdmin(Session)) { alertAndGoback("you are not a system administrator. Please login"); return; } DBC dbc = new DBC(); Data data = new Data(); data.add("insuranceId", Param.get("insuranceId")); InsuranceBiz inBiz = new InsuranceBiz(); Data result = inBiz.list(data); insurance.DataSource = result.Source; insurance.DataBind(); }