public bool Execute(DbUser alteredUser) { // update user details GetStreamID id = new GetStreamID(); string stream_id = id.Read(alteredUser.Stream); GetTStatusID id2 = new GetTStatusID(); string tstatus_id = id2.Read(alteredUser.TStatus); ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); IDbCommand cmd = new OleDbCommand("sp_update_profile", (OleDbConnection)cn); cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); cmd.Transaction = tran; // Add job cmd.Parameters.Add(new OleDbParameter("@userLocation", alteredUser.Location)); cmd.Parameters.Add(new OleDbParameter("@userID", alteredUser.UserId)); cmd.Parameters.Add(new OleDbParameter("@userStream", stream_id)); cmd.Parameters.Add(new OleDbParameter("@tstatID", tstatus_id)); cmd.Parameters.Add(new OleDbParameter("@userDegree", alteredUser.Degree)); cmd.Parameters.Add(new OleDbParameter("@userModules", alteredUser.Modules)); int affectedRows = cmd.ExecuteNonQuery(); if (affectedRows > 0) { tran.Commit(); return(true); } else { tran.Rollback(); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return(false); }
public bool Execute(DbUser alteredUser) { // update user details GetStreamID id = new GetStreamID(); string stream_id = id.Read(alteredUser.Stream); GetTStatusID id2 = new GetTStatusID(); string tstatus_id = id2.Read(alteredUser.TStatus); ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); IDbCommand cmd = new OleDbCommand("sp_update_profile", (OleDbConnection)cn); cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); cmd.Transaction = tran; // Add job cmd.Parameters.Add(new OleDbParameter("@userLocation", alteredUser.Location)); cmd.Parameters.Add(new OleDbParameter("@userID", alteredUser.UserId)); cmd.Parameters.Add(new OleDbParameter("@userStream", stream_id)); cmd.Parameters.Add(new OleDbParameter("@tstatID", tstatus_id)); cmd.Parameters.Add(new OleDbParameter("@userDegree", alteredUser.Degree)); cmd.Parameters.Add(new OleDbParameter("@userModules", alteredUser.Modules)); int affectedRows = cmd.ExecuteNonQuery(); if (affectedRows > 0) { tran.Commit(); return true; } else { tran.Rollback(); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return false; }