public void Add( int partitionId, long?emailSenderUserId, string @from, string[] to, string[] copyTo, string subject, string body, bool isBodyHtml, byte[] files) { _executor.Execute( "[dbo].[EmailMessage_Add]", new { State = EmailMessageState.New, partitionId, @from, To = EmailMessageData.Join(to), CopyTo = EmailMessageData.Join(copyTo), subject, body, isBodyHtml, files, emailSenderUserId }); }
public void Add(CalculationData data, long applicationId) { _executor.Execute("[dbo].[Calculation_Add]", new { data.ClientId, ApplicationHistoryId = applicationId, data.AirWaybillDisplay, data.ApplicationDisplay, data.MarkName, data.Weight, data.TariffPerKg, data.ScotchCost, data.InsuranceRate, data.FactureCost, data.FactureCostEx, data.TransitCost, data.PickupCost, data.FactoryName, data.CreationTimestamp, ClassId = data.Class, data.Count, data.Invoice, data.Value, data.Profit, data.TotalTariffCost }); }
public long Add(StateEditData data) { using (var scope = new TransactionScope()) { var id = _executor.Query <long>("[dbo].[State_Add]", new { data.Name, data.Position, IsSystem = false, }); _executor.Execute("[dbo].[StateLocalization_Merge]", new { Name = data.LocalizedName, TwoLetterISOLanguageName = data.Language, StateId = id }); scope.Complete(); return(id); } }
public void SetStateAvailabilities(long stateId, RoleType[] roles) { if (roles == null) { throw new ArgumentNullException("roles"); } var table = TableParameters.GeIdsTable("Roles", roles.Select(x => (long)x).ToArray()); _executor.Execute("[dbo].[State_SetStateAvailabilities]", new TableParameters(new { stateId }, table)); }
public void Add(int partitionId, long?userId, EventType type, EventState state, byte[] data) { _executor.Execute( "[dbo].[Event_Add]", new { EventTypeId = type, data, StateId = state, partitionId, userId }); }
public void Update(long id, string name, string email, string phone, string contact, string address, string login) { _executor.Execute("[dbo].[Carrier_Update]", new { id, name, login, email, phone, contact, address }); }
public void AddToHistory(long clientId, decimal balance, decimal money, EventType type, DateTimeOffset timestamp, string comment, bool isCalculation) { _executor.Execute("[dbo].[ClientBalanceHistory_Add]", new { clientId, balance, money, EventTypeId = type, timestamp, comment, isCalculation }); }
public void Update(long senderId, SenderData data) { _executor.Execute("[dbo].[Sender_Update]", new { id = senderId, data.Login, data.Name, data.Email, data.TariffOfTapePerBox, TwoLetterISOLanguageName = data.Language, data.Contact, data.Phone, data.Address }); }
public void AddOrReplace(long applicationId, BillData data) { _executor.Execute("[dbo].[Bill_AddOrReplace]", new { applicationId, data.Accountant, data.Bank, data.BIC, data.Client, data.CorrespondentAccount, data.Count, data.CurrentAccount, data.Goods, data.Head, data.HeaderText, data.Payee, data.Price, data.Shipper, data.TaxRegistrationReasonCode, data.TIN, data.VAT, data.EuroToRuble, data.Number, data.SaveDate, data.SendDate }); }
public void SetForEvent(EventType eventType, string language, bool enableEmailSend, EmailTemplateLocalizationData localization) { _executor.Execute("[dbo].[EmailTemplate_MergeEvent]", new { EventTypeId = eventType, localization.Body, localization.IsBodyHtml, localization.Subject, TwoLetterISOLanguageName = language, enableEmailSend }); }
public void Update(long id, string englishName, string russianName, int position) { _executor.Execute("[dbo].[Country_Update]", new { englishName, russianName, position, id }); }
public void Set(EventType eventType, RoleType[] recipients) { var table = TableParameters.GeIdsTable("Recipients", recipients.Select(x => (long)x).ToArray()); _executor.Execute("[dbo].[EventEmailRecipient_Set]", new TableParameters(new { EventTypeId = eventType }, table)); }
public void Update(long id, string name, string login, string email) { _executor.Execute("[dbo].[Forwarder_Update]", new { id, name, login, email }); }
public void Update(TransitData transit) { _executor.Execute("[dbo].[Transit_Update]", transit); }
public void SetLanguage(long userId, string language) { _executor.Execute("[dbo].[User_SetLanguage]", new { userId, language }); }
public void Delete(long id) { _executor.Execute("[dbo].[AwbFile_Delete]", new { id }); }
public void SetClientContract(long clientId, string name, byte[] data) { _executor.Execute("[dbo].[ClientContract_Merge]", new { clientId, name, data }); }