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