// GET: LandDetail public ActionResult Index() { LandSearchViewModel model = new LandSearchViewModel(); var regions = db.RegionMasters.ToList(); model.RegionList = regions.Select(x => new SelectListItem() { Text = x.Region, Value = x.Id.ToString() }).ToList(); return(View(model)); }
public ActionResult Index(LandSearchViewModel model) { model.RegionList = db.RegionMasters.Select(x => new SelectListItem() { Text = x.Region, Value = x.Id.ToString() }).ToList(); model.TalukList = db.TalukMasters.Where(x => x.RegionID == model.Region).Select(x => new SelectListItem() { Value = x.TalukID.ToString(), Text = x.TalukName }).ToList(); model.RevenueList = db.RevenueVillageMasters.Where(x => x.Id == model.Revenue).Select(x => new SelectListItem() { Value = x.Id.ToString(), Text = x.RevenueVillageName }).ToList(); model.WardList = db.WardMasters.Where(x => x.WardID == model.Ward).Select(x => new SelectListItem() { Value = x.WardID.ToString(), Text = x.WardName }).ToList(); model.BlockList = db.BlockMasters.Where(x => x.BlockID == model.Block).Select(x => new SelectListItem() { Value = x.BlockID.ToString(), Text = x.BlockName }).ToList(); model.LandDetails = db.UsersDatas .Include(x => x.TalukMaster) .Include(x => x.RevenueVillageMaster) .Include(x => x.BlockMaster) .Include(x => x.RegionMaster) .Where(x => (x.RegionID == model.Region || model.Region == 0) && (x.TalukID == model.Taluk || model.Taluk == 0) && (x.RevenueVillageID == model.Revenue || model.Revenue == 0) && (x.WardID == model.Ward || model.Ward == 0) && (x.BlockID == model.Block || model.Block == 0) && (x.TSNo == model.TSNo || string.IsNullOrEmpty(model.TSNo)) ) .Select(x => new LandDetailsModel() { ID = x.ID, AddressLine1 = x.AddressLine1, AddressLine2 = x.AddressLine2, AddressLine3 = x.AddressLine3, BlockID = x.BlockID, BlockName = x.BlockMaster.BlockName, OwnerName = x.OwnerName, PattaNo = x.PattaNo, PreviousOwnerAddLine1 = x.PreviousOwnerAddLine1, PreviousOwnerAddLine2 = x.PreviousOwnerAddLine2, PreviousOwnerAddLine3 = x.PreviousOwnerAddLine3, RegionID = x.RegionID, RegionName = x.RegionMaster.Region, Remarks = x.Remarks, RevenueVillageID = x.RevenueVillageID, RevenueVillageName = x.RevenueVillageMaster.RevenueVillageName, RSNo = x.RSNo, SubDivisionNo = x.SubDivisionNo, TalukID = x.TalukID, TalukName = x.TalukMaster.TalukName, TenantName = x.TenantName, TSNo = x.TSNo, WardID = x.WardID, WardName = "" }) .ToList(); return(View(model)); }
public ActionResult AddUserData(LandSearchViewModel model) { var isImagesValid = ValidateUploadedImage(model.files); if (isImagesValid == false) { TempData[Constants.ErrorAlert] = "Please upload JPG image files"; return(View(model)); } UsersData data = new UsersData() { RegionID = (byte)model.Region, TalukID = model.Taluk, RevenueVillageID = model.Revenue, OwnerName = model.Details.OwnerName, TenantName = model.Details.TenantName, AddressLine1 = model.Details.AddressLine1, AddressLine2 = model.Details.AddressLine2, AddressLine3 = model.Details.AddressLine3, PreviousOwnerAddLine1 = model.Details.PreviousOwnerAddLine1, PreviousOwnerAddLine2 = model.Details.PreviousOwnerAddLine2, PreviousOwnerAddLine3 = model.Details.PreviousOwnerAddLine3, PattaNo = model.LGR, RSNo = model.RSNo, TSNo = model.TSNo, Remarks = model.Details.Remarks, Location = model.Details.Location, Email = model.Details.Email }; if (model.Ward != 0) { data.WardID = model.Ward; } if (model.Block != 0) { data.BlockID = model.Block; } var id = db.UsersDatas.Add(data); db.SaveChanges(); List <UserImage> images = new List <UserImage>(); foreach (HttpPostedFileBase file in model.files) { if (file != null) { var InputFileName = Path.GetFileName(file.FileName); var ServerSavePath = Path.Combine(Server.MapPath("~/Images/") + InputFileName); var path = "/Images/" + InputFileName; file.SaveAs(ServerSavePath); UserImage image = new UserImage() { UserDataID = id.ID, ImagePath = path }; images.Add(image); } } db.UserImages.AddRange(images); db.SaveChanges(); TempData[Constants.SuccessAlert] = "Updated Successfully"; return(RedirectToAction(nameof(AddUserData))); }