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