public static Result CheckNhanXetExist(string nhanXetKhamLamSangGUID, int loai, string nhanXet) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); NhanXetKhamLamSang nxkls = null; if (nhanXetKhamLamSangGUID == null || nhanXetKhamLamSangGUID == string.Empty) { nxkls = db.NhanXetKhamLamSangs.SingleOrDefault <NhanXetKhamLamSang>(s => s.NhanXet.Trim().ToLower() == nhanXet.Trim().ToLower() && s.Loai == loai); } else { nxkls = db.NhanXetKhamLamSangs.SingleOrDefault <NhanXetKhamLamSang>(s => s.NhanXet.Trim().ToLower() == nhanXet.Trim().ToLower() && s.Loai == loai && s.NhanXetKhamLamSangGUID.ToString() != nhanXetKhamLamSangGUID); } if (nxkls == 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); }
private bool InsertNhanXetKhamLamSang(string nhanXet, int loai) { if (nhanXet.Trim() == string.Empty) { return(true); } Result result = NhanXetKhamLamSangBus.CheckNhanXetExist(null, loai, nhanXet); if (result.Error.Code == ErrorCode.EXIST || result.Error.Code == ErrorCode.NOT_EXIST) { if (result.Error.Code == ErrorCode.NOT_EXIST) { NhanXetKhamLamSang nhanXetKhamLamSang = new NhanXetKhamLamSang(); nhanXetKhamLamSang.Status = (byte)Status.Actived; nhanXetKhamLamSang.CreatedDate = DateTime.Now; nhanXetKhamLamSang.CreatedBy = Guid.Parse(Global.UserGUID); nhanXetKhamLamSang.NhanXet = nhanXet; nhanXetKhamLamSang.Loai = loai; result = NhanXetKhamLamSangBus.InsertNhanXetKhamLamSang(nhanXetKhamLamSang); if (!result.IsOK) { MsgBox.Show(this.Text, result.GetErrorAsString("NhanXetKhamLamSangBus.InsertNhanXetKhamLamSang"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("NhanXetKhamLamSangBus.InsertNhanXetKhamLamSang")); return(false); } } } else { MsgBox.Show(this.Text, result.GetErrorAsString("NhanXetKhamLamSangBus.CheckNhanXetExist"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("NhanXetKhamLamSangBus.CheckNhanXetExist")); return(false); } return(true); }
public static Result InsertNhanXetKhamLamSang(NhanXetKhamLamSang nhanXetKhamLamSang) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); string desc = string.Empty; using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew)) { //Insert if (nhanXetKhamLamSang.NhanXetKhamLamSangGUID == null || nhanXetKhamLamSang.NhanXetKhamLamSangGUID == Guid.Empty) { nhanXetKhamLamSang.NhanXetKhamLamSangGUID = Guid.NewGuid(); db.NhanXetKhamLamSangs.InsertOnSubmit(nhanXetKhamLamSang); db.SubmitChanges(); //Tracking desc += string.Format("- GUID: '{0}', Nhận xét: '{1}', Loại: '{2}'", nhanXetKhamLamSang.NhanXetKhamLamSangGUID.ToString(), nhanXetKhamLamSang.NhanXet, nhanXetKhamLamSang.Loai); 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 nhận xét khám lâm sàng"; tk.Description = desc; tk.TrackingType = (byte)TrackingType.None; tk.ComputerName = Utility.GetDNSHostName(); db.Trackings.InsertOnSubmit(tk); db.SubmitChanges(); } else //Update { NhanXetKhamLamSang nxkls = db.NhanXetKhamLamSangs.SingleOrDefault <NhanXetKhamLamSang>(s => s.NhanXetKhamLamSangGUID == nhanXetKhamLamSang.NhanXetKhamLamSangGUID); if (nxkls != null) { nxkls.NhanXet = nhanXetKhamLamSang.NhanXet; nxkls.Loai = nhanXetKhamLamSang.Loai; nxkls.GhiChu = nhanXetKhamLamSang.GhiChu; nxkls.CreatedDate = nhanXetKhamLamSang.CreatedDate; nxkls.CreatedBy = nhanXetKhamLamSang.CreatedBy; nxkls.UpdatedDate = nhanXetKhamLamSang.UpdatedDate; nxkls.UpdatedBy = nhanXetKhamLamSang.UpdatedBy; nxkls.DeletedDate = nhanXetKhamLamSang.DeletedDate; nxkls.DeletedBy = nhanXetKhamLamSang.DeletedBy; nxkls.Status = nhanXetKhamLamSang.Status; //Tracking desc += string.Format("- GUID: '{0}', Nhận xét: '{1}', Loại: '{2}'", nxkls.NhanXetKhamLamSangGUID.ToString(), nxkls.NhanXet, nxkls.Loai); 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 nhận xét khám lâm sàng"; 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); }
public static Result DeleteNhanXetKhamLamSang(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) { NhanXetKhamLamSang nxkls = db.NhanXetKhamLamSangs.SingleOrDefault <NhanXetKhamLamSang>(ss => ss.NhanXetKhamLamSangGUID.ToString() == key); if (nxkls != null) { nxkls.DeletedDate = DateTime.Now; nxkls.DeletedBy = Guid.Parse(Global.UserGUID); nxkls.Status = (byte)Status.Deactived; desc += string.Format("- GUID: '{0}', Nhận xét: '{1}', Loại: '{2}'\n", nxkls.NhanXetKhamLamSangGUID.ToString(), nxkls.NhanXet, nxkls.Loai); } } //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 nhận xét khám lâm sàng"; 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); }