public IHttpActionResult Insert([FromBody] PROJECTDC projectDC) { try { var projectBL = new PROJECTBL(); projectDC.CREATED_ON = Convert.ToDateTime(projectDC.CREATED_ON); projectDC.MODIFIED_ON = Convert.ToDateTime(projectDC.MODIFIED_ON); List <PROJECTDC> projectList = new List <PROJECTDC>(); projectList.Add(projectDC); int ID = projectBL.Insert(projectList); return(Ok(ID)); } catch (Exception ex) { if (ex.Message.Contains("unique_Projects_Project_Bid_Name")) { throw new System.InvalidOperationException("ProjectName"); } else { throw ex; } } }
public IHttpActionResult Update([FromBody] PROJECTDC projectDC) { List <EXCEPTIONDC> lstException = new List <EXCEPTIONDC>(); try { var objProject = new PROJECTBL(); int IsUpdated = 0; projectDC.CREATED_ON = Convert.ToDateTime(projectDC.CREATED_ON); projectDC.MODIFIED_ON = Convert.ToDateTime(projectDC.MODIFIED_ON); List <PROJECTDC> projectList = new List <PROJECTDC>(); projectList.Add(projectDC); int UpdatedCount = objProject.Update(projectList, ref lstException); if (UpdatedCount > 0) { IsUpdated = 1; } return(Ok(IsUpdated)); } catch (Exception ex) { return(new TextResult(lstException, Request)); } }
public IHttpActionResult GetAllByStatus(String projectStatus) { PROJECTBL objPROJECTs = new PROJECTBL(); List <PROJECTDC> objResultList = new List <PROJECTDC>(); objResultList = objPROJECTs.LoadAllByStatus(projectStatus); return(Ok(new { objResultList })); }
public IHttpActionResult GetAll(string clientIDs = "All", string projectStatusIDs = "All") { PROJECTBL objPROJECTs = new PROJECTBL(); List <PROJECTDC> objResultList = new List <PROJECTDC>(); objResultList = objPROJECTs.LoadAll(clientIDs, projectStatusIDs); return(Ok(new { objResultList })); }
public IHttpActionResult Get(int id) { var objProjects = new PROJECTBL(); var objResults = new PROJECTDC(); if (id > 0) { objResults = objProjects.LoadByPrimaryKey(id); } return(Ok(new { objResults })); }