public int InsertFinancialSupportRequest(FinancialSupportRequest financialSupportRequest)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", financialSupportRequest.Id),
new MySqlParameter("@approval_amount", financialSupportRequest.ApprovedAmount),
new MySqlParameter("@branch", financialSupportRequest.branch),
new MySqlParameter("@current_status", financialSupportRequest.CurrentStatus),
new MySqlParameter("@date", financialSupportRequest.Date),
new MySqlParameter("@details", financialSupportRequest.Details),
new MySqlParameter("@digital_signature", financialSupportRequest.DigitalSignature),
new MySqlParameter("@is_approved", financialSupportRequest.IsApproved),
new MySqlParameter("@is_cancaled", financialSupportRequest.Iscanceled),
new MySqlParameter("@number_of_month_approved", financialSupportRequest.NumberOfMonthsApproved),
new MySqlParameter("@student", financialSupportRequest.Student)
};
return(_dbContext.Insert(DbContent.Tables.FinancialSupportRequest.InsertTable, true, parameters));
}
public static FinancialSupportRequestDto ConvertToDto(FinancialSupportRequest financialSupportRequest)
{
if (financialSupportRequest == null)
{
return(null);
}
return(new FinancialSupportRequestDto()
{
ApprovedAmount = financialSupportRequest.ApprovedAmount,
branch = financialSupportRequest.branch,
CurrentStatus = financialSupportRequest.CurrentStatus,
Date = financialSupportRequest.Date,
Details = financialSupportRequest.Details,
DigitalSignature = financialSupportRequest.DigitalSignature,
Id = financialSupportRequest.Id,
IsApproved = financialSupportRequest.IsApproved,
Iscanceled = financialSupportRequest.Iscanceled,
NumberOfMonthsApproved = financialSupportRequest.NumberOfMonthsApproved,
Student = financialSupportRequest.Student
});
}
public HttpResponseMessage InsertFinancialSupportRequest([FromBody] FinancialSupportRequestDto financialSupportRequestDto, [FromUri] int studentId)
{
try
{
FinancialSupportRequest financialSupportRequest = Converters.Convert(financialSupportRequestDto);
if (!ValidateModel.IsValid(new List <object>()
{
financialSupportRequest
}))
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ValidateModel.ModelsResults));
}
FinancialSupportManager.InsertFinancialSupportRequest(financialSupportRequest);
return(Request.CreateResponse(HttpStatusCode.OK, financialSupportRequest.Id));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, $"Failed to insert the financial support request, {ex.Message}"));
}
}
public static int InsertFinancialSupportRequest(FinancialSupportRequest financialSupportRequest)
{
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
//if (IFinancialSupportDataManager.IsExistIdentityNumber(student.IdentityNumber, student.Id))
// throw new Exception("The identity number is already exist.");
//todo has to be change
financialSupportRequest.branch.Id = 0;
financialSupportRequest.Student.Id = 0;
int insert = financialSupportRequest.Id = FinancialSupportDataManager.InsertFinancialSupportRequest(financialSupportRequest);
scope.Complete();
return(insert);
}
}
catch (Exception ex)
{
_logger.Debug($"Failed to insert finantial support", ex);
throw;
}
}
