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); }