public JsonResult GetFlatsMemberInfo(string HouseRenter)
{
var HRs = db.HouseRepresentatives.ToList();
HouseRepresentative HR = HRs.Find(a => a.MobileNo == HouseRenter);
var flatMembers = db.FlatMembers.Where(a => a.HouseRepresentativeId == HR.Id).ToList();
List <ViewMemberList> viewMemberLists = new List <ViewMemberList>();
foreach (var flatMember in flatMembers)
{
string to;
if (flatMember.LeavingDate == null)
{
to = "Not Leave";
}
else
{
to = flatMember.LeavingDate.Value.ToString();
}
ViewMemberList viewMemberList = new ViewMemberList()
{
Name = flatMember.Name,
MobileNo = flatMember.MobileNo,
From = flatMember.EntryDate.Date.ToString(),
To = to
};
viewMemberLists.Add(viewMemberList);
}
return(Json(viewMemberLists, JsonRequestBehavior.AllowGet));
}
public ActionResult Registration(HouseRepresentative houseRepresentative)
{
ViewBag.OccupationId = new SelectList(db.Occupations, "Id", "Name", houseRepresentative.OccupationId);
var nationalIdWithMobileNos = db.NationalIdWithMobileNos.ToList();
var houseRepresetatives = db.HouseRepresentatives.ToList();
ViewBag.NationalId = nationalIdWithMobileNos.Find(a => a.NationalId == houseRepresentative.NationalId && a.MobileNo == houseRepresentative.MobileNo);
ViewBag.ExistNationalId = houseRepresetatives.Find(a => a.NationalId == houseRepresentative.NationalId);
if (ViewBag.NationalId != null && ViewBag.ExistNationalId == null)
{
db.HouseRepresentatives.Add(houseRepresentative);
db.SaveChanges();
var houseRepresentatives2 = db.HouseRepresentatives.ToList();
HouseRepresentative houseRepresentativeSearch = houseRepresentatives2.Find(a => a.MobileNo == houseRepresentative.MobileNo && a.Password == houseRepresentative.Password);
Session["houseRepresentativeMobileName"] = houseRepresentativeSearch.MobileNo;
Session["houseRepresentativeName"] = houseRepresentativeSearch.Name;
Session["houseRepresentativeId"] = houseRepresentativeSearch.Id;
return(RedirectToAction("Index", "FlatMembers"));
}
else
{
if (ViewBag.NationalId == null)
{
ViewBag.NationalIdFound = "Id not Found";
}
return(View());
}
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["houseRepresentativeMobileName"] == null)
{
return(RedirectToAction("Index", "HouseRepresentatives"));
}
HouseRepresentative houseRepresentative = db.HouseRepresentatives.Find(id);
db.HouseRepresentatives.Remove(houseRepresentative);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name,NationalId,MobileNo,OccupationId,UserName,Password,ConfirmPassword")] HouseRepresentative houseRepresentative)
{
if (Session["houseRepresentativeMobileName"] == null)
{
return(RedirectToAction("Index", "HouseRepresentatives"));
}
if (ModelState.IsValid)
{
db.Entry(houseRepresentative).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OccupationId = new SelectList(db.Occupations, "Id", "Name", houseRepresentative.OccupationId);
return(View(houseRepresentative));
}
// GET: HouseRepresentatives/Details/5
public ActionResult Details(int?id)
{
if (Session["houseRepresentativeMobileName"] == null)
{
return(RedirectToAction("Index", "HouseRepresentatives"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HouseRepresentative houseRepresentative = db.HouseRepresentatives.Find(id);
if (houseRepresentative == null)
{
return(HttpNotFound());
}
return(View(houseRepresentative));
}
public JsonResult GetRenerFlatsInfo(string HouseRenter)
{
var HRs = db.HouseRepresentatives.ToList();
HouseRepresentative HR = HRs.Find(a => a.MobileNo == HouseRenter);
List <ViewRenterFlatInfo> RenterInfos = new List <ViewRenterFlatInfo>();
if (HR != null)
{
var RentedByAll = db.RentedBys.Include(a => a.Flats.Homes.HouseOwners).ToList();
var RentedBys = RentedByAll.Where(a => a.Id == HR.Id).ToList();
if (RentedBys.Count != 0)
{
foreach (var rentedBy in RentedBys)
{
string to;
if (rentedBy.LeavingDate == null)
{
to = "Not Leave";
}
else
{
to = rentedBy.LeavingDate.Value.ToString();
}
ViewRenterFlatInfo RenterInfo = new ViewRenterFlatInfo()
{
HouseName = rentedBy.Flats.Homes.Name,
HouseNo = rentedBy.Flats.Homes.HomeNo,
FlatNo = rentedBy.Flats.FlatNo,
OwnerName = rentedBy.Flats.Homes.HouseOwners.Name,
OwnerMobleNo = rentedBy.Flats.Homes.HouseOwners.MobileNo,
From = rentedBy.EntryDate.Date.ToString(),
To = to
};
RenterInfos.Add(RenterInfo);
}
}
}
return(Json(RenterInfos, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(HouseRepresentative houseRepresentative)
{
var houseRepresentatives = db.HouseRepresentatives.ToList();
HouseRepresentative houseRepresentativeSearch = houseRepresentatives.Find(a => a.MobileNo == houseRepresentative.MobileNo && a.Password == houseRepresentative.Password);
if (houseRepresentativeSearch != null)
{
Session["houseRepresentativeMobileName"] = houseRepresentativeSearch.MobileNo;
Session["houseRepresentativeName"] = houseRepresentativeSearch.Name;
Session["houseRepresentativeId"] = houseRepresentativeSearch.Id;
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.LogInError = "Either Password or UserName Not match!";
return(View());
}
}
// GET: HouseRepresentatives/Edit/5
public ActionResult Edit(int?id)
{
if (Session["houseRepresentativeMobileName"] == null)
{
return(RedirectToAction("Index", "HouseRepresentatives"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HouseRepresentative houseRepresentative = db.HouseRepresentatives.Find(id);
if (houseRepresentative == null)
{
return(HttpNotFound());
}
ViewBag.OccupationId = new SelectList(db.Occupations, "Id", "Name", houseRepresentative.OccupationId);
return(View(houseRepresentative));
}
public ActionResult Create(RentedBy rentedBy, string MobileNo)
{
var homes = db.Homes.ToList();
int HouseOwnerId = (int)Session["HouseOwnerId"];
ViewBag.HomeId = homes.Where(a => a.HouseOwnerId == HouseOwnerId);
List <HouseRepresentative> houseRepresentatives = db.HouseRepresentatives.ToList();
HouseRepresentative houseRepresentative = houseRepresentatives.Find(a => a.MobileNo == MobileNo);
if (houseRepresentative == null)
{
ViewBag.error = "There is No Representative with this Mobile No";
return(View());
}
List <RentedBy> rentedBys = db.RentedBys.ToList();
RentedBy HRForCheckRentedInfo = rentedBys.Find(a => a.HouseRepresentative == houseRepresentative.Id && a.LeavingDate == null);
if (HRForCheckRentedInfo != null)
{
ViewBag.error = "This House Representaive Allready lives In A House!";
return(View());
}
HRForCheckRentedInfo = rentedBys.Find(a => a.LeavingDate == null && a.FlatId == rentedBy.FlatId);
if (HRForCheckRentedInfo != null)
{
ViewBag.error = "This House has Allready Occupied By Other!";
return(View());
}
rentedBy.HouseRepresentative = houseRepresentative.Id;
db.RentedBys.Add(rentedBy);
db.SaveChanges();
return(RedirectToAction("Index"));
}