protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Utilities.IsUserLoggedIn())
{
pnl.Visible = true;
Int32 userId = 0;
if (Session["currentUserId"] != null)
{
Int32.TryParse(Session["currentUserId"].ToString(), out userId);
hdnUserId.Value = userId.ToString();
}
}
List <SqlParameter> sqlparameters = new List <SqlParameter>();
DataSet ds = BO.CallSQLProcwithReturnValue("dbo.sp_GetAllHome", sqlparameters.ToArray());
XmlDocument doc = new XmlDocument();
doc.LoadXml(ds.GetXml());
if (ds.Tables.Count > 0)
{
rptHome.DataSource = ds;
rptHome.DataBind();
}
}
catch (Exception)
{
//throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Utilities.IsUserLoggedIn())
{
Response.Redirect("/login.aspx?returnurl=/UserListing.aspx");
}
else
{
Int32 userId = 0;
if (Session["currentUserId"] != null)
{
Int32.TryParse(Session["currentUserId"].ToString(), out userId);
hdnUserId.Value = userId.ToString();
}
}
String storedProc = "dbo.sp_GetAllHome";
List <SqlParameter> sqlparameters = new List <SqlParameter>();
ltrName.Text = "All Homes";
if (Request.QueryString["type"] != null)
{
String homeTypeProc = Request.QueryString["type"];
if (homeTypeProc.Equals("apt"))
{
ltrName.Text = "Apartments";
storedProc = "dbo.sp_GetApartments";
}
else if (homeTypeProc.Equals("home"))
{
storedProc = "dbo.sp_GetHome";
ltrName.Text = "Individual Homes";
}
else if (homeTypeProc.Equals("fav"))
{
ltrName.Text = "User Favorite Homes";
showFav = false;
storedProc = "dbo.sp_GetFavorites";
Int32 userId = 0;
if (Session["currentUserId"] != null)
{
Int32.TryParse(Session["currentUserId"].ToString(), out userId);
}
sqlparameters.Add(new SqlParameter("@user_id", userId));
}
}
DataSet ds = BO.CallSQLProcwithReturnValue(storedProc, sqlparameters.ToArray());
if (ds.Tables.Count > 0)
{
rptHome.DataSource = ds;
rptHome.DataBind();
}
}
private void StartImport()
{
Int32 userId = 0;
Int32 homeId = 0;
if (Session["currentUserId"] != null)
{
Int32.TryParse(Session["currentUserId"].ToString(), out userId);
}
else
{
Response.Redirect("/login.aspx?returnurl=/PostProperty.aspx");
}
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@home_no_of_beds", bed.Text));
parameters.Add(new SqlParameter("@home_no_of_baths", bath.Text));
parameters.Add(new SqlParameter("@home_occupancy", occupancy.Text));
parameters.Add(new SqlParameter("@home_parking", parking.Checked ? 1 : 0));
parameters.Add(new SqlParameter("@home_monthly_rent", rent.Text));
parameters.Add(new SqlParameter("@home_Address", Address1.Text));
parameters.Add(new SqlParameter("@home_city", City.Text));
parameters.Add(new SqlParameter("@home_state", State.Text));
parameters.Add(new SqlParameter("@apartment_flag", apartment.Checked ? 1 : 0));
parameters.Add(new SqlParameter("@home_zipcode", zip.Text));
parameters.Add(new SqlParameter("@home_image", txtfileName));
BO.CallSQLProc("dbo.sp_AddHome", parameters.ToArray());
DataSet ds = BO.CallSQLProcwithReturnValue("dbo.sp_GetLatestHome", new SqlParameter[0]);
XmlDocument doc = new XmlDocument();
doc.LoadXml(ds.GetXml());
if (doc.SelectSingleNode("NewDataSet/Table/Home_ID") != null)
{
Int32.TryParse(doc.SelectSingleNode("NewDataSet/Table/Home_ID").InnerText, out homeId);
}
List <SqlParameter> sqlparameters = new List <SqlParameter>();
sqlparameters.Add(new SqlParameter("@manager_id", userId));
sqlparameters.Add(new SqlParameter("@property_id", homeId));
BO.CallSQLProc("dbo.sp_Lister_and_Property", sqlparameters.ToArray());
Response.Redirect("/propertylisting.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString.HasKeys())
{
if (Request.QueryString["id"] != null)
{
Int32 propertyId = 0;
Int32.TryParse(Request.QueryString["id"], out propertyId);
List <SqlParameter> sqlparameters = new List <SqlParameter>();
sqlparameters.Add(new SqlParameter("@property_id", propertyId));
DataSet ds = BO.CallSQLProcwithReturnValue("dbo.sp_GetProperty", sqlparameters.ToArray());
XmlDocument doc = new XmlDocument();
doc.LoadXml(ds.GetXml());
ltrImage.Text = String.Format("<img src=\"{0}\" style=\"width:100%\"/>", doc.SelectSingleNode("NewDataSet/Table/Home_image").InnerText);
ltrPrice.Text = "$" + doc.SelectSingleNode("NewDataSet/Table/Home_MonthlyRent").InnerText;
ltrBeds.Text = doc.SelectSingleNode("NewDataSet/Table/Home_No_Of_Beds").InnerText + " beds";
lrBath.Text = doc.SelectSingleNode("NewDataSet/Table/Home_No_Of_Baths").InnerText + " baths";
ltroccu.Text = doc.SelectSingleNode("NewDataSet/Table/Home_Occupancy").InnerText;
ltrparking.Text = doc.SelectSingleNode("NewDataSet/Table/Home_Parking").InnerText.Equals("1") ? "Yes" : "No";
ltraddress.Text = doc.SelectSingleNode("NewDataSet/Table/Home_Address").InnerText + " " + doc.SelectSingleNode("NewDataSet/Table/Home_City").InnerText + " " +
doc.SelectSingleNode("NewDataSet/Table/Home_State").InnerText + " " + doc.SelectSingleNode("NewDataSet/Table/Home_Zipcode").InnerText;
}
}
else
{
Response.Redirect("/propertylisting.aspx");
}
}
catch (Exception)
{
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
bool isPageValid = true;
if (Page.IsValid)
{
if (!Utilities.IsValidInput(username.Text.Trim()))
{
sbErrors.Append("The username is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsValidInput(password.Text.Trim()))
{
sbErrors.Append("The username password is invalid!<br/>");
isPageValid = false;
}
if (isPageValid)
{
String sqlFunctionName = String.Empty;
if (radioList.SelectedItem.Value != String.Empty)
{
sqlFunctionName = radioList.SelectedItem.Value;
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@student_pass", password.Text.Trim()));
parameters.Add(new SqlParameter("@student_username", username.Text.Trim()));
bool isUserValidLogin = BO.CallSQLFunction(sqlFunctionName, parameters.ToArray());
if (isUserValidLogin)
{
Session["UserLoggedIn"] = "true";
Session["CurrentUser"] = username.Text.Trim();
Session["currentUserType"] = radioList.SelectedItem.Text.Trim();
String sqlProc = String.Empty;
String property = String.Empty;
String currentUserId = String.Empty;
//get user id and put in session
if (radioList.SelectedItem.Text.Equals("Student"))
{
sqlProc = "dbo.sp_GetStudent";
property = "student_vcu_vNumber";
}
else if (radioList.SelectedItem.Text.Equals("Faculty"))
{
sqlProc = "dbo.sp_GetFaculty";
property = "faculty_vcu_vNumber";
}
else
{
sqlProc = "dbo.sp_GetPropertyLister";
property = "property_lister_ID";
}
List <SqlParameter> sqlparameters = new List <SqlParameter>();
sqlparameters.Add(new SqlParameter("@student_Username", username.Text.Trim()));
DataSet ds = BO.CallSQLProcwithReturnValue(sqlProc, sqlparameters.ToArray());
XmlDocument doc = new XmlDocument();
doc.LoadXml(ds.GetXml());
if (doc.SelectSingleNode("NewDataSet/Table/" + property) != null)
{
currentUserId = doc.SelectSingleNode("NewDataSet/Table/" + property).InnerText;
Session["currentUserId"] = currentUserId;
}
if (Request.QueryString["returnurl"] != null)
{
Response.Redirect(Request.QueryString["returnurl"]);
}
if (radioList.SelectedItem.Text.Equals("Property Manager"))
{
Response.Redirect("/PropertyListing.aspx");
}
else
{
Response.Redirect("/UserListing.aspx");
}
}
else
{
sbErrors.Append("please check the username and password!<br/>");
}
}
else
{
sbErrors.Append("please select the user type to login!<br/>");
}
}
}
ltrErrors.Text = sbErrors.ToString();
}
protected void registerButton_Click(object sender, EventArgs e)
{
bool isPageValid = true;
if (Page.IsValid)
{
if (!Utilities.IsValidInput(username.Text))
{
sbErrors.Append("The username is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsValidInput(txtPassword.Text))
{
sbErrors.Append("The username password is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsValidInput(first_name.Text))
{
sbErrors.Append("The first is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsValidInput(last_name.Text))
{
sbErrors.Append("The lastname is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsEmailValidInput(email.Text))
{
sbErrors.Append("The email is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsValidInput(phone.Text))
{
sbErrors.Append("The Phone is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsValidInput(fax.Text))
{
sbErrors.Append("The Fax is invalid!<br/>");
isPageValid = false;
}
if (!Utilities.IsValidInput(vcu.Text))
{
sbErrors.Append("The VCU number is invalid!<br/>");
isPageValid = false;
}
if (isPageValid)
{
if (!radioList.SelectedItem.Text.Equals("Property Manager"))
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@student_id", vcu.Text));
parameters.Add(new SqlParameter("@student_email", email.Text));
bool isUserValid = BO.CallSQLFunction("dbo.IsValidVCUMember", parameters.ToArray());
if (!isUserValid)
{
sbErrors.Append("The VCU number is invalid!<br/>");
isPageValid = false;
}
}
}
if (isPageValid)
{
//create user account
List <SqlParameter> parameters = new List <SqlParameter>();
if (radioList.SelectedItem.Text.Equals("Student"))
{
parameters.Add(new SqlParameter("@student_id", vcu.Text));
parameters.Add(new SqlParameter("@student_password", txtPassword.Text));
parameters.Add(new SqlParameter("@student_username", username.Text));
parameters.Add(new SqlParameter("@student_lastname", last_name.Text));
parameters.Add(new SqlParameter("@student_firstname", first_name.Text));
parameters.Add(new SqlParameter("@student_MobilePhoneNumber", phone.Text));
parameters.Add(new SqlParameter("@student_gradeLevel", fax.Text));
parameters.Add(new SqlParameter("@student_email", email.Text));
parameters.Add(new SqlParameter("@student_Gender", referencedfrom.SelectedItem.Text.Equals("Please Select") ? "" : referencedfrom.SelectedItem.Text));
BO.CallSQLProc("dbo.sp_AddStudent", parameters.ToArray());
}
else if (radioList.SelectedItem.Text.Equals("Faculty"))
{
parameters.Add(new SqlParameter("@faculty_vcu_vNumber", vcu.Text));
parameters.Add(new SqlParameter("@faculty_Password", txtPassword.Text));
parameters.Add(new SqlParameter("@faculty_Username", username.Text));
parameters.Add(new SqlParameter("@faculty_lastName", last_name.Text));
parameters.Add(new SqlParameter("@faculty_firstName", first_name.Text));
parameters.Add(new SqlParameter("@faculty_MobilePhoneNumber", phone.Text));
parameters.Add(new SqlParameter("@faculty_Gender", referencedfrom.SelectedItem.Text.Equals("Please Select") ? "" : referencedfrom.SelectedItem.Text));
parameters.Add(new SqlParameter("@faculty_email", email.Text));
BO.CallSQLProc("dbo.sp_AddFaculty", parameters.ToArray());
}
else
{
parameters.Add(new SqlParameter("@propertyLister_password", txtPassword.Text));
parameters.Add(new SqlParameter("@propertyLister_username", username.Text));
parameters.Add(new SqlParameter("@propertyLister_lastname", last_name.Text));
parameters.Add(new SqlParameter("@propertyLister_firstname", first_name.Text));
parameters.Add(new SqlParameter("@propertyLister_MobilePhoneNumber", phone.Text));
parameters.Add(new SqlParameter("@propertyLister_email", email.Text));
BO.CallSQLProc("dbo.sp_AddPropertyLister", parameters.ToArray());
}
Session["UserLoggedIn"] = "true";
Session["CurrentUser"] = username.Text.Trim();
Session["currentUserType"] = radioList.SelectedItem.Text.Trim();
String sqlProc = String.Empty;
String property = String.Empty;
String currentUserId = String.Empty;
//get user id and put in session
if (radioList.SelectedItem.Text.Equals("Student"))
{
sqlProc = "dbo.sp_GetStudent";
property = "student_vcu_vNumber";
}
else if (radioList.SelectedItem.Text.Equals("Faculty"))
{
sqlProc = "dbo.sp_GetFaculty";
property = "faculty_vcu_vNumber";
}
else
{
sqlProc = "dbo.sp_GetPropertyLister";
property = "property_lister_ID";
}
List <SqlParameter> sqlparameters = new List <SqlParameter>();
sqlparameters.Add(new SqlParameter("@student_Username", username.Text.Trim()));
DataSet ds = BO.CallSQLProcwithReturnValue(sqlProc, sqlparameters.ToArray());
XmlDocument doc = new XmlDocument();
doc.LoadXml(ds.GetXml());
if (doc.SelectSingleNode("NewDataSet/Table/" + property) != null)
{
currentUserId = doc.SelectSingleNode("NewDataSet/Table/" + property).InnerText;
Session["currentUserId"] = currentUserId;
}
if (Request.QueryString["returnurl"] != null)
{
Response.Redirect(Request.QueryString["returnurl"]);
}
if (radioList.SelectedItem.Text.Equals("Property Manager"))
{
Response.Redirect("/PropertyListing.aspx");
}
else
{
Response.Redirect("/UserListing.aspx");
}
}
ltrError.Text = sbErrors.ToString();
}
}