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