// 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)));
}
