public Result <NaklFullViewModel> Full(int id)
{
try
{
var naklDataBase = new NaklDataBase(ConnectionStringPattern, Login, Password);
var nakl = naklDataBase.GetFullNaklById(id);
if (nakl != null)
{
return(new Result <NaklFullViewModel>(new NaklFullViewModel()
{
nakl_id = nakl.nakl_id,
company_id = nakl.company_id,
contract_num = nakl.contract_num,
doc_num = nakl.doc_num,
doc_date = nakl.doc_date,
operation_date = nakl.operation_date,
contract_type_id = nakl.contract_type_id,
provider_id = nakl.provider_id,
receive_type_id = nakl.receive_type_id,
source_type_id = nakl.source_type_id,
turnover_type_id = nakl.turnover_type_id
}));
}
else
{
return(new Result <NaklFullViewModel>("Накладная с таким id не найдена."));
}
}
catch (Exception e)
{
return(new Result <NaklFullViewModel>(e.Message));
}
}
public Result <int> Add(NaklFullViewModel naklFullViewModel, int userId)
{
try
{
var addressDataBase = new AddressDataBase(ConnectionStringPattern, Login, Password);
var naklDataBase = new NaklDataBase(ConnectionStringPattern, Login, Password);
var addressId = addressDataBase.GetCompanyAddresses(userId).First().Id;
var nakl = new NaklFull()
{
contract_num = naklFullViewModel.contract_num,
contract_type_id = naklFullViewModel.contract_type_id,
doc_date = naklFullViewModel.doc_date,
operation_date = naklFullViewModel.operation_date,
provider_id = naklFullViewModel.provider_id,
receiver_id = addressId,
doc_num = naklFullViewModel.doc_num,
receive_type_id = naklFullViewModel.receive_type_id,
source_type_id = naklFullViewModel.source_type_id,
turnover_type_id = naklFullViewModel.turnover_type_id
};
return(new Result <int>(naklDataBase.Add(nakl)));
}
catch (Exception e)
{
return(new Result <int>(e.Message));
}
}
public Result <NaklViewModel> GetNakl(int id)
{
try
{
var naklDataBase = new NaklDataBase(ConnectionStringPattern, Login, Password);
var nakl = naklDataBase.GetById(id);
if (nakl != null)
{
return(new Result <NaklViewModel>(new NaklViewModel()
{
nakl_id = nakl.nakl_id,
doc_num = nakl.doc_num,
doc_date = nakl.date,
nakl_status_id = nakl.nakl_status_id,
provider_inn = nakl.provider_inn,
provider_name = nakl.provider_name,
provider_address = nakl.provider_address,
receiver_inn = nakl.receiver_inn,
receiver_name = nakl.receiver_name,
receiver_address = nakl.receiver_address,
acceptance_type = nakl.acceptance_type,
form_caption = "Поясняющий текст",
provider_tooltip = nakl.provider_name + " " + nakl.provider_inn + " " + nakl.provider_address,
receiver_tooltip = nakl.receiver_name + " " + nakl.receiver_inn + " " + nakl.receiver_address
}));
}
return(null);
}
catch (Exception e)
{
return(new Result <NaklViewModel>(e.Message));
}
}
public Result <object> Delete(int id)
{
try
{
var naklDataBase = new NaklDataBase(ConnectionStringPattern, Login, Password);
naklDataBase.Delete(id);
return(new Result <object>());
}
catch (Exception e)
{
return(new Result <object>(e.Message));
}
}
public Result <object> TrustAccept(int id)
{
try
{
var naklDataBase = new NaklDataBase(ConnectionStringPattern, Login, Password);
naklDataBase.SetNaklTrust(id, true);
return(new Result <object>());
}
catch (Exception e)
{
return(new Result <object>(e.Message));
}
}
public Result <object> SignAndSend(int id)
{
try
{
var naklDataBase = new NaklDataBase(ConnectionStringPattern, Login, Password);
naklDataBase.SetNaklStatus(id, 3);
return(new Result <object>());
}
catch (Exception e)
{
return(new Result <object>(e.Message));
}
}
public Result <IEnumerable <NaklGridViewModel> > Filtr(int?company_id = null, int?year = null, int?month = null, int?status_id = null)
{
try
{
var naklDataBase = new NaklDataBase(ConnectionStringPattern, Login, Password);
return(new Result <IEnumerable <NaklGridViewModel> >(naklDataBase.Get(company_id, year, month, status_id)
.Select((x) => new NaklGridViewModel()
{
nakl_id = x.Id,
doc_num = x.DocNum,
doc_date = x.DateTime,
contract_type = x.ContractType,
acceptance_type = x.AcceptanceType,
provider = x.Povider,
status = x.Status,
status_style = x.StatusStule,
sum = x.Sum
}).ToList()));
}
catch (Exception e)
{
return(new Result <IEnumerable <NaklGridViewModel> >(e.Message));
}
}
public object GetService(Type serviceType)
{
if (serviceType == typeof(UsersController))
{
var dataBase = new UserDataBase(connectionString);
var controller = new UsersController(dataBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(NaklStatusesController))
{
var dataBase = new NaklStatusDataBase(connectionString);
var controller = new NaklStatusesController(dataBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(SgtinsController))
{
var sgtinDataBase = new SgtinDataBase(connectionString);
var naklDataBase = new NaklDataBase(connectionString);
var naklItemDateBase = new NaklItemDataBase(connectionString);
var controller = new SgtinsController(sgtinDataBase, naklDataBase, naklItemDateBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(AddressesController))
{
var dataBase = new AddressDataBase(connectionString);
var controller = new AddressesController(dataBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(NaklsController))
{
var naklDataBase = new NaklDataBase(connectionString);
var naklItemDataBase = new NaklItemDataBase(connectionString);
var controller = new NaklsController(naklDataBase, naklItemDataBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(NaklItemsController))
{
var dataBase = new NaklItemDataBase(connectionString);
var controler = new NaklItemsController(dataBase);
AddInstance(serviceType, controler);
return(controler);
}
else if (serviceType == typeof(CompaniesController))
{
var dataBase = new CompanyDataBase(connectionString);
var controller = new CompaniesController(dataBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(ReceiveTypesController))
{
var dataBase = new RecesiverTypeDataBase(connectionString);
var controller = new ReceiveTypesController(dataBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(ContractTypesController))
{
var dataBase = new ContractTypeDataBase(connectionString);
var controller = new ContractTypesController(dataBase);
AddInstance(serviceType, controller);
return(controller);
}
else if (serviceType == typeof(SourceTypesController))
{
var dataBase = new SourceTypDataBase(connectionString);
var controller = new SourceTypesController(dataBase);
AddInstance(serviceType, controller);
return(controller);
}
else
{
return(null);
}
}
