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