static public int insertPatient(Patient p)
{
int sex = p.sex == "Nam" ? 1 : 0;
int id = Active.insert("INSERT INTO patient(name, sex, yob, address, is_delete) VALUES (N'" + p.full_name + "', " + sex + ", " + p.year_of_birth + ", N'" + p.address + "', 0)");
return(id);
}
static public int insertMedicine(FullMedicine medicine, int user_update)
{
int id = Active.insert("INSERT INTO medicine(name, another_name, user_change) VALUES (N'" + medicine.name + "',N'" + medicine.another_name + "','" + user_update + "')");
if (id > 0)
{
int id_unit_price = Active.insert("INSERT INTO unit_price_medicine(medicine_id, unit_id, unit_price, num_smallest_unit, user_change) VALUES ('" + id + "','" + medicine.unit_id + "','" + medicine.unit_price + "','" + medicine.num_smallest_unit + "','" + user_update + "')");
return(id);
}
return(0);
}
static public int insertUser(User u)
{
int id = Active.insert("INSERT INTO user(user, name, pw, email, role_id) VALUES ('" + u.name + "',N'" + u.full_name + "','" + u.password + "','" + u.email + "','" + u.role_id + "')");
return(id);
}
static public int insertUseMedicine(UserMedicine use, int user_update)
{
int id = Active.insert("INSERT INTO use_medicine(name, detail, user_change) VALUES (N'" + use.name + "',N'" + use.detail + "','" + user_update + "')");
return(id);
}
static public int insertUnitMedicine(UnitMedicine unit, int user_update)
{
int id = Active.insert("INSERT INTO unit_medicine(name, user_change) VALUES (N'" + unit.name + "','" + user_update + "')");
return(id);
}
static public int insertMedicalExam(string code, int patientID, int doctorID)
{
int num = Active.insert("INSERT INTO medical_exam(code, patient_id, physician_id, date_exam, status, fee_exam, fee_medicine) VALUES ('" + code + "', " + patientID + ", " + doctorID + ", '" + DateTime.Now.ToString("yyyy-MM-dd") + "', 1, 0, 0)");
return(num);
}
static public int insertPrescription(Prescription p, string code)
{
int num = Active.insert("INSERT INTO prescription(code, medicine_id, unit_id, amount, use_id) VALUES ('" + code + "', " + p.medicine_id + ", " + p.unit_id + ", " + p.amount + ", " + p.use_id + ")");
return(num);
}
static public int insertSickness(Sickness sick, int user_update)
{
int id = Active.insert("INSERT INTO sickness(name, noted, user_change) VALUES (N'" + sick.name + "',N'" + sick.noted + "','" + user_update + "')");
return(id);
}