public static Result InsertThongTinCapCuu(KhoCapCuu khoCapCuu)
{
Result result = new Result();
MMOverride db = null;
try
{
db = new MMOverride();
string desc = string.Empty;
using (TransactionScope tnx = new TransactionScope(TransactionScopeOption.RequiresNew))
{
//Insert
if (khoCapCuu.KhoCapCuuGUID == null || khoCapCuu.KhoCapCuuGUID == Guid.Empty)
{
khoCapCuu.KhoCapCuuGUID = Guid.NewGuid();
db.KhoCapCuus.InsertOnSubmit(khoCapCuu);
db.SubmitChanges();
//Tracking
desc += string.Format("- GUID: '{0}', Tên cấp cứu: '{1}', ĐVT: '{2}'",
khoCapCuu.KhoCapCuuGUID.ToString(), khoCapCuu.TenCapCuu, khoCapCuu.DonViTinh);
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 cấp cứu";
tk.Description = desc;
tk.TrackingType = (byte)TrackingType.None;
tk.ComputerName = Utility.GetDNSHostName();
db.Trackings.InsertOnSubmit(tk);
db.SubmitChanges();
}
else //Update
{
KhoCapCuu kcc = db.KhoCapCuus.SingleOrDefault <KhoCapCuu>(k => k.KhoCapCuuGUID == khoCapCuu.KhoCapCuuGUID);
if (kcc != null)
{
kcc.TenCapCuu = khoCapCuu.TenCapCuu;
kcc.DonViTinh = khoCapCuu.DonViTinh;
kcc.Note = khoCapCuu.Note;
kcc.CreatedDate = khoCapCuu.CreatedDate;
kcc.CreatedBy = khoCapCuu.CreatedBy;
kcc.UpdatedDate = khoCapCuu.UpdatedDate;
kcc.UpdatedBy = khoCapCuu.UpdatedBy;
kcc.DeletedDate = khoCapCuu.DeletedDate;
kcc.DeletedBy = khoCapCuu.DeletedBy;
kcc.Status = khoCapCuu.Status;
//Update DVT to NhapKhoCapCuu
var nhapKhoCapCuus = kcc.NhapKhoCapCuus;
foreach (var nk in nhapKhoCapCuus)
{
if (kcc.DonViTinh == nk.DonViTinhQuiDoi)
{
continue;
}
nk.DonViTinhQuiDoi = kcc.DonViTinh;
if (nk.DonViTinhNhap != "Hộp" && nk.DonViTinhNhap != "Vỉ")
{
nk.DonViTinhNhap = kcc.DonViTinh;
}
else if (nk.DonViTinhNhap == "Vỉ" && kcc.DonViTinh != "Viên")
{
nk.DonViTinhNhap = "Hộp";
}
}
//Tracking
desc += string.Format("- GUID: '{0}', Tên cấp cứu: '{1}', ĐVT: '{2}'",
kcc.KhoCapCuuGUID.ToString(), kcc.TenCapCuu, kcc.DonViTinh);
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 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);
}
