public AddressDto CreateAddress(AddressDto addressDto)
{
if (addressDto == null)
{
throw new ArgumentNullException(nameof(addressDto), "AddresDto argument is not provided!");
}
try
{
var address = Mappers.AddressRepository.MapToDbEntity(addressDto);
address.DateCreated = DateTime.Now;
address.DateModified = DateTime.Now;
_dbContext.Add(address);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.AddressRepository.MapToDto(address));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
throw;
}
return(null);
}
PricingPackageDto IPricingPackageRepository.SavePricingPackage(PricingPackageDto pricingPackage)
{
var newPricingPackage = MapToDbEntity(pricingPackage);
_dbContext.PricingPackage.Add(newPricingPackage);
if (_dbContext.SaveChanges() != 0)
{
return(MapToDto(newPricingPackage));
}
return(null);
}
public HearingDto InsertHearing(HearingDto model)
{
var entity = Mappers.HearingsRepository.MapToDbEntity(model);
_dbContext.Hearing.Add(entity);
if (_dbContext.SaveChanges() > 0)
{
return(GetHearingById(entity.HearingId));
}
throw new NSIException("Erro while inserting new hearing");
}
public bool DeleteDocument(int id)
{
var document = _dbContext.Document.Include(x => x.Case).Include(x => x.DocumentCategory).FirstOrDefault(d => d.DocumentId == id);
document.IsDeleted = true;
var response = _dbContext.Update(document);
AddToHistory(document);
_dbContext.SaveChanges();
return(response != null);
}
SubscriptionDto ISubscriptionRepository.SaveSubscription(SubscriptionDto subscription)
{
var newSubscription = MapToDbEntity(subscription);
_dbContext.Subscription.Add(newSubscription);
if (_dbContext.SaveChanges() != 0)
{
return(MapToDto(newSubscription));
}
return(null);
}
public MeetingDto InsertMeeting(MeetingDto model)
{
var entity_meeting = Mappers.MeetingsRepository.MapToDbEntity(model);
_dbContext.Meeting.Add(entity_meeting);
if (_dbContext.SaveChanges() > 0)
{
return(GetMeetingById(entity_meeting.MeetingId));
}
throw new NSIException("Error while inserting new meeting");
}
public TaskDto CreateTask(TaskDto taskDto)
{
if (taskDto == null)
{
throw new NSIException("Parameter taskDto is null!", Level.Error, ErrorType.InvalidParameter);
}
var task = Mappers.TaskRepository.MapToDbEntity(taskDto);
_dbContext.Add(task);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.TaskRepository.MapToDto(task));
}
throw new NSIException("No data in database!", Level.Info, ErrorType.MissingData);
}
public CaseInfo CreateCaseInfo(CaseInfoDto caseInfoDto)
{
try
{
CaseInfo caseInfo = Mappers.CaseInfoRepository.MapToDbEntity(caseInfoDto);
_dbContext.CaseInfo.Add(caseInfo);
if (_dbContext.SaveChanges() != 0)
{
return(caseInfo);
}
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.Message);
}
return(null);
}
public PaymentGatewayDto SavePaymentGateway(PaymentGatewayDto paymentGateway)
{
var newPaymentGateway = MapToDbEntity(paymentGateway);
_dbContext.PaymentGateway.Add(newPaymentGateway);
if (_dbContext.SaveChanges() != 0)
{
return(MapToDto(newPaymentGateway));
}
return(null);
}
TransactionDto ITransactionRepository.SaveTransaction(TransactionDto transaction)
{
var newTransaction = MapToDbEntity(transaction);
_dbContext.Transaction.Add(newTransaction);
if (_dbContext.SaveChanges() != 0)
{
return(MapToDto(newTransaction));
}
return(null);
}
public ClientDTO CreateClient(ClientDTO clientDTO)
{
try
{
var client = Mappers.ClientRepository.MapToDbEntity(clientDTO);
client.DateCreated = DateTime.Now;
client.DateModified = null;
_dbContext.Add(client);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.ClientRepository.MapToDto(client));
}
}
catch (Exception ex)
{
//log ex
throw ex.InnerException;
//throw new Exception("Database error!");
}
return(null);
}
public ClientDto CreateClient(ClientDto clientDTO)
{
try
{
var client = Mappers.ClientRepository.MapToDbEntity(clientDTO);
client.ClientId = null;
client.DateCreated = DateTime.Now;
client.DateModified = null;
client.IsDeleted = false;
_dbContext.Add(client);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.ClientRepository.MapToDto(client));
}
}
catch (Exception ex)
{
throw new NSIException(ex.InnerException.Message, Level.Error, ErrorType.InvalidParameter, HttpStatusCode.BadRequest);
}
return(null);
}
public CustomerDto CreateCustomer(CustomerDto customerDto)
{
try
{
var customer = Mappers.CustomerRepository.MapToDbEntity(customerDto);
customer.DateCreated = DateTime.Now;
customer.DateModified = null;
_dbContext.Add(customer);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.CustomerRepository.MapToDto(customer));
}
}
catch (Exception ex)
{
//log ex
throw ex.InnerException;
//throw new Exception("Database error!");
}
return(null);
}
public ContactDto CreateContact(ContactDto contactDto, int caseId)
{
try
{
this.addressRepository = new AddressRepository(_dbContext);
DC.AddressRepository.AddressDto address = null;
if (contactDto.Address != null)
{
address = addressRepository.CreateAddress(contactDto.Address);
contactDto.AddressId = address.AddressId;
}
var contact = Mappers.ContactRepository.MapToDbEntity(contactDto);
contact.ModifiedDate = contact.CreatedDate = DateTime.Now;
contact.IsDeleted = false;
_dbContext.Add(contact);
if (_dbContext.SaveChanges() != 0)
{
ContactDto c = Mappers.ContactRepository.MapToDto(contact);
if (caseId != 0)
{
CaseContact caseInfo = new CaseContact();
caseInfo.CaseId = caseId;
caseInfo.Contact = c.Contact1;
this._dbContext.CaseContact.Add(caseInfo);
}
if (_dbContext.SaveChanges() != 0)
{
return(c);
}
}
}
catch (Exception ex)
{
//log ex
throw new Exception(ex.Message);
}
return(null);
}
public CustomerDto CreateCustomer(CustomerDto customerDto)
{
try
{
var customer = Mappers.CustomerRepository.MapToDbEntity(customerDto);
customer.CustomerId = null;
customer.DateCreated = DateTime.Now;
customer.DateModified = DateTime.Now;
_dbContext.Add(customer);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.CustomerRepository.MapToDto(customer));
}
}
catch (Exception ex)
{
if (ex.InnerException.GetType().ToString() == "Npgsql.PostgresException")
{
PostgresException postgresException = (PostgresException)ex.InnerException;
if (postgresException.SqlState == "23503")
{
throw new NSIException("Foreign key error: " + postgresException.Detail, Level.Error, ErrorType.InvalidParameter);
}
if (postgresException.SqlState == "23505")
{
throw new NSIException("Primary key error: " + postgresException.Detail, Level.Error, ErrorType.InvalidParameter);
}
throw new NSIException("Db error: " + postgresException.Detail, Level.Error, ErrorType.DBError);
}
else
{
throw ex.InnerException;
}
}
return(null);
}
public AddressTypeDto CreateAddressType(AddressTypeDto addressTypeDto)
{
if (addressTypeDto == null)
{
throw new ArgumentNullException(nameof(addressTypeDto), "AddressTypeDto is not provided!");
}
try
{
var addressType = Mappers.AddressTypeRepository.MapToDbEntity(addressTypeDto);
_dbContext.Add(addressType);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.AddressTypeRepository.MapToDto(addressType));
}
}
catch (Exception ex)
{
//log ex
throw;
}
return(null);
}
public CaseCategoryDto CreateCaseCategory(CaseCategoryDto model)
{
if (model == null)
{
throw new ArgumentNullException(nameof(model), "Model is null!");
}
var sameName = _dbContext.CaseCategory.FirstOrDefault(x => x.CaseCategoryName == model.CaseCategoryName && x.IsDeleted == false);
if (sameName != null)
{
throw new Exception("Case category with this name already exists.");
}
try
{
var caseCategory = Mappers.AdminRepository.MapToDbEntity(model);
caseCategory.DateModified = caseCategory.DateCreated = DateTime.Now;
caseCategory.IsDeleted = false;
_dbContext.Add(caseCategory);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.AdminRepository.MapToDto(caseCategory));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
throw new Exception("Cannot create new case category!");
}
return(null);
}
public CaseCategoryDto CreateCaseCategory(CaseCategoryDto caseCategoryDto)
{
try
{
var caseCategory = Mappers.AdminRepository.MapToDbEntity(caseCategoryDto);
caseCategory.DateModified = caseCategory.DateCreated = DateTime.Now;
caseCategory.IsDeleted = false;
_dbContext.Add(caseCategory);
if (_dbContext.SaveChanges() != 0)
{
return(Mappers.AdminRepository.MapToDto(caseCategory));
}
}
catch (Exception ex)
{
//log ex
throw new Exception(ex.Message);
}
return(null);
}
