public WarehouseEntryVm GetWarehouseEntry(Expression <Func <WarehouseEntry, bool> > filterPredicate = null) { WarehouseEntry warehouseEntry = _uow.Repository <WarehouseEntry>().Get(filterPredicate, false, null); WarehouseEntryVm warehouseEntryVm = Mapper.Map <WarehouseEntryVm>(warehouseEntry); return(warehouseEntryVm); }
public WarehouseEntryViewModel(INavigation navigation, WarehouseEntry warehouseentry) : base(navigation) { EntryNo = warehouseentry.EntryNo; EntryType = warehouseentry.EntryType; LocationCode = warehouseentry.LocationCode; ZoneCode = warehouseentry.ZoneCode; BinCode = warehouseentry.BinCode; ItemNo = warehouseentry.ItemNo; VariantCode = warehouseentry.VariantCode; Description = warehouseentry.Description; UnitofMeasureCode = warehouseentry.UnitofMeasureCode; RegisteringDate = warehouseentry.RegisteringDate; Quantity = warehouseentry.Quantity; QuantityBase = warehouseentry.QuantityBase; WarrantyDate = warehouseentry.WarrantyDate; SourceNo = warehouseentry.SourceNo; }
public IHttpActionResult GetWarehouseEntries(string query = null) { try { using (OracleConnection Con = new Oracle.ManagedDataAccess.Client.OracleConnection(Static.Secrets.ApiConnectionString)) { if (Con.State == System.Data.ConnectionState.Closed) { Con.Open(); } if (query == null) { query = $"(pi.C_DATE >= '{DateTime.Now.StartOfWeek().ToString("yyyy-MM-dd HH:mm:ss")}')"; } else { if (!query.Contains("C_DATE")) { //make sure start date is always indicated //otherwise we can crash the db query += $" AND (pi.C_DATE >= '{DateTime.Now.StartOfWeek().ToString("yyyy-MM-dd HH:mm:ss")}') "; } } string str = $@"SELECT pr.PRODUCT_NR, s.SERIAL_NR, pi.PRODUCTION_ID, pi.LOADUNIT_ID, pi.LOADUNIT_NR, pi.PRODUCT_ID, pi.DATE_PROD, pi.QUANTITY, pi.WEIGHT, pi.LENGTH, pi.WIDTH, pi.HEIGHT, pi.STATUS, pi.C_DATE, pi.LM_DATE FROM PRODUCTION_ITEMS pi LEFT OUTER JOIN QCM_PRODUCTS pr ON pr.PRODUCT_ID = pi.PRODUCT_ID LEFT OUTER JOIN QCM_PROD_SERIALS s ON s.PROD_SERIAL_ID = pi.PROD_SERIAL_ID WHERE {query}"; var Command = new Oracle.ManagedDataAccess.Client.OracleCommand(str, Con); var reader = Command.ExecuteReader(); List <WarehouseEntry> Entries = new List <WarehouseEntry>(); if (reader.HasRows) { while (reader.Read()) { WarehouseEntry w = new WarehouseEntry(); w.LOADUNIT_ID = Convert.ToInt64(reader["LOADUNIT_ID"].ToString()); w.LOADUNIT_NR = reader["LOADUNIT_NR"].ToString(); w.PRODUCTION_ID = Convert.ToInt64(reader["PRODUCTION_ID"].ToString()); w.PRODUCT_ID = Convert.ToInt64(reader["PRODUCT_ID"].ToString()); w.PRODUCT_NR = reader["PRODUCT_NR"].ToString(); w.SERIAL_NR = reader["SERIAL_NR"].ToString(); w.QUANTITY = Convert.ToInt32(reader["QUANTITY"].ToString()); w.STATUS = reader["STATUS"].ToString(); w.WEIGHT = Convert.ToDouble(reader["WEIGHT"].ToString()); w.WIDTH = Convert.ToInt32(reader["WIDTH"].ToString()); w.LENGTH = Convert.ToInt32(reader["LENGTH"].ToString()); w.HEIGHT = Convert.ToInt32(reader["HEIGHT"].ToString()); w.C_DATE = Convert.ToDateTime(reader["C_DATE"].ToString()); w.LM_DATE = Convert.ToDateTime(reader["LM_DATE"].ToString()); Entries.Add(w); } return(Ok(Entries)); } else { Logger.Info("GetWarehouseEntries: Porażka, nie znaleziono nic.."); return(NotFound()); } } } catch (Exception ex) { Logger.Error("GetWarehouseEntries: Błąd. Szczegóły: {Message}", ex.ToString()); return(InternalServerError(ex)); } }