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);
}
