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