private void DeleteButton_OnClick(object sender, RoutedEventArgs e)
{
//throw new NotImplementedException();
using (var patientRoomDao = new PatientRoomDao())
{
patientRoomDao.DeletePatientRoom(Datalist[ListView1.SelectedIndex].Id);
RefreshData();
}
}
private void ListViewCPatientRoom_OnLoaded(object sender, RoutedEventArgs e)
{
#region refresh data list
try
{
using (var patientRoomDao = new PatientRoomDao())
{
Datalist.Clear();
var condition = new Dictionary <string, object>();
var list = patientRoomDao.SelectPatientRoom(condition);
foreach (var pa in list)
{
var patientRoomData = new PatientRoomData();
patientRoomData.Id = pa.Id;
patientRoomData.Name = pa.Name;
{
using (var patientAreaDao = new PatientAreaDao())
{
condition.Clear();
condition["ID"] = pa.PatientAreaId;
var arealist = patientAreaDao.SelectPatientArea(condition);
if (arealist.Count == 1)
{
patientRoomData.PatientArea = arealist[0].Name;
}
}
}
{
using (var infectTypeDao = new InfectTypeDao())
{
condition.Clear();
condition["ID"] = pa.InfectTypeId;
var arealist = infectTypeDao.SelectInfectType(condition);
if (arealist.Count == 1)
{
patientRoomData.InfectType = arealist[0].Name;
}
}
}
patientRoomData.Description = pa.Description;
Datalist.Add(patientRoomData);
}
}
}
catch (Exception ex)
{
MainWindow.Log.WriteInfoConsole("In CPatientRoom.xaml.cs:ListViewCPatientRoom_OnLoaded 3 exception messsage: " + ex.Message);
}
#endregion
}
private void AddButton_OnClick(object sender, RoutedEventArgs e)
{
//throw new NotImplementedException();
try
{
using (var patientRoomDao = new PatientRoomDao())
{
var patientRoom = new PatientRoom();
patientRoom.Name = this.NameTextBox.Text;
var condition = new Dictionary <string, object>();
using (var patientAreaDao = new PatientAreaDao())
{
condition.Clear();
condition["Name"] = ComboBoxPatientArea.Text;
var arealist = patientAreaDao.SelectPatientArea(condition);
if (arealist.Count == 1)
{
patientRoom.PatientAreaId = arealist[0].Id;
}
}
using (var infectTypeDao = new InfectTypeDao())
{
condition.Clear();
condition["Name"] = ComboBoxInfectType.Text;
var arealist = infectTypeDao.SelectInfectType(condition);
if (arealist.Count == 1)
{
patientRoom.InfectTypeId = arealist[0].Id;
}
}
patientRoom.Description = this.DescriptionTextBox.Text;
int lastInsertId = -1;
patientRoomDao.InsertPatientRoom(patientRoom, ref lastInsertId);
//UI
PatientRoomData patientRoomData = new PatientRoomData();
patientRoomData.Id = patientRoom.Id;
patientRoomData.Name = patientRoom.Name;
patientRoomData.PatientArea = ComboBoxPatientArea.Text;
patientRoomData.InfectType = ComboBoxInfectType.Text;
patientRoomData.Description = patientRoom.Description;
Datalist.Add(patientRoomData);
}
}
catch (Exception ex)
{
MainWindow.Log.WriteInfoConsole("In CPatientRoom.xaml.cs:AddButton_OnClick exception messsage: " + ex.Message);
}
}
private void RefreshData()
{
try
{
using (var patientRoomDao = new PatientRoomDao())
{
Datalist.Clear();
Dictionary <string, object> condition = new Dictionary <string, object>();
var list = patientRoomDao.SelectPatientRoom(condition);
foreach (PatientRoom pa in list)
{
var patientRoomData = new PatientRoomData();
patientRoomData.Id = pa.Id;
patientRoomData.Name = pa.Name;
{
using (var patientAreaDao = new PatientAreaDao())
{
condition.Clear();
condition["ID"] = pa.PatientAreaId;
var arealist = patientAreaDao.SelectPatientArea(condition);
if (arealist.Count == 1)
{
patientRoomData.PatientArea = arealist[0].Name;
}
}
}
{
using (var infectTypeDao = new InfectTypeDao())
{
condition.Clear();
condition["ID"] = pa.InfectTypeId;
var arealist = infectTypeDao.SelectInfectType(condition);
if (arealist.Count == 1)
{
patientRoomData.InfectType = arealist[0].Name;
}
}
}
patientRoomData.Description = pa.Description;
Datalist.Add(patientRoomData);
}
}
}
catch (Exception ex)
{
MainWindow.Log.WriteInfoConsole("In CPatientArea.xaml.cs:AddButton_OnClick exception messsage: " + ex.Message);
}
}
private void UpdateButton_OnClick(object sender, RoutedEventArgs e)
{
//throw new NotImplementedException();
using (var patientRoomDao = new PatientRoomDao())
{
var condition = new Dictionary <string, object>();
condition["ID"] = Datalist[ListView1.SelectedIndex].Id;
var fileds = new Dictionary <string, object>();
fileds["NAME"] = NameTextBox.Text;
var condition2 = new Dictionary <string, object>();
using (var patientAreaDao = new PatientAreaDao())
{
condition2.Clear();
condition2["Name"] = ComboBoxPatientArea.Text;
var arealist = patientAreaDao.SelectPatientArea(condition2);
if (arealist.Count == 1)
{
fileds["PATIENTAREAID"] = arealist[0].Id;
}
}
using (var infectTypeDao = new InfectTypeDao())
{
condition2.Clear();
condition2["Name"] = ComboBoxInfectType.Text;
var arealist = infectTypeDao.SelectInfectType(condition2);
if (arealist.Count == 1)
{
fileds["INFECTTYPEID"] = arealist[0].Id;
}
}
fileds["DESCRIPTION"] = DescriptionTextBox.Text;
patientRoomDao.UpdatePatientRoom(fileds, condition);
RefreshData();
}
}