public static long Transaction(VM_Transaction transaction)
{
int intRez = 0;
using (var exodusDB = new exodusEntities())
{
var Result = new ObjectParameter("TransactionID", 0);
intRez = exodusDB.stp_Transaction_Add(
transactionAmount: transaction.TransactionAmount,
transactionCurrencyID: (int)transaction.TransactionCurrency,
transactionSender_UserID: transaction.TransactionSender.UserID,
transactionReceiver_UserID: transaction.TransactionReceiver.UserID,
tagID: transaction.Tag?.TagID,
applicationID: transaction.Application?.ApplicationID,
obligationID: transaction.Obligation?.ObligationID,
isConfirmed: transaction.IsConfirmed,
isConfirmedBySender: transaction.IsConfirmedBySender,
isConfirmedByReceiver: transaction.IsConfirmedByReceiver,
transactionDateTime: transaction.TransactionDateTime,
transactionAccountID: transaction.TransactionAccount?.AccountID,
transferTypeID: (int)transaction.TransferType,
transactionMemo: transaction.TransactionMemo,
transactionID: Result);
return(Convert.ToInt64(Result.Value));
}
}
public static VM_Transaction ByID(long TransactionID)
{
VM_Transaction transaction = null;
using (var exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_Transaction_ByID(TransactionID).FirstOrDefault();
if (rez != null)
{
transaction = new VM_Transaction()
{
TransactionID = rez.TransactionID,
Application = new VM_Application()
{
ApplicationID = rez.ApplicationID.HasValue ? rez.ApplicationID.Value : 0,
ApplicationNameEng = rez.ApplicationNameEng,
ApplicationNameRus = rez.ApplicationNameRus
},
IsConfirmed = rez.isConfirmed,
IsConfirmedByReceiver = rez.isConfirmedByReceiver,
IsConfirmedBySender = rez.isConfirmedBySender,
Obligation = new VM_Obligation()
{
ObligationID = rez.ObligationID.HasValue ? rez.ObligationID.Value : 0,
ObligationKind = new VM_ObligationKind()
{
ObligationKindID = rez.ObligationKindID.HasValue ? (EN_ObligationKind)rez.ObligationKindID.Value : EN_ObligationKind.H2OUserHelp,
ObligationNameEng = rez.ObligationNameEng,
ObligationNameRus = rez.ObligationNameRus,
ObligationComment = rez.ObligationComment
},
},
Tag = new VM_Tag()
{
TagID = rez.TagID.HasValue ? rez.TagID.Value : 0,
NameEng = rez.TagNameEng,
NameRus = rez.TagNameRus
},
TransactionAmount = rez.TransactionAmount,
TransactionDateTime = rez.TransactionDateTime,
TransactionMemo = rez.TransactionMemo,
TransactionAccount = new VM_Account()
{
AccountDetails = rez.AccountDetails,
AccountID = rez.AccountID.HasValue ? rez.AccountID.Value : 0,
fk_AccountTypeID = rez.AccountTypeID.HasValue ? rez.AccountTypeID.Value : 0
//fk_UserID
},
TransactionSender = new VM_User()
{
UserID = rez.SenderUserID,
UserFirstName = rez.SenderUserFirstName,
UserLastName = rez.SenderUserLastName
},
TransactionReceiver = new VM_User()
{
UserID = rez.ReceiverUserID,
UserFirstName = rez.ReceiverUserFirstName,
UserLastName = rez.ReceiverUserLastName
},
TransferType = (EN_TransferType)rez.TransferTypeID,
TransactionCurrency = (En_Currency)rez.CurrencyID
};
}
}
return(transaction);
}
