public async Task <string> DeleteCabAsync(long id) { try { utblMstCab curObj = await db.utblMstCabs.FindAsync(id); db.utblMstCabs.Remove(curObj); await db.SaveChangesAsync(); return("Cab 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> SaveCab(utblMstCab model) { if (ModelState.IsValid) { return(await objCab.SaveCabAsync(model)); } string messages = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)); return("Operation Error: " + messages); }
public async Task <string> SaveCabAsync(utblMstCab model) { try { var parCabID = new SqlParameter("@CabID", model.CabID); var parCabName = new SqlParameter("@CabName", model.CabName); var parCabNo = new SqlParameter("@CabNo", model.CabNo); var parTypeID = new SqlParameter("@CabTypeID", model.CabTypeID); var parHead = new SqlParameter("@CabHeadID", model.CabHeadID); return(await db.Database.SqlQuery <string>("udspMstCabSave @CabID, @CabName, @CabNo, @CabTypeID, @CabHeadID", parCabID, parCabName, parCabNo, parTypeID, parHead).FirstOrDefaultAsync()); } catch (Exception ex) { return("Error: " + ex.Message); } }