public ActionResult SaveVillage(sdtoVillage village) { sdtoUser userDetails = UtilityHelper.UserSession.GetSession(UtilityHelper.UserSession.LoggedInUser); if (userDetails == null) userDetails = new sdtoUser(); if (ModelState.IsValid) { if (db.Villages.Count(x => x.VillageName.Equals(village.VillageName.Trim(), StringComparison.InvariantCultureIgnoreCase) && x.TalukId == village.TalukId && x.VillageId != village.VillageId) == 0) { if (village.VillageId == 0) { db.Villages.Add(new sdtoVillage() { TalukId = village.TalukId, VillageName = village.VillageName, VillageAbbr = village.VillageAbbr, CreatedBy = userDetails.UserID, CreatedOn = DateTime.Now }); } else { village.ModifiedBy = userDetails.UserID; village.ModifiedOn = DateTime.Now; db.Entry(village).State = EntityState.Modified; } db.SaveChanges(); return RedirectToAction("VillageList", new { TalukId = village.TalukId }); } else ModelState.AddModelError("VillageName", "Village already exists!!!"); } sdtoTaluk taluk = db.Taluks.Find(village.TalukId); var district = db.Districts.Find(taluk.DistrictId); var state = db.States.Find(district.StateId); ViewBag.CountryId = state.CountryId; ViewBag.StateId = district.StateId; ViewBag.DistrictId = taluk.DistrictId; ViewBag.TalukId = taluk.TalukId; return View(village); }
public ActionResult SaveVillage(long TalukId, long VillageId = 0) { sdtoUser userDetails = UtilityHelper.UserSession.GetSession(UtilityHelper.UserSession.LoggedInUser); if (userDetails == null) userDetails = new sdtoUser(); sdtoTaluk taluk = db.Taluks.Find(TalukId); if (taluk == null) taluk = new sdtoTaluk(); var district = new sdtoDistrict(); var state = new sdtoState(); if (taluk != null) district = db.Districts.Find(taluk.DistrictId); if (district == null) district = new sdtoDistrict(); if (district != null) state = db.States.Find(district.StateId); if (state == null) state = new sdtoState(); sdtoVillage village = new sdtoVillage() { TalukId = taluk.TalukId }; ViewBag.CountryId = state.CountryId; ViewBag.StateId = district.StateId; ViewBag.DistrictId = taluk.DistrictId; ViewBag.TalukId = taluk.TalukId; sdtoTaluk parent = db.Taluks.Find(taluk.TalukId); if (parent != null) { ViewBag.ParentId = parent.TalukId; village = db.Villages.Find(VillageId); if (village == null) village = new sdtoVillage() { TalukId = parent.TalukId, TalukDetails = parent }; else village.TalukDetails = parent; } return View(village); }