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