public static void ExcuteNonQueryWithTransaction(string query, DGCParameter[] param, IFactory factory) { DbCommand cmd = factory.MakeCommand(query); GenerateQuery.PrepareParametersList(cmd, param); cmd.ExecuteNonQuery(); }
public static void ExcuteNonQuery(string query, DGCParameter[] param) { IFactory factory = CreateFactory(); try { DbCommand cmd = factory.MakeCommand(query); GenerateQuery.PrepareParametersList(cmd, param); cmd.ExecuteNonQuery(); } catch (Exception ex) { Write2Log.WriteLogs("DBHelper", "ExcuteNonQuery(string query, DGCParameter[] param)", ex.Message); } }
public static DataSet ExcuteDataSetFromCmd(string stroreName, DGCParameter[] parameters) { DataSet ds = null; Database db = CreateDB(); try { DbCommand cmd = db.GetSqlStringCommand(stroreName); GenerateQuery.PrepareParametersList(cmd, parameters); ds = db.ExecuteDataSet(cmd); } catch (Exception ex) { Write2Log.WriteLogs("Generic<T>", "ExcuteFromStore(string stroreName, DGCParameter[] parameters)", ex.Message); } return(ds); }
/// <summary> /// Get All by a table in DB with where Clause /// </summary> /// <param name="obj">a object in Model</param> /// <param name="whereClause"></param> /// <param name="parameters"></param> /// <returns></returns> public static DataSet GetAllByDataSet(object obj, string whereClause, DGCParameter[] parameters) { DataSet ds = null; Database db = CreateDB(); try { string query = GenerateQuery.CommandTextList(obj, whereClause); DbCommand cmd = db.GetSqlStringCommand(query); GenerateQuery.PrepareParametersList(cmd, parameters); ds = db.ExecuteDataSet(cmd); } catch (Exception ex) { Write2Log.WriteLogs("DBHElper", "GetAllByDataSet(object obj, string whereClause, DGCParameter[] parameters)", ex.Message); } return(ds); }
public static DataTable ExcuteFromCmd(string query, DGCParameter[] parameters) { DataTable dt = new DataTable(); Database db = CreateDB(); try { DbCommand cmd = db.GetSqlStringCommand(query); GenerateQuery.PrepareParametersList(cmd, parameters); DataSet ds = db.ExecuteDataSet(cmd); dt = ds.Tables[0]; } catch (Exception ex) { Write2Log.WriteLogs("Generic<T>", "ExcuteFromCmd(string query, DGCParameter[] parameters)", ex.Message); } return(dt); }
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); }
public static void ExcuteFromStoreNonQuery(string stroreName, DGCParameter[] parameters) { Database db = CreateDB(); DbCommand cmd = null; try { cmd = db.GetStoredProcCommand(stroreName); GenerateQuery.PrepareParametersList(cmd, parameters); db.ExecuteNonQuery(cmd); } catch (Exception ex) { Write2Log.WriteLogs("Generic<T>", "ExcuteFromStore(string stroreName, DGCParameter[] parameters)", ex.Message); } finally { cmd.Connection.Close(); cmd.Dispose(); } }
public static int ExcuteIntFromStore(string stroreName, DGCParameter[] parameters) { DataSet ds = null; Database db = CreateDB(); int ret = 0; try { DbCommand cmd = db.GetStoredProcCommand(stroreName); GenerateQuery.PrepareParametersList(cmd, parameters); ds = db.ExecuteDataSet(cmd); if (ds != null && ds.Tables.Count > 0) { ret = ds.Tables.Count; } } catch (Exception ex) { Write2Log.WriteLogs("Generic<T>", "ExcuteFromStore(string stroreName, DGCParameter[] parameters)", ex.Message); } return(ret); }