public async Task <string> DeleteDestinationAsync(long id)
{
try
{
utblMstDestination curObj = await objDB.utblMstDestinations.FindAsync(id);
objDB.utblMstDestinations.Remove(curObj);
await objDB.SaveChangesAsync();
return("Destination 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 int Save(utblMstDestination destination)
{
int result = 0;
if (destination.DestinationID == 0)
{
try
{
_db.utblMstDestinations.Add(destination);
_db.SaveChanges();
result = 1;
}
catch (Exception ex)
{
result = 0;
}
}
else
{
utblMstDestination dbEntry = _db.utblMstDestinations.Find(destination.DestinationID);
if (dbEntry != null)
{
dbEntry.DestinationName = destination.DestinationName;
dbEntry.CountryID = destination.CountryID;
dbEntry.DestinationDesc = destination.DestinationDesc;
}
_db.SaveChanges();
result = 1;
}
return(result);
}
public async Task <string> SaveDestination(utblMstDestination model)
{
if (ModelState.IsValid)
{
return(await objDal.SaveDestinationAsync(model));
}
string messages = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
return("Operation Error: " + messages);
}
public int Delete(long id)
{
int result = 0;
utblMstDestination obj = _db.utblMstDestinations.Find(id);
try
{
_db.utblMstDestinations.Remove(obj);
_db.SaveChanges();
result = 1;
return(result);
}
catch (Exception ex)
{
return(result);
}
}
public async Task <string> SaveDestinationAsync(utblMstDestination model)
{
try
{
var parDestID = new SqlParameter("@DestinationID", model.DestinationID);
var parCountryID = new SqlParameter("@CountryID", model.CountryID);
var parStateID = new SqlParameter("@StateID", model.StateID);
var parDestName = new SqlParameter("@DestinationName", model.DestinationName);
var parDestDesc = new SqlParameter("@DestinationDesc", model.DestinationDesc ?? "");
var parDestImg = new SqlParameter("@DestinationImagePath", model.DestinationImagePath ?? "");
return(await objDB.Database.SqlQuery <string>("udspMstDestinationSave @DestinationID, @CountryID, @StateID, @DestinationName, @DestinationDesc,@DestinationImagePath",
parDestID, parCountryID, parStateID, parDestName, parDestDesc, parDestImg).FirstOrDefaultAsync());
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public utblMstDestination GetDestinationByID(long id)
{
utblMstDestination obj = _db.utblMstDestinations.FirstOrDefault(p => p.DestinationID == id);
return(obj);
}
