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