Esempio n. 1
0
        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");
        }
Esempio n. 2
0
        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;
                }
            }
        }
Esempio n. 3
0
        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;
            }
        }
Esempio n. 4
0
        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";
            //    }
            //}
        }