/// <summary> /// Get the Role. /// </summary> /// <returns>Collection of Role.</returns> public IList <Role> GetRoles() { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.Role.StoreProcedure.usp_SelectUserRole, cn, true)) { IList <Role> listRole = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { listRole = new List <Role>(); if (reader.HasRows) { while (reader.Read()) { Role Role = new Role(); Role.Id = TypeConversionUtility.ToInteger(reader[DbConstant.Role.DbColumn.Id]); Role.RoleName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.Role.DbColumn.RoleName]); Role.IsActive = TypeConversionUtility.ToBoolean(reader[DbConstant.Role.DbColumn.IsActive]); Role.CreatedDate = TypeConversionUtility.ToDateTime(reader[DbConstant.Role.DbColumn.CreatedDate]); listRole.Add(Role); } } cn.Close(); } return(listRole); } } }
public List<UserOrderDiscount> GetOrderDiscounts(int userId) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.StoreProcedure.usp_GetOrderDiscount, cn, true)) { SqlParameter paramUserId = new SqlParameter(DbConstant.Parameter.UserId, userId); cmd.Parameters.Add(paramUserId); List<UserOrderDiscount> userPromoDiscounts = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { userPromoDiscounts = new List<UserOrderDiscount>(); if (reader.HasRows) { while (reader.Read()) { var data = new UserOrderDiscount { Discount = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Discount]), OrderNumber = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.OrderNumber]), TemplateId = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.TemplateId]), Savings = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Savings]), GlobalPromoCode= TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.GlobalPromoCode]) }; userPromoDiscounts.Add(data); } } } return userPromoDiscounts; } } }
/// <summary> /// Get the Menus. /// </summary> /// <param name="id"></param> /// <returns>Collection of Menus.</returns> public IList <Role> GetMenus(int?id = null) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.Role.StoreProcedure.usp_SelectMenuOrSubMenu, cn, true)) { SqlParameter paramId = new SqlParameter(DbConstant.Role.DbParameter.Id, id); cmd.Parameters.Add(paramId); IList <Role> listRole = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { listRole = new List <Role>(); if (reader.HasRows) { while (reader.Read()) { Role Role = new Role(); Role.MenuId = TypeConversionUtility.ToInteger(reader[DbConstant.Role.DbColumn.MenuId]); Role.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.Role.DbColumn.MenuName]); Role.SubMenuId = TypeConversionUtility.ToInteger(reader[DbConstant.Role.DbColumn.SubMenuId]); Role.SubMenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.Role.DbColumn.SubMenuName]); Role.MenuLink = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.MenuLink]); listRole.Add(Role); } } cn.Close(); } return(listRole); } } }
/// <summary> /// Get the SubMenu. /// </summary> /// <returns>Collection of SubMenu.</returns> public IList<SubMenu> GetSubMenus() { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.SubMenu.StoreProcedure.usp_SelectSubMenu, cn, true)) { IList<SubMenu> SubMenus = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { SubMenus = new List<SubMenu>(); if (reader.HasRows) { while (reader.Read()) { SubMenu SubMenu = new SubMenu(); SubMenu.Id = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.Id]); SubMenu.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.MenuName]); SubMenu.SubMenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.SubMenuName]); SubMenu.MenuId = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.MenuId]); SubMenu.DisplayOrder = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.DisplayOrder]); SubMenu.IsActive = TypeConversionUtility.ToBoolean(reader[DbConstant.SubMenu.DbColumn.IsActive]); SubMenu.CreatedDate = TypeConversionUtility.ToDateTime(reader[DbConstant.SubMenu.DbColumn.CreatedDate]); SubMenus.Add(SubMenu); } } cn.Close(); } return SubMenus; } } }
/// <summary> /// Get the Menu. /// </summary> /// <returns>Collection of Menu.</returns> public IList<MenuNav> GetMenus() { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.Menu.StoreProcedure.usp_SelectMenu, cn, true)) { IList<MenuNav> listMenuNav = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { listMenuNav = new List<MenuNav>(); if (reader.HasRows) { while (reader.Read()) { MenuNav menuNav = new MenuNav(); menuNav.Id = TypeConversionUtility.ToInteger(reader[DbConstant.Menu.DbColumn.Id]); menuNav.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.Menu.DbColumn.MenuName]); menuNav.DisplayOrder = TypeConversionUtility.ToInteger(reader[DbConstant.Menu.DbColumn.DisplayOrder]); menuNav.IsActive = TypeConversionUtility.ToBoolean(reader[DbConstant.Menu.DbColumn.IsActive]); menuNav.CreatedDate = TypeConversionUtility.ToDateTime(reader[DbConstant.Menu.DbColumn.CreatedDate]); listMenuNav.Add(menuNav); } } cn.Close(); } return listMenuNav; } } }
/// <summary> /// Get the Menus By Role. /// </summary> /// <param name="id"></param> /// <returns>Collection of Menus.</returns> public IList<MenuNav> GetMenusByRole(int? roleId = null) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.Menu.StoreProcedure.usp_SelectRoleByMenu, cn, true)) { SqlParameter paramRoleId = new SqlParameter(DbConstant.Menu.DbParameter.RoleId, roleId); cmd.Parameters.Add(paramRoleId); IList<MenuNav> listMenuNav = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { listMenuNav = new List<MenuNav>(); if (reader.HasRows) { while (reader.Read()) { MenuNav menuNav = new MenuNav(); menuNav.Id = TypeConversionUtility.ToInteger(reader[DbConstant.Role.DbColumn.Id]); menuNav.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.Role.DbColumn.MenuName]); listMenuNav.Add(menuNav); } } cn.Close(); } return listMenuNav; } } }
/// <summary> /// Gets the user based on User ID. /// </summary> /// <param name="userId">The User ID to be loaded.</param> /// <param name="emailAddress">The email address.</param> /// <param name="password">The password.</param> /// <param name="status">The status.</param> /// <returns>Object of <see cref="User" />.</returns> public User GetUser(int? userId, string emailAddress, string password, Enums.Status status) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.StoreProcedure.usp_GetUser, cn, true)) { SqlParameter paramUserId = new SqlParameter(DbConstant.Parameter.Id, userId); cmd.Parameters.Add(paramUserId); SqlParameter paramEmailAddress = new SqlParameter(DbConstant.Parameter.Email, emailAddress); cmd.Parameters.Add(paramEmailAddress); SqlParameter paramPassword = new SqlParameter(DbConstant.Parameter.Password, password); cmd.Parameters.Add(paramPassword); if (status != Enums.Status.NotDefined) { SqlParameter paramStatus = new SqlParameter(DbConstant.Parameter.Status, status); cmd.Parameters.Add(paramStatus); } User user = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { if (reader.HasRows) { if (reader.Read()) { user = new User(); user.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.Id]); user.FirstName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.FirstName]); user.LastName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.LastName]); user.Status = (Enums.Status)TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.Status]); user.UserType = (Enums.UserType)TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.UserType]); user.Email = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Email]); user.Password = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Password]); user.ProfileImage = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.ProfileImage]); user.PhoneNumber = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.PhoneNumber]); user.SchoolName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.SchoolName]); user.DateCreated = TypeConversionUtility.ToDateTime(reader[DbConstant.DbColumn.DateCreated]); user.PromoCode = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.PromoCode]); user.SYId = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.SYId]); user.IsGiftFree = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsGiftFree]); user.IsTaxExempt = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsTaxExempt]); user.RoleId = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.RoleId]); } } } return user; } } }
protected void lkbSubmit_OnClick(object sender, EventArgs e) { try { var objUser = new clsUser(); if (!string.IsNullOrEmpty(Convert.ToString(Request.QueryString["Id"]))) { objUser.UserId = TypeConversionUtility.ToInteger(Request.QueryString["Id"]); } else { objUser.UserId = 0; } objUser.UserName = TypeConversionUtility.ToStringWithNull(txtName.Text.Trim()); objUser.EmailId = TypeConversionUtility.ToStringWithNull(txtEmailId.Text.Trim()); objUser.LoginId = TypeConversionUtility.ToStringWithNull(txtLoginId.Text.Trim()); objUser.LoginPwd = TypeConversionUtility.ToStringWithNull(txtPwd.Text.Trim()); objUser.Status = TypeConversionUtility.ToInteger(ddlStatus.SelectedValue); objUser.TypeId = Convert.ToInt32(ddUserLevel.SelectedValue); if (UserRepository.CheckUserExits(objUser.UserId, objUser.LoginId)) { lblMsg.Text = "Login Id already exist. Try using different login id."; pnlMsg.Visible = true; } else if (UserRepository.UserAddUpdate(objUser)) // Add/Update Login Details { if (objUser.UserId == 0) { pnlMsg.Visible = true; lblMsg.Text = "Record has been successfully inserted."; lblMsg.CssClass = "success"; txtName.Text = ""; txtEmailId.Text = ""; txtPwd.Text = ""; txtLoginId.Text = ""; ddlStatus.SelectedValue = "0"; } else { Response.Redirect("userList.aspx?msg=Record has been successfully updated."); } } } catch (Exception ex) { lblMsg.Text = string.Format("<p class=\"error\">{0}</p>", ex); pnlMsg.Visible = true; } }
/// <summary> /// Get the SubMenu. /// </summary> /// <returns>Details of SubMenu.</returns> public SubMenu GetSubMenu(int id,bool ? isAddPage) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.SubMenu.StoreProcedure.usp_SelectSubMenu, cn, true)) { SqlParameter paramId = new SqlParameter(DbConstant.SubMenu.DbParameter.Id, id); cmd.Parameters.Add(paramId); SqlParameter paramIsAddPage = new SqlParameter(DbConstant.SubMenu.DbParameter.IsAddPage, isAddPage); cmd.Parameters.Add(paramIsAddPage); SubMenu subMenus = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { subMenus = new SubMenu(); if (reader.HasRows) { while (reader.Read()) { subMenus.Id = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.Id]); subMenus.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.MenuName]); subMenus.MenuLink = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.MenuLink]); subMenus.SubMenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.SubMenuName]); subMenus.ListPageHeading = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.ListPageHeading]); subMenus.ListPageDescription = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.ListPageDescription]); subMenus.AddPageHeading = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.AddPageHeading]); subMenus.AddPageDescription = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.AddPageDescription]); subMenus.IsAddPage = TypeConversionUtility.ToBoolean(reader[DbConstant.SubMenu.DbColumn.IsAddPage]); subMenus.MenuId = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.MenuId]); subMenus.DisplayOrder = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.DisplayOrder]); subMenus.IsActive = TypeConversionUtility.ToBoolean(reader[DbConstant.SubMenu.DbColumn.IsActive]); subMenus.CreatedDate = TypeConversionUtility.ToDateTime(reader[DbConstant.SubMenu.DbColumn.CreatedDate]); } } cn.Close(); } return subMenus; } } }
/// <summary> /// Get the Sub Menus by Role. /// </summary> /// <param name="id"></param> /// <param name="roleId"></param> /// <returns>Collection of Sub Menus.</returns> public IList<SubMenu> GetSubMenusByRole(int? id = null, int ? roleId = null) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.SubMenu.StoreProcedure.usp_SelectSubMenuByRole, cn, true)) { SqlParameter paramId = new SqlParameter(DbConstant.Role.DbParameter.Id, id); cmd.Parameters.Add(paramId); SqlParameter paramRoleId = new SqlParameter(DbConstant.Menu.DbParameter.RoleId, roleId); cmd.Parameters.Add(paramRoleId); IList<SubMenu> listSubMenu = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { listSubMenu = new List<SubMenu>(); if (reader.HasRows) { while (reader.Read()) { SubMenu subMenu = new SubMenu(); subMenu.Id = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.Id]); subMenu.MenuId = TypeConversionUtility.ToInteger(reader[DbConstant.SubMenu.DbColumn.MenuId]); subMenu.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.MenuName]); subMenu.SubMenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.SubMenuName]); subMenu.MenuLink = TypeConversionUtility.ToStringWithNull(reader[DbConstant.SubMenu.DbColumn.MenuLink]); listSubMenu.Add(subMenu); } } cn.Close(); } return listSubMenu; } } }
/// <summary> /// Get the Users Paged. /// </summary> /// <param name="name"></param> /// <param name="startPage">Page number at which to start reading.</param> /// <param name="pageLength">Number of records to be displayed per page.</param> /// <param name="noOfPages">Out parameter which returns the number of pages.</param> /// <param name="totalRecords">Out parameter which returns the total records.</param> /// <param name="email"></param> /// <returns>Collection of User.</returns> public IList<User> GetUsers(string email, string name, int startPage, int pageLength, out int noOfPages, out int totalRecords) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.StoreProcedure.usp_GetUsersPaged, cn, true)) { SqlParameter paramName = new SqlParameter(DbConstant.Parameter.Name, name); cmd.Parameters.Add(paramName); SqlParameter paramEmailAddress = new SqlParameter(DbConstant.Parameter.Email, email); cmd.Parameters.Add(paramEmailAddress); SqlParameter parStart = new SqlParameter(DbConstant.Parameter.StartPage, startPage); cmd.Parameters.Add(parStart); SqlParameter parPageLength = new SqlParameter(DbConstant.Parameter.PageLength, pageLength); cmd.Parameters.Add(parPageLength); SqlParameter parNoOfPage = new SqlParameter(DbConstant.Parameter.NoOfPages, noOfPages = 0); parNoOfPage.Direction = ParameterDirection.Output; cmd.Parameters.Add(parNoOfPage); SqlParameter partotalRecords = new SqlParameter(DbConstant.Parameter.TotalRecords, totalRecords = 0); partotalRecords.Direction = ParameterDirection.Output; cmd.Parameters.Add(partotalRecords); IList<User> users = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { users = new List<User>(); if (reader.HasRows) { while (reader.Read()) { var user = new User(); user.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.Id]); user.FirstName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.FirstName]); user.LastName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.LastName]); user.Password = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Password]); user.Status = (Enums.Status)TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.Status]); user.UserType = (Enums.UserType)TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.UserType]); user.Email = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Email]); user.ProfileImage = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.ProfileImage]); user.PhoneNumber = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.PhoneNumber]); user.SchoolName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.SchoolName]); user.DateCreated = TypeConversionUtility.ToDateTime(reader[DbConstant.DbColumn.DateCreated]); user.AccountType.Id = TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.AccountType]); user.AccountCategory.CategoryName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.CategoryName]); user.SYId = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.SYId]); users.Add(user); } } cn.Close(); if (reader.IsClosed) { noOfPages = TypeConversionUtility.ToInteger(parNoOfPage.Value); totalRecords = TypeConversionUtility.ToInteger(partotalRecords.Value); } } return users; } } }
/// <summary> /// Gets the user based on User ID. /// </summary> /// <param name="userId">The User ID to be loaded.</param> /// <param name="emailAddress">The email address.</param> /// <param name="password">The password.</param> /// <param name="status">The status.</param> /// <returns>Object of <see cref="User" />.</returns> public User GetUserProfile(int? userId, string emailAddress, string password, Enums.Status status) { using (SqlConnection cn = new SqlConnection(_connectionString)) { using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.StoreProcedure.usp_GetUserProfile, cn, true)) { SqlParameter paramUserId = new SqlParameter(DbConstant.Parameter.Id, userId); cmd.Parameters.Add(paramUserId); User user = null; cn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { if (reader.HasRows) { if (reader.Read()) { user = new User(); user.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.Id]); user.FirstName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.FirstName]); user.LastName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.LastName]); user.Status = (Enums.Status)TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.Status]); user.UserType = (Enums.UserType)TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.UserType]); user.Email = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Email]); user.Password = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Password]); user.ProfileImage = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.ProfileImage]); user.PhoneNumber = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.PhoneNumber]); user.SchoolName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.SchoolName]); user.DateCreated = TypeConversionUtility.ToDateTime(reader[DbConstant.DbColumn.DateCreated]); user.PromoCode = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.PromoCode]); user.SYId = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.SYId]); user.AccountType.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.AccountType]); user.PromoType = (Enums.PromoType)TypeConversionUtility.ToByte(reader[DbConstant.DbColumn.PromoType]); user.IsGiftFree = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsGiftFree]); user.PhoneNumberType = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.PhoneNumberType]); user.Address1 = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Address1]); user.Address2 = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.Address2]); user.City = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.City]); user.ZipCode = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.ZipCode]); user.SchoolDistrict = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.SchoolDistrict]); user.ApprovedVendor = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.ApprovedVendor]); user.IsTaxExempt = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsTaxExempt]); user.TaxExempt = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.TaxExempt]); user.TaxExemptFile = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.TaxExemptFile]); user.AccountCategory.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.AccountCategory]); user.AccountCategory.CategoryName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.CategoryName]); user.AccountCategory.IsOther = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsOtherCategoryName]); user.SchoolCampus.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.SchoolCampusId]); user.SchoolCampus.CampusName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.CampusName]); user.SchoolCampus.IsOther = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsOtherCampus]); user.SchoolType.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.SchoolTypeId]); user.SchoolType.IsOther = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsOtherSchoolType]); user.SchoolType.SchoolTypeName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.SchoolTypeName]); user.State.Id = TypeConversionUtility.ToInteger(reader[DbConstant.DbColumn.StateId]); user.State.StateName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.StateName]); user.State.StateCode = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.StateCode]); user.State.IsOther = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsOtherState]); user.IsSchoolDistrictExempt = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsSchoolDistrictExempt]); user.IsActiveCategory = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsActiveCategory]); user.IsProfile = true; user.IsNotifications = TypeConversionUtility.ToBoolean(reader[DbConstant.DbColumn.IsNotifications]); user.CellPhone = TypeConversionUtility.ToStringWithNull(reader[DbConstant.DbColumn.CellPhone]); } } } return user; } } }