/// <summary> /// Created By : Satish Verma /// Created Date : 11-Dec-2014 /// Purpose : To get user details /// </summary> /// <param name="objUserManagementBO"></param> /// <returns></returns> public DataTable GetUserDetails(UserManagementBO objUserManagementBO) { DataTable objDataTable = new DataTable(); try { sqlConnection.Open(); sqlCommand = new SqlCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = "Sp_GetUserDetails"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@PageNumber", objUserManagementBO.PageNumber); sqlCommand.Parameters.AddWithValue("@PageSize", objUserManagementBO.PageSize); sqlCommand.Parameters.AddWithValue("@Sort", objUserManagementBO.Sort); sqlCommand.Parameters.AddWithValue("@SearchText", objUserManagementBO.SearchText); sqlDataAdapter = new SqlDataAdapter(sqlCommand); sqlDataAdapter.Fill(objDataTable); } catch (Exception ex) { throw ex; } finally { sqlDataAdapter.Dispose(); sqlCommand.Dispose(); sqlConnection.Close(); sqlConnection.Dispose(); } return(objDataTable); }
public void GenerateSubmissionView(int numSubs) { SubmissionManagementBO bo = new SubmissionManagementBO(); UserManagementBO userBO = new UserManagementBO(); List <SubmissionVO> subList; string sortType = Request.QueryString["sort"]; if (sortType == "top") { subList = bo.GetListOfSubmissionsTop(NUMBER_OF_SUBMISSIONS); } if (sortType == "popular") { subList = bo.GetListOfSubmissionsPopular(NUMBER_OF_SUBMISSIONS); } else { subList = bo.GetListOfSubmissionsNew(NUMBER_OF_SUBMISSIONS); } foreach (SubmissionVO sub in subList) { Submission submission = new Submission(); submission.ID = "submission" + sub.SubmissionID; submission.submissionID = sub.SubmissionID; subPanel.Controls.Add(submission); } }
public void LoadUserDetails() { UserManagementBO bo = new UserManagementBO(); UserVO vo = null; if (Username != null) { vo = bo.GetUser(Username); UserID = vo.UserID; } else if (UserID != 0) { vo = bo.GetUser(UserID); Username = vo.Username; } usernameLabel.Text = "<h1>" + vo.Username + "</h1>"; ratingLabel.Text = vo.Rating + " collective positive rating"; joinDateLabel.Text = "Joined on " + vo.RegisterDate.ToLongDateString(); if (Session["login"] != null) { if (Session["login"].ToString() == Username) { passwordChangePanel.Visible = true; } } //Load the content in the first time we visit if (!Page.IsPostBack) { GenerateRecentContent("submissions"); } }
public void Insert(UserManagementBO userBO) { string userQueryString = ""; userQueryString = @"SBPSaveUserInfo"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@userName", SqlDbType.NVarChar, userBO.UserName); _dbConnection.AddParameter("@roleName", SqlDbType.NVarChar, userBO.RoleName); _dbConnection.AddParameter("@password", SqlDbType.NVarChar, userBO.Password); _dbConnection.AddParameter("@name", SqlDbType.VarChar, userBO.Name); _dbConnection.AddParameter("@address", SqlDbType.VarChar, userBO.Address); _dbConnection.AddParameter("@contact", SqlDbType.VarChar, userBO.ContactNo); _dbConnection.AddParameter("@remark", SqlDbType.VarChar, userBO.Remarks); _dbConnection.AddParameter("@isActive", SqlDbType.Bit, userBO.IsActive); _dbConnection.AddParameter("@branchID", SqlDbType.Int, userBO.BranchId); _dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName); _dbConnection.AddParameter("@employeeCode", SqlDbType.VarChar, userBO.EmployeeCode); _dbConnection.ExecuteNonQuery(userQueryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
protected void SubmitVote(int vote) { UserManagementBO userBO = new UserManagementBO(); UserVO userVO; if (Session["login"] != null) { userVO = userBO.GetUser(Session["login"].ToString()); if (userBO.CheckIfVoted(submissionID, userVO.UserID) == 0) { userBO.SubmitVote(submissionID, userVO.UserID, vote); int i = int.Parse(submissionRating.Text); i += vote; submissionRating.Text = i.ToString(); if (vote == 1) { upArrow.ImageUrl = "~/Images/uparrow_voted.png"; } else if (vote == -1) { downArrow.ImageUrl = "~/Images/downarrow_voted.png"; } } } }
public List <UserManagementBO> GetUserDetails(string pageNumber, string pageSize, string sort, string searchText) { try { if (string.IsNullOrEmpty(pageNumber)) { pageNumber = "0"; } if (string.IsNullOrEmpty(pageSize)) { pageSize = "0"; } UserManagementBO objUserManagementBO = new UserManagementBO(); objUserManagementBO.PageNumber = Convert.ToInt32(pageNumber); objUserManagementBO.PageSize = Convert.ToInt32(pageSize); objUserManagementBO.Sort = sort; objUserManagementBO.SearchText = searchText; List <UserManagementBO> lstUserManagementBO = new UserManagementBL().GetUserDetails(objUserManagementBO); return(lstUserManagementBO); } catch (Exception ex) { throw ex; } }
protected void GenerateLoggedInText() { UserManagementBO userBO = new UserManagementBO(); UserVO userVO = userBO.GetUser(Session["login"].ToString()); viewProfile.Text = userVO.Username; loggedInLabel.Text = " [" + userVO.Rating.ToString() + "] | "; }
protected void LoadCommentDetails() { CommentManagementBO bo = new CommentManagementBO(); UserManagementBO userBO = new UserManagementBO(); CommentVO vo = bo.GetComment(commentID); comVO = vo; //Give comment space for its depth for (int i = 0; i < commentDepth; i++) { spacingLabel.Text = spacingLabel.Text + "<td width=\"25px\"></td>"; } commentRating = vo.Rating; string username = userBO.GetUser(vo.UserID).Username; userLink.Text = username; commentInfo.Text = " rated at " + commentRating + " points, posted " + bo.FormatePostTime(vo.PostDate); commentContents.Text = "<p>" + vo.CommentContents + "</p>"; //Choose which controls to display if (Session["login"] == null) { editButton.Visible = false; deleteButton.Visible = false; replyButton.Visible = false; } else if (!username.Equals(Session["login"].ToString())) { editButton.Visible = false; deleteButton.Visible = false; } //Change vote image based on whether or not it's been voted on if (Session["login"] != null) { int i = bo.CheckIfVoted(commentID, userBO.GetUser(Session["login"].ToString()).UserID); if (i == 1) { upArrow.ImageUrl = "~/Images/uparrow_voted.png"; } else if (i == -1) { downArrow.ImageUrl = "~/Images/downarrow_voted.png"; } } }
protected void CreateUser_Submit(object sender, EventArgs e) { UserManagementBO userBO = new UserManagementBO(); //Make sure username isn't already taken try { //For starters, make sure they've entered info in all the fields. if (createUserUsername.Text.Equals("") || createUserPassword.Text.Equals("")) { throw new Exception(MISSING_INFO_EXCEPTION); } //Check if there are any illegal characters. if (createUserUsername.Text.IndexOfAny(ILLEGAL_CHAR_ARRAY) >= 0) { throw new Exception(ILLEGAL_CHARACTER_EXCEPTION); } //Check if name taken try { userBO.GetUser(createUserUsername.Text); //If it's found in the db, it won't throw the exception, causing it //to hit this exception throw new Exception(USERNAME_ALREADY_TAKEN_EXCEPTION); } catch (Exception exce) { //If the exception we caught was the username taken, throw it again if (exce.Message.Equals(USERNAME_ALREADY_TAKEN_EXCEPTION)) { throw new Exception(USERNAME_ALREADY_TAKEN_EXCEPTION); } } //Make sure the passwords are the same if (createUserPassword.Text != createUserPassword2.Text) { throw new Exception(PASSWORD_MISMATCH_EXCEPTION); } //And if their info passed all of that, we make their account userBO.CreateNewUser(createUserUsername.Text, createUserPassword.Text); Session["login"] = createUserUsername.Text; Response.Redirect(WebConstants.HOME_PAGE); } catch (Exception exc) { errorMessage.Text = exc.Message; } }
protected void GenerateSubmissionDetails() { CommentManagementBO comBO = new CommentManagementBO(); SubmissionManagementBO bo = new SubmissionManagementBO(); SubmissionVO sub = bo.GetSubmission(submissionID); UserManagementBO userBO = new UserManagementBO(); UserVO vo = userBO.GetUser(sub.UserID); submissionRating.Text = sub.Rating.ToString(); submissionCommentLink.Text = (comBO.GetListOfSubmissionComments(submissionID).Count + " comments"); Uri url; try { url = new Uri(sub.Link); } catch (Exception e) { try { url = new Uri("http://" + sub.Link); } catch (Exception exc) { url = new Uri("http://CouldntParseUrl"); } } submissionTitle.Text = "<a href=\"" + url + "\">" + sub.Title + "</a> (" + url.Host.ToString() + ")"; submissionDetails.Text = bo.FormatePostTime(sub.PostTime); userLink.Text = vo.Username; //Change arrow based on voting if (Session["login"] != null) { int i = userBO.CheckIfVoted(submissionID, userBO.GetUser(Session["login"].ToString()).UserID); if (i == 1) { upArrow.ImageUrl = "~/Images/uparrow_voted.png"; } else if (i == -1) { downArrow.ImageUrl = "~/Images/downarrow_voted.png"; } } }
protected void SubmitVote(int vote) { CommentManagementBO comBO = new CommentManagementBO(); UserManagementBO userBO = new UserManagementBO(); CommentVO comVO = comBO.GetComment(commentID); UserVO userVO; if (Session["login"] != null) { userVO = userBO.GetUser(Session["login"].ToString()); if (comBO.CheckIfVoted(commentID, userVO.UserID) == 0) { comBO.SubmitVote(commentID, userVO.UserID, vote); commentRating += vote; Response.Redirect(Request.Url.ToString()); } } }
protected void Login_Submit(object sender, EventArgs e) { UserManagementBO umbo = new UserManagementBO(); try { if (umbo.CheckIfValidLogin(loginUsername.Text, loginPassword.Text)) { Session["login"] = loginUsername.Text; System.Diagnostics.Trace.WriteLine(Session["login"]); Session.Timeout = 1000; Response.Redirect(Request.Url.ToString()); } } catch (Exception exc) { loginErrorMessage.Visible = true; loginErrorMessage.Text = exc.Message; } }
protected void SubmitReply_Click(object sender, EventArgs e) { CommentManagementBO bo = new CommentManagementBO(); UserManagementBO userBO = new UserManagementBO(); try { if (replyTextBox.Text == "") { throw new Exception("You must enter text to reply"); } bo.CreateNewComment(userBO.GetUser(Session["login"].ToString()).Username, replyTextBox.Text, Convert.ToInt32(Request.QueryString["subid"]), Convert.ToInt32(parentCommentID.Text)); Response.Redirect(Request.Url.ToString()); } catch (Exception exc) { errorLabel.Text = exc.Message; } }
protected void PasswordChange_Click(object sender, EventArgs e) { UserManagementBO bo = new UserManagementBO(); UserVO vo = bo.GetUser(UserID); //Look for invalid inputs try { if (newPassword.Text != newPasswordConfirm.Text) { throw new Exception("Both new password fields must match"); } if (!bo.CheckIfValidLogin(Username, oldPassword.Text)) { throw new Exception("Invalid entry for current password"); } bo.ChangePassword(UserID, newPassword.Text); errorLabel.Text = "Password succesfully changed"; } catch (Exception exc) { errorLabel.Text = exc.Message; } }
/// <summary> /// Created By : Satish Verma /// Created Date : 11-Dec-2014 /// Purpose : To get user details /// </summary> /// <param name="objUserManagementBO"></param> /// <returns></returns> public List <UserManagementBO> GetUserDetails(UserManagementBO objUserManagementBO) { DataTable objDataTable = new UserManagementDA().GetUserDetails(objUserManagementBO); List <UserManagementBO> lstUserManagementBO = new List <UserManagementBO>(); foreach (DataRow Row in objDataTable.Rows) { UserManagementBO obUserManagementBO = new UserManagementBO(); obUserManagementBO.UserDetailId = Convert.ToInt32(Row["UserDetailId"]); if (string.IsNullOrEmpty(Convert.ToString(Row["FirstName"]))) { obUserManagementBO.FirstName = string.Empty; } else { obUserManagementBO.FirstName = Convert.ToString(Row["FirstName"]); } if (string.IsNullOrEmpty(Convert.ToString(Row["LastName"]))) { obUserManagementBO.LastName = string.Empty; } else { obUserManagementBO.LastName = Convert.ToString(Row["LastName"]); } if (string.IsNullOrEmpty(Convert.ToString(Row["CountryId"]))) { obUserManagementBO.CountryId = null; } else { obUserManagementBO.CountryId = Convert.ToInt32(Row["CountryId"]); } if (string.IsNullOrEmpty(Convert.ToString(Row["Phone"]))) { obUserManagementBO.Phone = null; } else { obUserManagementBO.Phone = Convert.ToInt64(Row["Phone"]); } if (string.IsNullOrEmpty(Convert.ToString(Row["Email"]))) { obUserManagementBO.Email = string.Empty; } else { obUserManagementBO.Email = Convert.ToString(Row["Email"]); } obUserManagementBO.DOB = Convert.ToDateTime(Row["DOB"]).ToString("dd-MMM-yyyy"); if (string.IsNullOrEmpty(Convert.ToString(Row["Balance"]))) { obUserManagementBO.Balance = string.Empty; } else { obUserManagementBO.Balance = Convert.ToString(Row["Balance"]); } obUserManagementBO.IsActive = Convert.ToBoolean(Row["IsActive"]); obUserManagementBO.UserLoginId = (Guid)Row["UserLoginId"]; obUserManagementBO.UserName = Convert.ToString(Row["UserName"]); obUserManagementBO.Email = Convert.ToString(Row["Email"]); obUserManagementBO.RoleId = Convert.ToInt32(Row["RoleId"]); obUserManagementBO.Total = Convert.ToInt32(Row["Total"]); lstUserManagementBO.Add(obUserManagementBO); } return(lstUserManagementBO); }