public async Task <CreateContactResponse> Handle(CreateContactCommand request, CancellationToken cancellationToken)
{
_logger.LogInformation("CreateContactHandler - handle");
await _validator.HandleValidation(request.ContactRequest);
var requestedContact = request.ContactRequest;
var contact = new Domain.Contact(ContactType.Contact,
requestedContact.FirstName,
requestedContact.LastName,
requestedContact.Title,
requestedContact.Company,
requestedContact.Description,
null);
var contactId = await _uow.Connection.InsertAsync <Guid, Domain.Contact>(contact);
await _bus.Publish <ContactCreated>(new
{
FirstName = "sss",
CorrelationId = _correlationContextAccessor?.CorrelationContext?.CorrelationId
});
return(new CreateContactResponse
{
Contact = contact.ToContactProtobuf()
});
}
public List <Domain.Contact> GetContacts()
{
List <Domain.Contact> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Contact_SelectAll"
, inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
Domain.Contact c = new Domain.Contact();
int startingIndex = 0;
c.Id = reader.GetSafeInt32(startingIndex++);
c.FullName = reader.GetSafeString(startingIndex++);
c.Subject = reader.GetSafeString(startingIndex++);
c.Email = reader.GetSafeString(startingIndex++);
c.Message = reader.GetSafeString(startingIndex++);
if (list == null)
{
list = new List <Domain.Contact>();
}
list.Add(c);
}
);
return(list);
}
public static ContactDto ToContactProtobuf(this Domain.Contact contact)
{
return(new ContactDto
{
Id = contact.ContactId.ToString(),
FirstName = contact.FirstName,
LastName = contact.LastName,
Company = contact.Company,
Description = contact.Description,
Title = contact.Title,
MailingAddress = new StreetAddressDto
{
City = contact.MailingAddress?.City,
Country = contact.MailingAddress?.Country,
State = contact.MailingAddress?.State,
Street = contact.MailingAddress?.Street,
Zipcode = contact.MailingAddress?.ZipCode
},
ContactInfo = new ContactInfoDto
{
Email = contact.ContactInfo?.Email,
HomePhone = contact.ContactInfo?.HomePhone,
Mobile = contact.ContactInfo?.Mobile,
WorkPhone = contact.ContactInfo?.WorkPhone
}
});
}
public static Protobuf.Contacts.V1.Contact ToContactProtobuf(this Domain.Contact contact)
{
return(new Protobuf.Contacts.V1.Contact
{
Id = contact.ContactId.ToString(),
FirstName = contact.FirstName,
LastName = contact.LastName,
Company = contact.Company,
Description = contact.Description,
Title = contact.Title,
Address = new Protobuf.Contacts.V1.Address
{
City = contact.MailingCity,
Country = contact.MailingCountry,
State = contact.MailingState,
Street = contact.MailingStreet,
Zipcode = contact.MailingZipCode
},
ContactInfo = new Protobuf.Contacts.V1.ContactInformation
{
Email = contact.Email,
HomePhone = contact.HomePhone,
Mobile = contact.Mobile,
WorkPhone = contact.WorkPhone
}
});
}
public async Task <CreateContactResponse> Handle(CreateContactCommand request, CancellationToken cancellationToken)
{
await _validator.HandleValidation(request.ContactRequest);
var requestedContact = request.ContactRequest;
var contact = new Domain.Contact(ContactType.Contact,
requestedContact.FirstName,
requestedContact.LastName,
requestedContact.Title,
requestedContact.Company,
requestedContact.Description,
null);
var contactId = await _uow.Connection.InsertAsync <Guid, Domain.Contact>(contact);
_eventBus.Publish(new ContactCreatedEvent()
{
Id = Guid.NewGuid()
});
return(new CreateContactResponse
{
Contact = contact.ToContactProtobuf()
});
}
internal static Domain.Contact Parse(IDataReader reader)
{
var result = new Domain.Contact();
FillData(reader, result);
EntityManager.SetSaved(result, reader[0].ToString().To <Guid>());
return(result);
}
public static Domain.Contact CreateContact(string firstname, string lastname, string phone, string address, string date)
{
Domain.Contact user = new Domain.Contact();
user.ID = Data.ContactDataFunctions.returnNextID();
user.UserID = findUID();
user.FirstName = firstname;
user.LastName = lastname;
user.Phone = phone;
user.Address = address;
user.BirthDate = DateTime.Parse(date);
return(user);
}
internal static void FillData(IDataReader reader, Domain.Contact entity)
{
var values = new object[reader.FieldCount];
reader.GetValues(values);
entity.Name = (string)values[1];
if (values[2] != DBNull.Value)
{
entity.Email = (string)values[2];
}
if (values[3] != DBNull.Value)
{
entity.Tel = (string)values[3];
}
if (values[4] != DBNull.Value)
{
entity.Notes = (string)values[4];
}
if (values[5] != DBNull.Value)
{
entity.TypeId = values[5].ToStringOrEmpty().To <Guid>();
}
if (values[6] != DBNull.Value)
{
entity.DateOfBirth = (values[6] as string)?.To <DateTime>().Date;
}
if (values[7] != DBNull.Value)
{
entity.TimeOfBirth = values[7].ToString().TryParseAs <TimeSpan>();
}
if (values[8] != DBNull.Value)
{
entity.Photo = new Document {
FileName = values[8] as string
}
}
;
entity.Number = values[9].ToStringOrEmpty().To <int>();
if (values[10] != DBNull.Value)
{
entity.IsNice = Convert.ToBoolean(values[10]);
}
}
public static int Register(List <string> all_fields)
{
if (FieldsFilled(all_fields))
{
Domain.Contact user = CreateContact(all_fields[0], all_fields[1], all_fields[2], all_fields[3], all_fields[4]);
AddressBook.Data.ContactDataFunctions.AddContact(user);
return(1);
}
else
{
return(-1);
}
}
IDataParameter[] CreateParameters(Domain.Contact item)
{
var result = new List <IDataParameter>();
result.Add(CreateParameter("OriginalId", item.OriginalId));
result.Add(CreateParameter("Id", item.GetId()));
result.Add(CreateParameter("Name", item.Name));
result.Add(CreateParameter("Email", item.Email));
result.Add(CreateParameter("Tel", item.Tel));
result.Add(CreateParameter("Notes", item.Notes));
result.Add(CreateParameter("Type", item.TypeId));
result.Add(CreateParameter("DateOfBirth", item.DateOfBirth, DbType.DateTime2));
result.Add(CreateParameter("TimeOfBirth", item.TimeOfBirth));
result.Add(CreateParameter("Photo_FileName", item.Photo));
result.Add(CreateParameter("Number", item.Number));
result.Add(CreateParameter("IsNice", item.IsNice));
return(result.ToArray());
}
public Domain.Contact GetByID(int id)
{
Domain.Contact p = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Contact_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}, map : delegate(IDataReader reader, short set)
{
p = new Domain.Contact();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.FullName = reader.GetSafeString(startingIndex++);
p.Subject = reader.GetSafeString(startingIndex++);
p.Email = reader.GetSafeString(startingIndex++);
p.Message = reader.GetSafeString(startingIndex++);
}
);
return(p);
}
void Update(Domain.Contact item)
{
ExecuteScalar(UPDATE_COMMAND, CommandType.Text, CreateParameters(item));
}
void Insert(Domain.Contact item)
{
ExecuteScalar(INSERT_COMMAND, CommandType.Text, CreateParameters(item));
}
public Domain.Customer Get(int customerId)
{
using (var context = new PRToolsEntities())
{
Customer customerEntity = context.Customers.Include("Addresses").Include("Contacts")
.FirstOrDefault(x => x.CustomerId == customerId);
Domain.Customer customer = _mappingEngine.Map<Customer, Domain.Customer>(customerEntity);
foreach (Contact contactEntity in customerEntity.Contacts)
{
var contact = new Domain.Contact
{
Id = contactEntity.ContactId,
FirstName = contactEntity.FirstName,
LastName = contactEntity.LastName,
Phone = contactEntity.Phone,
Email = contactEntity.Email,
};
customer.AddContact(contact);
}
return customer;
}
}
