/// <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();
}
