public static int ProcessUpdate(DataSet ds, string insert, string update, DGCParameter[] paramInsert, DGCParameter[] paramUpdate)
{
Database db = CreateDB();
int rowsAffected = 0;
try
{
DbCommand cmdInsert = db.GetSqlStringCommand(insert);
GenerateQuery.PrepareParametersListWithSourceColumn(cmdInsert, paramInsert);
DbCommand cmdUpdate = db.GetSqlStringCommand(update);
GenerateQuery.PrepareParametersListWithSourceColumn(cmdUpdate, paramUpdate);
rowsAffected = db.UpdateDataSet(ds, "Table", cmdInsert, cmdUpdate, null, UpdateBehavior.Transactional);
}
catch (Exception ex)
{
Write2Log.WriteLogs("Generic<T>", "ExcuteFromCmd(string query, DGCParameter[] parameters)", ex.Message);
}
return(rowsAffected);
}
public static int ProcessUpdateStoreWithTransaction(DataSet ds, string insert, string update, string delete, DGCParameter[] paramInsert, DGCParameter[] paramUpdate, DGCParameter[] paramDelete, DGCParameter[] paramInsertNotSource, DGCParameter[] paramUpdateNotSource, IFactory factory)
{
Database db = CreateDB();
int rowsAffected = 0;
DbCommand cmdInsert = factory.MakeCommandFromStore(insert);
GenerateQuery.PrepareParametersListWithSourceColumn(cmdInsert, paramInsert);
GenerateQuery.PrepareParametersList(cmdInsert, paramInsertNotSource);
DbCommand cmdUpdate = factory.MakeCommandFromStore(update);
GenerateQuery.PrepareParametersListWithSourceColumn(cmdUpdate, paramUpdate);
GenerateQuery.PrepareParametersList(cmdUpdate, paramUpdateNotSource);
DbCommand cmdDelete = factory.MakeCommandFromStore(delete);
GenerateQuery.PrepareParametersListWithSourceColumn(cmdDelete, paramDelete);
rowsAffected = db.UpdateDataSet(ds, "Table", cmdInsert, cmdUpdate, cmdDelete, factory.GetTransaction());
return(rowsAffected);
}
