public static Result AddPhongCho(List <string> patientKeys)
{
Result result = new Result();
MMOverride db = null;
try
{
db = new MMOverride();
using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew))
{
DateTime fromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
DateTime toDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59);
foreach (string key in patientKeys)
{
PhongCho pc = db.PhongChos.SingleOrDefault(p => p.PatientGUID.ToString() == key &&
p.Ngay >= fromDate && p.Ngay <= toDate);
if (pc == null)
{
pc = new PhongCho();
pc.PhongChoGUID = Guid.NewGuid();
pc.PatientGUID = Guid.Parse(key);
pc.Ngay = DateTime.Now;
db.PhongChos.InsertOnSubmit(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 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);
}
