public async Task <IActionResult> Create([FromBody] CityEntry pModel) { // Validation if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (Validate(pModel, false) == false) { return(BadRequest(ModelState)); } else { // Execution of concrete process SQLResult result = new SQLResult(); result = await _repo.Create(pModel); if (result.ErrorNo > 0) { return(BadRequest(result)); } else { return(Ok(result)); } } }
private bool Validate(CityEntry pModel, bool isUpdateValidation) { if (isUpdateValidation == true) { if (pModel.CityId <= 0) { ModelState.AddModelError("", Messages.Blank("City entry")); return(false); } } if (pModel.CityCode.Trim().Length == 0) { ModelState.AddModelError("", Messages.Blank("Code")); return(false); } if (pModel.City.Trim().Length == 0) { ModelState.AddModelError("", Messages.Blank("City")); return(false); } if (pModel.CountryId <= 1) { ModelState.AddModelError("", Messages.Blank("CountryId")); return(false); } if (pModel.StateId <= 1) { ModelState.AddModelError("", Messages.Blank("StateId")); return(false); } return(true); }
public ActionResult DeleteConfirmed(int id) { CityEntry cityEntry = db.CityEntries.Find(id); db.CityEntries.Remove(cityEntry); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,CityName,About,NoOfDweller,Location,Weather,CoutEntryId")] CityEntry cityEntry) { if (ModelState.IsValid) { db.Entry(cityEntry).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CoutEntryId = new SelectList(db.CountryEntries, "Id", "CountyName", cityEntry.CoutEntryId); return(View(cityEntry)); }
public async Task <SQLResult> Edit(CityEntry pModel) { SQLResult result = new SQLResult(); _Context.Database.BeginTransaction(); try { string csql = @" EXEC spmCityUpdate @pi_mCityId , @pi_CityCode , @pi_City , @pi_mCountryId , @pi_mStateId , @pi_Active , @pi_UserId , @pi_HostName , @pi_IPAddress , @pi_DeviceType , @pi_MACAddress"; List <SqlParameter> sqlparam = new List <SqlParameter>() { new SqlParameter("@pi_mCityId", pModel.CityId), new SqlParameter("@pi_CityCode", pModel.CityCode), new SqlParameter("@pi_City", pModel.City), new SqlParameter("@pi_mCountryId", pModel.CountryId), new SqlParameter("@pi_mStateId", pModel.StateId), new SqlParameter("@pi_Active", pModel.Active), new SqlParameter("@pi_UserId", pModel.AuditColumns.UserId), new SqlParameter("@pi_HostName", pModel.AuditColumns.HostName), new SqlParameter("@pi_IPAddress", pModel.AuditColumns.IPAddress), new SqlParameter("@pi_DeviceType", pModel.AuditColumns.DeviceType), new SqlParameter("@pi_MACAddress", pModel.AuditColumns.MACAddress), }; result = await _Context.DBResult.FromSql(csql, sqlparam.ToArray()).SingleOrDefaultAsync(); if (result.ErrorNo != 0) { _Context.Database.RollbackTransaction(); } else { _Context.Database.CommitTransaction(); } } catch (Exception ex) { _Context.Database.RollbackTransaction(); result.ErrorNo = 9999999999; result.ErrorMessage = ex.Message.ToString(); result.SQLErrorNumber = ex.HResult; result.SQLErrorMessage = ex.Source.ToString(); } return(result); }
// GET: CityEntries/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CityEntry cityEntry = db.CityEntries.Find(id); if (cityEntry == null) { return(HttpNotFound()); } return(View(cityEntry)); }
// GET: CityEntries/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CityEntry cityEntry = db.CityEntries.Find(id); if (cityEntry == null) { return(HttpNotFound()); } ViewBag.CoutEntryId = new SelectList(db.CountryEntries, "Id", "CountyName", cityEntry.CoutEntryId); return(View(cityEntry)); }
public JsonResult IsCityExist(CityEntry city) { return(Json(!db.CityEntries.Any(m => m.CityName.Trim() == city.CityName.Trim()), JsonRequestBehavior.AllowGet)); }