public static long Intention(VM_Intention intention)
{
long rezult = 0;
using (var exodusDB = new exodusEntities())
{
var Result = new ObjectParameter("Result", 0);
exodusDB.stp_Intention_Update(
obligationTypeID: (int)intention.ObligationType.ObligationTypeID,
obligationKindID: (long)intention.ObligationKind.ObligationKindID,
periodID: (int)intention.Period,
intentionTermID: (int)intention.IntentionTerm,
issuerUserID: intention.IntentionIssuer.UserID,
holderUserID: intention.IntentionHolder.UserID,
tagID: intention.IntentionTag.TagID,
applicationID: intention.IntentionApplication.ApplicationID,
intentionAmount: intention.IntentionAmount,
currencyID: (int)intention.CurrencyID,
intentionDurationMonths: intention.IntentionDurationMonths,
intentionStartDate: intention.IntentionStartDate,
intentionEndDate: intention.IntentionEndDate,
intentionIsActive: intention.IntentionIsActive,
intentionID: intention.IntentionID,
result: Result,
dayOfWeek: intention.IntentionDayOfWeek,
dayOfMonth: intention.IntentionDayOfMonth,
intentionMemo: intention.IntentionMemo
);
rezult = Convert.ToInt64(Result.Value);
}
return(rezult);
}
public static VM_PaymentAccount ByID(int ID)
{
using (var exodusDB = new exodusEntities())
{
var acc = exodusDB.stp_GetPaymentAccountByID(ID).FirstOrDefault();
if (acc != null)
{
return(new VM_PaymentAccount()
{
AccountID = ID,
AccountDetails = acc.AccountDetails,
AccountType = (En_AccountType)acc.fk_AccountTypeID,
AccountTypeName = ((En_AccountType)acc.fk_AccountTypeID).ToString(),
User = _DL.User.Get.ByID(acc.fk_UserID),
Card = new VM_BankCard()
{
CardID = acc.CreditCardID.HasValue ? acc.CreditCardID.Value : -1,
AdditionalInfo = acc.CardAdditionalInfo,
BankID = acc.fk_BankID.HasValue ? acc.fk_BankID.Value : -1,
BankName = acc.BankName,
CardNumber = acc.CardNumber,
CardValidTill = acc.CardValidTill.HasValue ? acc.CardValidTill.Value : new DateTime(0),
TypeID = acc.fk_CardTypeID.HasValue ? (EN_CardType)acc.fk_CardTypeID.Value : EN_CardType.None,
UserID = acc.fk_UserID
}
});
}
else
{
return(null);
}
}
}
public static long ByID(long EventID)
{
using (exodusEntities db = new exodusEntities())
{
return(db.stp_EventDeleteByID(EventID));
}
}
public static VM_EventTemplate EventTemplate_ByEventTypeID(EN_EventType EventType)
{
using (var exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_EventTemplate_ByEventTypeID(EventType.ToInt()).FirstOrDefault();
if (rez != null)
{
var template = new VM_EventTemplate()
{
eventType = new VM_EventType()
{
ID = rez.fk_EventTypeID
},
ID = rez.EventTemplateID,
TitleEng = rez.EventTitleEng,
TitleRus = rez.EventTitleRus
};
// Create XML
template.Content.LoadXml(rez.EventContent);
template.Thumbnail.LoadXml(rez.EventThumbnail);
// return template
return(template);
}
else
{
return(null);
}
}
}
public static int TagID_AppID_XML(long EventID, string Thumbnail, string Content, long?TagID, long?ApplicationID)
{
using (exodusEntities exodusDB = new exodusEntities())
{
return(exodusDB.stp_EventUpdate_XML(EventID, Thumbnail, Content, TagID, ApplicationID));
}
}
/*public static int Thumbnail(long EventID, string Thumbnail)
* {
* using (exodusEntities exodusDB = new exodusEntities())
* {
* return exodusDB.stp_EventUpdate_Thumbnail(EventID, Thumbnail);
* }
* }*/
public static int MarkETU_Processed(long UserID, long EventID)
{
using (exodusEntities exodusDB = new exodusEntities())
{
return(exodusDB.stp_Event_MarkETU_Processed(eventID: EventID, userID: UserID));
}
}
public static List <long> ListID()
{
using (exodusEntities exodusDB = new exodusEntities())
{
return(exodusDB.stp_EventListID().Select(a => a.Value).ToList());
}
}
public static VM_Event ByID(long EventID)
{
using (exodusEntities exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_Event_ByID(EventID).FirstOrDefault();
if (rez != null)
{
var tag = rez.fk_TagID.HasValue ? _DL.Tag.Get.ByID(rez.fk_TagID.Value) : null;
//
var _event = new VM_Event()
{
ID = rez.EventID,
Title = rez.EventTitle,
Added = rez.EventAdded,
Category = new VM_EventCategory()
{
ID = rez.fk_EventCategoryID
},
Type = Global.Cache.dicEventTypes[(EN_EventType)rez.fk_EventTypeID],
Tag = tag ?? new VM_Tag(),
Application = (tag == null) ? new VM_Application() : Global.Cache.dicApplications[tag.ApplicationType],
ImportanLevel = new VM_ImportanLevel()
{
ID = (int)Global.Cache.dicEventTypes[(EN_EventType)rez.fk_EventTypeID].ImportantLevel
}
};
// load XML
_event.Content.LoadXml(rez.EventContent);
_event.Thumbnail.LoadXml(rez.EventThumbnail);
return(_event);
}
;
}
return(null);
}
public static VM_User ByExternalID(string externalID, EN_RegistrationSource registrationSource)
{
VM_User User = new VM_User();
using (var exodusDB = new exodusEntities())
{
var result = exodusDB.stp_User_ByExternalID(externalID,
registrationSource.ToInt()).FirstOrDefault();
if (result != null)
{
User.UserID = result.UserID;
User.UserGuid = result.UserGuid;
User.UserFirstName = result.UserFirstName;
User.UserLastName = result.UserLastName;
User.UserType = (En_UserType)result.UserTypeID;
User.UserStatus = (En_CurrentStatus)result.UserStatusID;
User.UserStatusMessage = result.UserStatusMessage;
User.UserAbout = result.UserAbout;
User.UserRegistered = result.UserRegistered;
User.UserRegistrationSource = (EN_RegistrationSource)result.RegistrationSourceID;
User.Avatar = Global.Cache.dicUserAvatars[result.UserID];
}
else
{
return(null);
}
}
return(User);
}
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 long Routing(DTO_ObligationRouting obligationRouting)
{
using (exodusEntities exodusDB = new exodusEntities())
{
var routingID = new ObjectParameter("routingID", 0);
var rez = exodusDB.stp_Obligation_Routing_Add(
obligationID: obligationRouting.ObligationID,
routingTypeID: obligationRouting.RoutingTypeID.ToInt(),
routedBy_UserID: obligationRouting.RoutedByUserID,
routedTo_UserID: obligationRouting.RoutedToUserID,
transferTypeID: obligationRouting.TransferTypeID.ToInt(),
accountTypeID: obligationRouting.AccountTypeID.ToInt(),
accountID: obligationRouting.AccountID,
accountCustomDetails: obligationRouting.AccountCustomDetails,
transfer_UserID: obligationRouting.TransferUserID,
transferUserCustomDetails: obligationRouting.TransferUserCustomDetails,
transferAmount: obligationRouting.TransferAmount,
transferAmountCurrency: obligationRouting.TransferAmountCurrency.ToInt(),
desiredEndDate: obligationRouting.DesiredEndDate,
routingID: routingID);
return(Convert.ToInt64(routingID.Value));
}
}
public static List <long> All_ID()
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_Tag_GelAllId().Select(a => a.Value).ToList());
}
}
public static int Confirm(long obligationID)
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_Obligation_Confirm(obligationID));
}
}
public static long Obligation(VM_Obligation obligation)
{
using (var exodusDB = new exodusEntities())
{
var obligationID = new ObjectParameter("obligationID", 0);
exodusDB.stp_ObligationAdd(
obligationKindID: (long)obligation.ObligationKind.ObligationKindID,
currencyID: (int)obligation.ObligationCurrency,
amountPerPayment: obligation.AmountPerPayment,
amountDue: obligation.AmountDue,
amountTotal: obligation.AmountTotal,
isActive: obligation.IsActive,
obligationPeriodID: (int)obligation.ObligationPeriod,
obligationDate: obligation.ObligationDate,
obligationExpiration: obligation.ObligationExpiration,
obligationClassID: (long)obligation.ObligationClass.ObligationClass,
obligationStatusID: (int)obligation.ObligationStatus.ObligationStatus,
obligationTypeID: (int)obligation.ObligationType.ObligationTypeID,
tagID: obligation.ObligationTag.TagID,
applicationID: (int)obligation.ObligationApplication.ApplicationID,
issuerUserID: obligation.ObligationIssuer.UserID,
holderUserID: obligation.ObligationHolder.UserID,
obligationID: obligationID,
intentionID: obligation.IntentionID
);
return(Convert.ToInt64(obligationID.Value));
}
}
public static List <TagSearch> SearchByUserID(long UserID)
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_Tags_ByUserID(UserID)
.Where(a => Global.Cache.ApplicationsActiveId.Contains(a.ApplicationID)).
Select(a => new TagSearch()
{
TagID = a.TagID,
NameEng = a.TagNameEng,
NameRus = a.TagNameRus,
Description = a.TagDescription,
Owner_UserID = a.TagOwner_UserID,
OwnerFirstName = a.TagOwnerFirstName,
OwnerLastName = a.TagOwnerLastName,
Period = (EN_TagPeriod)a.PeriodID,
PeriodNameEng = a.PeriodNameEng,
PeriodNameRus = a.PeriodNameRus,
ApplicationID = a.ApplicationID,
Obligations_Persent = a.obligations_percent.HasValue ? a.obligations_percent.Value : 0,
Obligations_Total = a.obligations_total.HasValue ? a.obligations_total.Value : 0,
DaysLeft = a.days_left.HasValue ? a.days_left.Value : 0,
Intentions_Persent = a.intentions_percent.HasValue ? a.intentions_percent.Value : 0,
Intentions_Total = a.intentions_total.HasValue ? a.intentions_total.Value : 0,
OwnerStatusID = a.tag_owner_statusID.HasValue ? a.tag_owner_statusID.Value : 0,
TagCurrency = (En_Currency)a.TotalAmountCurrencyID
}).ToList());
}
}
public static long AddTag(VM_Tag Tag)
{
using (var exodusDB = new exodusEntities())
{
var tagID = new ObjectParameter("TagID", 0);
exodusDB.stp_Tag_Add(tagOwnerID: Tag.Owner_UserID,
tagTypeID: (long)Tag.Type,
tagAccessTypeID: (int)Tag.AccessType,
tagNameEng: Tag.NameEng,
tagNameRus: Tag.NameRus,
tagDescription: Tag.Description,
tagID: tagID,
tagApplicationID: Tag.ApplicationID,
tagDayOfMonth: Tag.DayOfMonth,
tagDayOfWeek: Tag.DayOfWeek,
tagEndDate: Tag.EndDate,
tagMinIntentionAmount: Tag.MinIntentionAmount,
tagPeriod: (int)Tag.Period,
tagTotalAmount: Tag.TotalAmount,
tagMinIntentionCurrencyID: Tag.MinIntentionCurrencyID,
tagTotalAmountCurrencyID: Tag.TotalAmountCurrencyID,
defaultIntentionOwnerID: Tag.DefaultIntentionOwner.UserID);
long TagID = Convert.ToInt64(tagID.Value);
//
Global.Cache.AddTagId(TagID);
//
return(TagID);
}
}
public static List <VM_User> RelationsByID(long UserID)
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_GetUserRelations_ByUserID(UserID).Select(a => new VM_User()
{
UserID = a.UserID,
UserGuid = a.UserGuid,
UserFirstName = a.UserFirstName,
UserLastName = a.UserLastName,
UserType = (En_UserType)a.UserTypeID,
UserStatus = (En_CurrentStatus)a.UserStatusID,
UserStatusMessage = a.UserStatusMessage,
UserAbout = a.UserAbout,
UserRegistered = a.UserRegistered,
UserRegistrationSource = (EN_RegistrationSource)a.RegistrationSourceID,
Avatar = Global.Cache.dicUserAvatars[a.UserID],
HelpDetail = new VM_UserHelpDetail
{
HelpDetailID = a.HelpDetailID.HasValue ? a.HelpDetailID.Value : 0,
UpdatedDateTime = a.UpdatedDateTime.HasValue ? a.UpdatedDateTime.Value : DateTime.MinValue,
UserHelpAmountCurrency = a.CurrencyID.HasValue ? (En_Currency)a.CurrencyID.Value : En_Currency.NONE,
UserHelpAmountRequired = a.UserHelpAmountRequired.HasValue ? a.UserHelpAmountRequired.Value : 0,
UserHelpDetails = a.UserHelpDetails,
UserHelpPeriod = a.UserHelpPeriodID.HasValue ? (En_HelpPeriods)a.UserHelpPeriodID.Value : En_HelpPeriods.Undefined,
UserID = a.UserID
},
UserInvitedBy = new VM_User()
{
UserID = a.UserInvitedBy,
Avatar = Global.Cache.dicUserAvatars[a.UserInvitedBy]
}
}).ToList());
}
}
public static int About(long UserID, string UserAbout)
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_User_About_Update(UserID, UserAbout));
}
}
public static List <VM_Intention> ByUserIssuerID_ByTagID(long TagID, long UserID)
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_Intention_ByUserIssuerID_ByTagID(TagID, UserID).Select(a => GetIntentionFromDB(a)).ToList());
}
}
public static int Obligation(long obligationID)
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_Obligation_Delete(obligationID));
}
}
public static int TokenActionAdd(string token, DateTime?ExpirationDate, string action, long?userID)
{
using (var exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_AddTokenAction(token, DateTime.Now, ExpirationDate, action, userID);
return(rez);
}
}
public static List <VM_Obligation> ByIssuerID(long UserID)
{
using (var exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_Obligations_All_ByIssuerID(UserID);
return(rez.Select(a => GetFromDB(a)).ToList());
}
}
public static VM_Obligation ByID(long ObligationID)
{
using (var exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_Obligation_ByID(ObligationID).FirstOrDefault();
return((rez != null) ? GetFromDB(rez) : null);
}
}
public static int Transaction_ConfirmByReceiver(long TransactionID, bool IsConfirmedByReceiver)
{
using (var exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_Transaction_Confirm_ByReceiver(TransactionID, IsConfirmedByReceiver);
return(rez);
}
}
public static UserAvatar Avatar(long UserID, UserAvatar avatar)
{
using (var exodusDB = new exodusEntities())
{
int rezult = exodusDB.stp_User_Avatar_Update(avatar.AvatarBigName, avatar.AvatarSmallName, UserID);
return((rezult != 0) ? avatar : null);
}
}
public static long ByID(long ID)
{
using (var exodusDB = new exodusEntities())
{
long rezID = exodusDB.stp_Intention_Delete_ByID(ID);
return(rezID);
}
}
public static List <VM_Tag> ByUserID(long UserID)
{
using (var exodusDB = new exodusEntities())
{
return(exodusDB.stp_Tags_ByUserID(UserID)
.Where(a => Global.Cache.ApplicationsActiveId.Contains(a.ApplicationID)).
Select(a => new VM_Tag()
{
TagID = a.TagID,
NameSystem = a.TagNameSystem,
NameEng = a.TagNameEng,
NameRus = a.TagNameRus,
Description = a.TagDescription,
Created = a.TagCreated,
Owner_UserID = a.TagOwner_UserID,
OwnerFirstName = a.TagOwnerFirstName,
OwnerLastName = a.TagOwnerLastName,
Type = (EN_TagType)a.TagTypeID,
TypeNameEng = a.TagTypeNameEng,
TypeNameRus = a.TagTypeNameRus,
TypeCommentEng = a.TagTypeCommentEng,
TypeCommentRus = a.TagTypeCommentRus,
IsTypePredefined = a.IsTagTypePredefined,
AccessType = (EN_TagAccessType)a.TagAccessTypeID,
AccessTypeNameEng = a.TagAccessTypeNameEng,
AccessTypeNameRus = a.TagAccessTypeNameRus,
UsersCount = a.TagUsersCount.Value,
Added = a.Added,
Role = new VM_TagRole()
{
TagRoleID = a.TagRoleID,
NameEng = a.TagRoleNameEng,
NameRus = a.TagRoleNameRus
},
Period = (EN_TagPeriod)a.PeriodID,
PeriodNameEng = a.PeriodNameEng,
PeriodNameRus = a.PeriodNameRus,
ApplicationID = a.ApplicationID,
ApplicationNameEng = a.ApplicationNameEng,
ApplicationNameRus = a.ApplicationNameRus,
EndDate = a.EndDate.HasValue ? a.EndDate.Value : new DateTime(),
DayOfMonth = a.DayOfMonth.HasValue ? a.DayOfMonth.Value : -1,
DayOfWeek = a.DayOfWeek.HasValue ? a.DayOfWeek.Value : -1,
TotalAmount = a.TotalAmount,
TotalAmountCurrencyCode = a.TotalAmountCurrencyCode,
TotalAmountCurrencyID = a.TotalAmountCurrencyID,
MinIntentionAmount = a.MinIntentionAmount,
MinIntentionCurrencyID = a.MinIntentionCurrencyID,
MinIntentionCurrencyCode = a.MinIntentionCurrencyCode,
DefaultIntentionOwner = new VM_User()
{
UserID = a.DefaultIntentionOwnerID,
UserFirstName = a.DefaultIntentionOwnerFirstName,
UserLastName = a.DefaultIntentionOwnerLastName
}
}).ToList());
}
}
public static decimal Intentions_ByUserID_CurrentMonth(long UserID, DateTime dateTime, En_Currency currency = En_Currency.USD)
{
using (var exodusDB = new exodusEntities())
{
var intentionAmount = new ObjectParameter("IntentionAmount", 0);
int rez = exodusDB.stp_H2O_Intentions_ByUserID_n_Month(UserID, dateTime, currency.ToInt(), intentionAmount);
return(Convert.ToDecimal(intentionAmount.Value));
}
}
public static decimal Intention_Sum_ByTagID(long TagID)
{
using (var exodusDB = new exodusEntities())
{
ObjectParameter Sum = new ObjectParameter("Sum", 0);
var rez = exodusDB.stp_Intention_Sum_ByTagID(TagID, Sum);
return(Convert.ToDecimal(Sum.Value));
}
}
public static decimal Obligations_ByUserID_CurrentMonth(long UserID, En_Currency currency = En_Currency.USD)
{
using (var exodusDB = new exodusEntities())
{
var obligationAmount = new ObjectParameter("ObligationAmount", 0);
int rez = exodusDB.stp_H2O_Obligations_ByUserID_CurrentMonth(UserID, currency.ToInt(), obligationAmount);
return(Convert.ToDecimal(obligationAmount.Value));
}
}
