public Result <int> Add(CompanyViewModel companyViewModel)
{
try
{
var companiesDataBase = new CompaniesDataBase(ConnectionStringPattern, Login, Password);
return(new Result <int>(
companiesDataBase.Add(companyViewModel.inn, companyViewModel.name, companyViewModel.short_name)
));
}
catch (Exception e)
{
return(new Result <int>(e.Message));
}
}
public Result <object> Update(CompanyViewModel companyViewModel)
{
try
{
var companiesDataBase = new CompaniesDataBase(ConnectionStringPattern, Login, Password);
companiesDataBase.Update(companyViewModel.company_id, companyViewModel.short_name);
return(new Result <object>());
}
catch (Exception e)
{
return(new Result <object>(e.Message));
}
}
public Result <IEnumerable <CompanyViewModel> > Get()
{
try
{
var companiesDataBase = new CompaniesDataBase(ConnectionStringPattern, Login, Password);
return(new Result <IEnumerable <CompanyViewModel> >(companiesDataBase.GetAll()
.Select((x) => new CompanyViewModel()
{
company_id = x.Id, name = x.Name, inn = x.Inn, short_name = x.ShortName
})
.ToList()));
}
catch (Exception e)
{
return(new Result <IEnumerable <CompanyViewModel> >(e.Message));
}
}
public Result <CompanyViewModel> GetUserCompany(int userId)
{
try
{
var companiesDataBase = new CompaniesDataBase(ConnectionStringPattern, Login, Password);
var company = companiesDataBase.GetUserCompany(userId);
return(new Result <CompanyViewModel>(new CompanyViewModel()
{
company_id = company.Id,
inn = company.Inn,
name = company.Name
}));
}
catch (Exception e)
{
return(new Result <CompanyViewModel>(e.Message));
}
}
public Result <CompanyViewModel> GetById(int id)
{
try
{
var companiesDataBase = new CompaniesDataBase(ConnectionStringPattern, Login, Password);
var company = companiesDataBase.GetById(id);
if (company != null)
{
return(new Result <CompanyViewModel>(new CompanyViewModel()
{
company_id = company.Id,
inn = company.Inn,
name = company.Name,
short_name = company.ShortName
}));
}
return(null);
}
catch (Exception e)
{
return(new Result <CompanyViewModel>(e.Message));
}
}
