public void Select(ParameterDTO parameterDTO) { var rowHandle = _gridViewBinder.RowHandleFor(parameterDTO); _gridView.FocusedRowHandle = rowHandle; }
private void onParameterValueSet(ParameterDTO parameter, PropertyValueSetEventArgs <double> e) { OnEvent(() => _presenter.OnParameterValueSet(parameter, e.NewValue)); }
public async Task <List <HISUploadErrorMessageDTO> > ValidateSPFileAsync(IFileListEntry fileEntry, HISUploadDataDTO HISfileOwner) { List <HISUploadErrorMessageDTO> ErrorMessage = new List <HISUploadErrorMessageDTO>(); try { string path = ""; const bool FIRSTROW_IS_HEADER = true; 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 HISUploadErrorMessageDTO { hfu_status = 'E', hfu_Err_type = "E", hfu_Err_no = 1, hfu_Err_Column = "", hfu_Err_Message = "ไม่พบ Config PATH กรุณาติดต่อผู้ดูแลระบบ " }); return(ErrorMessage); } string str_CurrentDate = DateTime.Now.ToString("yyyyMMdd"); path = Path.Combine(path, str_CurrentDate, HISfileOwner.hfu_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(); DataSet result = new DataSet(); using (var stream = File.Open(path, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { if (FIRSTROW_IS_HEADER == true) { result = reader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration() { UseHeaderRow = true } } ); } else { result = reader.AsDataSet(); } ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'I', hfu_Err_type = "I", hfu_Err_no = 1, hfu_Err_Column = "Total", hfu_Err_Message = result.Tables[0].Rows.Count.ToString() }); } } #endregion //---------- Validate Data in File ------------- var dataTable = result.Tables[0]; const int colRefNo = 0; const int colHNNo = 1; const int colLabNo = 2; const int colSpecDate = 3; const string COL_REF_NO = "Ref No"; const string COL_HN_NO = "HN"; const string COL_LAB_NO = "Lab"; const string COL_DATE = "Date"; // Check column Exist Boolean columnExists = result.Tables[0].Columns.Contains(COL_REF_NO) && result.Tables[0].Columns.Contains(COL_HN_NO) && result.Tables[0].Columns.Contains(COL_LAB_NO) && result.Tables[0].Columns.Contains(COL_DATE); if (columnExists == false) { ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'E', hfu_Err_type = "C", hfu_Err_no = 1, hfu_Err_Column = COL_REF_NO, hfu_Err_Message = "ไม่พบ Column " + COL_REF_NO }); } for (var i = 0; i < dataTable.Rows.Count; i++) { for (var j = 0; j < dataTable.Columns.Count; j++) { //HISWithSP if (HISfileOwner.hfu_file_type == "HIS" && j == 4) { break; } var data = dataTable.Rows[i][j]; // Check column not null if (string.IsNullOrEmpty(data.ToString())) { string columnError = ""; if (j == colRefNo) { columnError = "Ref No."; } else if (j == colHNNo) { columnError = "HN No."; } else if (j == colLabNo) { columnError = "Lab No."; } else if (j == colSpecDate) { columnError = "Date"; } } // Check Date format incorrect if (j == colSpecDate) { //string dateString = data.ToString(); //DateTime dtValue; //DateTime dt; //string[] formateDate = { "dd/MM/yyyy" }; //if (DateTime.TryParse(dateString, out dtValue)) //{ // var dateonly = dtValue.Date; // if (!DateTime.TryParseExact(dateonly.ToString(), formateDate, // new CultureInfo("en-US"), // DateTimeStyles.None, out dt)) // { // //your condition fail code goes here // ErrorMessage.Add(new HISUploadErrorMessageDTO // { // hfu_status = 'E', // hfu_Err_type = "E", // hfu_Err_no = 1, // hfu_Err_Column = "", // hfu_Err_Message = "Column Date ต้องอยู่ในรูปแบบ " + formateDate[0] // }); ; // return ErrorMessage; // } //} //else //{ // ErrorMessage.Add(new HISUploadErrorMessageDTO // { // hfu_status = 'E', // hfu_Err_type = "E", // hfu_Err_no = 1, // hfu_Err_Column = "", // hfu_Err_Message = "Column Date ต้องอยู่ในรูปแบบ " + formateDate[0] // }); ; // return ErrorMessage; //} } } } var chkError = ErrorMessage.FirstOrDefault(x => x.hfu_status == 'E'); if (chkError != null) { File.Delete(path); } else { ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'I', hfu_Err_type = "P", hfu_Err_no = 1, hfu_Err_Column = "path", hfu_Err_Message = path }); } } } catch (Exception ex) { //create log } return(ErrorMessage); }
protected virtual SuperToolTip GetToolTipFor(ParameterDTO parameterDTO, GridHitInfo hi) { return(_toolTipCreator.ToolTipFor(parameterDTO)); }
private void onSetDimension(ParameterDTO parameter, IDimension newValue) { _presenter.SetDimensionFor(parameter, newValue); }
private void setParameterValue(ParameterDTO parameterDTO, double newDisplayValue) { OnEvent(() => _presenter.SetParameterValue(parameterDTO, newDisplayValue)); }
private void onIsPersistableSet(ParameterDTO parameterDTO, bool newValue) { _presenter.SetIsPersistable(parameterDTO, newValue); }
public void SetDescription(ParameterDTO parameterDTO, string newDescription) { AddCommand(_parameterTask.SetDescriptionForParameter(parameterDTO.Parameter, newDescription, BuildingBlock).Run(_interactionTaskContext.Context)); }
public void SetName(ParameterDTO parameterDTO, string newName) { AddCommand(_parameterTask.SetNameForParameter(parameterDTO.Parameter, newName, BuildingBlock).Run(_interactionTaskContext.Context)); }
private void updateValueOrigin(ParameterDTO parameterDTO, ValueOrigin newValueOrigin) { OnEvent(() => _presenter.SetParameterValueOrigin(parameterDTO, newValueOrigin)); }
public async Task <List <HISUploadErrorMessageDTO> > ValidateAndUploadFileSPFileAsync(IFileListEntry fileEntry , HISUploadDataDTO HISfileOwner , HISFileTemplateDTO HISTemplateActive) { List <HISUploadErrorMessageDTO> ErrorMessage = new List <HISUploadErrorMessageDTO>(); try { string path = ""; List <ParameterDTO> objParamList = new List <ParameterDTO>(); var searchModel = new ParameterDTO() { prm_code_major = "UPLOAD_PATH" }; const bool FIRSTROW_IS_HEADER = true; const int colRefNo = 0; const int colHNNo = 1; const int colLabNo = 2; const int colSpecDate = 3; var formateDate = HISTemplateActive.hft_date_format; var COL_REF_NO = HISTemplateActive.hft_field1; // "Ref No"; var COL_HN_NO = HISTemplateActive.hft_field2; //"HN"; var COL_LAB_NO = HISTemplateActive.hft_field3; // "Lab"; var COL_DATE = HISTemplateActive.hft_field4; //"Date"; 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 HISUploadErrorMessageDTO { hfu_status = 'E', hfu_Err_type = "E", hfu_Err_no = 1, hfu_Err_Column = "", hfu_Err_Message = "ไม่พบ Config PATH กรุณาติดต่อผู้ดูแลระบบ " }); return(ErrorMessage); } string str_CurrentDate = DateTime.Now.ToString("yyyyMMdd"); path = Path.Combine(path, str_CurrentDate, HISfileOwner.hfu_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(); } } #region ReadExcel if (Path.GetExtension(fileEntry.Name) == ".xls" || Path.GetExtension(fileEntry.Name) == ".xlsx") { ExcelDataSetConfiguration option = new ExcelDataSetConfiguration(); DataSet result = new DataSet(); using (var stream = File.Open(path, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { if (FIRSTROW_IS_HEADER == true) { result = reader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration() { UseHeaderRow = true } } ); } else { result = reader.AsDataSet(); } while (reader.Read()) { var strFileFormatDate = reader.GetNumberFormatString(3); if (strFileFormatDate.ToLower() != formateDate.ToLower()) { ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'E', hfu_Err_type = "E", hfu_Err_no = 1, hfu_Err_Column = "", hfu_Err_Message = "Column Date ต้องอยู่ในรูปแบบ " + formateDate });; return(ErrorMessage); } } ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'I', hfu_Err_type = "I", hfu_Err_no = 1, hfu_Err_Column = "Total", hfu_Err_Message = result.Tables[0].Rows.Count.ToString() }); } } #endregion //---------- Validate Data in File ------------- var dataTable = result.Tables[0]; // Check column Exist Boolean columnExists = result.Tables[0].Columns.Contains(COL_REF_NO) && result.Tables[0].Columns.Contains(COL_HN_NO) && result.Tables[0].Columns.Contains(COL_LAB_NO) && result.Tables[0].Columns.Contains(COL_DATE); if (columnExists == false) { ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'E', hfu_Err_type = "C", hfu_Err_no = 1, hfu_Err_Column = COL_REF_NO, hfu_Err_Message = "ไม่พบ Column " + COL_REF_NO }); } for (var i = 0; i < dataTable.Rows.Count; i++) { for (var j = 0; j < 4; j++) { var data = dataTable.Rows[i][j]; // Check column not null if (string.IsNullOrEmpty(data.ToString())) { string columnError = ""; if (j == colRefNo) { columnError = COL_REF_NO; } else if (j == colHNNo) { columnError = COL_HN_NO; } else if (j == colLabNo) { columnError = COL_LAB_NO; } else if (j == colSpecDate) { columnError = COL_DATE; } var chkErrExist = ErrorMessage.FirstOrDefault(e => e.hfu_status == 'W' && e.hfu_Err_no == i + 2); if (chkErrExist == null) { ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'W', hfu_Err_type = columnError, hfu_Err_no = i + 2, hfu_Err_Column = "Required", hfu_Err_Message = "Field is required" }); } else { //ErrorMessage.Where(e => e.hfu_status == 'W' && e.hfu_Err_no == i + 1). // Select(n => { n.hfu_Err_Message = ""; return n; }).ToList(); chkErrExist.hfu_Err_type += ',' + columnError; } } // Check Date format incorrect //if (j == colSpecDate) //{ // string dateString = data.ToString(); // DateTime dt; // //string[] formateDate = { HISTemplateActive.hft_date_format }; // dd/MM/yyyy // // en-GB , en-US // //var formateDate = HISTemplateActive.hft_date_format; // try // { // dt = DateTime.Parse(dateString,new CultureInfo("en-US")); // } // catch (Exception ex) // { // ErrorMessage.Add(new HISUploadErrorMessageDTO // { // hfu_status = 'E', // hfu_Err_type = "E", // hfu_Err_no = 1, // hfu_Err_Column = "", // hfu_Err_Message = "Column Date ต้องอยู่ในรูปแบบ " + formateDate // }); ; // return ErrorMessage; // } //} } } var chkError = ErrorMessage.FirstOrDefault(x => x.hfu_status == 'E'); if (chkError != null) { File.Delete(path); } else { ErrorMessage.Add(new HISUploadErrorMessageDTO { hfu_status = 'I', hfu_Err_type = "P", hfu_Err_no = 1, hfu_Err_Column = "path", hfu_Err_Message = path }); } } } catch (Exception ex) { //create log } return(ErrorMessage); }
protected virtual bool IsValueOriginEditable(ParameterDTO parameterDTO) { return(_presenter.CanEditValueOrigin(parameterDTO)); }
private void updateListOfValues(ParameterDTO parameterDTO, IParameter parameter) => _parameterListOfValuesRetriever.UpdateLisOfValues(parameterDTO.ListOfValues, parameter);
public async Task <IQueryable <ProductDTO> > SortProducsByParameters(int TypeId, bool StateOrder = true) { string param = "Стандарт"; int paramId = 2; // тип штока int paramDiameterId = 4; string diameter = "60"; var products = await _context.ProductParameters .Include(p => p.Product) .Where(p => p.Product.ProductTypeId == TypeId && p.Value == param && p.ParameterId == paramId) .Select(p => p.Product) .Include(p => p.ProductType) .Include(p => p.ProductParameters) .ToListAsync(); if (StateOrder == true) { products = products.OrderBy(v => v.ProductParameters.Where(g => g.ParameterId == paramDiameterId) .OrderBy(t => Convert.ToInt32(t.Product.Amount)).FirstOrDefault().Product.Amount).ToList(); } else { products = products.OrderByDescending(v => v.ProductParameters.Where(g => g.ParameterId == paramDiameterId) .OrderByDescending(t => t.Product.Amount).FirstOrDefault().Product.Amount).ToList(); } var items = new List <ProductDTO>(); foreach (var product in products) { var foundParam = product.ProductParameters.Where(pp => pp.ParameterId == paramDiameterId && pp.Value == diameter) .FirstOrDefault(); if (foundParam == null) { continue; } var productDTO = new ProductDTO() { ProductId = product.Id, Number = product.Number, Manufacturer = product.Manufacturer, Amount = product.Amount, PrimeCostEUR = product.PrimeCostEUR, ProductTypeId = product.ProductTypeId, NameType = product.ProductType.NameType }; foreach (var typeParam in product.ProductParameters) { var paramDTO = new ParameterDTO(); var value = product.ProductParameters.FirstOrDefault(t => t.ParameterId == typeParam.Id); if (value != null) { paramDTO.Id = value.Id; paramDTO.Value = value.Value; } paramDTO.Id = typeParam.Id; paramDTO.Name = typeParam.Product.ProductType.NameType; paramDTO.ParameterId = typeParam.ParameterId; paramDTO.Value = typeParam.Value; productDTO.Parameters.Add(paramDTO); } items.Add(productDTO); } return(items.AsQueryable()); }
private void onIsFavoriteSet(ParameterDTO parameterDTO, bool newValue) { _presenter.SetIsFavorite(parameterDTO, newValue); }
protected override void Context() { base.Context(); _parameter = new PKSimParameter(); _parameterDTO = new ParameterDTO(_parameter); }
private void configureRepository(BaseEdit activeEditor, ParameterDTO parameter) { _unitControl.UpdateUnitsFor(activeEditor, parameter); }
private void setParameterUnit(ParameterDTO parameterDTO, Unit unit) { OnEvent(() => _presenter.SetParameterUnit(parameterDTO, unit)); }