// ------------------------- GetAccounts ------------------ // return DataSet containing all the accounts. public virtual DataSet GetAccounts(AcPage InPage) { SqlDataAdapter da = null; SqlCommand cmd = null; SqlConnection conn = null; DataSet accounts = null; try { conn = InPage.GetDatabaseConnection( ); cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * " + " FROM " + TableName + " ORDER BY AccountNbr"; da = new SqlDataAdapter( ); da.SelectCommand = cmd; accounts = new DataSet(); da.Fill(accounts, "Accounts"); } finally { if (conn != null) { conn.Close( ); } } return(accounts); }
// ------------------------- Delete ---------------------------- // delete account master by AccountNbr public virtual void Delete( AcPage InPage, string InAccountNbr) { SqlConnection conn = null; SqlCommand cmd; try { conn = InPage.GetDatabaseConnection( ); cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@AccountNbr", InAccountNbr)); cmd.CommandText = "DELETE " + TableName + " WHERE AccountNbr = @AccountNbr"; cmd.ExecuteNonQuery( ); } finally { if (conn != null) { conn.Close( ); } } }
// -------------------------- Update -------------------------- public virtual void Update( AcPage InPage, string InLoadId, AcLoadMasterRow InNewRow) { SqlConnection conn = null; SqlCommand cmd = new SqlCommand( ); try { conn = InPage.GetDatabaseConnection( ); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@WhereLoadId", InLoadId)); cmd.Parameters.Add(new SqlParameter("@LoadId", InNewRow.LoadId)); cmd.Parameters.Add(new SqlParameter("@SessionId", InNewRow.SessionId)); cmd.Parameters.Add(new SqlParameter("@Seqn", InNewRow.Seqn)); cmd.Parameters.Add(new SqlParameter("@PageName", InNewRow.PageName)); cmd.Parameters.Add(new SqlParameter("@PageFileName", InNewRow.PageFileName)); cmd.Parameters.Add(new SqlParameter("@PageDirPath", InNewRow.PageDirPath)); cmd.Parameters.Add(new SqlParameter("@LoadTs", InNewRow.LoadTs)); cmd.Parameters.Add(new SqlParameter("@LastPostbackTs", InNewRow.LastPostbackTs)); cmd.Parameters.Add(new SqlParameter("@PostbackCx", InNewRow.PostbackCx)); cmd.Parameters.Add(new SqlParameter("@ReferrerLoadId", InNewRow.ReferrerLoadId)); cmd.Parameters.Add(new SqlParameter("@RawUrl", InNewRow.RawUrl)); cmd.CommandText = "UPDATE " + TableName + " SET LoadId = @LoadId, " + "SessionId = @SessionId, " + "Seqn = @Seqn, " + "PageName = @PageName, " + "PageFileName = @PageFileName, " + "PageDirPath = @PageDirPath, " + "LoadTs = @LoadTs, " + "LastPostbackTs = @LastPostbackTs, " + "PostbackCx = @PostbackCx, " + "ReferrerLoadId = @ReferrerLoadId, " + "RawUrl = @RawUrl" + " WHERE LoadId = @WhereLoadId"; cmd.ExecuteNonQuery( ); } finally { if (conn != null) { conn.Close( ); } } }
// -------------------------- Add -------------------------------- public virtual AcLoadMasterRow Add( AcPage InPage, AcLoadMasterRow InRow) { SqlConnection conn = null; // assign a LoadId if (InRow.LoadId == null) { InRow.LoadId = System.Guid.NewGuid( ).ToString( ); } try { conn = InPage.GetDatabaseConnection( ); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@LoadId", InRow.LoadId)); cmd.Parameters.Add(new SqlParameter("@SessionId", InRow.SessionId)); cmd.Parameters.Add(new SqlParameter("@Seqn", InRow.Seqn)); cmd.Parameters.Add(new SqlParameter("@PageName", InRow.PageName)); cmd.Parameters.Add(new SqlParameter("@PageFileName", InRow.PageFileName)); cmd.Parameters.Add(new SqlParameter("@PageDirPath", InRow.PageDirPath)); cmd.Parameters.Add(new SqlParameter("@LoadTs", InRow.LoadTs)); cmd.Parameters.Add(new SqlParameter("@LastPostbackTs", InRow.LastPostbackTs)); cmd.Parameters.Add(new SqlParameter("@PostbackCx", InRow.PostbackCx)); cmd.Parameters.Add(new SqlParameter("@ReferrerLoadId", InRow.ReferrerLoadId)); cmd.Parameters.Add(new SqlParameter("@RawUrl", InRow.RawUrl)); cmd.CommandText = "INSERT " + TableName + " ( " + "LoadId, SessionId, Seqn, PageName, PageFileName, PageDirPath, " + "LoadTs, LastPostbackTs, PostbackCx, ReferrerLoadId, RawUrl ) " + "Values( @LoadId, @SessionId, @Seqn, @PageName, @PageFileName, @PageDirPath, " + "@LoadTs, @LastPostbackTs, @PostbackCx, @ReferrerLoadId, @RawUrl )"; cmd.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close( ); } } return(InRow); }
// -------------------------- Add -------------------------------- public virtual AcVisitorMasterRow Add( AcPage InPage, AcVisitorMasterRow InRow) { SqlConnection conn = null; try { conn = InPage.GetDatabaseConnection( ); SqlCommand cmd = new SqlCommand(); // assign the VisitorId if (InRow.VisitorId == null) { InRow.VisitorId = System.Guid.NewGuid( ).ToString( ); } if (InRow.UserId == null) { InRow.UserId = ""; } cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@VisitorId", InRow.VisitorId)); cmd.Parameters.Add(new SqlParameter("@UserId", InRow.UserId)); cmd.CommandText = "INSERT " + TableName + " ( " + "VisitorId, UserId ) " + "Values( @VisitorId, @UserId )"; cmd.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close( ); } } return(InRow); }
// -------------------------- Add -------------------------------- public virtual UserMasterRow Add( AcPage InPage, UserMasterRow InRow) { SqlConnection conn = null; try { conn = InPage.GetDatabaseConnection( ); SqlCommand cmd = new SqlCommand(); // assign the UserId if (InRow.UserId == null) { InRow.UserId = System.Guid.NewGuid( ).ToString( ); } cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@UserId", InRow.UserId)); cmd.Parameters.Add(new SqlParameter("@Password", InRow.Password)); cmd.Parameters.Add(new SqlParameter("@UserName", InRow.UserName)); cmd.Parameters.Add(new SqlParameter("@EmailAddress", InRow.EmailAddress)); cmd.CommandText = "Insert " + TableName + " ( " + "UserId, Password, UserName, EmailAddress ) " + "Values( @UserId, @Password, @UserName, @EmailAddress )"; cmd.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close( ); } } return(InRow); }
// -------------------------- Update -------------------------- public virtual void Update( AcPage InPage, string InAccountNbr, AcAccountMasterRow InNewRow) { SqlConnection conn = null; SqlCommand cmd = new SqlCommand( ); try { conn = InPage.GetDatabaseConnection( ); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@WhereAccountNbr", InAccountNbr)); cmd.Parameters.Add(new SqlParameter("@AccountNbr", InNewRow.AccountNbr)); cmd.Parameters.Add(new SqlParameter("@AccountName", InNewRow.AccountName)); cmd.Parameters.Add(new SqlParameter("@Password", InNewRow.Password)); cmd.Parameters.Add(new SqlParameter("@EmailAddress", InNewRow.EmailAddress)); cmd.Parameters.Add(new SqlParameter("@CreateTs", InNewRow.CreateTs)); cmd.CommandText = "UPDATE " + TableName + "SET AccountNbr = @AccountNbr, " + "AccountName = @AccountName, " + "Password = @Password, " + "EmailAddress = @EmailAddress, " + "CreateTs = @CreateTs " + "WHERE AccountNbr = @WhereAccountNbr"; cmd.ExecuteNonQuery( ); } finally { if (conn != null) { conn.Close( ); } } }
// -------------------------- Add -------------------------------- public virtual AcAccountMasterRow Add( AcPage InPage, AcAccountMasterRow InRow) { SqlConnection conn = null; ValidityCheck(InRow); try { conn = InPage.GetDatabaseConnection( ); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@AccountNbr", InRow.AccountNbr)); cmd.Parameters.Add(new SqlParameter("@AccountName", InRow.AccountName)); cmd.Parameters.Add(new SqlParameter("@Password", InRow.Password)); cmd.Parameters.Add(new SqlParameter("@EmailAddress", InRow.EmailAddress)); cmd.Parameters.Add(new SqlParameter("@CreateTs", InRow.CreateTs)); cmd.CommandText = "INSERT " + TableName + " ( " + "AccountNbr, AccountName, Password, EmailAddress, CreateTs ) " + "Values( @AccountNbr, @AccountName, @Password, @EmailAddress, @CreateTs )"; cmd.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close( ); } } return(InRow); }