public ActionResult DeleteConfirmed(int?id)
{
Property_Details pd = Db.Property_Details.Find(id);
Db.Property_Details.Remove(pd);
Db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteProperty(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Property_Details pd = Db.Property_Details.Find(id);
if (pd == null)
{
return(HttpNotFound());
}
return(View(pd));
}
public ActionResult Confirmation(Sold_Property sp)
{
sp.Customer_Id = (int)Session["customerid"];
sp.Property_Id = (int)Session["propertyid"];
sp.Seller_Id = (int)Session["sellerid"];
sp.Date_of_Sale = DateTime.Now.ToString();
Db.Sold_Property.Add(sp);
Db.SaveChanges();
int pid = (int)Session["propertyid"];
int cid = (int)Session["customerid"];
string cemail = Db.Customer_Details.Where(m => m.Customer_Id == cid).Select(m => m.Customer_Email).FirstOrDefault();
var customer = Db.Booking_Details.Where(m => m.Customer_Id == cid && m.Property_Id == pid).FirstOrDefault();
string pname = Db.Property_Details.Where(m => m.Property_ID == pid).Select(m => m.Property_Name).FirstOrDefault();
string paddress = Db.Property_Details.Where(m => m.Property_ID == pid).Select(m => m.Property_Address).FirstOrDefault();
ConfirmationMail(cemail, pname, paddress);
Db.Booking_Details.Remove(customer);
Db.SaveChanges();
List <Booking_Details> result = Db.Booking_Details.Where(m => m.Property_Id == pid && m.Customer_Id != cid).ToList <Booking_Details>();
Property_Details bd = Db.Property_Details.Where(m => m.Property_ID == pid).FirstOrDefault();
bd.Property_Status = "Not Available";
Db.SaveChanges();
if (result != null)
{
foreach (Booking_Details x in result)
{
string email = Db.Customer_Details.Where(m => m.Customer_Id == x.Customer_Id).Select(m => m.Customer_Email).FirstOrDefault();
string propertyname = Db.Property_Details.Where(m => m.Property_ID == pid).Select(m => m.Property_Name).FirstOrDefault();
string propertyaddress = Db.Property_Details.Where(m => m.Property_ID == pid).Select(m => m.Property_Address).FirstOrDefault();
RejectionMail(email, propertyname, propertyaddress);
Db.Booking_Details.Remove(x);
Db.SaveChanges();
}
}
Session.Remove("propertyid");
Session.Remove("customerid");
return(RedirectToAction("Index"));
}
public ActionResult Edit(Property_Details property_Details)
{
if (ModelState.IsValid)
{
property_Details.Seller_Id = (int)Session["sellerid"];
int id = (int)Session["prop"];
Property_Details pd = Db.Property_Details.First(m => m.Property_ID == id);
pd.Property_Status = property_Details.Property_Status;
pd.Property_Type = property_Details.Property_Type;
pd.Property_Address = property_Details.Property_Address;
pd.Property_City = property_Details.Property_City;
pd.Property_Name = property_Details.Property_Name;
pd.Property_Pin = property_Details.Property_Pin;
pd.Property_State = property_Details.Property_State;
pd.Seller_Id = property_Details.Seller_Id;
Property_Information pi = Db.Property_Information.First(m => m.Property_ID == id);
pi.Total_Floor = property_Details.Property_Information.Total_Floor;
pi.Age = property_Details.Property_Information.Age;
pi.ExpectedRent = property_Details.Property_Information.ExpectedRent;
pi.Expected_Deposit = property_Details.Property_Information.Expected_Deposit;
pi.Floor = property_Details.Property_Information.Floor;
pi.Size = property_Details.Property_Information.Size;
pi.BHK = property_Details.Property_Information.BHK;
pi.Facing = property_Details.Property_Information.Facing;
pi.Furnishing = property_Details.Property_Information.Furnishing;
pi.Parking = property_Details.Property_Information.Parking;
pi.Preferred_Tenants = property_Details.Property_Information.Preferred_Tenants;
Session.Remove("prop");
Db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
List <SelectListItem> li = new List <SelectListItem>();
li.Add(new SelectListItem {
Text = "House", Value = "House"
});
li.Add(new SelectListItem {
Text = "Flat", Value = "Flat"
});
ViewData["type"] = li;
List <SelectListItem> bhk = new List <SelectListItem>();
bhk.Add(new SelectListItem {
Text = "1Bhk", Value = "1BHK"
});
bhk.Add(new SelectListItem {
Text = "2Bhk", Value = "2BHK"
});
bhk.Add(new SelectListItem {
Text = "3Bhk", Value = "3BHK"
});
bhk.Add(new SelectListItem {
Text = "4Bhk", Value = "4BHK"
});
bhk.Add(new SelectListItem {
Text = "5Bhk", Value = "5BHK"
});
ViewData["bhk"] = bhk;
List <SelectListItem> facing = new List <SelectListItem>();
facing.Add(new SelectListItem {
Text = "North", Value = "North"
});
facing.Add(new SelectListItem {
Text = "East", Value = "East"
});
facing.Add(new SelectListItem {
Text = "West", Value = "West"
});
facing.Add(new SelectListItem {
Text = "South", Value = "South"
});
ViewData["facing"] = facing;
List <SelectListItem> furnish = new List <SelectListItem>();
furnish.Add(new SelectListItem {
Text = "Fully Furnished", Value = "Fully Furnished"
});
furnish.Add(new SelectListItem {
Text = "Semi Furnished", Value = "Semi Furnished"
});
furnish.Add(new SelectListItem {
Text = "Not Furnished", Value = "Not Furnished"
});
ViewData["furnish"] = furnish;
List <SelectListItem> tenant = new List <SelectListItem>();
tenant.Add(new SelectListItem {
Text = "Family", Value = "Family"
});
tenant.Add(new SelectListItem {
Text = "Bacholer", Value = "Bacholer"
});
tenant.Add(new SelectListItem {
Text = "Family/Bacholer", Value = "Family/Bacholer"
});
ViewData["tenant"] = tenant;
List <SelectListItem> parking = new List <SelectListItem>();
parking.Add(new SelectListItem {
Text = "Available", Value = "Available"
});
parking.Add(new SelectListItem {
Text = "Not Available", Value = "Not Available"
});
ViewData["parking"] = parking;
List <SelectListItem> status = new List <SelectListItem>();
status.Add(new SelectListItem {
Text = "Available", Value = "Available"
});
status.Add(new SelectListItem {
Text = "Not Available", Value = "Not Available"
});
ViewData["status"] = status;
return(View(property_Details));
}
}
public ActionResult Edit(int?id)
{
Session["prop"] = id;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Property_Details property_Details = Db.Property_Details.Find(id);
if (property_Details == null)
{
return(HttpNotFound());
}
List <SelectListItem> li = new List <SelectListItem>();
li.Add(new SelectListItem {
Text = "House", Value = "House"
});
li.Add(new SelectListItem {
Text = "Flat", Value = "Flat"
});
ViewData["type"] = li;
List <SelectListItem> bhk = new List <SelectListItem>();
bhk.Add(new SelectListItem {
Text = "1Bhk", Value = "1BHK"
});
bhk.Add(new SelectListItem {
Text = "2Bhk", Value = "2BHK"
});
bhk.Add(new SelectListItem {
Text = "3Bhk", Value = "3BHK"
});
bhk.Add(new SelectListItem {
Text = "4Bhk", Value = "4BHK"
});
bhk.Add(new SelectListItem {
Text = "5Bhk", Value = "5BHK"
});
ViewData["bhk"] = bhk;
List <SelectListItem> facing = new List <SelectListItem>();
facing.Add(new SelectListItem {
Text = "North", Value = "North"
});
facing.Add(new SelectListItem {
Text = "East", Value = "East"
});
facing.Add(new SelectListItem {
Text = "West", Value = "West"
});
facing.Add(new SelectListItem {
Text = "South", Value = "South"
});
ViewData["facing"] = facing;
List <SelectListItem> furnish = new List <SelectListItem>();
furnish.Add(new SelectListItem {
Text = "Fully Furnished", Value = "Fully Furnished"
});
furnish.Add(new SelectListItem {
Text = "Semi Furnished", Value = "Semi Furnished"
});
furnish.Add(new SelectListItem {
Text = "Not Furnished", Value = "Not Furnished"
});
ViewData["furnish"] = furnish;
List <SelectListItem> tenant = new List <SelectListItem>();
tenant.Add(new SelectListItem {
Text = "Family", Value = "Family"
});
tenant.Add(new SelectListItem {
Text = "Bacholer", Value = "Bacholer"
});
tenant.Add(new SelectListItem {
Text = "Family/Bacholer", Value = "Family/Bacholer"
});
ViewData["tenant"] = tenant;
List <SelectListItem> parking = new List <SelectListItem>();
parking.Add(new SelectListItem {
Text = "Available", Value = "Available"
});
parking.Add(new SelectListItem {
Text = "Not Available", Value = "Not Available"
});
ViewData["parking"] = parking;
List <SelectListItem> status = new List <SelectListItem>();
status.Add(new SelectListItem {
Text = "Available", Value = "Available"
});
status.Add(new SelectListItem {
Text = "Not Available", Value = "Not Available"
});
ViewData["status"] = status;
return(View(property_Details));
}
public async Task <ActionResult> AddProperty(Property_Details pd, HttpPostedFileBase[] images)
{
if (ModelState.IsValid)
{
pd.Seller_Id = (int)Session["sellerid"];
Db.Property_Details.Add(pd);
await Db.SaveChangesAsync();
int id = Db.Property_Details.Max(p => p.Property_ID);
if (images.Length > 0)
{
foreach (var image in images)
{
if (image != null)
{
BinaryReader binary = new BinaryReader(image.InputStream);
Property_Images pi = new Property_Images
{
Property_Id = id,
Image = binary.ReadBytes((int)image.ContentLength)
};
Db.Property_Images.Add(pi);
}
}
Db.SaveChanges();
}
}
else
{
List <SelectListItem> li = new List <SelectListItem>();
li.Add(new SelectListItem {
Text = "House", Value = "House"
});
li.Add(new SelectListItem {
Text = "Flat", Value = "Flat"
});
ViewData["type"] = li;
List <SelectListItem> bhk = new List <SelectListItem>();
bhk.Add(new SelectListItem {
Text = "1Bhk", Value = "1BHK"
});
bhk.Add(new SelectListItem {
Text = "2Bhk", Value = "2BHK"
});
bhk.Add(new SelectListItem {
Text = "3Bhk", Value = "3BHK"
});
bhk.Add(new SelectListItem {
Text = "4Bhk", Value = "4BHK"
});
bhk.Add(new SelectListItem {
Text = "5Bhk", Value = "5BHK"
});
ViewData["bhk"] = bhk;
List <SelectListItem> facing = new List <SelectListItem>();
facing.Add(new SelectListItem {
Text = "North", Value = "North"
});
facing.Add(new SelectListItem {
Text = "East", Value = "East"
});
facing.Add(new SelectListItem {
Text = "West", Value = "West"
});
facing.Add(new SelectListItem {
Text = "South", Value = "South"
});
ViewData["facing"] = facing;
List <SelectListItem> furnish = new List <SelectListItem>();
furnish.Add(new SelectListItem {
Text = "Fully Furnished", Value = "Fully Furnished"
});
furnish.Add(new SelectListItem {
Text = "Semi Furnished", Value = "Semi Furnished"
});
furnish.Add(new SelectListItem {
Text = "Not Furnished", Value = "Not Furnished"
});
ViewData["furnish"] = furnish;
List <SelectListItem> tenant = new List <SelectListItem>();
tenant.Add(new SelectListItem {
Text = "Family", Value = "Family"
});
tenant.Add(new SelectListItem {
Text = "Bacholer", Value = "Bacholer"
});
tenant.Add(new SelectListItem {
Text = "Family/Bacholer", Value = "Family/Bacholer"
});
ViewData["tenant"] = tenant;
List <SelectListItem> parking = new List <SelectListItem>();
parking.Add(new SelectListItem {
Text = "Available", Value = "Available"
});
parking.Add(new SelectListItem {
Text = "Not Available", Value = "Not Available"
});
ViewData["parking"] = parking;
List <SelectListItem> status = new List <SelectListItem>();
status.Add(new SelectListItem {
Text = "Available", Value = "Available"
});
status.Add(new SelectListItem {
Text = "Not Available", Value = "Not Available"
});
ViewData["status"] = status;
return(View(pd));
}
return(RedirectToAction("Index"));
}
