public async Task <string> DeleteDriverAsync(long id) { try { utblMstCabDriver curObj = await db.utblMstCabDrivers.FindAsync(id); db.utblMstCabDrivers.Remove(curObj); await db.SaveChangesAsync(); return("Driver Details Removed"); } catch (SqlException ex) { if (ex.Errors.Count > 0) // Assume the interesting stuff is in the first error { switch (ex.Errors[0].Number) { case 547: // Foreign Key violation return("This record has dependencies on other records, so cannot be removed."); default: return("Error: " + ex.Message); } } return("Error while operation. Error Message: " + ex.Message); } catch (Exception ex) { return("Error: " + ex.Message); } }
public async Task <string> SaveDriverAsync(utblMstCabDriver model) { try { if (model.DriverID == 0) { db.utblMstCabDrivers.Add(model); await db.SaveChangesAsync(); return("New Driver Added"); } else { utblMstCabDriver curObj = await db.utblMstCabDrivers.FindAsync(model.DriverID); curObj.DriverName = model.DriverName; curObj.DriverContact = model.DriverContact; return("Driver Details Updated"); } } catch (Exception ex) { return("Error: " + ex.Message); } }
public async Task <string> SaveDriver(utblMstCabDriver model) { if (ModelState.IsValid) { return(await objCab.SaveDriverAsync(model)); } string messages = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)); return("Operation Error: " + messages); }
public ActionResult Edit(long id) { try { ViewBag.ActiveURL = "/Admin/cabdriver"; utblMstCabDriver model = objAPI.GetObjectByKey <utblMstCabDriver>("cabconfig", "driverbyid", id.ToString(), "id"); return(View(model)); } catch (AuthorizationException) { TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again"; return(RedirectToAction("Login", "Account", new { Area = "" })); } }
public ActionResult Edit(utblMstCabDriver model) { try { ViewBag.ActiveURL = "/Admin/cabdriver"; if (ModelState.IsValid) { string jsonStr = JsonConvert.SerializeObject(model); TempData["ErrMsg"] = objAPI.PostRecordtoApI("cabconfig", "savedriver", jsonStr); return(RedirectToAction("index", "cabdriver", new { Area = "Admin" })); } return(View(model)); } catch (AuthorizationException) { TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again"; return(RedirectToAction("Login", "Account", new { Area = "" })); } }