private async Task SavePayment(Payment payment, SqlConnection conn, SqlTransaction tx) { DataAccess.StructuredParamValue amounts = null; if (payment.PersonalAmounts.Count > 0) { amounts = new DataAccess.StructuredParamValue(_amountsMetadata, payment.PersonalAmounts.Count); foreach (PersonalAmount pa in payment.PersonalAmounts) { amounts.NewRecord(); amounts.AddInt32(pa.EmployeeId); amounts.AddDecimal(pa.Amount); } } using (SqlCommand cmd = _sqlServer.GetSpCommand("payment.SavePayment", conn, tx)) { cmd.AddIntParam("@PlaceId", payment.PlaceId); cmd.AddIntParam("@EmployeeId", payment.EmployeeId); cmd.AddIntParam("@ShareSchemeHistoryId", payment.ShareSchemeHistoryId); cmd.AddTinyIntParam("@Status", (byte)payment.Status); cmd.AddTinyIntParam("@ReasonToReturn", (byte?)payment.ReasonToReturn); cmd.AddCharParam("@DataSource", 6, payment.DataSource); cmd.AddCharParam("@Provider", 6, payment.Provider); cmd.AddDecimalParam("@OriginalAmount", 18, 2, payment.OriginalAmount); cmd.AddDecimalParam("@ReceivedAmount", 18, 2, payment.ReceivedAmount); cmd.AddDecimalParam("@BankCommissionAmount", 18, 2, payment.BankCommissionAmount); cmd.AddDecimalParam("@AgentCommissionAmount", 18, 2, payment.AgentCommissionAmount); cmd.AddDecimalParam("@IncomeAmount", 18, 2, payment.IncomeAmount); cmd.AddDecimalParam("@PayoutAmount", 18, 2, payment.PayoutAmount); cmd.AddDateTime2Param("@PaymentDateTime", payment.PaymentDateTime); cmd.AddBitParam("@IsTimeSpecified", payment.IsTimeSpecified); cmd.AddDateTime2Param("@ArrivalDateTime", payment.ArrivalDateTime); cmd.AddVarCharParam("@DocumentName", 100, (payment.DocumentId.HasValue ? null : payment.DocumentName)); SqlParameter documentIdParam = cmd.AddIntParam("@DocumentId", payment.DocumentId).InputOutput(); cmd.AddVarCharParam("@DocumentNumber", 40, (payment.DocumentId.HasValue ? null : payment.DocumentNumber)); cmd.AddDateParam("@DocumentDate", (payment.DocumentId.HasValue ? null : payment.DocumentDate)); cmd.AddVarCharParam("@ExternalId", 50, payment.ExternalId); cmd.AddNVarCharParam("@Fio", 100, payment.Fio); cmd.AddNVarCharParam("@Address", 150, payment.Address); cmd.AddNVarCharParam("@Purpose", 150, payment.Purpose); cmd.AddNVarCharMaxParam("@RawData", payment.RawData); cmd.AddStructuredParam("@Amounts", "payment.PaymentShare", amounts); SqlParameter PaymentIdParam = cmd.AddBigIntParam("@PaymentId").Output(); SqlParameter StatusParam = cmd.AddTinyIntParam("@FinalStatus").Output(); await cmd.ExecuteNonQueryAsync(); payment.Id = PaymentIdParam.GetInt64(); payment.Status = (PaymentStatus)StatusParam.GetByte(); if (!payment.DocumentId.HasValue) { payment.DocumentId = documentIdParam.GetInt32OrNull(); } } }
private async Task CreateRequest() { using (SqlConnection conn = _sqlServer.GetConnection()) { await conn.OpenAsync(); try { using (SqlCommand cmd = _sqlServer.GetSpCommand("acquiring.SucceedRequest", conn)) { cmd.AddIntParam("@RequestId", _requestId); SqlParameter TypeParam = cmd.AddTinyIntParam("@Type").Output(); SqlParameter PlaceIdParam = cmd.AddIntParam("@PlaceId").Output(); SqlParameter EmployeeIdParam = cmd.AddIntParam("@EmployeeId").Output(); SqlParameter AmountParam = cmd.AddDecimalParam("@Amount", 18, 2).Output(); SqlParameter retValParam = cmd.AddReturnValue(); await cmd.ExecuteNonQueryAsync(); int retVal = retValParam.GetInt32OrDefault(); if (retVal == -1) { _response.SetError(3, "Запрос на платёж не найден"); return; } _type = (PaymentType)TypeParam.GetByte(); _placeId = PlaceIdParam.GetInt32(); _employeeId = EmployeeIdParam.GetInt32OrDefault(); _amount = AmountParam.GetDecimal(); } } catch (Exception e) { _response.SetError(2, e.Message); } } }
private async Task <ShareData> GetShareData(Payment payment, SqlConnection conn, SqlTransaction tx) { ShareData share = new ShareData(); Dictionary <int, GroupShareData> groups = new Dictionary <int, GroupShareData>(); using (SqlCommand cmd = _sqlServer.GetSpCommand("payment.LoadShareData", conn, tx)) { cmd.AddIntParam("@PlaceId", payment.PlaceId); cmd.AddIntParam("@EmployeeId", payment.EmployeeId); cmd.AddDateTime2Param("@PaymentDateTime", payment.PaymentDateTime); cmd.AddBitParam("@IsTimeSpecified", payment.IsTimeSpecified); SqlParameter PaymentLimitParam = cmd.AddDecimalParam("@PaymentLimit", 18, 2).Output(); SqlParameter SystemCommissionParam = cmd.AddDecimalParam("@SystemCommission", 4, 2).Output(); SqlParameter IsPlaceActiveParam = cmd.AddIntParam("@IsPlaceActive").Output(); SqlParameter PlaceDisplayNameParam = cmd.AddNVarCharParam("@PlaceDisplayName", 100).Output(); SqlParameter ShareSchemeHistoryIdParam = cmd.AddIntParam("@ShareSchemeHistoryId").Output(); SqlParameter PersonalShareParam = cmd.AddTinyIntParam("@PersonalShare").Output(); SqlParameter EmployeeFirstNameParam = cmd.AddNVarCharParam("@EmployeeFirstName", 50).Output(); SqlParameter EmployeeLastNameParam = cmd.AddNVarCharParam("@EmployeeLastName", 50).Output(); SqlParameter EmployeeIsFiredParam = cmd.AddBitParam("@EmployeeIsFired").Output(); using (SqlDataReader dr = await cmd.ExecuteReaderAsync()) { while (dr.Read()) { GroupShareData gdata = new GroupShareData(); gdata.Name = dr.GetString("Name"); gdata.Id = dr.GetInt32("GroupId"); gdata.Weight = dr.GetByte("GroupWeight"); groups.Add(gdata.Id, gdata); share.Groups.Add(gdata); } dr.NextResult(); while (dr.Read()) { MembershipData md = new MembershipData(); md.EmployeeId = dr.GetInt32("EmployeeId"); md.GroupId = dr.GetInt32("GroupId"); md.BeginDateTime = dr.GetDateTime("BeginDateTime"); md.EndDateTime = dr.GetDateTime("EndDateTime"); md.IsManager = dr.GetBoolean("IsManager"); md.IsOwner = dr.GetBoolean("IsOwner"); share.Memberships.Add(md); groups[md.GroupId].AddMembership(md); } } share.PaymentLimit = PaymentLimitParam.GetDecimal(); share.SystemCommission = SystemCommissionParam.GetDecimal(); share.Place.Id = payment.PlaceId; share.Place.Name = PlaceDisplayNameParam.Value.ToString(); share.Place.IsActive = (IsPlaceActiveParam.GetInt32() != 0); share.ShareSchemeHistoryId = ShareSchemeHistoryIdParam.GetInt32(); share.PersonalShare = PersonalShareParam.GetByte(); if (payment.EmployeeId.HasValue) { share.Receiver = new ReceiverData(); share.Receiver.Id = payment.EmployeeId.Value; share.Receiver.FirstName = EmployeeFirstNameParam.Value.ToString(); share.Receiver.LastName = EmployeeLastNameParam.Value.ToString(); share.Receiver.IsFired = EmployeeIsFiredParam.GetBooleanOrDefault(); } } return(share); }