public DBTransaction(StateBag sb) { SB = sb; CreateTransaction(); }
public Boolean Execute(StateBag sb) { //execute db.ExecuteReader(sb); return(sb.Valid); }
public void ExecuteReader(StateBag sb) { if (sb.Valid) { if (sb.Tn == null) { if (ConfigurationManager.ConnectionStrings["connstr"] == null) { throw new Exception("Add connection string 'connstr' to web.config"); } conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstr"].ConnectionString); cmd.Connection = conn; } else { conn = sb.Tn.Connection; cmd.Connection = conn; cmd.Transaction = sb.Tn; } if (conn.State == ConnectionState.Closed) { conn.Open(); } //store SP for error logging if (HttpContext.Current != null && HttpContext.Current.IsDebuggingEnabled) { if (HttpContext.Current.Items.Contains("LastSP")) { HttpContext.Current.Items["LastSP"] = DumpSqlData(); } else { HttpContext.Current.Items.Add("LastSP", DumpSqlData()); } } //EXECUTE if (sb.Valid) { SqlParameter retval = new SqlParameter("RetVal", SqlDbType.Int); retval.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(retval); try { dr = cmd.ExecuteReader(); } catch (Exception ex) { //if (sb.Tn != null) //{ //System.Diagnostics.Debug.Assert(false, ex.ToString()); sb.ErrorMsg = ex.Message.ToString(); //} } } } //check result error CheckForErr(ref sb); }