public bool Insert(Student student, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_StudentInsert"); db.AddInParameter(command, "StudentId", DbType.Guid, Guid.NewGuid()); db.AddInParameter(command, "UserId", DbType.Guid, student.StudentUser.UserId); db.AddInParameter(command, "SchoolId", DbType.Guid, student.School.SchoolId); db.AddInParameter(command, "IsDeleted", DbType.Boolean, student.IsDeleted); db.AddInParameter(command, "Year", DbType.String, student.School.Year); db.AddInParameter(command, "StartYear", DbType.String, student.StartYear); db.AddInParameter(command, "StartMonth", DbType.String, student.StartMonth); db.AddInParameter(command, "Status", DbType.String, student.Status); db.AddInParameter(command, "PreviousSchoolInfo", DbType.String, student.PreviousSchoolInfo); db.AddInParameter(command, "PreviousSchool", DbType.String, student.PreviousSchool); db.AddInParameter(command, "MajorId", DbType.Int16, student.MajorId); db.AddInParameter(command, "CreatedBy", DbType.Guid, student.CreatedBy); db.AddOutParameter(command, "CreatedDate", DbType.DateTime, 30); db.ExecuteNonQuery(command, transaction); student.CreatedDate = Convert.ToDateTime(db.GetParameterValue(command, "CreatedDate").ToString()); student.UpdatedDate = student.CreatedDate; return true; }
public bool Delete(Student student, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_StudentDelete"); db.AddInParameter(command, "StudentId", DbType.Guid, student.StudentId); db.ExecuteNonQuery(command, transaction); return true; }
/// <summary> /// Checks if user record with UserId exist in User table of the database. /// </summary> /// <param name="user"></param> /// <returns></returns> public bool IsStudentExist(Student student) { Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_Student_IsStudentExist"); db.AddInParameter(command, "StudentId", DbType.Guid, student.StudentId); db.AddOutParameter(command, "IsExist", DbType.Boolean, 1); db.ExecuteNonQuery(command); return Convert.ToBoolean(db.GetParameterValue(command, "IsExist").ToString()); }
public void loaddata() { // school data student = RHP.StudentManagement.Student.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString())); if (student != null) { // Session[Constants.SESSION_LOGGED_STUDENT] = student; if (student.School != null) { if (!string.IsNullOrEmpty(student.School.SchoolId.ToString())) { HiddenFieldSchoolId.Value = student.School.SchoolId.ToString(); for (int i = 0; i < DrpSchoolName.Items.Count; i++) { if (DrpSchoolName.Items[i].Value.ToString().ToLower() == student.School.SchoolId.ToString()) { DrpSchoolName.Value = student.School.SchoolId.ToString(); //DrpSchoolName.Items[i].Selected = true; } } } } if (!string.IsNullOrEmpty(student.Year.ToString())) { for (int i = 0; i < DRPYear.Items.Count; i++) { if (DRPYear.Items[i].Value.ToString().ToLower() == student.Year.ToString()) { DRPYear.ClearSelection(); DRPYear.Items[i].Selected = true; } } } if (!string.IsNullOrEmpty(student.Status)) { for (int i = 0; i < Status.Items.Count; i++) { if (Status.Items[i].Value.ToString().ToLower() == student.Status.ToLower()) { Status.ClearSelection(); Status.Items[i].Selected = true; } } } if (!string.IsNullOrEmpty(student.PreviousSchoolInfo)) { for (int i = 0; i < DRPpreviousschoolinfo.Items.Count; i++) { if (DRPpreviousschoolinfo.Items[i].Value.ToString().ToLower() == student.PreviousSchoolInfo.ToLower()) { DRPpreviousschoolinfo.ClearSelection(); DRPpreviousschoolinfo.Items[i].Selected = true; } } } if (student.MajorId.HasValue) { for (int i = 0; i < DRPCurentMajor.Items.Count; i++) { if (DRPCurentMajor.Items[i].Value.ToString().ToLower() == student.MajorId.ToString().ToLower()) { DRPCurentMajor.ClearSelection(); DRPCurentMajor.Items[i].Selected = true; } } } if (!string.IsNullOrEmpty(student.StartMonth.ToString())) { for (int i = 0; i < DRPstartMonth.Items.Count; i++) { if (DRPstartMonth.Items[i].Value.ToString().ToLower() == student.StartMonth.ToString()) { DRPstartMonth.ClearSelection(); DRPstartMonth.Items[i].Selected = true; } } } if (!string.IsNullOrEmpty(student.StartYear.ToString())) { for (int i = 0; i < DRPstartYear.Items.Count; i++) { if (DRPstartYear.Items[i].Value.ToString().ToLower() == student.StartYear.ToString()) { DRPstartYear.ClearSelection(); DRPstartYear.Items[i].Selected = true; } } } if (DRPpreviousschoolinfo.SelectedItem.Value == "Transfer student") { previousschoolID.Visible = true; previousschool.Text = string.IsNullOrEmpty(student.PreviousSchool) ? string.Empty : student.PreviousSchool; } else { previousschoolID.Visible = false; } // startMonth.Text = string.IsNullOrEmpty(student.StartMonth.ToString()) ? string.Empty : student.StartMonth.ToString(); // startYear.Text = string.IsNullOrEmpty(student.StartYear.ToString()) ? string.Empty : student.StartYear.ToString(); // LandLoadPlace.Text = string.IsNullOrEmpty(student.LandloadPlace) ? string.Empty : student.LandloadPlace; } }
protected void Page_Load(object sender, EventArgs e) { string ReturnURL = string.Empty; string userRole = string.Empty; Uri currentDomainURL = new Uri(HttpContext.Current.Request.Url.AbsoluteUri); string value = Utility.GetQueryStringValueByKey(Request, "type"); if (!IsPostBack) { if (value == "s") { ReturnURL = "/Student/Student_Profile.aspx"; userRole = "student"; } else if (value == "l") { ReturnURL = "/Land_load/Land_load_Profile.aspx"; userRole = "landlord"; } else { ReturnURL = "~/"; } } try { IAuthorizationState authorization = facebookClient.ProcessUserAuthorization(); User user = new User(); RHP.StudentManagement.Student student = new RHP.StudentManagement.Student(); Landlord landload = new Landlord(); if (authorization == null) { SendEmail("FBReturn URL", string.Format("Return URL: {0}, App Id: {1}, App Secret: {2}", currentDomainURL.ToString(), facebookClient.ClientIdentifier.ToString(), facebookClient.ClientCredentialApplicator.ToString())); facebookClient.RequestUserAuthorization(scope: new[] { FBClient.Scopes.Email }, returnTo: currentDomainURL); } else// if (authorization.Scope.Count > 0) { string accessCode = string.Empty; if (authorization != null && authorization.AccessToken != null) { accessCode = Uri.EscapeDataString(authorization.AccessToken); } IOAuth2Graph oauth2Graph = facebookClient.GetGraph(authorization, new[] { FBGraph.Fields.Defaults, FBGraph.Fields.Email, FBGraph.Fields.Picture }); //Todo: Register the user here if not an existing member. user.FBid = string.IsNullOrEmpty(HttpUtility.HtmlEncode(oauth2Graph.Id)) ? string.Empty : HttpUtility.HtmlEncode(oauth2Graph.Id); user.FirstName = string.IsNullOrEmpty(HttpUtility.HtmlEncode(oauth2Graph.FirstName)) ? string.Empty : HttpUtility.HtmlEncode(oauth2Graph.FirstName); user.LastName = string.IsNullOrEmpty(HttpUtility.HtmlEncode(oauth2Graph.LastName)) ? string.Empty : HttpUtility.HtmlEncode(oauth2Graph.LastName); user.Email = string.IsNullOrEmpty(HttpUtility.HtmlEncode(oauth2Graph.Email)) ? string.Empty : HttpUtility.HtmlEncode(oauth2Graph.Email); user.PersonalEmail = string.IsNullOrEmpty(HttpUtility.HtmlEncode(oauth2Graph.Email)) ? string.Empty : HttpUtility.HtmlEncode(oauth2Graph.Email); user.FBAccessToken = string.IsNullOrEmpty(authorization.AccessToken) ? string.Empty : authorization.AccessToken; user.FBProfilePictureURL = string.IsNullOrEmpty(HttpUtility.HtmlEncode(oauth2Graph.AvatarUrl)) ? string.Empty : HttpUtility.HtmlEncode(oauth2Graph.AvatarUrl); user.Gender = string.IsNullOrEmpty(HttpUtility.HtmlEncode(oauth2Graph.Gender)) ? string.Empty : HttpUtility.HtmlEncode(oauth2Graph.Gender); user.IsFBUser = true; user.Password = user.FBid; user.UserName = user.FBid; user.Question = "Are you FB User ?"; user.Answer = "FB" + user.FBid; if (user.IsExistingFbUser(user.FBid)) { // authanticate fbuser get userneame and pwd // get user from fbid (username) // stringpassword = membership user.UserName = user.GetFBUsernameByFBId(user.FBid); if (user.AuthenticateUser()) { try { Session[Constants.SESSION_LOGGED_USER] = user; user.RedirectUserFromLogin(false); } catch (Exception ex) { user.LogOut(); } } else { user.LogOut(); } } else { if (user.IsUserEmailExist(user.Email)) { //Todo need to handle this part correctly. Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.EmailExist + "'); window.location = '/Login.aspx'; }", true); } else { bool boolMembershipUserCreated = false; object objCreateMembershipUser = new object(); user.UserId = Guid.NewGuid(); objCreateMembershipUser = user.AddMembershipPartialUser(user.UserName, user.Password, user.Email, user.Question, user.Answer, true, user.UserId.Value, userRole); bool.TryParse(objCreateMembershipUser.ToString(), out boolMembershipUserCreated); if (boolMembershipUserCreated) { FormsAuthentication.SetAuthCookie(user.UserName, false); user.UpdatedBy = user.UserId.HasValue ? user.UserId.Value : Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()); user.CreatedBy = user.UserId.HasValue ? user.UserId.Value : Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()); if (user.Save()) { Session[Constants.SESSION_LOGGED_USER] = user; MembershipUser newUser = Membership.GetUser(user.UserName); user.RedirectUserFromLogin(true); } else { user.LogOut(); //Todo delete membership user from tables Response.Redirect("~/Login.aspx", false); } } else { user.LogOut(); Response.Redirect("~/Login.aspx", false); } } } } } catch (Exception ex) { string emailText = String.Format("Message:{0}, Source:{1}, StackTrace:{2}", ex.Message, ex.Source, ex.StackTrace); SendEmail("FB Exception", emailText); throw ex; } }
public void LoadUserData() { // user data user = User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString())); Name.Text = string.IsNullOrEmpty(user.Name) ? string.Empty : user.Name; Email.Text = string.IsNullOrEmpty(Membership.GetUser().Email.ToString()) ? string.Empty : Membership.GetUser().Email.ToString(); Address.Text = string.IsNullOrEmpty(user.StreetAddress) ? string.Empty : user.StreetAddress; City.Text = string.IsNullOrEmpty(user.City) ? string.Empty : user.City; Zip.Text = string.IsNullOrEmpty(user.Zip) ? string.Empty : user.Zip; Mobile.Text = string.IsNullOrEmpty(user.BestContactNumber) ? string.Empty : user.BestContactNumber; Question.Text = user.GetSeacretQuestion(Membership.GetUser().UserName.ToString()); DriversLicense.Text = string.IsNullOrEmpty(user.DriversLicenseNumber) ? string.Empty : user.DriversLicenseNumber; if (!string.IsNullOrEmpty(user.Status)) { for (int i = 0; i < Status.Items.Count; i++) { if (Status.Items[i].Value.ToString().ToLower() == user.Status.ToLower()) { Status.Items[i].Selected = true; } } } if (!string.IsNullOrEmpty(user.State)) { for (int i = 0; i < Drpstate.Items.Count; i++) { if (Drpstate.Items[i].Value.ToString().ToLower() == user.State.ToLower()) { Drpstate.Items[i].Selected = true; } } } if (!string.IsNullOrEmpty(user.Gender)) { for (int i = 0; i < DrpGender.Items.Count; i++) { if (DrpGender.Items[i].Value.ToString().ToLower() == user.Gender.ToLower()) { DrpGender.Items[i].Selected = true; } } } // school data student = RHP.StudentManagement.Student.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString())); if (student != null) { if (!string.IsNullOrEmpty(student.School.SchoolId.ToString())) { for (int i = 0; i < DrpSchoolName.Items.Count; i++) { if (DrpSchoolName.Items[i].Value.ToString().ToLower() == student.School.SchoolId.ToString()) { DrpSchoolName.Items[i].Selected = true; } } } if (!string.IsNullOrEmpty(student.Year.ToString())) { for (int i = 0; i < DRPYear.Items.Count; i++) { if (DRPYear.Items[i].Value.ToString().ToLower() == student.Year.ToString()) { DRPYear.Items[i].Selected = true; } } } LandLoadName.Text = string.IsNullOrEmpty(student.LandloadName) ? string.Empty : student.LandloadName; LandLoadPlace.Text = string.IsNullOrEmpty(student.LandloadPlace) ? string.Empty : student.LandloadPlace; } }