public void UpdatePoolProject(PoolProject model) { try { ProjectRepository.UpdatePoolProject(model); } catch (Exception ex) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.ExpectationFailed) { ReasonPhrase = ex.Message }); } }
public int AddPoolProject(PoolProject model) { try { int poolProjectId = ProjectRepository.AddPoolProject(model); if (poolProjectId == 0) throw new Exception("Returned 0 on poolMasterVersionId " + model.PoolMasterVersionID); return poolProjectId; } catch (Exception ex) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.ExpectationFailed) { ReasonPhrase = ex.Message }); } }
public Int32 AddPoolProject(PoolProject model) { int retval = 0; using (SqlCommand command = new SqlCommand("[TIP].[AddPoolProject]") { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@PoolMasterVersionId", model.PoolMasterVersionID); command.Parameters.AddWithValue("@ProjectName", model.ProjectName != null ? (object)model.ProjectName.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@Description", model.Description != null ? (object)model.Description.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@BeginAt", model.BeginAt != null ? (object)model.BeginAt.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@EndAt", model.EndAt != null ? (object)model.EndAt.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@Cost", model.Cost != null ? (object)model.Cost.Value: (object)DBNull.Value); SqlParameter outParam = new SqlParameter("@PoolProjectId", SqlDbType.Int); outParam.Direction = ParameterDirection.Output; command.Parameters.Add(outParam); this.ExecuteNonQuery(command); retval = (int)command.Parameters["@PoolProjectId"].Value; } return retval; }
public void UpdatePoolProject(PoolProject model) { using (SqlCommand command = new SqlCommand("[TIP].[UpdatePoolProject]") { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@PoolProjectId", model.PoolProjectID); command.Parameters.AddWithValue("@ProjectName", model.ProjectName != null ? (object)model.ProjectName.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@Description", model.Description != null ? (object)model.Description.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@BeginAt", model.BeginAt != null ? (object)model.BeginAt.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@EndAt", model.EndAt != null ? (object)model.EndAt.ToString() : (object)DBNull.Value); command.Parameters.AddWithValue("@Cost", model.Cost != null ? (object)model.Cost.Value : (object)DBNull.Value); this.ExecuteNonQuery(command); } }
public JsonResult UpdatePoolProject(int poolProjectId, string projectName, string description, string beginAt, string endAt, decimal cost) { PoolProject model = new PoolProject() { PoolProjectID = poolProjectId , ProjectName = projectName , Description = description , BeginAt = beginAt , EndAt = endAt , Cost = cost }; try { _projectRepository.UpdatePoolProject(model); } catch (Exception ex) { //this.Logger.LogMethodError("ProjectController", "UpdatePoolProject", Request.Form.ToString(), ex); return Json(new { error = "Changes could not be stored. An error has been logged." }); } return Json(new { message = "Pool Project successfully updated." }); }
public JsonResult AddPoolProject(int poolMasterVersionId, string projectName, string description, string beginAt, string endAt, decimal cost) { PoolProject model = new PoolProject() { PoolMasterVersionID = poolMasterVersionId , ProjectName = projectName , Description = description , BeginAt = beginAt , EndAt = endAt , Cost = cost }; int poolProjectId = 0; try { poolProjectId = _projectRepository.AddPoolProject(model); if (poolProjectId == 0) throw new Exception("Returned 0 on poolMasterVersionId" + poolMasterVersionId); } catch (Exception ex) { //this.Logger.LogMethodError("ProjectController", "AddPoolProject", Request.Form.ToString(), ex); return Json(new { error = "Changes could not be stored. An error has been logged." }); } return Json(new { message = "Pool Project successfully added.", poolprojectid = poolProjectId }); }