public bool Delete(Landlord landlord, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_LandlordDelete");
db.AddInParameter(command, "LandlordId", DbType.Guid, landlord.LandlordId);
db.ExecuteNonQuery(command, transaction);
return true;
}
public bool Delete(Landlord landlord, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_LandlordDelete");
db.AddInParameter(command, "LandlordId", DbType.Guid, landlord.LandlordId);
db.ExecuteNonQuery(command, transaction);
return(true);
}
public Landlord GetLandlordByRoomId(Guid roomId)
{
Landlord returnLandlord = new Landlord();
Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING);
DbCommand dbCommand = db.GetStoredProcCommand("usp_HouseSelect");
db.AddInParameter(dbCommand, "HouseId", DbType.Guid, roomId);
return returnLandlord;
}
/// <summary>
/// Checks if user record with UserId exist in User table of the database.
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool IsLandlordExist(Landlord landlord)
{
Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING);
DbCommand command = db.GetStoredProcCommand("usp_Landlord_IsLandlordExist");
db.AddInParameter(command, "LandlordId", DbType.Guid, landlord.LandlordId);
db.AddOutParameter(command, "IsExist", DbType.Boolean, 1);
db.ExecuteNonQuery(command);
return Convert.ToBoolean(db.GetParameterValue(command, "IsExist").ToString());
}
/// <summary>
/// Checks if user record with UserId exist in User table of the database.
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool IsLandlordExist(Landlord landlord)
{
Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING);
DbCommand command = db.GetStoredProcCommand("usp_Landlord_IsLandlordExist");
db.AddInParameter(command, "LandlordId", DbType.Guid, landlord.LandlordId);
db.AddOutParameter(command, "IsExist", DbType.Boolean, 1);
db.ExecuteNonQuery(command);
return(Convert.ToBoolean(db.GetParameterValue(command, "IsExist").ToString()));
}
public bool Update(Landlord landlord, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_LandlordUpdate");
db.AddInParameter(command, "LandlordId", DbType.Guid, landlord.LandlordId);
db.AddInParameter(command, "UserId", DbType.Guid, landlord.user.UserId);
db.AddInParameter(command, "LandlordName", DbType.String, landlord.LandlordName);
db.AddInParameter(command, "IsDeleted", DbType.Boolean, landlord.IsDeleted);
db.AddInParameter(command, "UpdatedBy", DbType.Guid, landlord.UpdatedBy);
db.AddInParameter(command, "LandlordTypeId", DbType.Int32, landlord.LandlordTypeId);
db.AddOutParameter(command, "UpdatedDate", DbType.DateTime, 30);
db.ExecuteNonQuery(command, transaction);
landlord.CreatedDate = Convert.ToDateTime(db.GetParameterValue(command, "UpdatedDate").ToString());
landlord.UpdatedDate = landlord.CreatedDate;
return true;
}
public bool Update(Landlord landlord, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_LandlordUpdate");
db.AddInParameter(command, "LandlordId", DbType.Guid, landlord.LandlordId);
db.AddInParameter(command, "UserId", DbType.Guid, landlord.user.UserId);
db.AddInParameter(command, "LandlordName", DbType.String, landlord.LandlordName);
db.AddInParameter(command, "IsDeleted", DbType.Boolean, landlord.IsDeleted);
db.AddInParameter(command, "UpdatedBy", DbType.Guid, landlord.UpdatedBy);
db.AddInParameter(command, "LandlordTypeId", DbType.Int32, landlord.LandlordTypeId);
db.AddOutParameter(command, "UpdatedDate", DbType.DateTime, 30);
db.ExecuteNonQuery(command, transaction);
landlord.CreatedDate = Convert.ToDateTime(db.GetParameterValue(command, "UpdatedDate").ToString());
landlord.UpdatedDate = landlord.CreatedDate;
return(true);
}
public static Landlord SelectByBaseHouseRoomId(Guid BaseHouseRoomId)
{
Landlord landlord = Generic.GetByFieldValue <Landlord>("BaseHouseRoomId", BaseHouseRoomId.ToString());
return(landlord);
}
public static Landlord Select(Guid Userid)
{
Landlord landlord = Generic.GetByFieldValue <Landlord>("Userid", Userid.ToString());
return(landlord);
}
public bool SaveLandload()
{
bool result = true;
aspnet_Roles aspnet_Roles_ = new aspnet_Roles();
Landlord landload = new Landlord();
aspnet_Roles_ = aspnet_Roles.Select("landlord");
User Landlorduser = new User();
if (hdLandloadId.Value != null && hdLandloadId.Value != string.Empty)
{
Landlorduser.UserId = Guid.Parse(hdLandloadId.Value);
Landlorduser.PersonalEmail = LandloadEmail.Text.Trim();
Landlorduser.FirstName = LandloadFirstName.Text.Trim();
Landlorduser.MiddleName = LandloadMiddleName.Text.Trim();
Landlorduser.LastName = LandloadLastName.Text.Trim();
Landlorduser.BestContactNumber = LandloadMobileArea.Text.Trim() + LandloadMobile1.Text.Trim() + LandloadMobile2.Text.Trim();//Mobile.Text.Trim();
Landlorduser.CreatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
Landlorduser.UpdatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
Landlorduser.IsPartialUser = true;
Landlorduser.RoleId = aspnet_Roles_.RoleId;
Landlorduser.UpdatedDate = DateTime.Now;
if (Landlorduser.Save())
{
landload.user = Landlorduser;
landload.LandlordId = Landlorduser.UserId.HasValue ? Landlorduser.UserId.Value : Landlorduser.UserId.Value;
landload.LandlordName = Landlorduser.FirstName + " " + Landlorduser.MiddleName + " " + Landlorduser.LastName;
landload.CreatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
landload.UpdatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
result = landload.Save();
string strMsgContent = Landloadmessage(Landlorduser.UserId.Value, Landlorduser);
string strMsgTitle = SystemConfig.GetValue(RHP.Common.Enums.SystemConfig.SITEURL) + " is Requesting you to join with Us.";
int rtn = LandloadSendEmail(Landlorduser.PersonalEmail, strMsgTitle, strMsgContent);
if (rtn == 1)
{
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "Redirect", "window.onload = function(){ alert('" + Messages.Save_Success + "'); window.location = '/Student/Student_Profile_Update_Current_House.aspx';}", true);
}
}
else
{
LandloadLabelmessage.Text = "Landlord Details cannot saved.Please try again!";
// no Landload id
}
return result;
}
public void LoadUserData()
{
// user data
user = User.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
user.UserId = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
user.AspnetUserId = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
FirstName.Text = string.IsNullOrEmpty(user.FirstName) ? string.Empty : user.FirstName;
MiddleName.Text = string.IsNullOrEmpty(user.MiddleName) ? string.Empty : user.MiddleName;
LastName.Text = string.IsNullOrEmpty(user.LastName) ? string.Empty : user.LastName;
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;
MobileArea.Text = string.IsNullOrEmpty(user.BestContactNumber) ? string.Empty : user.BestContactNumber.Substring(0, 3);
Mobile1.Text = string.IsNullOrEmpty(user.BestContactNumber) ? string.Empty : user.BestContactNumber.Substring(3, 3);
Mobile2.Text = string.IsNullOrEmpty(user.BestContactNumber) ? string.Empty : user.BestContactNumber.Substring(6, 4);
DOB.Text = string.IsNullOrEmpty(user.DateOfBirth.ToString()) ? string.Empty : user.DateOfBirth.Value.ToShortDateString();
if (user.StateId.HasValue)
{
for (int i = 0; i < Drpstate.Items.Count; i++)
{
if (Drpstate.Items[i].Value.ToString().ToLower() == user.StateId.ToString().ToLower())
{
Drpstate.ClearSelection();
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.ClearSelection();
DrpGender.Items[i].Selected = true;
}
}
}
landload = Landlord.Select(Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()));
}
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 Guid SaveLandload(int baseHouseId)
{
Guid landlordId;
List<BaseHouse> dormHouses = BaseHouseDAO.SelectAllByHouseTypeId(HouseTypeId);
CurrentHouse = dormHouses.Find(bh => bh.BaseHouseId == baseHouseId);
if (CurrentHouse.LandlordId.HasValue)
{
landlordId = CurrentHouse.LandlordId.Value;
}
else
{
aspnet_Roles aspnet_Roles_ = new aspnet_Roles();
Landlord landload = new Landlord();
aspnet_Roles_ = aspnet_Roles.Select("landlord");
User Landlorduser = new User();
Landlorduser.UserId = Guid.NewGuid();
landlordId = Landlorduser.UserId.Value;
Landlorduser.PersonalEmail = CurrentHouse.ManagerEmail;
Landlorduser.FirstName = CurrentHouse.PropertyManagementCompanyName;
Landlorduser.BestContactNumber = CurrentHouse.PhoneNumber;
Landlorduser.CreatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
Landlorduser.UpdatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
Landlorduser.IsPartialUser = true;
Landlorduser.RoleId = aspnet_Roles_.RoleId;
Landlorduser.UpdatedDate = DateTime.Now;
if (Landlorduser.Save())
{
landload.user = Landlorduser;
landload.LandlordId = Landlorduser.UserId.Value;
landload.LandlordName = Landlorduser.FirstName;
landload.IsDeleted = false;
landload.LandlordTypeId = (int)Enums.LandlordType.CorporateLandlord;
landload.CreatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
landload.UpdatedBy = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
if (landload.Save())
{
//Todo: Update the basehouse table with the new LandlordId
CurrentHouse.LandlordId = landlordId;
CurrentHouse.CreatedBy = Membership.GetUser().UserName;
CurrentHouse.UpdatedBy = Membership.GetUser().UserName;
if (CurrentHouse.Save())
{
//Base House is updated with new landlord id
}
}
}
}
return landlordId;
}
