public Result <object> Update(int nakl_item_id, decimal cost, int nds_value_id) { try { var ndsDataBase = new NdsValueDataBase(ConnectionStringPattern, Login, Password); var ndsValue = ndsDataBase.GetById(nds_value_id); if (ndsValue != null) { var nds = ndsValue.Value == null ? 0 : ndsValue.Value.Value; var vat_value = (cost * nds) / (100 + nds); var naklItemDataBase = new NaklItemDataBase(ConnectionStringPattern, Login, Password); naklItemDataBase.Update(nakl_item_id, cost, vat_value, ndsValue.Value); return(new Result <object>()); } else { return(new Result <object>("Значение НДС с таким id не найдено.")); } } catch (Exception e) { return(new Result <object>(e.Message)); } }
public Result <IEnumerable <NaklItemViewModel> > Get(int naklId) { try { var naklItemDataBase = new NaklItemDataBase(ConnectionStringPattern, Login, Password); return(new Result <IEnumerable <NaklItemViewModel> >(naklItemDataBase.Get(naklId).Select((x) => new NaklItemViewModel() { nakl_item_id = x.Id, name = x.Name, nds = x.Nds, code_count = x.CodeCount, cost = x.Cost, status = x.Status, count = x.Count, vat_value = x.VatValue, sum = x.Sum, style = x.Style, validation = "Нет" }))); }catch (Exception e) { return(new Result <IEnumerable <NaklItemViewModel> >(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); } }