protected static Result ExcuteQueryDataSet(string query) { Result result = new Result(); MMOverride db = null; SqlDataAdapter adapter = null; try { db = new MMOverride(); adapter = new SqlDataAdapter(query, (SqlConnection)db.Connection); adapter.SelectCommand.CommandTimeout = 0; DataSet ds = new DataSet(); adapter.Fill(ds); result.QueryResult = ds; } 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 (adapter != null) { adapter.Dispose(); adapter = null; } if (db != null) { db.Dispose(); db = null; } } return(result); }
public static Result GetThayDoiSoHoaSonSauCung() { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); var ngayThayDoi = (from n in db.NgayBatDauLamMoiSoHoaDonXetNghiemYKhoas orderby n.NgayBatDau descending select n).FirstOrDefault(); if (ngayThayDoi != null) { result.QueryResult = ngayThayDoi; } else { result.QueryResult = null; } } 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 GetNgayHetHanCuaThuoc(string thuocGUID) { Result result = new Result(); MMOverride db = null; try { DateTime dt = DateTime.Now; db = new MMOverride(); LoThuoc loThuoc = (from t in db.Thuocs join l in db.LoThuocs on t.ThuocGUID equals l.ThuocGUID where t.Status == (byte)Status.Actived && l.Status == (byte)Status.Actived && t.ThuocGUID.ToString() == thuocGUID orderby new DateTime(l.NgayHetHan.Year, l.NgayHetHan.Month, l.NgayHetHan.Day) descending, l.CreatedDate descending select l).FirstOrDefault <LoThuoc>(); if (loThuoc != null) { result.QueryResult = loThuoc.NgayHetHan; } } 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 CheckMaxNgayXNExist(string patientGUID, string loaiXN, DateTime maxNgayXN) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); MaxNgayXetNghiem m = db.MaxNgayXetNghiems.FirstOrDefault(p => p.PatientGUID.ToString() == patientGUID && p.MaxNgayXetNghiem1 == maxNgayXN && p.LoaiXN == loaiXN); if (m == 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 InsertMaxNgayXN(string patientGUID, string loaiXN, DateTime maxNgayXN) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew)) { MaxNgayXetNghiem m = new MaxNgayXetNghiem(); m.MaxNgayXetNghiemGUID = Guid.NewGuid(); m.PatientGUID = Guid.Parse(patientGUID); m.LoaiXN = loaiXN; m.MaxNgayXetNghiem1 = maxNgayXN; db.MaxNgayXetNghiems.InsertOnSubmit(m); 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 DeletePhongCho(List <string> keys) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew)) { foreach (string key in keys) { PhongCho pc = db.PhongChos.SingleOrDefault(p => p.PhongChoGUID.ToString() == key); db.PhongChos.DeleteOnSubmit(pc); } 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 GetNgayXuatHoaDon(string soHoaDon) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); Invoice invoice = (from i in db.Invoices where i.InvoiceCode == soHoaDon && i.Status == (byte)Status.Deactived && i.InvoiceDate >= Global.NgayThayDoiSoHoaDonSauCung orderby i.InvoiceDate descending select i).FirstOrDefault(); if (invoice != null) { result.QueryResult = invoice.InvoiceDate; } } 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 CheckInvoiceExistCode(int soHoaDon) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); QuanLySoHoaDon qlshd = db.QuanLySoHoaDons.SingleOrDefault <QuanLySoHoaDon>(q => q.SoHoaDon == soHoaDon && (q.DaXuat == true || q.XuatTruoc == true) && q.NgayBatDau.Value >= Global.NgayThayDoiSoHoaDonSauCung); if (qlshd == 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 GetDichVuChiDinhList(string chiDinhGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <DichVuChiDinhView> dichVuChiDinhList = (from cd in db.ChiDinhs join ct in db.ChiTietChiDinhs on cd.ChiDinhGUID equals ct.ChiDinhGUID join dv in db.DichVuChiDinhViews on ct.ChiTietChiDinhGUID equals dv.ChiTietChiDinhGUID where cd.ChiDinhGUID.ToString() == chiDinhGUID && cd.Status == (byte)Status.Actived && ct.Status == (byte)Status.Actived && dv.Status == (byte)Status.Actived select dv).ToList(); result.QueryResult = dichVuChiDinhList; } 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 GetUser(string customerId) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); User user = db.Users.FirstOrDefault(u => u.CustomerId.ToLower() == customerId.ToLower()); if (user == null) { result.Error.Code = ErrorCode.NOT_EXIST; } else { result.Error.Code = ErrorCode.EXIST; result.QueryResult = user; } } 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 ChangePassword(string password) { Result result = new Result(); MMOverride db = null; try { RijndaelCrypto crypt = new RijndaelCrypto(); password = crypt.Encrypt(password); db = new MMOverride(); Logon logon = db.Logons.SingleOrDefault <Logon>(l => l.LogonGUID.ToString() == Global.LogonGUID); if (logon != null) { logon.Password = password; logon.UpdatedDate = DateTime.Now; logon.UpdatedBy = Guid.Parse(Global.UserGUID); db.SubmitChanges(); } } 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 GetDiaChiCongTy(string maCongTy) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); DiaChiCongTy diaChiCongTy = db.DiaChiCongTies.FirstOrDefault <DiaChiCongTy>(s => s.MaCongTy.ToLower() == maCongTy.ToLower()); if (diaChiCongTy == null) { result.QueryResult = string.Empty; } else { result.QueryResult = diaChiCongTy.DiaChi; } } 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 GetLichKhamTheoThang(int thang, int nam) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); DateTime fromDate = new DateTime(nam, thang, 1, 0, 0, 0, 0); int daysInMonth = DateTime.DaysInMonth(nam, thang); DateTime toDate = new DateTime(nam, thang, daysInMonth, 23, 59, 59); List <LichKham> lichKhams = (from l in db.LichKhams where l.Ngay >= fromDate && l.Ngay <= toDate select l).ToList(); result.QueryResult = lichKhams; } 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 GetLoiKhuyenList2(string patientGUID, DateTime fromDate, DateTime toDate) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <LoiKhuyenView> loiKhuyenList = (from lk in db.LoiKhuyenViews where lk.PatientGUID.ToString() == patientGUID && lk.Ngay >= fromDate && lk.Ngay <= toDate && lk.LoiKhuyenStatus == (byte)Status.Actived && lk.SymptomStatus == (byte)Status.Actived orderby lk.SymptomName descending select lk).ToList <LoiKhuyenView>(); result.QueryResult = loiKhuyenList; } 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 GetTenCongTy(string patientGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); CompanyMember m = db.CompanyMembers.SingleOrDefault <CompanyMember>(mm => mm.PatientGUID.ToString() == patientGUID && mm.Status == (byte)Status.Actived && mm.Company.Status == (byte)Status.Actived); if (m != null) { result.QueryResult = m.Company.TenCty; } } 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 CheckKhoCapCuuTonKho() { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); DateTime dt = DateTime.Now; NhapKhoCapCuu nkcc = (from l in db.NhapKhoCapCuus where l.Status == (byte)Status.Actived && new DateTime(l.NgayHetHan.Value.Year, l.NgayHetHan.Value.Month, l.NgayHetHan.Value.Day) > dt && l.SoLuongNhap * l.SoLuongQuiDoi - l.SoLuongXuat <= Global.AlertSoLuongHetTonKhoCapCuu select l).FirstOrDefault(); result.QueryResult = nkcc != null ? true: false; } 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 GetServiceGroup(string serviceGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); Service_ServiceGroup service_ServiceGroup = db.Service_ServiceGroups.SingleOrDefault <Service_ServiceGroup>(s => s.ServiceGUID.ToString() == serviceGUID && s.Status == (byte)Status.Actived); if (service_ServiceGroup != null) { if (service_ServiceGroup.ServiceGroup.Status == (byte)Status.Actived) { result.QueryResult = service_ServiceGroup.ServiceGroup; } } } 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 InsertBookmark(Bookmark bookmark) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); Bookmark bm = db.Bookmarks.SingleOrDefault(b => b.Type == bookmark.Type && b.Value.Trim().ToUpper() == bookmark.Value.Trim().ToUpper()); if (bm == null) { bookmark.BookmarkGUID = Guid.NewGuid(); db.Bookmarks.InsertOnSubmit(bookmark); db.SubmitChanges(); } } 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 GetReceiptByServiceHistoryGUID(string serviceHistoryGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); ReceiptDetail ctpt = db.ReceiptDetails.FirstOrDefault <ReceiptDetail>(r => r.ServiceHistoryGUID.ToString() == serviceHistoryGUID && r.Status == (byte)Status.Actived); Receipt receipt = null; if (ctpt != null) { receipt = ctpt.Receipt; } result.QueryResult = receipt; } 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 GetLastCanDo(string patientGUID, DateTime fromDate, DateTime toDate) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); CanDo canDo = (from cd in db.CanDos where cd.PatientGUID.ToString() == patientGUID && cd.NgayCanDo >= fromDate && cd.NgayCanDo <= toDate && cd.Status == (byte)Status.Actived orderby cd.NgayCanDo descending select cd).FirstOrDefault <CanDo>(); result.QueryResult = canDo; } 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 InsertSMSLog(SMSLog smsLog) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); string desc = string.Empty; using (TransactionScope tnx = new TransactionScope(TransactionScopeOption.RequiresNew)) { smsLog.SMSLogGUID = Guid.NewGuid(); db.SMSLogs.InsertOnSubmit(smsLog); 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 GetMauChayHoSo(string contractMemberGUID, string hopDongGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <MauHoSo> mauHoSoList = (from m in db.MauHoSos join c in db.ChiTietMauHoSos on m.MauHoSoGUID equals c.MauHoSoGUID join l in db.CompanyCheckLists on c.ServiceGUID equals l.ServiceGUID where l.Status == 0 && c.HopDongGUID.ToString() == hopDongGUID && l.ContractMemberGUID.ToString() == contractMemberGUID select m).Distinct().OrderBy(x => x.Loai).ToList(); result.QueryResult = mauHoSoList; } 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 GetKetQuaCanLamSangList(string patientGUID, DateTime fromDate, DateTime toDate) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <KetQuaCanLamSangView> ketQuaCanLamSangList = (from s in db.KetQuaCanLamSangViews where s.PatientGUID.ToString() == patientGUID && s.NgayKham >= fromDate && s.NgayKham <= toDate && s.KetQuaCanLamSangStatus == (byte)Status.Actived && s.ServiceStatus == (byte)Status.Actived orderby s.Name ascending select s).ToList <KetQuaCanLamSangView>(); result.QueryResult = ketQuaCanLamSangList; } 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 SetThayDoiSoHoaSon(DateTime ngayThayDoi, string mauSo, string kiHieu, int soHoaDonBatDau) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); NgayBatDauLamMoiSoHoaDonXetNghiemYKhoa nbd = new NgayBatDauLamMoiSoHoaDonXetNghiemYKhoa(); nbd.MaNgayBatDauGUID = Guid.NewGuid(); nbd.NgayBatDau = ngayThayDoi; nbd.MauSo = mauSo; nbd.KiHieu = kiHieu; nbd.SoHoaDonBatDau = soHoaDonBatDau; db.NgayBatDauLamMoiSoHoaDonXetNghiemYKhoas.InsertOnSubmit(nbd); db.SubmitChanges(); } 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 GetBooking(DateTime ngay) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <Booking> bookingList = (from b in db.Bookings where b.BookingDate.Year == ngay.Year && b.BookingDate.Month == ngay.Month && b.BookingDate.Day == ngay.Day && b.BookingType == (byte)BookingType.Monitor && b.Status == (byte)Status.Actived && b.InOut == "IN" select b).ToList(); result.QueryResult = bookingList; } 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 GetMauBaoCaoList(string loaiSieuAmGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <MauBaoCao> mauBaoCaoList = (from m in db.MauBaoCaos where m.LoaiSieuAmGUID.ToString() == loaiSieuAmGUID && m.Status == (byte)Status.Actived orderby m.DoiTuong ascending select m).ToList(); result.QueryResult = mauBaoCaoList; } 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 DeleteTenKhachHang(string thongTinKhachHangGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); ThongTinKhachHang ttkh = db.ThongTinKhachHangs.FirstOrDefault(t => t.ThongTinKhachHangGUID.ToString().ToLower() == thongTinKhachHangGUID.ToLower()); if (ttkh != null) { ttkh.TenKhachHang = string.Empty; } db.SubmitChanges(); } 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 GetBacSiChiDinh(string serviceHistoryGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); DichVuChiDinh dvcd = db.DichVuChiDinhs.FirstOrDefault(d => d.ServiceHistoryGUID.ToString() == serviceHistoryGUID && d.Status == (byte)Status.Actived); if (dvcd != null && dvcd.ChiTietChiDinh.Status == (byte)Status.Actived && dvcd.ChiTietChiDinh.ChiDinh.Status == (byte)Status.Actived && dvcd.ChiTietChiDinh.ChiDinh.DocStaff.Contact.Archived == false) { result.QueryResult = dvcd.ChiTietChiDinh.ChiDinh.DocStaff.Contact.FullName; } } 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 GetNhomNguoiSuDung(string logonGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <UserGroup> userGroups = (from g in db.UserGroup_Logons join u in db.UserGroups on g.UserGroupGUID equals u.UserGroupGUID where g.LogonGUID.ToString() == logonGUID && u.Status == (byte)Status.Actived select u).ToList(); result.QueryResult = userGroups; } 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 GetDanhSachXetNghiemTheoNhom(string groupName) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); List <XetNghiem_Manual> xetNghiemList = (from x in db.XetNghiem_Manuals where x.GroupName.ToLower() == groupName.ToLower() && x.Status == (byte)Status.Actived orderby x.Order ascending select x).ToList(); result.QueryResult = xetNghiemList; } 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); }