public static Result CheckToaCapCuuExistCode(string toaCapCuuGUID, string code)
{
Result result = new Result();
MMOverride db = null;
try
{
db = new MMOverride();
ToaCapCuu tcc = null;
if (toaCapCuuGUID == null || toaCapCuuGUID == string.Empty)
{
tcc = db.ToaCapCuus.SingleOrDefault <ToaCapCuu>(o => o.MaToaCapCuu.ToLower() == code.ToLower());
}
else
{
tcc = db.ToaCapCuus.SingleOrDefault <ToaCapCuu>(o => o.MaToaCapCuu.ToLower() == code.ToLower() &&
o.ToaCapCuuGUID.ToString() != toaCapCuuGUID);
}
if (tcc == null)
{
result.Error.Code = ErrorCode.NOT_EXIST;
}
else
{
result.Error.Code = ErrorCode.EXIST;
}
}
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);
}
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);
}
public static Result DeleteToaCapCuu(List <string> keys)
{
Result result = new Result();
MMOverride db = null;
try
{
db = new MMOverride();
using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew))
{
string desc = string.Empty;
foreach (string key in keys)
{
ToaCapCuu toaCapCuu = db.ToaCapCuus.SingleOrDefault <ToaCapCuu>(tt => tt.ToaCapCuuGUID.ToString() == key);
if (toaCapCuu != null)
{
toaCapCuu.DeletedDate = DateTime.Now;
toaCapCuu.DeletedBy = Guid.Parse(Global.UserGUID);
toaCapCuu.Status = (byte)Status.Deactived;
string basSiKeToa = string.Empty;
if (toaCapCuu.DocStaff != null)
{
basSiKeToa = toaCapCuu.DocStaff.Contact.FullName;
}
desc += string.Format("- 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);
}
}
//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.Delete;
tk.Action = "Xó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();
t.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);
}