public void InsertResultUnit(ResultUnitModel r)
{
string query = $@"
insert into ResultUnits(IdOrderedTests, IdResult, Value)
values({r.IdOrderedTest},{r.IdResult},{BaseDAO.SetNullableDouble(r.Value)});
";
BaseDAO.InsertOrUpdate(query, false);
}
public ActionResult Index()
{
List <PatientModel> list = DB.PatientsDAO.ReadPatientsList();
PatientModel Janeczek = DB.PatientsDAO.ReadPatientById(1L);
DictionaryModel dic = DB.DictionaryDAO.ReadDictionaryById(Enums.DictionaryTypesEnum.Positions, 1L, "pl");
List <DictionaryModel> dicList = DB.DictionaryDAO.ReadDictionaryListByType(Enums.DictionaryTypesEnum.Positions, "pl");
DictionaryModel dic2 = DB.DictionaryDAO.ReadDictionaryById(Enums.DictionaryTypesEnum.Ward, 1L, "en");
List <DictionaryModel> dicList2 = DB.DictionaryDAO.ReadDictionaryListByType(Enums.DictionaryTypesEnum.Ward, "en");
DictionaryModel dic3 = DB.DictionaryDAO.ReadDictionaryById(Enums.DictionaryTypesEnum.Status, 1L, "pl");
List <DictionaryModel> dicList3 = DB.DictionaryDAO.ReadDictionaryListByType(Enums.DictionaryTypesEnum.Status, "pl");
DictionaryModel dic4 = DB.DictionaryDAO.ReadDictionaryById(Enums.DictionaryTypesEnum.Priorities, 1L, "en");
List <DictionaryModel> dicList4 = DB.DictionaryDAO.ReadDictionaryListByType(Enums.DictionaryTypesEnum.Priorities, "en");
List <EmployeeModel> empList = DB.EmployeesDAO.ReadEmployeesList();
EmployeeModel emp = DB.EmployeesDAO.ReadEmployeeById(1L);
List <UserModel> userList = DB.UserDAO.ReadUsersList();
UserModel user = DB.UserDAO.ReadUserById(2L);
List <OrderModel> orderList = DB.OrderDAO.ReadOrdersList();
OrderModel order = DB.OrderDAO.ReadOrderById(1L);
List <ProfileModel> profilesList = DB.ProfilesDAO.ReadProfilesList("pl");
ProfileModel profile = DB.ProfilesDAO.ReadProfileById(1, "pl");
List <StudyModel> studiesList = DB.StudiesDAO.ReadStudiesList();
StudyModel study = DB.StudiesDAO.ReadStudyById(1L);
List <SampleModel> samplesList = DB.SamplesDAO.ReadSamplesList();
SampleModel sample = DB.SamplesDAO.ReadSampleById(1L);
List <TestModel> testsList = DB.TestsDAO.ReadTestsList("pl");
TestModel test = DB.TestsDAO.ReadTestById(1L, "pl");
List <VerificationModel> verifList = DB.VerificationsDAO.ReadVerificationsList();
VerificationModel verificationModel = DB.VerificationsDAO.ReadVerificationById(1L);
VerificationModel verification2Model = DB.VerificationsDAO.ReadVerificationByResultId(1L);
List <ResultModel> resList = DB.ResultsDAO.ReadResultsList();
ResultModel resModel = DB.ResultsDAO.ReadResultById(1L);
List <ResultUnitModel> resUnitList = DB.ResultUnitsDAO.ReadResultUnitsList();
ResultUnitModel resUnitModel = DB.ResultUnitsDAO.ReadResultUnitModelById(1L);
List <ResultUnitModel> resUnit2Model = DB.ResultUnitsDAO.ReadResultUnitModelByResultId(1L);
return(View());
//return Json(Janeczek, JsonRequestBehavior.AllowGet);
}
public ActionResult AddResult(StudyModel study)
{
ActionResult wrongAuthorization = checkEmployeeAutorization((long)PositionTypeEnum.Lab);
if (wrongAuthorization != null)
{
return(wrongAuthorization);
}
if (study != null)
{
try
{
EmployeeModel employee = getEmployeeByUserId();
study.Result.IdEmployee = (long)employee.IdEmployee;
study.Result.IdStudy = (long)study.IdStudy;
long idResult = (long)DB.ResultsDAO.InsertResult(study.Result);
foreach (TestModel test in study.OrderedTest)
{
ResultUnitModel resultUnit = new ResultUnitModel();
resultUnit.IdResult = idResult;
resultUnit.IdOrderedTest = (long)test.IdOrderedTest;
NumberFormatInfo provider = new NumberFormatInfo();
provider.NumberDecimalSeparator = ".";
resultUnit.Value = Convert.ToDouble(test.Result, provider);
DB.ResultUnitsDAO.InsertResultUnit(resultUnit);
}
DB.StudiesDAO.ChangeStudyStatus((long)study.IdStudy, (long)StatusTypeEnum.ToVerify);
return(Json(study.IdStudy));
}
catch (Exception)
{
return(throwBadRequest());
}
}
return(throwValidateError());
}