public void UpdateFinancialRecordDetail(ProjectFinancialRecordDetail model)
{
using (SqlCommand command = new SqlCommand("[TIP].[UpdateProjectFinancialRecordDetail]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@projectFinancialRecordID", model.ProjectFinancialRecordID);
command.Parameters.AddWithValue("@fundingLevelID", model.FundingLevelID);
command.Parameters.AddWithValue("@fundingPeriodID", model.FundingPeriodID);
command.Parameters.AddWithValue("@fundingTypeID", model.FundingTypeID);
command.Parameters.AddWithValue("@incr01", !model.Incr01.Equals(default(decimal)) ? (object)model.Incr01 : (object)DBNull.Value);
command.Parameters.AddWithValue("@incr02", !model.Incr02.Equals(default(decimal)) ? (object)model.Incr02 : (object)DBNull.Value);
command.Parameters.AddWithValue("@incr03", !model.Incr03.Equals(default(decimal)) ? (object)model.Incr03 : (object)DBNull.Value);
command.Parameters.AddWithValue("@incr04", !model.Incr04.Equals(default(decimal)) ? (object)model.Incr04 : (object)DBNull.Value);
command.Parameters.AddWithValue("@incr05", !model.Incr05.Equals(default(decimal)) ? (object)model.Incr05 : (object)DBNull.Value);
this.ExecuteNonQuery(command);
}
}
public void DeleteFinancialRecordDetail(ProjectFinancialRecordDetail model)
{
using (SqlCommand command = new SqlCommand("[TIP].[DeleteProjectFinancialRecordDetail]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@projectFinancialRecordID", model.ProjectFinancialRecordID);
command.Parameters.AddWithValue("@fundingLevelID", model.FundingLevelID);
command.Parameters.AddWithValue("@fundingPeriodID", model.FundingPeriodID);
command.Parameters.AddWithValue("@fundingTypeID", model.FundingTypeID);
this.ExecuteNonQuery(command);
}
}
public JsonResult UpdateFinancialRecordDetail(int projectFinancialRecordID, int fundingTypeID, int fundingLevelID, int fundingPeriodID, decimal incr01, decimal incr02, decimal incr03, decimal incr04, decimal incr05)
{
ProjectFinancialRecordDetail model = new ProjectFinancialRecordDetail()
{
ProjectFinancialRecordID = projectFinancialRecordID
,
FundingLevelID = fundingLevelID
,
FundingTypeID = fundingTypeID
,
FundingPeriodID = fundingPeriodID
,
Incr01 = incr01
,
Incr02 = incr02
,
Incr03 = incr03
,
Incr04 = incr04
,
Incr05 = incr05
};
try
{
_projectRepository.UpdateFinancialRecordDetail(model);
}
catch (Exception ex)
{
//this.Logger.LogMethodError("ProjectController", "UpdateFinancialRecordDetail", Request.Form.ToString(), ex);
return Json(new
{
message = "Changes could not be stored. An error has been logged."
,
error = "true"
,
exceptionMessage = ex.Message
});
}
return Json(new
{
message = "Project Financial Record Detail successfully updated."
,
error = "false"
});
}
