public static bool ExecuteTransactionQuery(string query, Dictionary <string, string> Params = null)
{
query = $"{QueryMaker.BeginTransQuery()} {query} {QueryMaker.CommitTransQuery()}";
using (SqlConnection Connection = new SqlConnection(ConnectionString))
{
Connection.Open();
SqlCommand cmd = GetSqlCommandWithParams(query, Connection, Params);
int rowseffected = cmd.ExecuteNonQuery();
Connection.Close();
return(true);
}
}
public void BeginTrans()
{
Query = string.Empty;
Query += QueryMaker.BeginTransQuery();
}
