public async Task <Response> Insert(Company company)
{
Response response = Validate(company);
if (response.Success)
{
company.CPNJ = company.CPNJ.RemoveMask();
company.Active = true;
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
dataBase.Companies.Add(company);
await dataBase.SaveChangesAsync();
return(ResponseMessage.CreateSuccessResponse());
}
}
catch (Exception ex)
{
return(ResponseMessage.CreateErrorResponse(ex));
}
}
return(ResponseMessage.CreateErrorResponse(response.Exception));
}
public async Task <QueryResponse <Supplier> > GetAll()
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
List <Supplier> supplier = await dataBase.Suppliers.Where(c => c.Active == true).Include(c => c.Companies).ToListAsync();;
return(ResponseMessage.QuerySuccessResponse(supplier));
}
}
catch (Exception ex)
{
return(ResponseMessage.QueryErrorResponse <Supplier>(ex));
}
}
public async Task <QueryResponse <Company> > GetAll()
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
List <Company> companies = await dataBase.Companies.Where(c => c.Active == true).Include(c => c.Supplier).ToListAsync();;
return(ResponseMessage.QuerySuccessResponse <Company>(companies));
}
}
catch (Exception ex)
{
QueryResponse <Company> companies = (QueryResponse <Company>)ResponseMessage.QueryErrorResponse <Company>(ex);
return(companies);
}
}
public async Task <Response> Delete(int id)
{
try
{
Company company = new Company();
company.ID = id;
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
dataBase.Entry(company).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
await dataBase.SaveChangesAsync();
}
return(ResponseMessage.CreateSuccessResponse());
}
catch (Exception ex)
{
return(ResponseMessage.CreateErrorResponse(ex));
}
}
public async Task <QueryResponse <Supplier> > GetByRegisterDate(DateTime dateTime)
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
List <Supplier> supplier = await dataBase.Suppliers.Include(p => p.Companies).Where(p => p.Active == true).Where(p => p.DateRegistration == dateTime).ToListAsync();
if (supplier == null)
{
return(ResponseMessage.QueryErrorResponse <Supplier>(null));
}
return(ResponseMessage.QuerySuccessResponse(supplier));
}
}
catch (Exception ex)
{
return(ResponseMessage.QueryErrorResponse <Supplier>(ex));
}
}
public async Task <QueryResponse <Supplier> > GetByCpfOrCnpj(string cpfOuCnpj)
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
List <Supplier> supplier = await dataBase.Suppliers.Include(p => p.Companies).Where(p => p.Active == true).Where(p => p.CNPJ_CPF == cpfOuCnpj).ToListAsync();
if (supplier == null)
{
return(ResponseMessage.QueryErrorResponse <Supplier>(null));
}
return(ResponseMessage.QuerySuccessResponse(supplier));
}
}
catch (Exception ex)
{
return(ResponseMessage.QueryErrorResponse <Supplier>(ex));
}
}
public async Task <QueryResponse <Supplier> > GetByName(string name)
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
List <Supplier> supplier = await dataBase.Suppliers.Include(p => p.Companies).Where(p => p.Active == true).Where(p => p.PersonResponsible.Contains(name)).ToListAsync();
if (supplier == null)
{
return(ResponseMessage.QueryErrorResponse <Supplier>(null));
}
return(ResponseMessage.QuerySuccessResponse(supplier));
}
}
catch (Exception ex)
{
return(ResponseMessage.QueryErrorResponse <Supplier>(ex));
}
}
public async Task <SingleResponse <Company> > GetByID(int id)
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
Company company = await dataBase.Companies.Include(p => p.Supplier).FirstOrDefaultAsync(p => p.ID == id);
if (company == null)
{
return(ResponseMessage.NotFoundData <Company>());
}
return(ResponseMessage.SingleSuccessResponse <Company>(company));
}
}
catch (Exception ex)
{
SingleResponse <Company> company = (SingleResponse <Company>)ResponseMessage.ErrorFoundingData <Company>(ex);
return(company);
}
}
public async Task <SingleResponse <Supplier> > GetByID(int id)
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
Supplier supplier = await dataBase.Suppliers.Include(p => p.Companies).FirstOrDefaultAsync(p => p.ID == id);
if (supplier == null)
{
return(ResponseMessage.NotFoundData <Supplier>());
}
return(ResponseMessage.SingleSuccessResponse(supplier));
}
}
catch (Exception ex)
{
SingleResponse <Supplier> supplier = ResponseMessage.ErrorFoundingData <Supplier>(ex);
return(supplier);
}
}
public async Task <Response> Update(Company company)
{
Response Response = Validate(company);
if (Response.Success)
{
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
dataBase.Entry(company).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
await dataBase.SaveChangesAsync();
}
return(ResponseMessage.CreateSuccessResponse());
}
catch (Exception ex)
{
return(ResponseMessage.CreateErrorResponse(ex));
}
}
return(ResponseMessage.CreateErrorResponse(Response.Exception));
}
public async Task <Response> Insert(Supplier supplier)
{
Response response = Validate(supplier);
if (response.Success)
{
supplier.CNPJ_CPF = supplier.CNPJ_CPF.RemoveMask();
supplier.Telephone = supplier.Telephone.RemoveMaskPhoneNumber();
supplier.DateRegistration = DateTime.Now;
supplier.Active = true;
if (!string.IsNullOrWhiteSpace(supplier.Telephone2))
{
supplier.Telephone2.RemoveMaskPhoneNumber();
}
if (supplier.CNPJ_CPF.Length == 11)
{
supplier.RG = supplier.RG.RemoveMask();
}
try
{
using (KnowledgeTestDB dataBase = new KnowledgeTestDB())
{
dataBase.Companies.AttachRange(supplier.Companies);
dataBase.Suppliers.Add(supplier);
await dataBase.SaveChangesAsync();
return(ResponseMessage.CreateSuccessResponse());
}
}
catch (Exception ex)
{
return(ResponseMessage.CreateErrorResponse(ex));
}
}
return(ResponseMessage.CreateErrorResponse(response.Exception));
}
