public async Task <string> DeleteInclusionAsync(long InclustionID) { try { utblMstInclusion curObj = await objDB.utblMstInclusions.FindAsync(InclustionID); objDB.utblMstInclusions.Remove(curObj); await objDB.SaveChangesAsync(); return("Inclusion 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 <utblMstInclusion> GetInclusionByIDAsync(long id) { utblMstInclusion obj = new utblMstInclusion(); obj = await objDB.utblMstInclusions.Where(x => x.InclusionID == id).FirstOrDefaultAsync(); return(obj); }
public async Task <string> SaveInclusions(utblMstInclusion model) { if (ModelState.IsValid) { return(await objDal.SaveInclusionAsync(model)); } string messages = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)); return("Operation Error: " + messages); }
public async Task <string> SaveInclusionAsync(utblMstInclusion model) { try { var parPID = new SqlParameter("@InclusionID", model.InclusionID); var parIName = new SqlParameter("@InclusionName", model.InclusionName); var parIDesc = new SqlParameter("@InclusionType", model.InclusionType); return(await objDB.Database.SqlQuery <string>("udspMstInclusionAddEdit @InclusionID, @InclusionName,@InclusionType", parPID, parIName, parIDesc).FirstOrDefaultAsync()); } catch (Exception ex) { return("Error: " + ex.Message); } }