private List <ExportFieldSetting> GetExportFieldSettingsFromScreen() { var settings = new List <ExportFieldSetting>(); foreach (var row in grid.Rows) { var setting = new ExportFieldSetting { CompanyId = CompanyId, ColumnName = row.Cells["celColumnName"].Value.ToString(), Caption = row.Cells["celCaption"].Value.ToString(), ColumnOrder = row.Index + 1, AllowExport = int.Parse(row.Cells["celAllowExport"].Value.ToString()), ExportFileType = int.Parse(row.Cells["celExportFileType"].Value.ToString()), UpdateBy = Login.UserId, }; if (int.Parse(row.Cells["celDataType"].Value.ToString()) == 1) { setting.DataFormat = Convert.ToInt32(cmbDateFormat.SelectedItem.SubItems[1].Value); } settings.Add(setting); } settings.Add(new ExportFieldSetting { CompanyId = CompanyId, ColumnName = "RequireHeader", Caption = cbxRequireHeader.Text, ColumnOrder = 0, AllowExport = cbxRequireHeader.Checked ? 1 : 0, ExportFileType = ExportFileType, UpdateBy = Login.UserId, }); return(settings); }
public Task <ExportFieldSetting> SaveAsync(ExportFieldSetting setting, CancellationToken token = default(CancellationToken)) { #region merge query var query = @" MERGE INTO ExportFieldSetting target USING ( SELECT @CompanyId CompanyId , @ExportFileType ExportFileType , @ColumnName ColumnName ) source ON ( target.CompanyId = source.CompanyId AND target.ExportFileType = source.ExportFileType AND target.ColumnName = source.ColumnName ) WHEN MATCHED THEN UPDATE SET ColumnOrder = @ColumnOrder , AllowExport = @AllowExport , DataFormat = @DataFormat , UpdateBy = @UpdateBy , UpdateAt = GETDATE() WHEN NOT MATCHED THEN INSERT ( CompanyId , ExportFileType , ColumnName , ColumnOrder , AllowExport , CreateBy , CreateAt , UpdateBy , UpdateAt , DataFormat ) VALUES ( @CompanyId , @ExportFileType , @ColumnName , @ColumnOrder , @AllowExport , @UpdateBy , GETDATE() , @UpdateBy , GETDATE() , @DataFormat ) OUTPUT inserted.*;"; #endregion return(dbHelper.ExecuteAsync <ExportFieldSetting>(query, setting, token)); }
public async Task <IEnumerable <ExportFieldSetting> > GetAsync(ExportFieldSetting setting, CancellationToken token = default(CancellationToken)) { var items = (await exportFieldSettingQueryProcessor.GetAsync(setting, token)).ToList(); var app = await applicationControlQueryProcessor.GetAsync(setting.CompanyId, token); foreach (var item in items) { if (app.UseForeignCurrency == 0 && item.ColumnName == "CurrencyCode") { item.AllowExport = 0; } if (app.UseReceiptSection == 0 && (item.ColumnName == "SectionCode" || item.ColumnName == "SectionName")) { item.AllowExport = 0; } } return(items); }
public Task <IEnumerable <ExportFieldSetting> > GetAsync(ExportFieldSetting setting, CancellationToken token = default(CancellationToken)) { var query = @" SELECT es.CompanyId , es.ColumnName , esb.Caption , es.ColumnOrder [ColumnOrder] , es.AllowExport , es.ExportFileType , esb.DataType , es.DataFormat FROM ExportFieldSetting es INNER JOIN ExportFieldSettingBase esb ON es.CompanyId = @CompanyId AND es.ExportFileType = @ExportFileType AND es.ExportFileType = esb.ExportFileType AND es.ColumnName = esb.ColumnName UNION ALL SELECT @CompanyId [CompanyId] , esb.ColumnName , esb.Caption , esb.ColumnOrder [ColumnOrder] , esb.AllowExport , esb.ExportFileType , esb.DataType , 0 AS DataFormat FROM ExportFieldSettingBase esb WHERE esb.ExportFileType = @ExportFileType AND NOT EXISTS ( SELECT 1 FROM ExportFieldSetting es WHERE es.CompanyId = @CompanyId AND es.ExportFileType = @ExportFileType AND es.ColumnName = esb.ColumnName ) ORDER BY ColumnOrder; "; return(dbHelper.GetItemsAsync <ExportFieldSetting>(query, setting, token)); }
public async Task <ActionResult <IEnumerable <ExportFieldSetting> > > GetItems(ExportFieldSetting setting, CancellationToken token) => (await exportFieldSettingProcessor.GetAsync(setting, token)).ToArray();