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