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