public List <SpecimenDTO> create(List <Specimen> specimens)
{
List <SpecimenDTO> result = new List <SpecimenDTO>();
foreach (Specimen sp in specimens)
{
List <Slide> slides = null;
if (sp.Slides != null)
{
List <string> slideIds = sp.Slides;
slides = SlideRepository.Instance.ListAsync(slideIds).Result;
}
sp.Slides = null;
sp.SetPropertyValue("Slides", null);
SpecimenDTO dto = createDTO(sp);
if (slides != null)
{
dto.Slides = SlideFactory.Instance.create(slides);
}
result.Add(dto);
}
return(result);
}
public List <SpecimenDTO> GetListWithModel(SpecimenDTO searchModel)
{
log.MethodStart();
List <SpecimenDTO> objList = new List <SpecimenDTO>();
//var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.TCSpecimens.FromSqlRaw <TCSpecimen>("sp_GET_TCSpecimen {0}", searchModel.spc_mst_code).ToList();
objList = _mapper.Map <List <SpecimenDTO> >(objDataList);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
public string CheckDuplicate(SpecimenDTO model)
{
log.MethodStart();
string objReturn = "";
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objResult = _db.TCSpecimens.Any(x => x.spc_code == model.spc_code);
if (objResult == true)
{
objReturn = "Dup";
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
log.Error(ex.Message);
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public SpecimenDTO GetData(string spc_code)
{
log.MethodStart();
SpecimenDTO objModel = new SpecimenDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objReturn1 = _db.TCSpecimens.FirstOrDefault(x => x.spc_code == spc_code);
objModel = _mapper.Map <SpecimenDTO>(objReturn1);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public SpecimenDTO Post_SaveData([FromBody] SpecimenDTO model)
{
var objReturn = _service.SaveData(model);
//var objReturn = _service.GetList();
return(objReturn);
}
public async Task <SpecimenDTO> GetDataAsync(string mst_code)
{
SpecimenDTO menu = new SpecimenDTO();
menu = await _apiHelper.GetDataByIdAsync <SpecimenDTO>("specimen_api/Get_Data", mst_code);
return(menu);
}
public async Task <List <SpecimenDTO> > GetListByModelActiveAsync(SpecimenDTO searchData)
{
List <SpecimenDTO> objList = new List <SpecimenDTO>();
objList = await _apiHelper.GetDataListByModelAsync <SpecimenDTO, SpecimenDTO>("specimen_api/Get_List_Active_ByModel", searchData);
return(objList);
}
public async Task <List <SpecimenDTO> > GetListByParamAsync(SpecimenDTO searchData)
{
List <SpecimenDTO> objList = new List <SpecimenDTO>();
var searchJson = JsonSerializer.Serialize(searchData);
objList = await _apiHelper.GetDataListByParamsAsync <SpecimenDTO>("specimen_api/Get_List", searchJson);
return(objList);
}
public async Task <SpecimenDTO> SaveDataAsync(SpecimenDTO model)
{
//MenuDTO menu = new MenuDTO()
//{
// mnu_id = "2",
// mnu_name = "TEST_name",
// mnu_area = "TEST_area",
// mnu_controller = "TEST_controller"
//};
var menua = await _apiHelper.PostDataAsync <SpecimenDTO>("specimen_api/Post_SaveData", model);
return(menua);
}
public SpecimenDTO createDTO(Document doc)
{
SpecimenDTO result = JsonConvert.DeserializeObject <SpecimenDTO>(JsonConvert.SerializeObject(doc));
return(result);
}
public IEnumerable <SpecimenDTO> Get_List_Active_ByModel([FromBody] SpecimenDTO searchModel)
{
var objReturn = _service.GetList_Active_WithModel(searchModel);
return(objReturn);
}
public SpecimenDTO SaveData(SpecimenDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
SpecimenDTO objReturn = new SpecimenDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCSpecimen();
if (model.spc_status == "E")
{
objModel = _db.TCSpecimens.FirstOrDefault(x => x.spc_id == model.spc_id);
}
if (model.spc_status == "N")
{
objModel = _mapper.Map <TCSpecimen>(model);
objModel.spc_status = objModel.spc_active == true ? "A" : "I";
objModel.spc_createdate = currentDateTime;
currentUser = objModel.spc_createuser;
_db.TCSpecimens.Add(objModel);
}
else if (model.spc_status == "E")
{
objModel.spc_name = model.spc_name;
objModel.spc_desc = model.spc_desc;
objModel.spc_active = model.spc_active;
objModel.spc_status = objModel.spc_active == true ? "A" : "I";
objModel.spc_updateuser = model.spc_updateuser;
objModel.spc_updatedate = currentDateTime;
currentUser = objModel.spc_updateuser;
//_db.TCHospitals.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "Specimen",
log_tran_id = $"{objModel.spc_mst_code}:{objModel.spc_code}",
log_action = (model.spc_status == "N" ? "New" : "Update"),
log_desc = (model.spc_status == "N" ? "New" : "Update") + " Specimen " + objModel.spc_name,
log_createuser = currentUser,
log_createdate = currentDateTime
});
#endregion
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
