public async Task <string> DeleteItineraryAsync(long ItineraryID) { try { utblMstItinerarie curObj = await objDB.utblMstItineraries.FindAsync(ItineraryID); objDB.utblMstItineraries.Remove(curObj); await objDB.SaveChangesAsync(); return("Itinerary 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 <utblMstItinerarie> GetItineraryByIDAsync(long id) { utblMstItinerarie obj = new utblMstItinerarie(); obj = await objDB.utblMstItineraries.Where(x => x.ItineraryID == id).FirstOrDefaultAsync(); return(obj); }
public async Task <string> SaveItinerary(utblMstItinerarie model) { if (ModelState.IsValid) { return(await objDal.SaveItineraryAsync(model)); } string messages = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)); return("Operation Error: " + messages); }
public async Task <string> SaveItineraryAsync(utblMstItinerarie model) { try { var parPID = new SqlParameter("@ItineraryID", model.ItineraryID); var parItName = new SqlParameter("@ItineraryName", model.ItineraryName); var parItDesc = new SqlParameter("@ItineraryDesc", model.ItineraryDesc); var parOvDest = new SqlParameter("@OvernightDestinationID", DBNull.Value); if (model.OvernightDestinationID != null) { parOvDest = new SqlParameter("@OvernightDestinationID", model.OvernightDestinationID); } return(await objDB.Database.SqlQuery <string>("udspMstItineraryAddEdit @ItineraryID, @ItineraryName,@ItineraryDesc,@OvernightDestinationID", parPID, parItName, parItDesc, parOvDest).FirstOrDefaultAsync()); } catch (Exception ex) { return("Error: " + ex.Message); } }