public ApiResult <bool> DeleteProject(int?id) { if (id == null) { return(ApiResult <bool> .Failed(StatusCode.BadRequest, "Null options")); } var proj = GetProjectById(id.Value); context_.Remove(proj); try { var rows = context_.SaveChanges(); if (rows <= 0) { return(ApiResult <bool> .Failed( StatusCode.InternalServerError, "Project could not be deleted")); } } catch (Exception ex) { return(ApiResult <bool> .Failed(StatusCode.InternalServerError, ex.ToString())); } return(ApiResult <bool> .Successful(true)); }
public ApiResult <bool> DeleteClient(int?id) { if (id == null) { return(ApiResult <bool> .Failed(StatusCode.BadRequest, "Client Id is empty")); } var query = context_ .Set <Client>() .AsQueryable(); var client = query .Where(c => c.ClientId == id) .SingleOrDefault(); context_.Remove(client); try { var rows = context_.SaveChanges(); if (rows <= 0) { return(ApiResult <bool> .Failed( StatusCode.InternalServerError, "Client could not be deleted")); } } catch (Exception ex) { return(ApiResult <bool> .Failed(StatusCode.InternalServerError, ex.ToString())); } return(ApiResult <bool> .Successful(true)); }
public ApiResult <bool> DeletePackage(int?id) { if (id == null) { return(ApiResult <bool> .Failed(StatusCode.BadRequest, "The Package Id is empty")); } var project = context_ .Set <Project>() .Where(p => p.ProjectId == id) .SingleOrDefault(); var package = GetPackageById(id).Data; // removing package from package table & FundingPackages List(project class) project.Packages.Remove(package); context_.Remove(package); context_.Update(project); try { var rows = context_.SaveChanges(); if (rows <= 0) { return(ApiResult <bool> .Failed( StatusCode.InternalServerError, "Package could not be deleted")); } } catch (Exception ex) { return(ApiResult <bool> .Failed(StatusCode.InternalServerError, ex.ToString())); } return(ApiResult <bool> .Successful(true)); }