private void OnSaveInfo()
{
try
{
MethodInvoker method = delegate
{
_toaCapCuu.MaToaCapCuu = txtMaToaCapCuu.Text;
_toaCapCuu.NgayKeToa = dtpkNgayKeToa.Value;
if (cboDocStaff.SelectedValue != null && cboDocStaff.Text.Trim() != string.Empty)
{
_toaCapCuu.BacSiKeToaGUID = Guid.Parse(cboDocStaff.SelectedValue.ToString());
}
else
{
_toaCapCuu.BacSiKeToaGUID = null;
}
_toaCapCuu.MaBenhNhan = txtMaBenhNhan.Text;
_toaCapCuu.TenBenhNhan = txtTenBenhNhan.Text;
_toaCapCuu.DiaChi = txtDiaChi.Text;
_toaCapCuu.TenCongTy = _tenCongTy;
_toaCapCuu.Status = (byte)Status.Actived;
_toaCapCuu.Note = txtGhiChu.Text;
if (_isNew)
{
_toaCapCuu.CreatedDate = DateTime.Now;
_toaCapCuu.CreatedBy = Guid.Parse(Global.UserGUID);
}
List <ChiTietToaCapCuu> addedList = new List <ChiTietToaCapCuu>();
for (int i = 0; i < dgChiTiet.RowCount - 1; i++)
{
DataGridViewRow row = dgChiTiet.Rows[i];
ChiTietToaCapCuu cttcc = new ChiTietToaCapCuu();
if (row.Cells["ChiTietToaCapCuuGUID"].Value != null && row.Cells["ChiTietToaCapCuuGUID"].Value != DBNull.Value)
{
cttcc.ChiTietToaCapCuuGUID = Guid.Parse(row.Cells["ChiTietToaCapCuuGUID"].Value.ToString());
}
cttcc.CreatedDate = DateTime.Now;
cttcc.CreatedBy = Guid.Parse(Global.UserGUID);
cttcc.KhoCapCuuGUID = Guid.Parse(row.Cells["KhoCapCuuGUID"].Value.ToString());
if (row.Cells["SoLuong"].Value != null && row.Cells["SoLuong"].Value != DBNull.Value)
{
cttcc.SoLuong = Convert.ToDouble(row.Cells["SoLuong"].Value);
}
else
{
cttcc.SoLuong = 1;
}
cttcc.Status = (byte)Status.Actived;
addedList.Add(cttcc);
}
Result result = KeToaCapCuuBus.InsertToaCapCuu(_toaCapCuu, addedList, _deletedKeys);
if (!result.IsOK)
{
MsgBox.Show(this.Text, result.GetErrorAsString("KeToaCapCuuBus.InsertToaCapCuu"), IconType.Error);
Utility.WriteToTraceLog(result.GetErrorAsString("KeToaCapCuuBus.InsertToaCapCuu"));
this.DialogResult = System.Windows.Forms.DialogResult.Cancel;
}
};
if (InvokeRequired)
{
BeginInvoke(method);
}
else
{
method.Invoke();
}
}
catch (Exception e)
{
MsgBox.Show(this.Text, e.Message, IconType.Error);
Utility.WriteToTraceLog(e.Message);
}
}
public static Result InsertToaCapCuu(ToaCapCuu toaCapCuu, List <ChiTietToaCapCuu> addedList, List <string> deletedKeys)
{
Result result = new Result();
MMOverride db = null;
try
{
db = new MMOverride();
string desc = string.Empty;
using (TransactionScope tnx = new TransactionScope(TransactionScopeOption.RequiresNew))
{
//Insert
if (toaCapCuu.ToaCapCuuGUID == null || toaCapCuu.ToaCapCuuGUID == Guid.Empty)
{
toaCapCuu.ToaCapCuuGUID = Guid.NewGuid();
db.ToaCapCuus.InsertOnSubmit(toaCapCuu);
db.SubmitChanges();
string basSiKeToa = string.Empty;
if (toaCapCuu.DocStaff != null)
{
basSiKeToa = toaCapCuu.DocStaff.Contact.FullName;
}
desc += string.Format("-Toa cấp cứu GUID: '{0}', Mã toa cấp cứu: '{1}', Ngày kê toa: '{2}', Bác sĩ kê toa: '{3}', Bệnh nhân: '{4}', Ghi chú: '{5}'\n",
toaCapCuu.ToaCapCuuGUID.ToString(), toaCapCuu.MaToaCapCuu, toaCapCuu.NgayKeToa.ToString("dd/MM/yyyy HH:mm:ss"), basSiKeToa,
toaCapCuu.TenBenhNhan, toaCapCuu.Note);
if (addedList != null && addedList.Count > 0)
{
desc += "- Chi tiết toa cấp cứu được thêm:\n";
//Chi tiet toa cấp cứu
foreach (ChiTietToaCapCuu cttcc in addedList)
{
cttcc.ChiTietToaCapCuuGUID = Guid.NewGuid();
cttcc.ToaCapCuuGUID = toaCapCuu.ToaCapCuuGUID;
db.ChiTietToaCapCuus.InsertOnSubmit(cttcc);
db.SubmitChanges();
desc += string.Format(" + GUID: '{0}', Tên cấp cứu: '{1}', Số lượng: '{2}'\n", cttcc.ChiTietToaCapCuuGUID.ToString(),
cttcc.KhoCapCuu.TenCapCuu, cttcc.SoLuong);
}
}
//Tracking
desc = desc.Substring(0, desc.Length - 1);
Tracking tk = new Tracking();
tk.TrackingGUID = Guid.NewGuid();
tk.TrackingDate = DateTime.Now;
tk.DocStaffGUID = Guid.Parse(Global.UserGUID);
tk.ActionType = (byte)ActionType.Add;
tk.Action = "Thêm thông tin toa cấp cứu";
tk.Description = desc;
tk.TrackingType = (byte)TrackingType.None;
tk.ComputerName = Utility.GetDNSHostName();
db.Trackings.InsertOnSubmit(tk);
db.SubmitChanges();
}
else //Update
{
ToaCapCuu tcc = db.ToaCapCuus.SingleOrDefault <ToaCapCuu>(o => o.ToaCapCuuGUID.ToString() == toaCapCuu.ToaCapCuuGUID.ToString());
if (tcc != null)
{
tcc.MaToaCapCuu = toaCapCuu.MaToaCapCuu;
tcc.NgayKeToa = toaCapCuu.NgayKeToa;
tcc.BacSiKeToaGUID = toaCapCuu.BacSiKeToaGUID;
tcc.TenBenhNhan = toaCapCuu.TenBenhNhan;
tcc.MaBenhNhan = toaCapCuu.MaBenhNhan;
tcc.DiaChi = toaCapCuu.DiaChi;
tcc.TenCongTy = toaCapCuu.TenCongTy;
tcc.Note = toaCapCuu.Note;
tcc.CreatedDate = toaCapCuu.CreatedDate;
tcc.CreatedBy = toaCapCuu.CreatedBy;
tcc.UpdatedDate = toaCapCuu.UpdatedDate;
tcc.UpdatedBy = toaCapCuu.UpdatedBy;
tcc.DeletedDate = toaCapCuu.DeletedDate;
tcc.DeletedBy = toaCapCuu.DeletedBy;
tcc.Status = toaCapCuu.Status;
db.SubmitChanges();
string basSiKeToa = string.Empty;
if (tcc.DocStaff != null)
{
basSiKeToa = tcc.DocStaff.Contact.FullName;
}
desc += string.Format("-Toa cấp cứu GUID: '{0}', Mã toa cấp cứu: '{1}', Ngày kê toa: '{2}', Bác sĩ kê toa: '{3}', Bệnh nhân: '{4}', Ghi chú: '{5}'\n",
tcc.ToaCapCuuGUID.ToString(), tcc.MaToaCapCuu, tcc.NgayKeToa.ToString("dd/MM/yyyy HH:mm:ss"), basSiKeToa,
tcc.TenBenhNhan, tcc.Note);
//Delete chi tiet toa cấp cứu
if (deletedKeys != null && deletedKeys.Count > 0)
{
desc += "- Chi tiết toa cấp cứu được xóa:\n";
foreach (string key in deletedKeys)
{
ChiTietToaCapCuu cttcc = db.ChiTietToaCapCuus.SingleOrDefault <ChiTietToaCapCuu>(c => c.ChiTietToaCapCuuGUID.ToString() == key);
if (cttcc != null)
{
cttcc.DeletedDate = DateTime.Now;
cttcc.DeletedBy = Guid.Parse(Global.UserGUID);
cttcc.Status = (byte)Status.Deactived;
desc += string.Format(" + GUID: '{0}', Tên cấp cứu: '{1}', Số lượng: '{2}'\n", cttcc.ChiTietToaCapCuuGUID.ToString(),
cttcc.KhoCapCuu.TenCapCuu, cttcc.SoLuong);
}
}
db.SubmitChanges();
}
//Add chi tiet toa cấp cứu
if (addedList != null && addedList.Count > 0)
{
desc += "- Chi tiết toa cấp cứu được thêm:\n";
foreach (ChiTietToaCapCuu cttcc in addedList)
{
cttcc.ToaCapCuuGUID = tcc.ToaCapCuuGUID;
if (cttcc.ChiTietToaCapCuuGUID == Guid.Empty)
{
cttcc.ChiTietToaCapCuuGUID = Guid.NewGuid();
db.ChiTietToaCapCuus.InsertOnSubmit(cttcc);
db.SubmitChanges();
desc += string.Format(" + GUID: '{0}', Tên cấp cứu: '{1}', Số lượng: '{2}'\n", cttcc.ChiTietToaCapCuuGUID.ToString(),
cttcc.KhoCapCuu.TenCapCuu, cttcc.SoLuong);
}
else
{
ChiTietToaCapCuu chiTietToaCapCuu = db.ChiTietToaCapCuus.SingleOrDefault <ChiTietToaCapCuu>(c => c.ChiTietToaCapCuuGUID == cttcc.ChiTietToaCapCuuGUID);
if (chiTietToaCapCuu != null)
{
chiTietToaCapCuu.KhoCapCuuGUID = cttcc.KhoCapCuuGUID;
chiTietToaCapCuu.SoLuong = cttcc.SoLuong;
chiTietToaCapCuu.Note = cttcc.Note;
chiTietToaCapCuu.Status = (byte)Status.Actived;
chiTietToaCapCuu.UpdatedDate = cttcc.UpdatedDate;
chiTietToaCapCuu.UpdatedBy = cttcc.UpdatedBy;
db.SubmitChanges();
desc += string.Format(" + GUID: '{0}', Tên cấp cứu: '{1}', Số lượng: '{2}'\n",
chiTietToaCapCuu.ChiTietToaCapCuuGUID.ToString(), chiTietToaCapCuu.KhoCapCuu.TenCapCuu, chiTietToaCapCuu.SoLuong);
}
}
}
}
//Tracking
desc = desc.Substring(0, desc.Length - 1);
Tracking tk = new Tracking();
tk.TrackingGUID = Guid.NewGuid();
tk.TrackingDate = DateTime.Now;
tk.DocStaffGUID = Guid.Parse(Global.UserGUID);
tk.ActionType = (byte)ActionType.Edit;
tk.Action = "Sửa thông tin toa cấp cứu";
tk.Description = desc;
tk.TrackingType = (byte)TrackingType.None;
tk.ComputerName = Utility.GetDNSHostName();
db.Trackings.InsertOnSubmit(tk);
db.SubmitChanges();
}
}
tnx.Complete();
}
}
catch (System.Data.SqlClient.SqlException se)
{
result.Error.Code = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT;
result.Error.Description = se.ToString();
}
catch (Exception e)
{
result.Error.Code = ErrorCode.UNKNOWN_ERROR;
result.Error.Description = e.ToString();
}
finally
{
if (db != null)
{
db.Dispose();
db = null;
}
}
return(result);
}
