public MappingDataDTO GetMappingData(string mp_id) { MappingDataDTO objModel = new MappingDataDTO(); using (var _db = new LabDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { objModel = _db.MappingDataDTOs.FromSqlRaw <MappingDataDTO>("sp_GET_TRMappingByID {0}", mp_id).AsEnumerable().FirstOrDefault(); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } } return(objModel); }
public MappingDataDTO GetMappingDataActiveWithModel(MappingDataDTO model) { log.MethodStart(); MappingDataDTO objModel = new MappingDataDTO(); using (var trans = _db.Database.BeginTransaction()) { try { var objDataList = _db.TRMappings.FromSqlRaw <TRMapping>("sp_GET_TRMapping_Approve_Active {0} ,{1} ,{2} ,{3}", model.mp_hos_code, model.mp_lab, model.mp_program, model.mp_filetype).ToList(); var objListMapping = _mapper.Map <List <MappingDataDTO> >(objDataList); if (objListMapping.Count > 0) { objModel = objListMapping.FirstOrDefault(); } trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objModel); }
public async Task <MappingDataDTO> SaveMappingDataAsync(MappingDataDTO model) { if (model.mp_id.Equals(Guid.Empty)) { model.mp_id = Guid.NewGuid(); model.mp_status = 'N'; if (model.mp_version == 0) { model.mp_version = 1; } model.mp_flagdelete = false; } if (model.mp_status.Equals('A')) { model.mp_status = 'A'; } model.mp_updatedate = DateTime.Now; var mapping = await _apiHelper.PostDataAsync <MappingDataDTO>("mapping_api/Post_SaveMappingData", model); return(mapping); }
public async Task <MappingDataDTO> GetMappingDataActiveWithModelAsync(MappingDataDTO model) { MappingDataDTO objList = new MappingDataDTO(); objList = await _apiHelper.GetDataByModelAsync <MappingDataDTO, MappingDataDTO>("mapping_api/Get_MappingDataActiveWithModel", model); return(objList); }
public async Task <MappingDataDTO> GetchkDuplicateMappingApprovedAsync(MappingDataDTO model) { MappingDataDTO objList = new MappingDataDTO(); objList = await _apiHelper.GetDataByModelAsync <MappingDataDTO, MappingDataDTO>("mapping_api/Get_chkDuplicateMappingApproved", model); return(objList); }
public async Task <MappingDataDTO> GetMappingDataAsync(string mp_Id) { MappingDataDTO mapping = new MappingDataDTO(); mapping = await _apiHelper.GetDataByIdAsync <MappingDataDTO>("mapping_api/GetMappingDataById", mp_Id); return(mapping); }
public MappingDataDTO chkDuplicateMappingApproved(MappingDataDTO model) { log.MethodStart(); MappingDataDTO objModel = new MappingDataDTO(); using (var trans = _db.Database.BeginTransaction()) { try { var objReturn1 = _db.TRMappings.OrderByDescending(x => x.mp_version).FirstOrDefault(x => x.mp_lab == model.mp_lab && x.mp_hos_code == model.mp_hos_code && x.mp_program == model.mp_program && x.mp_filetype == model.mp_filetype && x.mp_startdate > model.mp_startdate && x.mp_status == 'A' && x.mp_flagdelete == false); if (objReturn1 != null) { objModel = _mapper.Map <MappingDataDTO>(objReturn1); } trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objModel); }
public async Task <List <LabFileUploadErrorMessageDTO> > ValidateLabFileAsync(IFileListEntry fileEntry, MappingDataDTO MappingTemplate) { var ErrorMessage = new List <LabFileUploadErrorMessageDTO>(); int row = 1; try { string path = ""; List <ParameterDTO> objParamList = new List <ParameterDTO>(); var searchModel = new ParameterDTO() { prm_code_major = "UPLOAD_PATH" }; objParamList = await _apiHelper.GetDataListByModelAsync <ParameterDTO, ParameterDTO>("dropdownlist_api/GetParameterList", searchModel); if (objParamList.FirstOrDefault(x => x.prm_code_minor == "PATH") != null) { path = objParamList.FirstOrDefault(x => x.prm_code_minor == "PATH").prm_value; } else { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'E', lfu_Err_no = 1, lfu_Err_Column = "", lfu_Err_Message = "ไม่พบ Config PATH กรุณาติดต่อผู้ดูแลระบบ " }); return(ErrorMessage); } string str_CurrentDate = DateTime.Now.ToString("yyyyMMdd"); path = Path.Combine(path, str_CurrentDate, MappingTemplate.mp_hos_code); bool exists = System.IO.Directory.Exists(path); if (!exists) { System.IO.Directory.CreateDirectory(path); } path = Path.Combine(path, fileEntry.Name); using (FileStream file = new FileStream(path, FileMode.Create)) { try { await fileEntry.Data.CopyToAsync(file); } catch (Exception ex) { } finally { file.Flush(); } } WHONetMappingSearch searchWHONet = new WHONetMappingSearch(); searchWHONet.wnm_mappingid = MappingTemplate.mp_id; searchWHONet.wnm_mst_code = MappingTemplate.mp_mst_code; List <WHONetMappingListsDTO> WHONetColumn = await _apiHelper.GetDataListByModelAsync <WHONetMappingListsDTO, WHONetMappingSearch>("mapping_api/Get_WHONetMappingListByModel", searchWHONet); var WHONetColumnMandatory = WHONetColumn.Where(x => x.wnm_mandatory == true); #region ReadExcel if (Path.GetExtension(fileEntry.Name) == ".xls" || Path.GetExtension(fileEntry.Name) == ".xlsx") { ExcelDataSetConfiguration option = new ExcelDataSetConfiguration(); using (var stream = File.Open(path, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { DataSet result = new DataSet(); //First row is header if (MappingTemplate.mp_firstlineisheader == true) { result = reader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration() { UseHeaderRow = true } } ); } else { result = reader.AsDataSet(); } ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'I', lfu_Err_type = 'I', lfu_Err_no = 1, lfu_Err_Column = "Total", lfu_Err_Message = result.Tables[0].Rows.Count.ToString() }); foreach (WHONetMappingListsDTO item in WHONetColumnMandatory) { var wnm_originalfield = item.wnm_originalfield; if (MappingTemplate.mp_firstlineisheader == false) { int index = 0; Int32.TryParse(item.wnm_originalfield.Replace("Column", ""), out index); item.wnm_originalfield = "Column" + (index - 1); } Boolean columnExists = result.Tables[0].Columns.Contains(item.wnm_originalfield); if (columnExists == false) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'C', lfu_Err_no = 1, lfu_Err_Column = wnm_originalfield, lfu_Err_Message = "ไม่พบ Column " + wnm_originalfield }); } if (columnExists) { var chkResult = result.Tables[0].Select("[" + item.wnm_originalfield + "]" + " is null"); if (chkResult.Length > 0) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'N', lfu_Err_no = 1, lfu_Err_Column = wnm_originalfield, lfu_Err_Message = "กรุณาตรวจสอบข้อมูล Column " + wnm_originalfield + " จะต้องไม่เท่ากับค่าว่าง" }); } //if (item.wnm_type == "Date") //{ // var FieldDateType = result.Tables[0].Columns[item.wnm_originalfield].DataType.ToString(); // if(FieldDateType == "System.String") // { // try // { // } // catch() // { // } // } //} } } var x = ErrorMessage; } } } #endregion #region ReadCSV else if (Path.GetExtension(fileEntry.Name) == ".csv") { using (var stream = File.Open(path, FileMode.Open, FileAccess.Read)) { var reader = ExcelReaderFactory.CreateCsvReader(stream, new ExcelReaderConfiguration() { FallbackEncoding = Encoding.GetEncoding(1252), AutodetectSeparators = new char[] { ',', ';', '\t', '|', '#' }, LeaveOpen = false, AnalyzeInitialCsvRows = 0, }); DataSet result = new DataSet(); ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'I', lfu_Err_type = 'I', lfu_Err_no = 1, lfu_Err_Column = "Total", lfu_Err_Message = result.Tables[0].Rows.Count.ToString() }); //First row is header if (MappingTemplate.mp_firstlineisheader == true) { result = reader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration() { UseHeaderRow = true } } ); } else { result = reader.AsDataSet(); } var ee = result.Tables[0]; foreach (WHONetMappingListsDTO item in WHONetColumnMandatory) { var wnm_originalfield = item.wnm_originalfield; if (MappingTemplate.mp_firstlineisheader == false) { int index = 0; Int32.TryParse(item.wnm_originalfield.Replace("Column", ""), out index); item.wnm_originalfield = "Column" + (index - 1); } Boolean columnExists = result.Tables[0].Columns.Contains(item.wnm_originalfield); if (columnExists == false) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'C', lfu_Err_no = 1, lfu_Err_Column = wnm_originalfield, lfu_Err_Message = "ไม่พบ Column " + wnm_originalfield }); } if (columnExists) { var chkResult = result.Tables[0].Select(item.wnm_originalfield + " = ''"); if (chkResult.Length > 0) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'N', lfu_Err_no = 1, lfu_Err_Column = wnm_originalfield, lfu_Err_Message = "กรุณาตรวจสอบข้อมูล Column " + wnm_originalfield + " จะต้องไม่เท่ากับค่าว่าง" }); } } } var x = ErrorMessage; } } #endregion #region ReadText else if (Path.GetExtension(fileEntry.Name) == ".txt") { string line; DataTable dt = new DataTable(); string tempFilename = Guid.NewGuid().ToString() + ".txt"; //var path = Path.Combine(@"D:\Work\02-DMSC ALISS\TEMP\", tempFilename); //var ms = new MemoryStream(); //await fileEntry.Data.CopyToAsync(ms); //using (FileStream file = new FileStream(path, FileMode.Create, FileAccess.Write)) //{ // ms.WriteTo(file); //} //using (TextReader tr = File.OpenText(@"D:\Work\02-DMSC ALISS\TEMP\" + tempFilename)) using (TextReader tr = File.OpenText(path)) { while ((line = tr.ReadLine()) != null) { string[] items = line.Split('\t'); if (dt.Columns.Count == 0) { if (MappingTemplate.mp_firstlineisheader == false) { for (int i = 0; i < items.Length; i++) { dt.Columns.Add(new DataColumn("Column" + i, typeof(string))); } } else { for (int i = 0; i < items.Length; i++) { dt.Columns.Add(new DataColumn(items[i].ToString(), typeof(string))); } } } dt.Rows.Add(items); } } File.Delete(path); ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'I', lfu_Err_type = 'I', lfu_Err_no = 1, lfu_Err_Column = "Total", lfu_Err_Message = (dt.Rows.Count - 1).ToString() }); foreach (WHONetMappingListsDTO item in WHONetColumnMandatory) { var wnm_originalfield = item.wnm_originalfield; if (MappingTemplate.mp_firstlineisheader == false) { int index = 0; Int32.TryParse(item.wnm_originalfield.Replace("Column", ""), out index); item.wnm_originalfield = "Column" + (index - 1); } Boolean columnExists = dt.Columns.Contains(item.wnm_originalfield); if (columnExists == false) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'C', lfu_Err_no = 1, lfu_Err_Column = wnm_originalfield, lfu_Err_Message = "ไม่พบ Column " + wnm_originalfield }); } if (columnExists) { var chkResult = dt.Select(item.wnm_originalfield + " = ''"); if (chkResult.Length > 0) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'N', lfu_Err_no = 1, lfu_Err_Column = wnm_originalfield, lfu_Err_Message = "กรุณาตรวจสอบข้อมูล Column " + wnm_originalfield + " จะต้องไม่เท่ากับค่าว่าง" }); } } } } #endregion else { string tempFilename = Guid.NewGuid().ToString() + ".dbf"; //var path = Path.Combine(@"D:\Work\02-DMSC ALISS\TEMP\", tempFilename); //bool exists = System.IO.Directory.Exists(@"D:\Work\02-DMSC ALISS\TEMP\"); //if (!exists) // System.IO.Directory.CreateDirectory(@"D:\Work\02-DMSC ALISS\TEMP\"); //using (FileStream file = new FileStream(path, FileMode.Create)) //{ // try // { // await fileEntry.Data.CopyToAsync(file); // } // catch (Exception ex) // { // } // finally // { // file.Flush(); // } //} var options = new DbfDataReaderOptions { Encoding = Encoding.GetEncoding(874) }; using (var dbfDataReader = new DbfDataReader.DbfDataReader(path, options)) //using (var dbfDataReader = new DbfDataReader.DbfDataReader(@"D:\Work\02-DMSC ALISS\TEMP\" + tempFilename, options)) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'I', lfu_Err_type = 'I', lfu_Err_no = 1, lfu_Err_Column = "Total", lfu_Err_Message = dbfDataReader.DbfTable.Header.RecordCount.ToString() }); while (dbfDataReader.Read()) { //Validate Mandatory Field foreach (WHONetMappingListsDTO item in WHONetColumnMandatory) { var columnExists = dbfDataReader.DbfTable.Columns.FirstOrDefault(x => x.Name == item.wnm_originalfield); //var ll = dbfDataReader.DbfTable.Rea if (columnExists != null) { if (dbfDataReader[item.wnm_originalfield] == "" || dbfDataReader[item.wnm_originalfield] == null) { if (ErrorMessage.FirstOrDefault(x => x.lfu_Err_type == 'N' && x.lfu_Err_Column == item.wnm_originalfield) == null) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'N', lfu_Err_no = 1, lfu_Err_Column = item.wnm_originalfield, lfu_Err_Message = "กรุณาตรวจสอบข้อมูล Column " + item.wnm_originalfield + " จะต้องไม่เท่ากับค่าว่าง" }); var ccc = dbfDataReader[item.wnm_originalfield]; } } } else { if (ErrorMessage.FirstOrDefault(x => x.lfu_Err_type == 'C' && x.lfu_Err_Column == item.wnm_originalfield) == null) { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'E', lfu_Err_type = 'C', lfu_Err_no = 1, lfu_Err_Column = item.wnm_originalfield, lfu_Err_Message = "ไม่พบ Column " + item.wnm_originalfield }); } } } row++; } var x = ErrorMessage; //using (FileStream file = new FileStream(@"D:\Work\02-DMSC ALISS\TEMP\"+ fileEntry.Name, FileMode.Create)) //{ // try // { // await fileEntry.Data.CopyToAsync(file); // } // catch (Exception ex) // { // } // finally // { // file.Flush(); // } //} //var zipStream = new MemoryStream(); //using (var compressedFileStream = new MemoryStream()) //{ // //compressedFileStream.Seek(0, SeekOrigin.Begin); // using (var zipArchive = new ZipArchive(compressedFileStream, ZipArchiveMode.Create, false)) // { // var zipEntry = zipArchive.CreateEntry(fileEntry.Name); // using (var zipEntryStream = zipEntry.Open()) // { // try // { // await fileEntry.Data.CopyToAsync(zipEntryStream); // //fileEntry.Data.CopyTo(zipEntryStream); // } // catch (Exception ex) // { // } // finally // { // zipEntryStream.Flush(); // } // } // } // using (var fileStream = new FileStream(@"D:\Work\02-DMSC ALISS\TEMP\test.zip", FileMode.Create)) // { // var bytes = compressedFileStream.GetBuffer(); // fileStream.Write(bytes, 0, bytes.Length); // try // { // await compressedFileStream.CopyToAsync(fileStream); // } // catch (Exception ex) // { // } // finally // { // fileStream.Flush(); // } // } //} //using (var outStream = new MemoryStream()) //{ // using (var archive = new ZipArchive(outStream, ZipArchiveMode.Create, true)) // { // var fileInArchive = archive.CreateEntry(fileEntry.Name, CompressionLevel.Optimal); // using (var entryStream = fileInArchive.Open()) // await fileEntry.Data.CopyToAsync(entryStream); // } // using (var fileStream = new FileStream(@"D:\test.zip", FileMode.Create)) // { // outStream.Seek(0, SeekOrigin.Begin); // outStream.CopyTo(fileStream); // } //} } //File.Delete(path); } var chkError = ErrorMessage.FirstOrDefault(x => x.lfu_status == 'E'); if (chkError != null) { File.Delete(path); } else { ErrorMessage.Add(new LabFileUploadErrorMessageDTO { lfu_status = 'I', lfu_Err_type = 'P', lfu_Err_no = 1, lfu_Err_Column = "path", lfu_Err_Message = path }); } } catch (Exception ex) { } return(ErrorMessage); }
public MappingDataDTO Get_MappingDataActiveWithModel([FromBody] MappingDataDTO model) { var objReturn = _service.GetMappingDataActiveWithModel(model); return(objReturn); }
public MappingDataDTO Get_chkDuplicateMappingApproved([FromBody] MappingDataDTO model) { var objReturn = _service.chkDuplicateMappingApproved(model); return(objReturn); }
public MappingDataDTO Post_CopyMappingData([FromBody] MappingDataDTO model) { var objReturn = _service.CopyMappingData(model); return(objReturn); }
public MappingDataDTO SaveMappingData(MappingDataDTO model) { log.MethodStart(); var currentDateTime = DateTime.Now; MappingDataDTO objReturn = new MappingDataDTO(); using (var trans = _db.Database.BeginTransaction()) { try { var objModel = new TRMapping(); if (model.mp_status == 'N') { objModel = _mapper.Map <TRMapping>(model); objModel.mp_createdate = currentDateTime; objModel.mp_updatedate = currentDateTime; _db.TRMappings.Add(objModel); } else if (model.mp_status == 'E') { objModel = _db.TRMappings.FirstOrDefault(x => x.mp_id == model.mp_id); objModel.mp_status = model.mp_status; objModel.mp_version = model.mp_version; objModel.mp_startdate = model.mp_startdate; objModel.mp_enddate = model.mp_enddate; objModel.mp_program = model.mp_program; objModel.mp_filetype = model.mp_filetype; objModel.mp_dateformat = model.mp_dateformat; objModel.mp_AntibioticIsolateOneRec = model.mp_AntibioticIsolateOneRec; objModel.mp_firstlineisheader = model.mp_firstlineisheader; objModel.mp_updateuser = model.mp_updateuser; objModel.mp_updatedate = currentDateTime; } else if (model.mp_status == 'A') { objModel = _db.TRMappings.FirstOrDefault(x => x.mp_id == model.mp_id); objModel.mp_status = model.mp_status; objModel.mp_version = objModel.mp_version + 0.01M; objModel.mp_approveduser = model.mp_approveduser; objModel.mp_approveddate = currentDateTime; objModel.mp_updateuser = model.mp_updateuser; objModel.mp_updatedate = currentDateTime; var oldVersion = _db.TRMappings.OrderByDescending(x => x.mp_version).FirstOrDefault(x => x.mp_lab == model.mp_lab && x.mp_hos_code == model.mp_hos_code && x.mp_status == 'A' && x.mp_program == model.mp_program && x.mp_filetype == model.mp_filetype && x.mp_startdate < model.mp_startdate && x.mp_enddate == null && x.mp_flagdelete == false); if (oldVersion != null) { oldVersion.mp_enddate = model.mp_startdate.Value.AddDays(-1); } } #region Save Log Process ... _db.LogProcesss.Add(new LogProcess() { log_usr_id = (objModel.mp_updateuser ?? objModel.mp_createuser), log_mnu_id = "", log_mnu_name = "Mapping", log_tran_id = objModel.mp_id.ToString(), log_action = (objModel.mp_status == 'N' ? "New" : "Update"), log_desc = "Update Mapping ", log_createuser = "******", log_createdate = currentDateTime }); #endregion _db.SaveChanges(); trans.Commit(); objReturn = _mapper.Map <MappingDataDTO>(objModel); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objReturn); }
public MappingDataDTO CopyMappingData(MappingDataDTO objParam) { log.MethodStart(); var currentDateTime = DateTime.Now; MappingDataDTO objReturn = new MappingDataDTO(); using (var trans = _db.Database.BeginTransaction()) { #region Create Mapping... var Mapping = _db.TRMappings.FirstOrDefault(x => x.mp_id == objParam.mp_id); Mapping.mp_id = Guid.NewGuid(); Mapping.mp_mst_code = objParam.mp_mst_code; Mapping.mp_status = 'E'; Mapping.mp_version = Math.Floor(objParam.mp_version); Mapping.mp_hos_code = objParam.mp_hos_code; Mapping.mp_lab = objParam.mp_lab; Mapping.mp_startdate = objParam.mp_startdate; Mapping.mp_enddate = null; Mapping.mp_createuser = objParam.mp_createuser; Mapping.mp_createdate = currentDateTime; Mapping.mp_updateuser = objParam.mp_createuser; Mapping.mp_updatedate = currentDateTime; _db.TRMappings.Add(Mapping); #endregion #region Create WHONetMapping... var WHONetMapping = _db.TRWHONetMappings.Where(w => w.wnm_mappingid == objParam.mp_id && w.wnm_flagdelete == false); if (WHONetMapping != null) { foreach (var w in WHONetMapping) { w.wnm_id = Guid.NewGuid(); w.wnm_mappingid = Mapping.mp_id; w.wnm_status = 'N'; w.wnm_createuser = objParam.mp_createuser; w.wnm_createdate = currentDateTime; w.wnm_updateuser = objParam.mp_createuser; w.wnm_updatedate = null; } _db.TRWHONetMappings.AddRange(WHONetMapping); } #endregion #region Create SpecimenMapping... var SpecimenMapping = _db.TRSpecimenMappings.Where(s => s.spm_mappingid == objParam.mp_id && s.spm_flagdelete == false); if (SpecimenMapping != null) { foreach (var s in SpecimenMapping) { s.spm_id = Guid.NewGuid(); s.spm_mappingid = Mapping.mp_id; s.spm_status = 'N'; s.spm_createuser = objParam.mp_createuser; s.spm_createdate = currentDateTime; s.spm_updateuser = objParam.mp_createuser; s.spm_updatedate = currentDateTime; } _db.TRSpecimenMappings.AddRange(SpecimenMapping); } #endregion #region Create OrganismMapping... var OrganismMapping = _db.TROrganismMappings.Where(o => o.ogm_mappingid == objParam.mp_id && o.ogm_flagdelete == false); if (OrganismMapping != null) { foreach (var o in OrganismMapping) { o.ogm_id = Guid.NewGuid(); o.ogm_mappingid = Mapping.mp_id; o.ogm_status = 'N'; o.ogm_createuser = objParam.mp_createuser; o.ogm_createdate = currentDateTime; o.ogm_updateuser = objParam.mp_createuser; o.ogm_updatedate = currentDateTime; } _db.TROrganismMappings.AddRange(OrganismMapping); } #endregion #region Create WardTypeMapping... var WardTypeMapping = _db.TRWardTypeMappings.Where(wd => wd.wdm_mappingid == objParam.mp_id && wd.wdm_flagdelete == false); if (WardTypeMapping != null) { foreach (var wd in WardTypeMapping) { wd.wdm_id = Guid.NewGuid(); wd.wdm_mappingid = Mapping.mp_id; wd.wdm_status = 'N'; wd.wdm_createuser = objParam.mp_createuser; wd.wdm_createdate = currentDateTime; wd.wdm_updateuser = objParam.mp_createuser; wd.wdm_updatedate = currentDateTime; } _db.TRWardTypeMappings.AddRange(WardTypeMapping); } #endregion #region Save Log Process ... _db.LogProcesss.Add(new LogProcess() { log_usr_id = (Mapping.mp_updateuser ?? Mapping.mp_createuser), log_mnu_id = "", log_mnu_name = "Mapping", log_tran_id = Mapping.mp_id.ToString(), log_action = (Mapping.mp_status == 'N' ? "New" : "Update"), log_desc = "Copy Mapping ", log_createuser = "******", log_createdate = currentDateTime }); #endregion _db.SaveChanges(); trans.Commit(); objReturn = _mapper.Map <MappingDataDTO>(Mapping); } log.MethodFinish(); return(objReturn); }
public async Task <MappingDataDTO> CopyMappingDataAsync(MappingDataDTO model) { var mapping = await _apiHelper.PostDataAsync <MappingDataDTO>("mapping_api/Post_CopyMappingData", model); return(mapping); }