private async Task <DbData> ReadDataImplAsync(DbCommand command) { try { DbData result = new DbData(); DbDataReader reader = await command.ExecuteReaderAsync(CommandBehavior.SequentialAccess); while (await reader.ReadAsync()) { IList <DbValue> dbRow = new List <DbValue>(); for (int columnNumber = 0; columnNumber < reader.FieldCount; columnNumber++) { object value = reader.GetValue(columnNumber); string column = reader.GetName(columnNumber); dbRow.Add(new DbValue(column, value)); } result.Rows.Add(dbRow); } return(result); } catch (Exception e) { _logger.LogError($"An error occured during read data impl async, exception: {e}"); //throw; return(null); } }
public object InsertDbData(string url, DbData data) { using (var client = new JsonServiceClient(url)) { return(client.Send <object>(new InsertDbDataRequest(data))); } }
public static Gdk.Pixbuf GetThumb(VolumeItem item, VolumeDatabase db, int size) { string dbDataPath = PathUtil.GetDbDataPath(db); string volumeDataPath = DbData.GetVolumeDataPath(dbDataPath, item.VolumeID); string thumbsPath = DbData.GetVolumeDataThumbsPath(volumeDataPath); string thumbName = System.IO.Path.Combine( thumbsPath, string.Format("{0}.png", item.ItemID)); if (File.Exists(thumbName)) { if (size > 0) { return(new Gdk.Pixbuf(thumbName, size, size, false)); } else { return(new Gdk.Pixbuf(thumbName)); } } else { return(null); } }
public void TestGenerate() { string reportFile = string.Format(ReportFileTemplate, Guid.NewGuid()); if (File.Exists(reportFile)) { File.Delete(reportFile); } ILoggerFactory loggerFactory = new LoggerFactory(); ILogger <ExcelReportGenerator> logger = loggerFactory.CreateLogger <ExcelReportGenerator>(); IReportGenerator generator = new ExcelReportGenerator(logger, TestExcelTemplate, reportFile); // Worksheet - 1, start row - 2, start column - 3 object[] parameters = { 1, 2, 3 }; DbData data = new DbData(); data.Rows.Add(GetDataRow("Иван", "Иванов", 20, "м.", "Екатеринбург", "Свердловская область")); data.Rows.Add(GetDataRow("Алексей", "Козлов", 25, "м.", "Нижний Тагил", "Свердловская область")); data.Rows.Add(GetDataRow("Татьяно", "Трололоева", 29, "ж.", "Челябинск", "Челябинская область")); data.Rows.Add(GetDataRow("Юра", "Первоуральский", 32, "м.", "Курган", "Курганская область")); data.Rows.Add(GetDataRow("Елена", "Головач", 22, "ж.", "Пермь", "Пермская область")); bool result = generator.Generate(data, parameters); Assert.True(result); Assert.True(File.Exists(reportFile)); // todo: umv: add read excel doc and check if (File.Exists(reportFile)) { File.Delete(reportFile); } }
public void Open(string aConnectionString, ServerType serverType) { dbCache.ConnectionString = aConnectionString; dbCache.ServerType = serverType; switch (serverType) { case ServerType.Firebird: connection = new FbConnection { ConnectionString = aConnectionString }; break; case ServerType.MsSql: connection = new SqlConnection { ConnectionString = aConnectionString }; break; } connection.Open(); if (serverType == ServerType.Firebird) { using (var transaction = connection.BeginTransaction()) { DbData.GetFieldValue(connection, transaction, "select rdb$set_context('USER_SESSION','RPL_SERVICE','1') from rdb$database;"); transaction.Commit(); } } var t = new Thread(LoadData); t.Start(); }
private void BuildStandardData(DbTestData testData, out string inputData, out DbData outputData, out DbQueryData queryData) { inputData = testData.Input; outputData = null; queryData = null; string stdOperCmd = testData.Operation; string stdQueryCmd = testData.Query; BaseDbOperator stdOperator = CreateJudgeEnv(inputData); try { DbDataReader reader = stdOperator.ExecuteReader(stdOperCmd ?? stdQueryCmd); if (stdOperCmd != null) { outputData = stdOperator.ReadDbData(); } if (stdQueryCmd != null) { queryData = BaseDbOperator.ReadQueryData(reader); } } catch (Exception ex) { throw new JudgeException("Build Db test data failed!" + ex); } finally { ClearJudgeEnv(stdOperator); } }
protected string CreateThumbsDir(string dbDataPath, long volumeID) { string volumeDataPath = DbData.CreateVolumeDataPath(dbDataPath, volumeID); volumeDataPaths.Add(volumeDataPath); return(DbData.CreateVolumeDataThumbsPath(volumeDataPath)); }
public override bool UpdateData(DataAction dataAction) { if (!_dataChanged) { return(true); } bool isError = false; try { DbData.BeginMultiTrans(); int index = DsData.Tables[0].Rows.IndexOf(_drCurrentMaster); if (!_customize.BeforeUpdate(index, DsData)) { DbData.RollbackMultiTrans(); return(false); } bool isNew = _drCurrentMaster.RowState == DataRowState.Added; if (Update(_drCurrentMaster)) { isError = isError || !TransferData(dataAction, index); _customize.AfterUpdate(); } else { isError = true; } // if (!isError) { DbData.EndMultiTrans(); } else { DbData.RollbackMultiTrans(); } if (isNew && !isError) { _autoIncreValues.UpdateNewStruct(_drCurrentMaster); } if (!isError) { base.InsertHistory(dataAction, DsData); DsData.AcceptChanges(); _dsDataTmp = DsData.Copy(); } DataChanged = false; } finally { if (DbData.Connection.State != ConnectionState.Closed) { DbData.Connection.Close(); } } return(!isError); }
public ActionResult AddEditAddressBook(AddressBookModel model) { if (ModelState.IsValid) //checking model is valid or not { DbData objDB = new DbData(); //calling class DBdata string result = string.Empty; if (model.ID.HasValue) { result = objDB.UpdateData(model); // passing Value to DBClass from model } else { result = objDB.InsertData(model); } ViewData["result"] = result; ModelState.Clear(); //clearing model return(RedirectToActionPermanent("ManageAddressBook")); // return View(); } else { // ModelState.AddModelError("", "Error in saving data"); return(View(new AddressBookModel())); } }
//GET : EditAddressBook public ActionResult EditAddressBook(int Id) { DbData objDB = new DbData(); //calling class DBdata var result = objDB.GetAddressBookDataByID(Id); // get values for editing return(View("AddEditAddressBook", result)); }
/// <summary> /// Handles the SelectedIndexChanged event of the Filter3 control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> private void Filter3_SelectedIndexChanged(object sender, EventArgs e) { try { VisualComboBox filter = sender as VisualComboBox; F3 = filter?.SelectedItem.ToString(); if (filter != null) { C3 = (Field)Enum.Parse(typeof(Field), filter.Tag.ToString()); } DataTable tbl = TableFilter(Table, C1, F1); DataTable tbl2 = TableFilter(tbl, C2, F2); DataTable tbl3 = TableFilter(tbl2, C3, F3); BindingSource.DataSource = tbl3; label6.Text = DbData.GetTotal(Source, tbl3).ToString("c"); label12.Text = tbl3.Rows.Count.ToString(); if (Filter4.Tag != null) { PopulateFilterItems(Filter4.Tag.ToString(), tbl3, Filter4, label4); } } catch (Exception ex) { new Error(ex).ShowDialog(); } }
public void ChangeCode(DataRow OldRow, DataRow NewRow) { string pk = _drTable["pk"].ToString(); string OldCode = OldRow[pk].ToString(); string NewCode = NewRow[pk].ToString(); DbData.BeginMultiTrans(); try { string sql = "select * from systable where systableid in(select systableid from sysfield where RootTable='" + _drTable["TableName"].ToString() + "' group by systableid) and Collecttype<>-1"; DataTable dsTable = _dbStruct.GetDataTable(sql); sql = "select * from sysfield where RootTable='" + _drTable["TableName"].ToString() + "'"; DataTable dsField = _dbStruct.GetDataTable(sql); foreach (DataRow dr in dsTable.Rows) { DataRow[] lstField = dsField.Select("sysTableID=" + dr["sysTableID"].ToString()); foreach (DataRow drField in lstField) { sql = "Update " + dr["TableName"] + " set " + drField["FieldName"].ToString() + " ='" + NewCode + "' where " + drField["FieldName"].ToString() + " ='" + OldCode + "'"; DbData.UpdateByNonQuery(sql); } } DbData.EndMultiTrans(); } catch (Exception ex) { DbData.RollbackMultiTrans(); } }
public async Task <DbData> ExtractAsync(string viewName, ViewParameters parameters) { using (DbConnection connection = DbConnectionFactory.Create(_dbEngine, _connectionString)) { try { _logger.LogDebug("Extract db data async via \"View\" started"); DbData result = null; await connection.OpenAsync().ConfigureAwait(false); string cmdText = SqlStatmentsGenerator.CreateSelectStatement(SqlStatmentsGenerator.SelectAllColumns, viewName, parameters); using (IDbCommand command = DbCommandFactory.Create(_dbEngine, connection, cmdText)) { command.CommandType = CommandType.Text; result = await ReadDataImplAsync((DbCommand)command); } connection.Close(); _logger.LogDebug("Extract db data async via \"View\" completed"); return(result); } catch (Exception e) { _logger.LogError($"An error occured during async data extraction via \"View\", exception: {e}"); return(null); } } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Home/Error"); // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllerRoute( name: "default", pattern: "{controller=Home}/{action=Index}/{id?}"); }); DbData.DbDataDoldur(app); }
public async Task AddOrganization(Organization organization) { var orgEnt = _mapper.Map(organization).ToOutFormat(); DbData.Add(orgEnt); await _context.SaveChangesAsync(); }
public void TestExtractFromViewWithParams(string name, bool?sex, int expectedNumberOfRows) { SetUpTestData(); // testing is here ViewParameters parameters = new ViewParameters(); if (!string.IsNullOrEmpty(name)) { parameters.WhereParameters.Add(new DbQueryParameter(null, "FirstName", "=", name)); } if (sex.HasValue) { IList <JoinCondition> sexJoin = parameters.WhereParameters.Count > 0 ? new List <JoinCondition>() { JoinCondition.And } : null; parameters.WhereParameters.Add(new DbQueryParameter(sexJoin, "Sex", "=", sex.Value ? "1" : "0")); } IDbExtractor extractor = new SimpleDbExtractor(_loggerFactory, DbEngine.SqlServer, GlobalTestsParams.TestSqlServerHost, GlobalTestsParams.TestSqlServerDatabasePattern); Task <DbData> result = extractor.ExtractAsync(TestView, parameters); result.Wait(); DbData rows = result.Result; Assert.Equal(expectedNumberOfRows, rows.Rows.Count); TearDownTestData(); }
private void Filter4_SelectedIndexChanged(object sender, EventArgs e) { try { VisualComboBox filter = sender as VisualComboBox; if (filter.SelectedItem != null) { F4 = filter.SelectedItem.ToString(); C4 = (Field)Enum.Parse(typeof(Field), filter.Tag.ToString()); } DataTable table = Table.AsEnumerable().Where(p => p.Field <string>(C1.ToString()).Equals(F1)).Where(p => p.Field <string>(C2.ToString()).Equals(F2)).Where(p => p.Field <string>(C3.ToString()).Equals(F3)).Where(p => p.Field <string>(C4.ToString()).Equals(F4)).Select(p => p).CopyToDataTable(); BindingSource.DataSource = table; if (table.Columns.Contains("Amount")) { label6.Text = DbData.GetTotal(Source, table).ToString("c"); } label12.Text = table.Rows.Count.ToString(); } catch (Exception ex) { new Error(ex).ShowDialog(); } }
private void Filter3_SelectedIndexChanged(object sender, EventArgs e) { try { VisualComboBox filter = sender as VisualComboBox; if (filter?.SelectedItem != null) { F3 = filter.SelectedItem.ToString(); C3 = (Field)Enum.Parse(typeof(Field), filter.Tag.ToString()); } DataTable table = Table.AsEnumerable().Where(p => p.Field <string>(C1.ToString()).Equals(F1)).Where(p => p.Field <string>(C2.ToString()).Equals(F2)).Where(p => p.Field <string>(C3.ToString()).Equals(F3)).Select(p => p).CopyToDataTable(); BindingSource.DataSource = table; label6.Text = DbData.GetTotal(Source, table).ToString("c") ?? "0"; label12.Text = table.Rows.Count.ToString() ?? "0"; if (Filter4.Tag != null) { PopulateFilterItems(Filter4.Tag.ToString(), table, Filter4, label4); } } catch (Exception ex) { new Error(ex).ShowDialog(); } }
public void TestGenerate() { string reportFile = string.Format(ReportFileTemplate, Guid.NewGuid()); if (File.Exists(reportFile)) { File.Delete(reportFile); } ILoggerFactory loggerFactory = new LoggerFactory(); ILogger <ExcelReportGenerator> logger = loggerFactory.CreateLogger <ExcelReportGenerator>(); IReportGenerator generator = new ExcelReportGenerator(logger, TestExcelTemplate, reportFile); // Worksheet - 1, start row - 2, start column - 3 object[] parameters = { 1, 2, 3 }; DbData data = TestData.GetSampleData(); Task <int> generatorTask = generator.GenerateAsync(data, parameters); generatorTask.Wait(); int result = generatorTask.Result; Assert.True(result > 0); Assert.True(File.Exists(reportFile)); // todo: umv: add read excel doc and check if (File.Exists(reportFile)) { File.Delete(reportFile); } }
/// <summary> /// Load a DragonBones instance from the JSON file at the given path. /// </summary> /// <param name="path">Relative or absolute path to the json DragonBones file.</param> /// <param name="texturer">The supplier that has all textures for the DragonBones file at the given path.</param> /// <param name="graphics">A GraphicsDevice used to initialize meshes for FFD if necessary.</param> /// <returns></returns> public static DragonBones FromJson(string path, ITextureSupplier texturer, GraphicsDevice graphics) { if (!File.Exists(path)) { throw new FileNotFoundException("Could not resolve the given path", path); } return(new DragonBones(texturer, graphics, DbData.FromJson(path))); }
public InitValues ClasificacionValues() { if (this.context.Clasificacion.Count() == 0) { this.context.Clasificacion.AddRange(DbData.getClasificacionData()); this.context.SaveChanges(); } return(this); }
public bool Generate(DbData data, object[] parameters) { const int parametersNumber = 3; if (parameters.Length < parametersNumber) { _logger.LogError($"Expected at least {parametersNumber} parameters (workSheetNumber, startRow and startColumn)"); throw new InvalidDataException("Invalid parameters array length"); } if (data == null) { _logger.LogWarning("Db data is NULL (data obtained from database)"); return(false); } try { int workSheetNumber = Convert.ToInt32(parameters[WorkSheetNumberIndex]); int startRow = Convert.ToInt32(parameters[StartRowIndex]); int startColumn = Convert.ToInt32(parameters[StartColumnIndex]); _logger.LogDebug($"Write DB data to excel file with template: {_template} at worksheet: {workSheetNumber}, start row: {startRow}, start column: {startColumn}"); ExcelWorksheet workSheet = _package.Workbook.Worksheets[workSheetNumber]; int row = startRow; int column = startColumn; foreach (IList <DbValue> dataRow in data.Rows) { // proccess each row WhiteExcelRow(workSheet, row, column, dataRow); row++; } // save excel file FileInfo fileInfo = new FileInfo(_reportFile); if (fileInfo.Exists) { fileInfo.Delete(); } if (Directory.Exists(fileInfo.DirectoryName) == false) { Directory.CreateDirectory(fileInfo.DirectoryName); } _package.SaveAs(fileInfo); _logger.LogDebug("Write DB data to excel file completed"); return(true); } catch (Exception e) { _logger.LogError($"An error occurred during writing report data to ms excel file, exception is: {e}"); return(false); } }
public override void TinhGiatri() { string sql; //Lấy Tổng giá trị cần phân bổ object[] os = DbData.GetValueByStore("sopsKetChuyen", new string[] { "@tk", "@ngayct", "@ngayct1", "@dk", "@psno" }, new object[] { tk, _Tungay, _Denngay, null, null }, new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.DateTime, SqlDbType.DateTime, SqlDbType.NVarChar, SqlDbType.Float }, new ParameterDirection[] { ParameterDirection.Input, ParameterDirection.Input, ParameterDirection.Input, ParameterDirection.Input, ParameterDirection.Output }); if (os == null || os.Length == 0) { return; } Tongtien = Double.Parse(os[0].ToString()); //Lấy hệ số phân bổ sql = "select " + dryt["TruongSP"].ToString() + " as Masp," + dryt["Heso"].ToString() + " as Heso from " + dryt["BangDM"].ToString(); //sql += " where ngayct between cast('" + _Tungay.ToShortDateString() + "'as datetime) and cast('" + _Denngay.ToShortDateString() + "'as datetime) "; sql += " where " + dryt["TruongSP"].ToString() + " in (select mavt from dmvt where nhomgt ='" + this.Manhom + "') and Thang = " + _Tungay.Month.ToString() + " and Nam = " + _Tungay.Year.ToString(); DataTable tbHeso = DbData.GetDataTable(sql); tbHeso.PrimaryKey = new DataColumn[] { tbHeso.Columns["MaSP"] }; //Lấy tổng hệ số phân bổ double TongHeso = 0; DataColumn col = new DataColumn("Heso", typeof(double)); col.DefaultValue = 0; dtkq.Columns.Add(col); foreach (DataRow dr in dtkq.Rows) { string Masp = dr["MaSP"].ToString(); DataRow drHeso; if (!tbHeso.Rows.Contains(Masp)) { continue; } drHeso = tbHeso.Rows.Find(Masp); //double heso=double.Parse(dr["soluong"].ToString()) * double.Parse(drHeso["Heso"].ToString()); double heso = double.Parse(drHeso["Heso"].ToString()); dr["Heso"] = heso; TongHeso += heso; } //Phân bổ if (TongHeso == 0) { return; } foreach (DataRow dr in dtkq.Rows) { dr[Name] = double.Parse(dr["Heso"].ToString()) * Tongtien / TongHeso; } dtkq.Columns.Remove("Heso"); dtkq.Columns.Remove("Soluong"); }
public override void TinhGiatri() { // string sql; dtkq = DbData.GetDataSetByStore("gtGiandon", new string[] { "@tungay", "@denngay", "@tk", "@manhom" }, new object [] { _Tungay, _Denngay, tk, Manhom }); DataColumn col = dtkq.Columns[1]; col.ColumnName = dryt["MaYT"].ToString(); col.DefaultValue = 0.0; col.Caption = dryt["TenYT"].ToString(); }
public void GetData(CDTData ParentData) { ConditionForPackage(); string extrasql = string.Empty; if (_drTable.Table.Columns.Contains("ExtraSql")) { if (_drTable["ExtraSql"] != null) { extrasql = _drTable["Extrasql"].ToString(); } } string queryData = "select * from " + _drTable["TableName"].ToString(); if (_condition != string.Empty && !(_condition.Contains("@"))) { queryData += " where " + _condition; if (extrasql != string.Empty) { queryData += " and (" + extrasql + ")"; } } else if (extrasql != string.Empty) { queryData += " where " + extrasql; } string lkCondition = GenConditionForLookup(ParentData); if (lkCondition != string.Empty) { if ((_condition == string.Empty && extrasql == string.Empty) || (_condition != string.Empty && _condition.Contains("@"))) { queryData += " where " + lkCondition; } else { queryData += " and ( " + lkCondition + ")"; } } if (_drTable["SortOrder"].ToString() != string.Empty) { queryData += " order by " + DrTable["SortOrder"].ToString(); } DsData = DbData.GetDataSet(queryData); if (DsData != null) { DsData.Tables[0].TableName = _drTable["TableName"].ToString(); _dsDataTmp = DsData.Copy(); } }
private void FormReport() { string query = _drTable["Query"].ToString().ToUpper(); query = trimSpace(query); query = query.Replace("+ @@PS", "+ '" + _psString.Replace("'", "''") + "' "); query = query.Replace("+@@PS", "+ '" + _psString.Replace("'", "''") + "' "); query = query.Replace("'@@PS'", " '" + _psString.Replace("'", "''") + "' "); query = query.Replace("@@PS", _psString); query = UpdateSpecialCondition(query); query = query.Replace("@@SYSREPORTID", _drTable["sysReportID"].ToString()); if (_dtData == null) { _dtData = DbData.GetDataTable(query); } if (_dtData == null) { return; } int n = _dtData.Columns.Count; for (int i = 0; i < _dtData.Rows.Count; i++) { if (_dtData.Rows[i]["CachTinh"].ToString() != string.Empty && _dtData.Rows[i]["CachTinh"].ToString() != "0") { FColumn x = new FColumn(i, _dtData.Rows[i]["CachTinh"].ToString(), false); listFColumn.Add(x); } else { continue; } } for (int i = _dtData.Columns.Count - 1; i >= 0; i--) { if (_dtData.Columns[i].DataType == typeof(System.Decimal)) { foreach (FColumn fc in listFColumn) { if (fc.IsEvaluated == false) { _dtData.Rows[fc.Rowstt][i] = Evaluated(fc, i, _dtData); } } } else { break; } } }
private void DefaultReport() { string query = _drTable["Query"].ToString().ToUpper(); query = trimSpace(query); query = query.Replace("+ @@PS", "+ '" + _psString.Replace("'", "''") + "' "); query = query.Replace("+@@PS", "+ '" + _psString.Replace("'", "''") + "' "); query = query.Replace("'@@PS'", " '" + _psString.Replace("'", "''") + "' "); query = query.Replace("@@PS", _psString); query = UpdateSpecialCondition(query); _dtData = DbData.GetDataTable(query); }
public static DbData GetSampleData() { DbData data = new DbData(); data.Rows.Add(GetDataRow("Иван", "Иванов", 20, "м.", "Екатеринбург", "Свердловская область")); data.Rows.Add(GetDataRow("Алексей", "Козлов", 25, "м.", "Нижний Тагил", "Свердловская область")); data.Rows.Add(GetDataRow("Татьяно", "Трололоева", 29, "ж.", "Челябинск", "Челябинская область")); data.Rows.Add(GetDataRow("Юра", "Первоуральский", 32, "м.", "Курган", "Курганская область")); data.Rows.Add(GetDataRow("Елена", "Головач", 22, "ж.", "Пермь", "Пермская область")); return(data); }
string[] IDataBuilder.GetUniqueValues(DataTable table, string col) { try { return(DbData.GetUniqueValues(table, col)); } catch (Exception ex) { new Error(ex).ShowDialog(); return(null); } }
public override bool UpdateData(DataAction dataAction) { if (!_dataChanged) { return(true); } DbData.BeginMultiTrans(); int index = DsData.Tables[0].Rows.IndexOf(_drCurrentMaster); if (index == -1) { return(false); } if (!_customize.BeforeUpdate(index, DsData)) { DbData.RollbackMultiTrans(); return(false); } DataRow[] arrDrCurrentDetails = new DataRow[_lstDrCurrentDetails.Count]; _lstDrCurrentDetails.CopyTo(arrDrCurrentDetails); bool isNew = _drCurrentMaster.RowState == DataRowState.Added; if ((dataAction != DataAction.Delete && Update(_drCurrentMaster) && UpdateDetail()) || (dataAction == DataAction.Delete && UpdateDetail() && Update(_drCurrentMaster))) { TransferData(dataAction, index); _customize.AfterUpdate(); } bool isError = DbData.HasErrors; if (!isError) { DbData.EndMultiTrans(); } else { DbData.RollbackMultiTrans(); } if (isNew && !isError) { _autoIncreValues.UpdateNewStruct(_drCurrentMaster); } if (!isError) { base.InsertHistory(dataAction, DsData); DsData.AcceptChanges(); _dsDataTmp = DsData.Copy(); } return(!isError); }