public void LoadLandlordData(User user_)
{
UserDAO userDAO = new UserDAO();
if (user_.HouseId != null)
{
DataSet LandlordData = userDAO.SelectLandlordByHouseId(user.HouseId.Value);
if (LandlordData != null && LandlordData.Tables[0].Rows.Count > 0)
{
string FirstName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim();
string MiddleName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim();
string LastName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim();
Name.Text = FirstName + " " + MiddleName + " " + LastName;
Email.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim();
Mobile.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim();
}
}
else if (user_.BaseHouseRoomId != null)
{
DataSet LandlordData = userDAO.SelectLandlordByBaseHouseRoomId(user.BaseHouseRoomId.Value);
if (LandlordData != null && LandlordData.Tables[0].Rows.Count > 0)
{
string FirstName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim();
string MiddleName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim();
string LastName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim();
Name.Text = FirstName + " " + MiddleName + " " + LastName;
Email.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim();
Mobile.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim();
}
}
}
public void LoadUserData()
{
// user data
UserDAO userDAO = new UserDAO();
user = User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
if (user.HouseId != null)
{
Labelmessage.Text = "";//Current landload Details";
DataSet LandlordData = userDAO.SelectLandlordByHouseId(user.HouseId.Value);
if(LandlordData != null && LandlordData.Tables[0].Rows.Count > 0)
{
PassID(Guid.Parse(LandlordData.Tables[0].Rows[0]["UserId"].ToString().Trim()));
ButtonVerify.Visible = false;
Email.Enabled = false;
FirstName.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim();
MiddleName.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim();
LastName.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim();
Email.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim();
// Mobile.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim();
MobileArea.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Substring(0, 3);
Mobile1.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Substring(3, 3);
Mobile2.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Substring(6, 4);
}
}
}
public void loadHouseDatadata(User user_)
{
if (user_.HouseId != null && user_.HouseId != Guid.Empty)
{
UserDAO userDAO = new UserDAO();
DataSet LandlordData = userDAO.SelectLandlordByHouseId(user_.HouseId.Value);
if (LandlordData != null && LandlordData.Tables[0].Rows.Count > 0)
{
hdLandloadId.Value = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim();
}
DataSet ds = new DataSet();
ds = new HouseDAO().SelectAllDataset(Guid.Parse(hdLandloadId.Value));
ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns["HouseId"] };
if (DrpHouse.Items.Count < 1)
{
DrpHouse.DataSource = ds;
DrpHouse.DataTextField = "StreetAddress";
DrpHouse.DataValueField = "HouseId";
DrpHouse.DataBind();
DrpHouse.Items.Insert(0, new ListItem(Constants.DROPDOWN_EMPTY_ITEM_TEXT, Constants.DROPDOWN_EMPTY_ITEM_VALUE));
}
HouseEdit.Visible = true;
// set selected house
if (user_.HouseId.HasValue)
{
for (int i = 0; i < DrpHouse.Items.Count; i++)
{
if (DrpHouse.Items[i].Value.ToString().ToLower() == user_.HouseId.ToString().ToLower())
{
DrpHouse.ClearSelection();
DrpHouse.Items[i].Selected = true;
}
}
}
House houseData = House.Select(user_.HouseId.Value);
if (houseData != null)
{
if (houseData.IsPartialHouse == true)
{
// HouseSearch.Visible = true;
chknotavailable.Visible = true;
DrpHouse.Enabled = true;
EnableEdit();
if (houseData.StateId.HasValue)
{
for (int i = 0; i < Drpstate.Items.Count; i++)
{
if (Drpstate.Items[i].Value.ToString().ToLower() == houseData.StateId.ToString().ToLower())
{
Drpstate.ClearSelection();
Drpstate.Items[i].Selected = true;
}
}
State state;
state = Generic.Get<State>(houseData.StateId.Value);
if (state != null)
{
State.Text = state.StateName;
}
}
Address.Text = houseData.StreetAddress;
City.Text = houseData.City;
Zip.Text = houseData.Zip;
RentalAddress.Text = houseData.StreetAddress;
RentalCity.Text = houseData.City;
RentalZip.Text = houseData.Zip;
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNotPartialHouse + "'); window.location = '/Student/Student_Profile_Current_House_Details.aspx';}", true);
}
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNoRecords + "'); window.location = '/Student/Student_Profile_Current_House.aspx';}", true);
}
}
public void LoadUserData()
{
UserDAO userDAO = new UserDAO();
if (Membership.GetUser() == null)
{
return;
}
user = RHP.UserManagement.User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
if (user.HouseId != null || user.BaseHouseRoomId != null)
{
LoadLandlordData(user);
LoadHouseData(user);
LoadStudentData(user);
}
else
{
if (!IsFromWizard)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNoRecords + "'); window.location = '/Student/Student_Profile_Current_House.aspx';}", true);
}
}
}
public void loaddata()
{
if (LandlordId != null)
{
house.LandlordId = LandlordId.Value;
if (DrpHouse.Items.Count < 1)
{
DrpHouse.DataSource = dsHouseList;
DrpHouse.DataTextField = "StreetAddress";
DrpHouse.DataValueField = "HouseId";
DrpHouse.DataBind();
DrpHouse.Items.Insert(0, new ListItem(Constants.DROPDOWN_EMPTY_ITEM_TEXT, Constants.DROPDOWN_EMPTY_ITEM_VALUE));
}
}
UserDAO userDAO = new UserDAO();
user = User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
if (user.HouseId != null)
{
// set selected house
if (user.HouseId.HasValue)
{
for (int i = 0; i < DrpHouse.Items.Count; i++)
{
if (DrpHouse.Items[i].Value.ToString().ToLower() == user.HouseId.ToString().ToLower())
{
DrpHouse.ClearSelection();
DrpHouse.Items[i].Selected = true;
}
}
}
House house = House.Select(user.HouseId.Value);
if (house != null)
{
HouseSearch.Visible = false;
chknotavailable.Visible = false;
DrpHouse.Enabled = false;
Drpstate.Enabled = false;
PassHouseID(house.HouseId.Value);
// set selected house details
if (house.StateId.HasValue)
{
for (int i = 0; i < Drpstate.Items.Count; i++)
{
if (Drpstate.Items[i].Value.ToString().ToLower() == house.StateId.ToString().ToLower())
{
Drpstate.ClearSelection();
Drpstate.Items[i].Selected = true;
}
}
}
Address.Text = house.StreetAddress;
City.Text = house.City;
Zip.Text = house.Zip;
}
}
}
public void LoadUserData()
{
UserDAO userDAO = new UserDAO();
User user = RHP.UserManagement.User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
if (user.HouseId != null)
{
// LoadHouseData(user);
loadHouseDatadata(user);
hdHouseId.Value = user.HouseId.Value.ToString();
hdUserID.Value = user.UserId.Value.ToString();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNoRecords + "'); window.location = '/Student/Student_Profile_Current_House.aspx';}", true);
}
}
public void LoadUserData()
{
UserDAO userDAO = new UserDAO();
User user = RHP.UserManagement.User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
if (user.HouseId != null)
{
LoadLandlordData(user);
//if ((user.UserId.HasValue && user.IsPartialUser == true) && (user.AspnetUserId.HasValue == null || user.AspnetUserId == Guid.Empty))
//{
//}
//else
//{
// Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNotPartialUser + "'); window.location = '/Student/Student_Profile_Update_Current_House.aspx';}", true);
//}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNoRecords + "'); window.location = '/Student/Student_Profile_Current_House.aspx';}", true);
}
}
public void LoadLandlordData(User user_)
{
UserDAO userDAO = new UserDAO();
if (user_.HouseId != null)
{
DataSet LandlordData = userDAO.SelectLandlordByHouseId(user_.HouseId.Value);
if (LandlordData != null && LandlordData.Tables[0].Rows.Count > 0)
{
string IspartialUser = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["IsPartialUser"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["IsPartialUser"].ToString().Trim();
string AspnetUserId = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["AspnetUserId"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["AspnetUserId"].ToString().Trim();
if (IspartialUser.ToLower() == "true" && (AspnetUserId == "" || AspnetUserId == string.Empty))
{
hdLandloadId.Value = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim();
string FirstName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim();
string MiddleName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim();
string LastName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim();
lbName.Text = FirstName + " " + MiddleName + " " + LastName;
lbEmail.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim();
lbMobile.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim();
LandloadEmail.Text = lbEmail.Text;
LandloadFirstName.Text = FirstName;
LandloadMiddleName.Text = MiddleName;
LandloadLastName.Text = LastName;
LandloadMobileArea.Text = string.IsNullOrEmpty(lbMobile.Text) ? string.Empty : lbMobile.Text.Substring(0, 3);
LandloadMobile1.Text = string.IsNullOrEmpty(lbMobile.Text) ? string.Empty : lbMobile.Text.Substring(3, 3);
LandloadMobile2.Text = string.IsNullOrEmpty(lbMobile.Text) ? string.Empty : lbMobile.Text.Substring(6, 4);
LandloadEdit.Visible = true;
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNotPartialUser + "'); window.location = '/Student/Student_Profile_Update_Current_House.aspx';}", true);
}
}
}
}
// Landload info
public void LoadLandlordData(User user_)
{
UserDAO userDAO = new UserDAO();
if (user_.HouseId != null || user_.BaseHouseRoomId != null)
{
DataSet LandlordData;
if (user_.HouseId != null)
{
LandlordData = userDAO.SelectLandlordByHouseId(user.HouseId.Value);
}
else
{
LandlordData = userDAO.SelectLandlordByBaseHouseRoomId(user.BaseHouseRoomId.Value);
}
if (LandlordData != null && LandlordData.Tables[0].Rows.Count > 0)
{
string IspartialUser = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["IsPartialUser"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["IsPartialUser"].ToString().Trim();
string AspnetUserId = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["AspnetUserId"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["AspnetUserId"].ToString().Trim();
if (IspartialUser.ToLower() == "true" && (AspnetUserId == "" || AspnetUserId == string.Empty))
{
EditLandloadInfoLink.Visible = true;
}
else
{
EditLandloadInfoLink.Visible = true;
}
hdLandloadId.Value = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LandlordId"].ToString().Trim();
string FirstName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["FirstName"].ToString().Trim();
string MiddleName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["MiddleName"].ToString().Trim();
string LastName = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["LastName"].ToString().Trim();
lbName.Text = FirstName + " " + MiddleName + " " + LastName;
lbEmail.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["PersonalEmail"].ToString().Trim();
lbMobile.Text = string.IsNullOrEmpty(LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim()) ? string.Empty : LandlordData.Tables[0].Rows[0]["BestContactNumber"].ToString().Trim();
}
}
}
public bool UpdateHouse()
{
bool result = false;
Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
UserDAO userDao = new UserDAO();
if (userDao.IsUserExist(this))
{
result = (new UserDAO()).UpdateHouse(this, db, transaction);
}
else
{
result = false;
}
transaction.Commit();
}
catch (System.Exception ex)
{
transaction.Rollback();
result = false;
throw ex;
}
finally
{
connection.Close();
}
return result;
}
public void LoadUserData()
{
UserDAO userDAO = new UserDAO();
// user = RHP.UserManagement.User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
if (user.HouseId != null)
{
ButtonLeaveHouseID.Visible = true;
LoadStudentByHouseId(user.HouseId.Value);
LoadLeaveCurrentHouseRequest(user.HouseId.Value);
}
else if (user.BaseHouseRoomId != null)
{
ButtonLeaveHouseID.Visible = true;
LoadStudentByBaseHouseRoomId(user.BaseHouseRoomId.Value);
LoadLeaveCurrentRoomRequest(user.BaseHouseRoomId.Value);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.CurrentHouseNoRecords + "'); window.location = '/Student/Student_Profile_Current_House.aspx';}", true);
}
}
