protected void BtnLogin_Click(object sender, EventArgs e) { try { UserInfoDAL UMobject = new UserInfoDAL(); dynamic result = UMobject.CheckIfUserExistsInDB(email.Value, UtilityFunctions.DecryptPassword(password.Value)); HttpContext.Current.Session["LoggedIn_User"] = (UserInfo)result.GetType().GetProperty("UserInfo").GetValue(result, null); if ((string)result.GetType().GetProperty("FailureMessage").GetValue(result, null) == string.Empty) { Response.Redirect("~/Application_Code/Views/frmReservations.aspx"); } } catch (Exception ex) { } }
/// <summary> /// Used for Get Specific User details /// </summary> /// <param name="Record_ID"></param> /// <returns></returns> public UserInfo GetLoginUserDetails() { ///Declare and Set paramiterized query String queryString = "[SP_GetAllUserInfo] @Page,@RecsPerPage,@Record_ID,@Record_SearchText,@UserTypeID"; UserInfo md = new UserInfo(); ///Establish SQL Connection using (SqlConnection connection = new SqlConnection(Connection_String)) { ///Set SQL Command SqlCommand command = new SqlCommand(queryString, connection); ///Set parameters for paramiterized query command.Parameters.Add("@Page", System.Data.SqlDbType.Int).Value = 1; command.Parameters.Add("@RecsPerPage", System.Data.SqlDbType.Int).Value = 10000; command.Parameters.Add("@Record_ID", System.Data.SqlDbType.Int).Value = -1; try { ///Open SQL Established connection connection.Open(); ///Execute SQL Command and store return result in a SQL Reader SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { ///Set Record details in Employee Object md.Id = dr.IsDBNull(dr.GetOrdinal("Id")) ? 0 : dr.GetInt64(dr.GetOrdinal("Id")); md.Username = dr.IsDBNull(dr.GetOrdinal("Username")) ? null : dr.GetString(dr.GetOrdinal("Username")); md.Email = dr.IsDBNull(dr.GetOrdinal("Email")) ? null : dr.GetString(dr.GetOrdinal("Email")); md.Password = dr.IsDBNull(dr.GetOrdinal("Password")) ? null : dr.GetString(dr.GetOrdinal("Password")); md.Password = UtilityFunctions.DecryptPassword(md.Password); md.UpdatedDate = dr.IsDBNull(dr.GetOrdinal("UpdatedDate")) ? new DateTime() : dr.GetDateTime(dr.GetOrdinal("UpdatedDate")); break; } } catch (Exception e) { } } return(md); }