//public static void UpdateUserPassword(SystemUser user)
//{
// string sql = string.Format(SQLCommands.UpdateUser, user.UserPassword, user.UserId);
// DBCommand dbc = new DBCommand(DBCommand.TransactionType.WithoutTransaction);
// dbc.ExecuteCommand(sql);
// dbc.CloseConnection();
//}
public void CreateUser(SystemUser user)
{
if (CheckIfUserExists(user))
{
throw new Exception("User '" + user.UserName + "' exists");
}
CommonFunctions.UpdateApostrophe(user);
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO SystemUser(FirstName,LastName,UserName, Email, UserPassword,StaffId) VALUES(");
sb.Append("'" + user.FirstName + "'");
sb.Append(",'" + user.LastName + "'");
sb.Append(",'" + user.UserName + "'");
sb.Append(",'" + user.Email + "'");
sb.Append(",'" + user.UserPassword + "'");
if (user.PersonId != 0)
{
sb.Append("," + user.PersonId);
}
else
{
sb.Append(",null");
}
sb.Append(")");
string sql = sb.ToString();
dbc.ExecuteCommand(sql);
dbc.CloseConnection();
}
public List <AppointmentBase> GetList(string sql)
{
List <AppointmentBase> appointments = new List <AppointmentBase>();
DataTable dt = dbc.GetDataTable(sql);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
appointments.Add(GetAppointment(dr));
}
return(appointments);
}
public List <Incident> GetList()
{
List <Incident> Incidents = new List <Incident>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_Incidents");
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
Incidents.Add(GetIncident(dr));
}
return(Incidents);
}
public List <MedicalCondition> GetList(int PersonId)
{
List <MedicalCondition> mecicalConditions = new List <MedicalCondition>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentMedicalConditions WHERE StudentId=" + PersonId);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
MedicalCondition mc = new MedicalCondition();
mc.StudentMedicalConditionId = (int)dr["StudentMedicalConditionId"];
mc.StudentId = (int)dr["StudentId"];
mc.MedicalConditionName = dr["MedicalCondition"].ToString();
if (dr["Description"].ToString() != string.Empty)
{
mc.Description = dr["Description"].ToString();
}
else
{
mc.Description = "** please update **";
}
if (dr["DegreeOfDisability"].ToString() != string.Empty)
{
mc.DegreeOfDisability = dr["DegreeOfDisability"].ToString();
}
else
{
mc.DegreeOfDisability = "** please update **";
}
mc.Comments = dr["Comments"].ToString();
mecicalConditions.Add(mc);
}
return(mecicalConditions);
}
public List <MedicationAndTreatment> GetList(int PersonId)
{
List <MedicationAndTreatment> medicationAndTreatment = new List <MedicationAndTreatment>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentMedicationAndTreatment WHERE StudentId=" + PersonId);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
MedicationAndTreatment at = new MedicationAndTreatment();
at.StudentMedicationAndTreatmentId = (int)dr["StudentMedicationAndTreatmentId"];
at.StudentId = (int)dr["StudentId"];
at.Frequency = dr["Frequency"].ToString();
at.Medication = dr["Medication"].ToString();
if (dr["Description"].ToString() != string.Empty)
{
at.Description = dr["Description"].ToString();
}
else
{
at.Description = "** please update **";
}
at.Comments = dr["Comments"].ToString();
medicationAndTreatment.Add(at);
}
return(medicationAndTreatment);
}
public static void UpdateUserPassword(SystemUser user)
{
string sql = string.Format(SQLCommands.UpdateUser, user.UserPassword, user.UserId);
DBCommand dbc = new DBCommand(DBCommand.TransactionType.WithoutTransaction);
dbc.ExecuteCommand(sql);
dbc.CloseConnection();
}
public static SystemUser GetSystemUser(string UserName, string Password)
{
DataTable dt;
DBCommand dbc = new DBCommand(DBCommand.TransactionType.WithoutTransaction);
dt = dbc.GetDataTable(string.Format(SQLCommands.User, UserName, Password));
dbc.CloseConnection();
return(CreateUser(dt));
}
public override void Remove(Person person, int StudentId)
{
StringBuilder sb = new StringBuilder();
sb.Append("DELETE FROM StudentNextOfKin WHERE NextOfKinId=" + person.PersonId + " AND StudentId=" + StudentId);
string sql = sb.ToString();
DBCommand db = new DBCommand(DBCommand.TransactionType.WithTransaction);
int returnDoctorId = db.ExecuteCommand(sql);
db.CommitTransactions();
db.CloseConnection();
}
public static void CreateUser(SystemUser user)
{
// Create Person
DBCommand dbc = new DBCommand(DBCommand.TransactionType.WithoutTransaction);
string sql = string.Format(SQLCommands.CreatePerson, user.PersonFirstName, user.PersonLastName);
int lastPersonId = dbc.ExecuteCommand(sql);
sql = string.Format(SQLCommands.CreateUser, user.UserName, user.UserPassword, lastPersonId);
int lastUserId = dbc.ExecuteCommand(sql);
foreach (string role in user.Roles)
{
sql = string.Format(SQLCommands.CreateRole, lastUserId, role);
dbc.ExecuteCommand(sql);
}
dbc.CloseConnection();
}
public List <StudentNote> GetList(int PersonId)
{
List <StudentNote> studentNotes = new List <StudentNote>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentNotes WHERE StudentId=" + PersonId);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
StudentNote sn = new StudentNote();
sn.StudentNoteId = (int)dr["StudentNoteId"];
sn.StudentId = (int)dr["StudentId"];
sn.StudentNoteName = dr["StudentNote"].ToString();
sn.NoteDate = (DateTime)dr["NoteDate"];
studentNotes.Add(sn);
}
return(studentNotes);
}
public List <StudentMedicalConditionAlertBase> GetList(int PersonId)
{
List <StudentMedicalConditionAlertBase> mecicalConditionsAlerts = new List <StudentMedicalConditionAlertBase>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentMedicalConditionAlerts WHERE StudentId=" + PersonId);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
StudentMedicalConditionAlertBase smca;
int medicationAlertTypeId = (int)dr["MedicalTypeAlertTypeId"];
switch (medicationAlertTypeId)
{
case 1:
smca = new Asthma();
break;
case 2:
smca = new Allergy();
break;
default:
smca = new Epilepsy();
break;
}
smca.StudentMedicalConditionAlertId = (int)dr["StudentMedicalConditionAlertId"];
smca.MedicalTypeAlertTypeId = medicationAlertTypeId;
smca.Definition = dr["Definition"].ToString();
if (dr["Description"].ToString() != string.Empty)
{
smca.Description = dr["Description"].ToString();
}
else
{
smca.Description = "** please update **";
}
smca.Comments = dr["Comments"].ToString();
mecicalConditionsAlerts.Add(smca);
}
return(mecicalConditionsAlerts);
}
private void CommandBinding_Executed(object sender, ExecutedRoutedEventArgs e)
{
mrm = new ModelRekamMedis(0, " ", " ", " ", " ", " ", " ", " ", " ", " ", DateTime.Now.ToShortDateString(),
" ", " ", " ");
var cmd = new DBCommand(conn);
var no_rm = txtRekamMedis.Text;
var riwayat_penyakit = txtRiwayat.Text;
var berat_badan = txtBeratBadan.Text;
var alergi = txtAlergi.Text;
var keluhan = textKeluhan.Text;
var diagnosa = textDiagnosa.Text;
var tindakan = textTindakan.Text;
var id_dokter = Settings.Default.KodeDokter;
var kode_poli = cmd.GetKodePoli();
cmd.CloseConnection();
if (CheckTextBox())
{
if (cmd.UpdateDataRekamMedis(no_rm, riwayat_penyakit, alergi, berat_badan, keluhan, diagnosa, tindakan,
id_dokter, kode_poli))
{
MessageBox.Show("Rekam medis berhasil di update.", "Informasi", MessageBoxButton.OK,
MessageBoxImage.Information);
DataContext = mrm;
vrm.DisplayDataPasien(no_rm);
Close();
}
else
{
MessageBox.Show("Rekam medis gagal di update.", "Error", MessageBoxButton.OK,
MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Pastikan data yang diinputkan sudah benar.", "Perhatian", MessageBoxButton.OK,
MessageBoxImage.Warning);
}
e.Handled = true;
}
public void Update(Location location)
{
DBCommand db = new DBCommand();
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE Location SET ");
sb.Append("LocationName = '" + location.LocationNameWithoutAbbreviation + "'");
sb.Append(",Abbreviation = '" + location.Abbreviation + "' ");
if (location.FullAddress != null && location.Telephone != string.Empty)
{
sb.Append(",FullAddress='" + location.FullAddress + "'");
}
else
{
sb.Append(",FullAddress=null");
}
if (location.Telephone != null && location.Telephone != string.Empty)
{
sb.Append(",Telephone='" + location.Telephone + "'");
}
else
{
sb.Append(",Telephone=null");
}
sb.Append(",IsResidence=" + location.IsResidence);
sb.Append(",IsStudentCentre=" + location.IsStudentCentre);
sb.Append(",IsRollCall=" + location.IsRollCall);
if (location.RollReference != null && location.RollReference != string.Empty)
{
sb.Append(",RollReference='" + location.RollReference + "'");
}
else
{
sb.Append(",RollReference=null");
}
sb.Append(" WHERE LocationId = " + location.LocationId);
string sql = sb.ToString();
db.ExecuteCommand(sql);
db.CloseConnection();
}
public List <StudentPersonalCare> GetList(int PersonId)
{
List <StudentPersonalCare> personalCate = new List <StudentPersonalCare>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentPersonalCare WHERE StudentId=" + PersonId);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
StudentPersonalCare pc = new StudentPersonalCare();
pc.StudentPersonalCareId = (int)dr["StudentPersonalCareId"];
pc.StudentId = (int)dr["StudentId"];
pc.Item = dr["Item"].ToString();
pc.Assistance = dr["Assistance"].ToString();
pc.Comments = dr["Comments"].ToString();
pc.Frequency = dr["Frequency"].ToString();
personalCate.Add(pc);
}
return(personalCate);
}
public List <PhysicalAbility> GetList(int PersonId)
{
List <PhysicalAbility> list = new List <PhysicalAbility>();
DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentPhysicalAbility WHERE StudentId=" + PersonId);
dbc.CloseConnection();
foreach (DataRow dr in dt.Rows)
{
PhysicalAbility pc = new PhysicalAbility();
pc.StudentPhysicalAbilityId = (int)dr["StudentPhysicalAbilityId"];
pc.StudentId = (int)dr["StudentId"];
pc.Item = dr["Item"].ToString();
pc.Description = dr["Description"].ToString();
pc.Comments = dr["Comments"].ToString();
list.Add(pc);
}
return(list);
}
public override void Save()
{
DBCommand dbc = new DBCommand(DBCommand.TransactionType.WithTransaction);
try
{
DataBase db = new StudentData(dbc);
if (Student.PersonId == 0)
{
int studentId = db.Add(Student);
if (Student.Doctors.Count > 0)
{
db = new DoctorData(dbc);
foreach (Doctor doctor in Student.Doctors)
{
db.Allocate(doctor, studentId);
}
}
if (Student.NextOfKin.Count > 0)
{
db = new NextOfKinData(dbc);
foreach (NextOfKin nok in Student.NextOfKin)
{
if (nok.PersonId == 0)
{
nok.PersonId = db.Add(nok, studentId);
}
else
{
db.Allocate(nok, studentId);
}
}
}
if (Student.EmergencyContacts.Count > 0)
{
db = new EmergencyContactData(dbc);
foreach (EmergencyContact ec in Student.EmergencyContacts)
{
//if (ec.PersonId == 0)
//{
ec.PersonId = db.Add(ec, studentId);
//}
//db.Allocate(ec, studentId);
}
}
if (Student.MedicalConditions.Count > 0)
{
MedicalConditionData mdc = new MedicalConditionData(dbc);
foreach (MedicalCondition mc in Student.MedicalConditions)
{
mdc.Add(mc, studentId);
}
}
}
else
{
db.Update(Student);
}
dbc.CommitTransactions();
dbc.CloseConnection();
Student.RemovedObjects.Clear();
}
catch (Exception ex)
{
dbc.rollbackTransactions();
dbc.CloseConnection();
throw new Exception(ex.Message);
}
}
private void AddRekamMedis_Executed(object sender, ExecutedRoutedEventArgs e)
{
mrm = new ModelRekamMedis(0, " ", " ", " ", " ", " ", " ", " ", " ", " ", DateTime.Now.ToShortDateString(),
" ", " ", " ");
var cmd = new DBCommand(conn);
var lstDiagnosa = txtKodeDiagnosis.Text.Split(';').ToArray();
var lstTindakan = txtKodeTindakan.Text.Split(';').ToArray();
var riwayat_penyakit = "";
if (txtRiwayat.Text == string.Empty)
{
riwayat_penyakit = "-";
}
else
{
riwayat_penyakit = txtRiwayat.Text;
}
var no_rm = txtRekamMedis.Text;
var berat_badan = txtBeratBadan.Text;
var alergi = txtAlergi.Text;
var keluhan = textKeluhan.Text;
var diagnosa = "";
var tindakan = "";
var id_dokter = Settings.Default.KodeDokter;
var kode_poli = cmd.GetKodePoli();
cmd.CloseConnection();
var res = false;
if (CheckTextBox())
{
if (!Regex.IsMatch(berat_badan, "^[A-Za-z]+$"))
{
for (var i = 0; i < lstDiagnosa.Length - 1; i++)
{
diagnosa = lstDiagnosa[i];
for (var j = 0; j < lstTindakan.Length - 1; j++)
{
if (string.IsNullOrEmpty(alergi))
{
alergi = "-";
}
tindakan = lstTindakan[j];
if (cmd.InsertDataRekamMedis(no_rm, riwayat_penyakit, alergi, berat_badan, keluhan,
diagnosa, tindakan, id_dokter, kode_poli))
{
res = true;
}
else
{
res = false;
break;
}
}
}
if (res)
{
MessageBox.Show("Rekam medis berhasil di tambahkan.", "Informasi", MessageBoxButton.OK,
MessageBoxImage.Information);
}
else
{
MessageBox.Show("Rekam medis gagal di tambahkan.", "Error", MessageBoxButton.OK,
MessageBoxImage.Error);
}
DataContext = mrm;
vmr.DisplayDataPasien(no_rm);
Close();
}
else
{
MessageBox.Show("Berat badan harus berupa angka.", "Perhatian", MessageBoxButton.OK,
MessageBoxImage.Warning);
}
}
else
{
MessageBox.Show("Pastikan data yang diinputkan sudah benar.", "Perhatian", MessageBoxButton.OK,
MessageBoxImage.Warning);
}
e.Handled = true;
}