public void Deve_Criar_Um_Novo_Cliente()
{
var code = 1;
var firstName = "Victor";
var lastName = "Domingues";
var name = new NameVo(firstName, lastName);
var number = "11992535010";
var phone = new PhoneVo(number);
var phone2 = new PhoneVo(number);
var cpf = "3333333333";
var document = new DocumentVo(cpf, EDocumentType.Cpf);
var emailAddress = "*****@*****.**";
var email = new EmailVo(emailAddress);
var address = new Address(Tenant.Id, "", "", "", "", "", "", "", "");
var customer = new Customer(Tenant.Id, code, name, phone, phone2, email, document, address.Id, null);
Assert.IsTrue(customer.Valid);
Assert.AreEqual(customer.TenantId, Tenant.Id);
Assert.AreEqual(customer.Name, name);
Assert.AreEqual(customer.Phone, phone);
Assert.AreEqual(customer.Phone2, phone2);
Assert.AreEqual(customer.Email, email);
Assert.AreEqual(customer.Document, document);
Assert.AreEqual(customer.Code, code);
}
public bool CreateReportBulkMailRequest(EmailVo emailVo)
{
bool isCompleted = false;
EmailSMSDao emailSMSDao = new EmailSMSDao();
try
{
isCompleted = bool.Parse(emailSMSDao.CreateReportBulkMailRequest(emailVo).ToString());
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "EmailSMSBo.cs:AddToEmailQueue(EmailVo emailVo)");
object[] objects = new object[1];
objects[0] = emailVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(isCompleted);
}
private bool ProcessBulkMailRequest(int requestId, int dependentRequestId)
{
EmailVo emailVo = new EmailVo();
DataSet dsReportInputOutPutData = GetBulkMailReportInputOutData(requestId, dependentRequestId);
DataTable dtRequestInputData = dsReportInputOutPutData.Tables[0];
DataTable dtRequestOutPutData = dsReportInputOutPutData.Tables[1];
bool flag;
try
{
emailVo = FillBulkMailParamerValues(dtRequestInputData, dtRequestOutPutData);
emailVo.Body = "Dear Customer Please find attached report";
emailVo.Subject = "MF Report";
emailVo.SourceId = requestId;
flag = CreateBulkMailRequest(emailVo);
return(flag);
}
catch (BaseApplicationException Ex)
{
UpdateRequestDetails(requestId);
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "BulkMailRequestGenerationBo:ProcessBulkMailRequest()");
object[] objects = new object[1];
objects[0] = daemonCode;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private EmailVo FillBulkMailParamerValues(DataTable dtRequestInputData, DataTable dtRequestOutPutData)
{
EmailVo emailVo = new EmailVo();
try
{
foreach (DataRow dr in dtRequestInputData.Rows)
{
switch (dr["WP_ParameterCode"].ToString())
{
case "AID":
emailVo.AdviserId = Int32.Parse(dr["WRD_InputParameterValue"].ToString());
break;
case "CID":
emailVo.CustomerId = Int32.Parse(dr["WRD_InputParameterValue"].ToString());
break;
case "CMAIL":
emailVo.To = dr["WRD_InputParameterValue"].ToString();
break;
case "RMAIL":
emailVo.EmailFrom = dr["WRD_InputParameterValue"].ToString();
break;
case "ONAME":
emailVo.OrgName = dr["WRD_InputParameterValue"].ToString();
break;
}
}
foreach (DataRow dr in dtRequestOutPutData.Rows)
{
emailVo.FileName += reportRepositoryFileLocation + @"\" + dr["WRD_OutPutParameterValue"].ToString() + "~";
}
if (emailVo.FileName.EndsWith("~"))
{
emailVo.FileName = emailVo.FileName.Substring(0, emailVo.FileName.Length - 1);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "BulkMailRequestGenerationBo:FillBulkMailParamerValues()");
object[] objects = new object[1];
objects[0] = daemonCode;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(emailVo);
}
/// <summary>
/// Method to Add Email Log Infor to the Table
/// </summary>
/// <param name="emailVo">EmailVo Object with the Details of the Email Sent</param>
/// <returns name="EmailLogId">The Unique Id created for the email Log Entry</returns>
///
public int AddToEmailLog(EmailVo emailVo)
{
int emailLogId = 0;
EmailSMSDao emailSMSDao = new EmailSMSDao();
try
{
emailLogId = emailSMSDao.AddToEmailLog(emailVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "EmailSMSBo.cs:AddToEmailLog(EmailVo emailVo)");
object[] objects = new object[1];
objects[0] = emailVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(emailLogId);
}
public void Update(NameVo name, EmailVo email, PhoneVo phone)
{
Name = name;
Email = email;
Phone = phone;
SetUpdatedAt();
}
public void Deve_Criar_Um_Valor_De_Objeto_Email()
{
var email = new EmailVo("*****@*****.**");
Assert.AreEqual(email.Address, "*****@*****.**");
Assert.IsTrue(email.Valid);
}
public IResult Handle(CreateCustomerCommand command)
{
//transações de negócios, regras de negócio, comunicação com outros handlers
//Criacao dos objetos
var name = new NameVo(command.Nome, command.Sobrenome);
var cpf = new CpfVo(command.Documento);
var email = new EmailVo(command.Email);
var customer = new Customer(name, cpf, email, command.Telefone);
//Validar
AddNotifications(name.Notifications);
AddNotifications(cpf.Notifications);
AddNotifications(email.Notifications);
if (Invalid)
{
return(new ApiContract(false,
"Erro. Corrija os campos abaixo:",
Notifications));
}
try
{
_repository.Save(customer, null);
}
catch (Exception ex)
{
//TO-DO: implementa log depois
throw new Exception("Erro - Handler CustomerCommandHandler" + ex.Message);
}
return(new ApiContract(true, "Customer criado com sucesso!", null));
}
public ICommandResult Handle(AddCustomerCommand command)
{
// Verificar se o CPF já existe
if (_customerRepository.checkDocumentExists(command.documentNumber))
{
AddNotification("Document", "Este CPF já está em uso!");
return(null);
}
// Verificar se o email já existe
if (_customerRepository.checkEmailExists(command.emailAddress))
{
AddNotification("Email", "Este email já está em uso!");
return(null);
}
// Gerar o novo cliente
var document = new DocumentVo(command.documentNumber);
var email = new EmailVo(command.emailAddress);
var address = new AddressVo(
command.addressStreet,
command.addressNumber,
command.addressNeighborhood,
command.addressCity,
command.addressState,
command.addressZipCode
);
var customer = new CustomerEntity(
command.name,
command.birthDate,
document,
address,
email,
DateTime.Now);
// Adicionar as notificação
AddNotifications(document.Notifications);
AddNotifications(email.Notifications);
AddNotifications(address.Notifications);
AddNotifications(customer.Notifications);
if (this.Invalid)
{
return(null);
}
// Inserir no banco
_customerRepository.save(customer);
// Enviar E-mail de boas vindas
/*_emailService.Send(
* customer.Name.ToString(),
* customer.Email.Address,
* string.Format(EmailTemplates.WelcomeEmailTitle, customer.Name),
* string.Format(EmailTemplates.WelcomeEmailBody, customer.Name));*/
return(new AddCustomerCommandResult(customer.id.ToString()));
}
public Customer(NameVo name, CpfVo cpf, EmailVo email, string phone)
{
Name = name;
Cpf = cpf;
Email = email;
Phone = phone;
_addresses = new List <Address>();
}
public Customer Get(Guid id)
{
var name = new NameVo("Ray", "Carneiro");
var cpf = new CpfVo("88041300081");
var email = new EmailVo("*****@*****.**");
return(new Customer(name, cpf, email, "(11) 99999-9999"));
}
public User(NameVo name, EmailVo email, UserRole role, PasswordVo password, PhoneVo phone, Guid tenantId)
{
Name = name;
Email = email;
Role = role;
Phone = phone;
Password = password;
SetTenantId(tenantId);
Validate();
}
public Customer(NameVo name, CpfVo cpf, EmailVo email, string phone)
{
Id = Guid.NewGuid();
Name = name;
Cpf = cpf;
Email = email;
Phone = phone;
_addresses = new List <Address>();
Validate();
}
private bool CreateBulkMailRequest(EmailVo emailVo)
{
try
{
bool flag = false;
SqlParameter[] Params = new SqlParameter[9];
Params[0] = new SqlParameter("@TO", emailVo.To);
Params[0].DbType = DbType.String;
Params[1] = new SqlParameter("@CC", emailVo.Cc);
Params[1].DbType = DbType.String;
Params[2] = new SqlParameter("@BCC", emailVo.Bcc);
Params[2].DbType = DbType.String;
Params[3] = new SqlParameter("@Subject", emailVo.Subject);
Params[3].DbType = DbType.String;
Params[4] = new SqlParameter("@Body", emailVo.Body);
Params[4].DbType = DbType.String;
Params[5] = new SqlParameter("@AdviserId", emailVo.AdviserId);
Params[5].DbType = DbType.Int32;
Params[6] = new SqlParameter("@FromEmailId", emailVo.EmailFrom);
Params[6].DbType = DbType.String;
Params[7] = new SqlParameter("@SourceId", emailVo.SourceId);
Params[7].DbType = DbType.Int32;
Params[8] = new SqlParameter("@FilePathList", emailVo.FileName);
Params[8].DbType = DbType.String;
Utils.ExecuteNonQuery("SPROC_CreateReportBulkMailRequest", Params);
flag = true;
return(flag);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "BulkMailRequestGenerationBo:CheckDependentRequestStatus()");
object[] objects = new object[1];
objects[0] = daemonCode;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public void Setup()
{
var name = new NomeVo("Jeff", "Almeida");
var email = new EmailVo("*****@*****.**");
_monitor = new Produto("Monitor", 50M, 3);
_carregador = new Produto("Carregador", 50M, 5);
_lixeira = new Produto("Lixeira", 50M, 1);
_cliente = new Cliente(name, email);
_pedido = new Pedido(_cliente);
}
public Customer(Guid tenantId, int code, NameVo name, PhoneVo phone, PhoneVo phone2, EmailVo email, DocumentVo document, Guid addressId, string ie)
{
SetTenantId(tenantId);
Code = code;
Name = name;
Phone = phone;
Phone2 = phone2;
Email = email;
Document = document;
AddressId = addressId;
Ie = ie;
}
public Company(Guid tenantId, string name, DocumentVo document, PhoneVo phone, EmailVo emailVo, Address address, Guid addressId, string site)
{
SetTenantId(tenantId);
Name = name;
Document = document;
Phone = phone;
Email = emailVo;
Address = address;
AddressId = addressId;
Site = site;
}
public void Setup()
{
//Simular dados
var name = new NameVo("Ray", "Carneiro");
var cpf = new CpfVo("15366015006");
var email = new EmailVo("*****@*****.**");
_teclado = new Product("Teclado Microsoft", "Melhor teclado", "teclado.jpg", 10M, 10);
_mouse = new Product("Mouse Microsoft", "Melhor mouse", "mouse.jpg", 5M, 10);
_monitor = new Product("Dell", "Melhor monitor", "dell.jpg", 50M, 10);
_customer = new Customer(name, cpf, email, "11-5555-5555");
_order = new Order(_customer);
}
public Cliente(string nomePessoa, DateTime dtNascimento, string nomeMae, string nomePai, string nomeSocial, CpfCnpjVo cpf, EmailVo email, TipoCliente tipoCliente)
{
NomePessoa = nomePessoa;
DtNascimento = dtNascimento;
NomeMae = nomeMae;
NomePai = nomePai;
NomeSocial = nomeSocial;
Cpf = cpf;
Email = email;
TipoCliente = tipoCliente;
Ativo = true;
DataCriacao = DateTime.Now;
_enderecosLista = new List <Enderecos>();
}
public void CreateCustomerCommandTests_CreateOrder_ShouldBeValid()
{
var command = new CreateCustomerCommand();
var name = new NameVo("Ray", "Carneiro");
var cpf = new CpfVo("15366015006");
var email = new EmailVo("*****@*****.**");
var customer = new Customer(name, cpf, email, command.Telefone);
//Validar
AddNotifications(name.Notifications);
AddNotifications(cpf.Notifications);
AddNotifications(email.Notifications);
Assert.AreEqual(true, !Invalid);
}
//To-DO: criar uma padrão para retorno com smart notification
public string Execute(PlaceOrderInput order)
{
#region Obter dados do banco
//Customer customer = _customerReadOnlyRepository.Get(customerId);
//if (customer == null)
//{
// AddNotification("Customer", "Customer does not exist.");
//}
#endregion
//Simulando dados, não implementei acesso a dados
var name = new NameVo("Ray", "Carneiro");
var cpf = new CpfVo("15366015006");
var email = new EmailVo("*****@*****.**");
_customer = new Customer(name, cpf, email, "11-5555-5555");
if (_customer.Invalid)
{
AddNotification("Cliente", "Erros identificados nos dados de cliente: ");
return(_customer.Notifications.FirstOrDefault().Message);
}
_order = new Order(_customer);
var product = new Product(order.ProductItem.Title, order.ProductItem.Description, order.ProductItem.Image, order.ProductItem.Price, 10);
_order.AddItem(product, order.ProductItem.Quantity);
if (_order.Invalid)
{
AddNotification("Pedido", "Erros identificados nos dados do seu pedido: ");
return(_order.Notifications.FirstOrDefault().Message);
}
string orderId;
try
{
orderId = _orderWriteOnlyRepository.PlaceOrder(_customer, _order);
_kafkaProducer.Produce(orderId);
}
catch (Exception ex)
{
//TO-DO: Implement log
throw;
}
return("Número do pedido: " + orderId);
}
public ICommandResult Handle(EditCustomerCommand command)
{
var oldCustomer = _customerRepository.getById(command.id);
// Verificar se existe o cliente
if (oldCustomer == null)
{
AddNotification("Customer", "Cliente não encontrado");
return(null);
}
// Gerar o novo cliente
var document = new DocumentVo(command.documentNumber);
var email = new EmailVo(command.emailAddress);
var address = new AddressVo(
command.addressStreet,
command.addressNumber,
command.addressNeighborhood,
command.addressCity,
command.addressState,
command.addressZipCode
);
var customer = new CustomerEntity(
command.name,
command.birthDate,
document,
address,
email,
oldCustomer.createAt,
id: oldCustomer.id);
// Adicionar as notificação
AddNotifications(document.Notifications);
AddNotifications(email.Notifications);
AddNotifications(address.Notifications);
AddNotifications(customer.Notifications);
if (this.Invalid)
{
return(null);
}
// altera
_customerRepository.update(customer);
return(new AddCustomerCommandResult(customer.id.ToString()));
}
public string Execute(PlaceOrderInput order)
{
//Simulação de dados e regras de negócios
var name = new NameVo("Ray", "Carneiro");
var cpf = new CpfVo("15366015006");
var email = new EmailVo("*****@*****.**");
_customer = new Customer(name, cpf, email, "11-5555-5555");
if (_customer.Invalid)
{
AddNotification("Cliente", "Erros identificados nos dados de cliente: ");
return(_customer.Notifications.FirstOrDefault().Message);
}
_order = new Order(_customer);
var product = new Product(order.ProductItem.Title, order.ProductItem.Description, order.ProductItem.Image, order.ProductItem.Price, 10);
_order.AddItem(product, order.ProductItem.Quantity);
if (_order.Invalid)
{
AddNotification("Pedido", "Erros identificados nos dados do seu pedido: ");
return(_order.Notifications.FirstOrDefault().Message);
}
string orderId;
try
{
//Salva ordem no banco de dados
orderId = _orderWriteOnlyRepository.PlaceOrder(_customer, _order);
//Envia mensagem para Kafka
_kafkaAdapter.Produce(orderId);
}
catch
{
throw;
}
return("Número do pedido: " + orderId);
}
public CustomerEntity(
string name,
DateTime?birthDate,
DocumentVo document,
AddressVo address,
EmailVo email,
DateTime createAt,
Guid?id = null) : base(id: id, createAt: createAt)
{
this.name = name;
this.birthDate = birthDate;
this.document = document;
this.address = address;
this.email = email;
AddNotifications(new Contract()
.IsNotNullOrEmpty(name, "CustomerEntity.name", "Nome é obrigatório")
);
}
protected DomainBaseUnitTest()
{
Settings.SecurityKey = "cbffeba849124af8b7b89675c223fd3d";
Tenant = new AppTenant("Treeze", "localhost:43500", null, null);
User = new User(new NameVo("Victor", "Luiz"), new EmailVo("*****@*****.**"), UserRole.User, new PasswordVo("12345678", "12345678"), null, Tenant.Id);
var code = 1;
var firstName = "Victor";
var lastName = "Domingues";
var name = new NameVo(firstName, lastName);
var number = "11992535010";
var phone = new PhoneVo(number);
var phone2 = new PhoneVo(number);
var cpf = "3333333333";
var document = new DocumentVo(cpf, EDocumentType.Cpf);
var emailAddress = "*****@*****.**";
var email = new EmailVo(emailAddress);
var address = new Address(Tenant.Id, "", "", "", "", "", "", "", "");
Customer = new Customer(Tenant.Id, code, name, phone, phone2, email, document, address.Id, null);
}
public Cliente(NomeVo name, EmailVo email)
{
Nome = name;
Email = email;
}
public void Setup()
{
_emailValido = new EmailVo("*****@*****.**");
_emailInvalido = new EmailVo("jefferson.almeida.konia");
}
public static void SendEmail(EmailVo emailVo, Action <IRestResponse <ResultSrv <ServiceCallResultSrv <ResponseSrv <SmsSrv> > > > > callback)
{
PrepareRestClient(ServiceCallProducts.SendEmail, emailVo, Method.POST, out var client, out var request);
callback(client.Execute <ResultSrv <ServiceCallResultSrv <ResponseSrv <SmsSrv> > > >(request));
}
/// <summary>
/// Method to Add Email Log Infor to the Table
/// </summary>
/// <param name="emailVo">EmailVo Object with the Details of the Email Sent</param>
/// <returns name="EmailLogId">The Unique Id created for the email Log Entry</returns>
public int AddToEmailLog(EmailVo emailVo)
{
int emailLogId = 0;
Database db;
DbCommand addToEmailLogCmd;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
addToEmailLogCmd = db.GetStoredProcCommand("SP_AddOutGoingEmailLog");
if (emailVo.EmailQueueId != null)
{
db.AddInParameter(addToEmailLogCmd, "@AEML_EmailQueueId", DbType.Int32, emailVo.EmailQueueId);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_EmailQueueId", DbType.Int32, DBNull.Value);
}
if (emailVo.AdviserId != null)
{
db.AddInParameter(addToEmailLogCmd, "@A_AdviserId", DbType.Int32, emailVo.AdviserId);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@A_AdviserId", DbType.Int32, DBNull.Value);
}
if (emailVo.CustomerId != null)
{
db.AddInParameter(addToEmailLogCmd, "@C_CustomerId", DbType.Int32, emailVo.CustomerId);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@C_CustomerId", DbType.Int32, DBNull.Value);
}
if (emailVo.EmailType != null && emailVo.EmailType != "")
{
db.AddInParameter(addToEmailLogCmd, "@AEML_EmailType", DbType.String, emailVo.EmailType);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_EmailType", DbType.String, DBNull.Value);
}
if (emailVo.HasAttachment != null)
{
db.AddInParameter(addToEmailLogCmd, "@AEML_Attachment", DbType.Int16, emailVo.HasAttachment);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_Attachment", DbType.Int16, DBNull.Value);
}
if (emailVo.AttachmentPath != null && emailVo.AttachmentPath != "")
{
db.AddInParameter(addToEmailLogCmd, "@AEML_AttachmentPath", DbType.String, emailVo.AttachmentPath);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_AttachmentPath", DbType.String, DBNull.Value);
}
if (emailVo.SentDate != DateTime.MinValue && emailVo.SentDate != null)
{
db.AddInParameter(addToEmailLogCmd, "@AEML_DateSent", DbType.DateTime, emailVo.SentDate);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_DateSent", DbType.DateTime, DBNull.Value);
}
if (emailVo.FileName != null && emailVo.FileName != "")
{
db.AddInParameter(addToEmailLogCmd, "@AEML_FileName", DbType.String, emailVo.FileName);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_FileName", DbType.String, DBNull.Value);
}
if (emailVo.ReportCode != null)
{
db.AddInParameter(addToEmailLogCmd, "@AEML_ReportCode", DbType.Int16, emailVo.ReportCode);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_ReportCode", DbType.Int16, DBNull.Value);
}
if (emailVo.Status != null)
{
db.AddInParameter(addToEmailLogCmd, "@AEML_Status", DbType.Int16, emailVo.Status);
}
else
{
db.AddInParameter(addToEmailLogCmd, "@AEML_Status", DbType.Int16, DBNull.Value);
}
db.AddOutParameter(addToEmailLogCmd, "@Id", DbType.Int32, 10000);
if (db.ExecuteNonQuery(addToEmailLogCmd) != 0)
{
emailLogId = int.Parse(db.GetParameterValue(addToEmailLogCmd, "Id").ToString());
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorDao.cs:AddToEmailLog(EmailVo emailVo)");
object[] objects = new object[1];
objects[0] = emailVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(emailLogId);
}
public bool CreateReportBulkMailRequest(EmailVo emailVo)
{
Database db;
bool isComplete = false;
DbCommand addToEmailQueueCmd;
Int16 noOfRecord;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
addToEmailQueueCmd = db.GetStoredProcCommand("SPROC_CreateReportBulkMailRequest");
if (emailVo.To != null)
{
db.AddInParameter(addToEmailQueueCmd, "@To", DbType.String, emailVo.To);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@To", DbType.String, DBNull.Value);
}
if (emailVo.Cc != null)
{
db.AddInParameter(addToEmailQueueCmd, "@Cc", DbType.String, emailVo.Cc);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@Cc", DbType.String, DBNull.Value);
}
if (emailVo.Bcc != null)
{
db.AddInParameter(addToEmailQueueCmd, "@Bcc", DbType.String, emailVo.Bcc);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@Bcc", DbType.String, DBNull.Value);
}
if (emailVo.Subject != null)
{
db.AddInParameter(addToEmailQueueCmd, "@Subject", DbType.String, emailVo.Subject);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@Subject", DbType.String, DBNull.Value);
}
if (emailVo.Body != null)
{
db.AddInParameter(addToEmailQueueCmd, "@Body", DbType.String, emailVo.Body);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@Body", DbType.String, DBNull.Value);
}
if (emailVo.HasAttachment != null)
{
db.AddInParameter(addToEmailQueueCmd, "@HasAttachment", DbType.Int32, emailVo.HasAttachment);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@HasAttachment", DbType.Int32, DBNull.Value);
}
if (emailVo.SourceId != 0)
{
db.AddInParameter(addToEmailQueueCmd, "@SourceId", DbType.String, emailVo.SourceId);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@SourceId", DbType.String, DBNull.Value);
}
if (emailVo.AttachmentPath != null)
{
db.AddInParameter(addToEmailQueueCmd, "@FilePathList", DbType.String, emailVo.AttachmentPath);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@FilePathList", DbType.String, DBNull.Value);
}
if (emailVo.AdviserId != 0)
{
db.AddInParameter(addToEmailQueueCmd, "@AdviserId", DbType.String, emailVo.AdviserId);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@AdviserId", DbType.String, DBNull.Value);
}
if (emailVo.EmailFrom != null)
{
db.AddInParameter(addToEmailQueueCmd, "@FromEmailId", DbType.String, emailVo.EmailFrom);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@FromEmailId", DbType.String, DBNull.Value);
}
if (emailVo.EmailType != null)
{
db.AddInParameter(addToEmailQueueCmd, "@TypeCode", DbType.String, emailVo.EmailType);
}
else
{
db.AddInParameter(addToEmailQueueCmd, "@TypeCode", DbType.String, DBNull.Value);
}
db.ExecuteNonQuery(addToEmailQueueCmd);
isComplete = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorDao.cs:CreateReportBulkMailRequest(EmailVo emailVo)");
object[] objects = new object[1];
objects[0] = emailVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(isComplete);
}
