public void Add(TechnicalContact entity)
{
DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("INSERT_CONTACT_SP", entity.Id, entity.ContactId, entity.Name, entity.Email, entity.Phone,
entity.LastName, entity.Charge,
entity.CreatedBy, entity.CreationDate, entity.CustomerId);
}
public IActionResult Create([FromBody] TechnicalContact techCont)
{
try
{
var newTechCont = _logic.Create(techCont);
return(new OkObjectResult(newTechCont));
}
catch (Exception ex)
{
return(new NotFoundObjectResult(ex));
}
}
public IActionResult Delete([FromBody] TechnicalContact techCont)
{
try
{
_logic.Delete(techCont);
return(new OkResult());
}
catch (Exception ex)
{
return(new NotFoundObjectResult(ex));
}
}
public virtual IActionResult ApiTechnicalContactsPut([FromBody] TechnicalContact techCont)
{
try
{
_datastore.Update(techCont);
}
catch (Crm.CrmApiException ex)
{
return(StatusCode((int)ex.HttpStatus, ex.Message));
}
return(StatusCode(200, techCont));
}
public TechnicalContact GetById(string id)
{
TechnicalContact contact = null;
var database = DatabaseFactory.CreateDatabase();
using (var cmd = database.GetStoredProcCommand("GET_CONTACT_BYID_SP", id)) {
using (var reader = database.ExecuteReader(cmd)) {
while (reader.Read())
{
contact = new TechnicalContact {
Id = DataConvert.ToString(reader["ID"]),
Name = DataConvert.ToString(reader["NAME"]),
Email = DataConvert.ToString(reader["EMAIL"]),
Phone = DataConvert.ToString(reader["PHONE"])
};
}
}
}
return(contact);
}
public virtual IActionResult ApiTechnicalContactsDelete([FromBody] TechnicalContact techCont)
{
try
{
var techContGet = _datastore.ById(techCont.Id.ToString());
if (techContGet.Id == Guid.Empty)
{
return(StatusCode(404));
}
_datastore.Delete(techCont);
}
catch (Crm.CrmApiException ex)
{
return(StatusCode((int)ex.HttpStatus, ex.Message));
}
return(StatusCode(200));
}
public void Update(TechnicalContact techCont)
{
_validator.ValidateAndThrow(techCont, ruleSet: nameof(ITechnicalContactLogic.Update));
_datastore.Update(techCont);
}
public TechnicalContact Create(TechnicalContact techCont)
{
_validator.ValidateAndThrow(techCont, ruleSet: nameof(ITechnicalContactLogic.Create));
return(_datastore.Create(techCont));
}
public void Update(TechnicalContact entity)
{
DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("UPDATE_CONTACT_SP", entity.Id, entity.Name, entity.LastName, entity.Email, entity.Phone,
entity.Charge, entity?.ModifiedBy);
}
public IList <TechnicalContact> GetPaginated(TechnicalContact filters, int pageIndex, int pageSize, out int totalRows)
{
totalRows = 10;
return(new List <TechnicalContact>());
}
public void Delete(TechnicalContact techCont)
{
Repository.Delete(techCont.EntityName, techCont.Id);
}
public void Update(TechnicalContact techCont)
{
Repository.UpdateEntity(techCont.EntityName, techCont.Id, techCont.SerializeToODataPut("cc_technicalcontactid"));
}
public TechnicalContact Create(TechnicalContact techCont)
{
Repository.CreateEntity(techCont.EntityName, techCont.SerializeToODataPost());
return(techCont);
}
