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