private void BindGridView()
{
try
{
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
Post post = new Post();
User user = new User();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
var postDetails = houseRent.Posts.Where(a => (a.CreatedBy == emailCheck.id)).FirstOrDefault();
var postDetails1 = (from x in houseRent.Posts select x).Where(a => (a.CreatedBy == emailCheck.id) && (a.isDeleted == 0)).ToList();
if (postDetails1.Count == 0)
{
lblPostMessage.Text = "No Posts to Display";
}
else
{
GridView1.DataSource = postDetails1;
GridView1.DataBind();
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void BindGridView()
{
try
{
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
Post post = new Post();
User user = new User();
//var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
//var postDetails = houseRent.Posts.Where(a => (a.CreatedBy == emailCheck.id)).FirstOrDefault();
//var postDetails1 = (from x in houseRent.Posts select x).ToList();
var postDetails = (from a in houseRent.Posts
select new
{
Id = a.Id,
HouseName = a.HouseName,
Rent = a.Rent,
Image = a.Image,
}
).DefaultIfEmpty().ToList();
//var postDetails = houseRent.Posts.ToList();
GridView1.DataSource = postDetails;
GridView1.DataBind();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Registration registration = new Registration();
string message = registration.RetrieveUser(email.Text, password.Text);
if (registration.flag == true)
{
lblmessage.Text = message;
}
else
{
Session["id"] = 1;
Session["email"] = email.Text;
Session["password"] = password.Text;
HouseRentEntities houseRent = new HouseRentEntities();
User user = new User();
var emailCheck = houseRent.Users.Where(a => a.Email.ToLower() == email.Text.ToLower()).FirstOrDefault();
Session["UserRoleId"] = emailCheck.UserRoleId;
if (emailCheck.UserRoleId == 1)
{
Response.Redirect("CustomerPage.aspx");
}
else
{
Response.Redirect("SellerPage.aspx");
}
Session.RemoveAll();
}
}
private void BindGridView()
{
try
{
string email = Session["email"].ToString();
int postId = Convert.ToInt32(Session["postId"]);
HouseRentEntities houseRent = new HouseRentEntities();
Post post = new Post();
User user = new User();
UserPost userPost = new UserPost();
var userPostDetails = houseRent.UserPosts.Where(a => a.PostId == postId).DefaultIfEmpty();
var userDetails = (from a in houseRent.Users
join b in userPostDetails on a.id equals b.RequestedUserId
select new
{
statusId = b.PostStatus,
postId = postId,
userId = a.id,
Name = a.FirstName + " " + a.LastName,
Email = a.Email,
PhoneNumber = a.PhoneNumber,
Status = b.Status.StatusDescription
}
).ToList();
GridView1.DataSource = userDetails;
GridView1.DataBind();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
protected void btnupload_Click(object sender, EventArgs e)
{
int length = FileUpload1.PostedFile.ContentLength;
byte[] pic = new byte[length];
FileUpload1.PostedFile.InputStream.Read(pic, 0, length);
string email = "*****@*****.**";
HouseRentEntities houseRent = new HouseRentEntities();
User user = new User();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
try
{
emailCheck.Images = pic;
houseRent.SaveChanges();
Label1.Visible = true;
Label1.Text = "Image Uploaded Sucessfully"; //after Sucessfully uploaded image
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
finally
{
byte[] bytes = emailCheck.Images;
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
Image1.ImageUrl = "data:image/png;base64," + base64String;
}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
Post post = new Post();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
var postDetails = houseRent.Posts.Where(a => (a.CreatedBy == emailCheck.id)).FirstOrDefault();
postDetails.isDeleted = 1;
houseRent.SaveChanges();
Response.Redirect("ViewAdd.aspx");
}
protected void EditButton_Click(object sender, EventArgs e)
{
lblFirst.Visible = false;
txtFirst.Visible = true;
lbllast.Visible = false;
txtLast.Visible = true;
lblPhn.Visible = false;
txtPhn.Visible = true;
lblEmail.Text = Session["email"].ToString();
lblLocation.Visible = false;
txtLocation.Visible = true;
lblPass.Visible = true;
lblConfirmPass.Visible = true;
txtPassword.Visible = true;
txtConfirm.Visible = true;
lblUpload.Visible = true;
FileUpload1.Visible = true;
BtnUpload.Visible = true;
HouseRentEntities houseRent = new HouseRentEntities();
User user = new User();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
txtFirst.Text = emailCheck.FirstName;
txtLast.Text = emailCheck.LastName;
txtPhn.Text = emailCheck.PhoneNumber;
txtPassword.Text = emailCheck.Password;
txtConfirm.Text = emailCheck.Password;
if (emailCheck.UserRoleId == 1)
{
lblUser.Text = "Customer";
}
else
{
lblUser.Text = "Seller";
}
if (emailCheck.Location == null)
{
txtLocation.Text = "Not Specified";
}
else
{
txtLocation.Text = emailCheck.Location;
}
SaveButton.Visible = true;
EditButton.Visible = false;
}
protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnkBtn = (LinkButton)e.Row.FindControl("BtnBookHouse");
Label lblStatus = (Label)e.Row.FindControl("lblStatus");
int postId = Convert.ToInt32(GridView1.DataKeys[e.Row.RowIndex].Values[0]);
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
UserPost userPost = houseRent.UserPosts.FirstOrDefault(i => i.PostId == postId && i.RequestedUserId == emailCheck.id);
if (userPost != null && (userPost.PostStatus == 1 || userPost.PostStatus == 2))
{
lblStatus.Text = userPost.Status.StatusDescription;
lnkBtn.Visible = false;
}
}
}
public void GetProfilePicture()
{
email = Session["email"].ToString();
string base64String;
HouseRentEntities houseRent = new HouseRentEntities();
User user = new User();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
byte[] bytes = emailCheck.Images;
if (bytes != null)
{
base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
Image1.ImageUrl = "data:image/png;base64," + base64String;
}
else
{
Image1.ImageUrl = "http://ssl.gstatic.com/accounts/ui/avatar_2x.png";
}
}
protected void BtnReject_Click(object sender, EventArgs e)
{
int rowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex;
//Get the value of column from the DataKeys using the RowIndex.
int id = Convert.ToInt32(GridView1.DataKeys[rowIndex].Values[0]);
int userId = Convert.ToInt32(GridView1.DataKeys[rowIndex].Values[2]);
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
//User user = houseRent.Users.First(i => i.Email == email);
UserPost userPost = houseRent.UserPosts.First(i => i.PostId == id && i.RequestedUserId == userId);
userPost.PostStatus = 3;
userPost.UpdatedDate = DateTime.Now;
userPost.UpdatedBy = emailCheck.id;
houseRent.SaveChanges();
Response.Redirect("ViewRequestedUsers.aspx");
}
public void GetProfileDetails()
{
email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
User user = new User();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
string userName = emailCheck.FirstName + " " + emailCheck.LastName;
lblUserName.Text = userName;
lblFirst.Visible = true;
txtFirst.Visible = false;
lbllast.Visible = true;
txtLast.Visible = false;
lblPhn.Visible = true;
txtPhn.Visible = false;
lblEmail.Text = Session["email"].ToString();
lblLocation.Visible = true;
txtLocation.Visible = false;
lblFirst.Text = emailCheck.FirstName;
lbllast.Text = emailCheck.LastName;
lblPhn.Text = emailCheck.PhoneNumber;
if (emailCheck.UserRoleId == 1)
{
lblUser.Text = "Customer";
userType = "Customer";
}
else
{
lblUser.Text = "Seller";
userType = "Seller";
}
if (emailCheck.Location == null)
{
lblLocation.Text = "Not Specified";
}
else
{
lblLocation.Text = emailCheck.Location;
}
}
private void BindGridView()
{
try
{
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
Post post = new Post();
User user = new User();
UserPost userPost = new UserPost();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
//var postdetailsCheck = houseRent.UserPosts.Where(a => a.RequestedUserId == emailCheck.id).Select(a=> a.PostId).;
var postdetailsCheck = (from x in houseRent.UserPosts select x).Where(a => a.RequestedUserId == emailCheck.id).DefaultIfEmpty();
//var postDetails = houseRent.Posts.Where(a => (a.Id == postdetailsCheck.)).ToList();
//var postDetails = (from x in houseRent.Posts select x).Where(x => (x.Id == postdetailsCheck.Where(a=> a.PostId));
var postDetails = (from a in houseRent.Posts
join b in postdetailsCheck on a.Id equals b.PostId
select new
{
Id = a.Id,
HouseName = a.HouseName,
Rent = a.Rent,
Image = a.Image,
Status = b.Status.StatusDescription,
statusId = b.PostStatus
}
).ToList();
GridView1.DataSource = postDetails;
GridView1.DataBind();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
Post post = new Post();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
post.HouseName = txtHouse.Text;
post.Address = txtAddress.Text;
post.PhoneNumber = txtPhoneNumber.Text;
post.Floor = Convert.ToInt32(txtFloor.Text);
post.Bedroom = Convert.ToInt32(ddBedRoom.SelectedValue);
if (rbKitchenYes.Checked)
{
post.Kitchen = true;
}
else
{
post.Kitchen = false;
}
if (rbDiningYes.Checked)
{
post.Dining = true;
}
else
{
post.Dining = false;
}
if (rbFamilyYes.Checked)
{
post.Family = "Yes";
}
else
{
post.Family = "No";
}
if (rbBachelorYes.Checked)
{
post.Bachelor = "Yes";
}
else
{
post.Bachelor = "No";
}
if (rbOfficeYes.Checked)
{
post.Office = "Yes";
}
else
{
post.Office = "No";
}
post.CreatedDate = DateTime.Now;
post.CreatedBy = emailCheck.id;
post.UpdatedDate = null;
post.Rent = Convert.ToInt32(txtRent.Text);
if (txtAdditional.Text != "")
{
post.Additional = txtAdditional.Text;
}
int length = fuImage.PostedFile.ContentLength;
byte[] pic = new byte[length];
fuImage.PostedFile.InputStream.Read(pic, 0, length);
post.Image = pic;
houseRent.Posts.Add(post);
houseRent.SaveChanges();
lblMessage.Text = "Post Saved Successfully";
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
protected void SendEmail(object sender, EventArgs e)
{
string username = string.Empty;
string password = string.Empty;
//string username = "******";
//string password = "******";
try
{
HouseRentEntities houseRent = new HouseRentEntities();
User user = new User();
var query = from data in houseRent.Users orderby data.FirstName, data.LastName, data.Password select data;
foreach (User details in query)
{
if (details.Email == txtEmail.Text)
{
username = details.FirstName + " " + details.LastName;
password = details.Password;
}
}
//var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == txtEmail.Text.ToLower())).FirstOrDefault();
//if (emailCheck != null)
//{
// username = emailCheck.FirstName + " " + emailCheck.LastName;
// password = emailCheck.Password;
//}
if (!string.IsNullOrEmpty(password))
{
//using (MailMessage mail = new MailMessage())
//{
// mail.From = new MailAddress("*****@*****.**");
// mail.To.Add(txtEmail.Text.Trim());
// mail.Subject = "Password Recovery";
// mail.Body = string.Format("Hi {0},<br /><br />Your password is {1}.<br /><br />Thank You.", username, password);
// mail.IsBodyHtml = true;
// //mail.Attachments.Add(new Attachment("C:\\file.zip"));
// using (SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587))
// {
// smtp.Credentials = new NetworkCredential("*****@*****.**", "Sangeethas10$");
// smtp.EnableSsl = true;
// smtp.Send(mail);
// }
//}
MailMessage mm = new MailMessage("*****@*****.**", txtEmail.Text.Trim());
mm.Subject = "Password Recovery";
mm.Body = string.Format("Hi {0},<br /><br />Your password is {1}.<br /><br />Thank You.", username, password);
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential();
NetworkCred.UserName = "******";
NetworkCred.Password = "******";
smtp.UseDefaultCredentials = false;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
lblMessage.ForeColor = Color.Green;
lblMessage.Text = "Password has been sent to your email address.";
}
else
{
lblMessage.ForeColor = Color.Red;
lblMessage.Text = "This email address does not match our records.";
}
}
catch (Exception ex)
{
lblMessage.ForeColor = Color.Red;
lblMessage.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["email"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
string email = Session["email"].ToString();
int postId = Convert.ToInt32(Session["postId"]);
HouseRentEntities houseRent = new HouseRentEntities();
Post post = new Post();
User user = new User();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
var postDetails = houseRent.Posts.Where(a => (a.Id == postId)).FirstOrDefault();
txtHouse.Text = postDetails.HouseName;
txtAddress.Text = postDetails.Address;
txtPhoneNumber.Text = postDetails.PhoneNumber;
ddBedRoom.SelectedValue = postDetails.Bedroom.ToString();
txtFloor.Text = postDetails.Floor.ToString();
if (postDetails.Kitchen == true)
{
rbKitchenYes.Checked = true;
}
else
{
rbKitchenNo.Checked = true;
}
if (postDetails.Dining == true)
{
rbDiningYes.Checked = true;
}
else
{
rbDiningNo.Checked = true;
}
if (postDetails.Family == "Yes")
{
rbFamilyYes.Checked = true;
}
else
{
rbFamilyNo.Checked = true;
}
if (postDetails.Bachelor == "Yes")
{
rbBachelorYes.Checked = true;
}
else
{
rbBachelorNo.Checked = true;
}
if (postDetails.Office == "Yes")
{
rbOfficeYes.Checked = true;
}
else
{
rbOfficeNo.Checked = true;
}
txtRent.Text = postDetails.Rent.ToString();
if (postDetails.Additional != null)
{
txtAdditional.Text = postDetails.Additional;
}
}
}
}
private void ViewPostDetails()
{
//Fetch the GridView Row from Session.
//GridViewRow row = Session["Row"] as GridViewRow;
//Fetch and display the Cell values.
//string houseName = row.Cells[1].Text;
int postId = Convert.ToInt32(Session["postId"]);
string base64String;
HouseRentEntities houseRent = new HouseRentEntities();
Post post = houseRent.Posts.First(a => (a.Id == postId));
byte[] bytes = post.Image;
if (bytes != null)
{
base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
Image1.ImageUrl = "data:image/png;base64," + base64String;
}
lblHouseNameValue.Text = post.HouseName;
lblAddressValue.Text = post.Address;
lblPhnValue.Text = post.PhoneNumber;
lblFloorValue.Text = post.Floor.ToString();
lblBedRoomValue.Text = post.Bedroom.ToString();
if (post.Kitchen == true)
{
lblKitchenValue.Text = "Yes";
}
else
{
lblKitchenValue.Text = "No";
}
if (post.Dining == true)
{
lblDiningValue.Text = "Yes";
}
else
{
lblDiningValue.Text = "No";
}
if (post.Family == "Yes")
{
lblFamilyValue.Text = "Yes";
}
else
{
lblFamilyValue.Text = "No";
}
if (post.Bachelor == "Yes")
{
lblBachelorValue.Text = "Yes";
}
else
{
lblBachelorValue.Text = "No";
}
if (post.Office == "Yes")
{
lblOfficeValue.Text = "Yes";
}
else
{
lblOfficeValue.Text = "No";
}
lblRentValue.Text = post.Rent.ToString();
if (post.Additional != null)
{
lblAdditionalValue.Text = post.Additional;
}
else
{
lblAdditionalValue.Text = "Not Specified";
}
}
protected void BtnBookHouse_Click(object sender, EventArgs e)
{
try
{
int rowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex;
int postId = Convert.ToInt32(GridView1.DataKeys[rowIndex].Values[0]);
string email = Session["email"].ToString();
HouseRentEntities houseRent = new HouseRentEntities();
var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
int requestedUserId = emailCheck.id;
int statusId = 1;
UserPost userPost = houseRent.UserPosts.Where(a => a.PostId == postId && a.RequestedUserId == emailCheck.id).FirstOrDefault();
if (userPost != null && userPost.PostStatus != 1)
{
userPost.PostStatus = statusId;
userPost.UpdatedBy = requestedUserId;
userPost.UpdatedDate = DateTime.Now;
houseRent.SaveChanges();
}
else
{
UserPost userP = new UserPost();
userP.PostId = postId;
userP.RequestedUserId = requestedUserId;
userP.PostStatus = statusId;
userP.CreatedDate = DateTime.Now;
userP.CreatedBy = requestedUserId;
userP.UpdatedBy = requestedUserId;
userP.UpdatedDate = DateTime.Now;
houseRent.UserPosts.Add(userP);
houseRent.SaveChanges();
}
Response.Redirect("CustomerPage.aspx");
//var userPostCheck = houseRent.UserPosts.Where(a => a.PostId == postId && a.RequestedUserId == requestedUserId).FirstOrDefault();
//if(userPostCheck != null)
//{
// LinkButton BtnBookHouse = (LinkButton)sender;
// BtnBookHouse.Visible = false;
// Label lblStatus = (Label)sender;
// lblStatus.Text = "Requested";
//}
//((Label)GridView1.SelectedRow.FindControl("lblStatus")).Text = "Requested";
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
//finally
//{
// int rowIndex = ((sender as LinkButton).NamingContainer as GridViewRow).RowIndex;
// int postId = Convert.ToInt32(GridView1.DataKeys[rowIndex].Values[0]);
// string email = Session["email"].ToString();
// HouseRentEntities houseRent = new HouseRentEntities();
// var emailCheck = houseRent.Users.Where(a => (a.Email.ToLower() == email.ToLower())).FirstOrDefault();
// int requestedUserId = emailCheck.id;
// var userPostCheck = houseRent.UserPosts.Where(a => a.PostId == postId && a.RequestedUserId == requestedUserId).FirstOrDefault();
// if (userPostCheck != null)
// {
// LinkButton BtnBookHouse = (LinkButton)sender;
// BtnBookHouse.Visible = false;
// //int index = GridView1.EditIndex;
// //GridViewRow row = GridView1.Rows[index];
// //Label lblStatus = (Label)row.FindControl("lblStatus");
// //lblStatus.Text = "Requested";
// }
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
if (Session["Row"] != null)
{
//Fetch the GridView Row from Session.
GridViewRow row = Session["Row"] as GridViewRow;
//Fetch and display the Cell values.
string houseName = row.Cells[1].Text;
string base64String;
HouseRentEntities houseRent = new HouseRentEntities();
Post post = houseRent.Posts.First(a => (a.HouseName == houseName));
byte[] bytes = post.Image;
if (bytes != null)
{
base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
Image1.ImageUrl = "data:image/png;base64," + base64String;
}
lblHouseNameValue.Text = post.HouseName;
lblAddressValue.Text = post.Address;
lblPhnValue.Text = post.PhoneNumber;
lblFloorValue.Text = post.Floor.ToString();
lblBedRoomValue.Text = post.Bedroom.ToString();
if (post.Kitchen == true)
{
lblKitchenValue.Text = "Yes";
}
else
{
lblKitchenValue.Text = "No";
}
if (post.Dining == true)
{
lblDiningValue.Text = "Yes";
}
else
{
lblDiningValue.Text = "No";
}
if (post.Family == "Yes")
{
lblFamilyValue.Text = "Yes";
}
else
{
lblFamilyValue.Text = "No";
}
if (post.Bachelor == "Yes")
{
lblBachelorValue.Text = "Yes";
}
else
{
lblBachelorValue.Text = "No";
}
if (post.Office == "Yes")
{
lblOfficeValue.Text = "Yes";
}
else
{
lblOfficeValue.Text = "No";
}
lblRentValue.Text = post.Rent.ToString();
lblAdditionalValue.Text = post.Additional;
}
else
{
Response.Redirect("Login.aspx");
}
}
}
