/// <summary> /// menampilkan data produk yang tiba /// </summary> /// <returns></returns> public List<PoDelivered> getProductDelivered() { var product = getProducts(); if (product.Count() > 0) { try { List<PoDelivered> lpod = new List<PoDelivered>(); foreach (var item in product) { int qty = 0; ProductDelivered pdd = db.productDeliveredData.FirstOrDefault(p => p.po == _po && p.product == item.product); if (pdd != null) { qty = pdd.qty_delivered; } PoDelivered pd = new PoDelivered() { product = item.product, product_t = item.product_t, qty = item.qty, unit = item.unit, qty_delivered = qty }; lpod.Add(pd); } return lpod.ToList(); } catch (Exception e) { Log.Error(e); return new List<PoDelivered>(); } } else { return new List<PoDelivered>(); } }
/// <summary> /// perubahan status barang tiba /// </summary> /// <param name="po"></param> /// <param name="noteModel"></param> /// <param name="statusModel"></param> /// <param name="model"></param> /// <returns></returns> public bool setPoDelivered(string po, string noteModel, string statusModel, IEnumerable<ProductDelivered> model) { try { DeliveredInfo di = db.deliveredInfoData.FirstOrDefault(p => p.po == po); if (di == null) { di = new DeliveredInfo() { po = po, note = noteModel, status = statusModel, created_at = DateTime.Now, updated_at = DateTime.Now }; db.deliveredInfoData.Add(di); } else { di.note = noteModel; di.status = statusModel; di.updated_at = DateTime.Now; } db.SaveChanges(); foreach (var item in model) { ProductDelivered pd = db.productDeliveredData.FirstOrDefault(p => p.po == po && p.product == item.product); if (pd == null) { pd = new ProductDelivered() { po = po, product = item.product, qty_delivered = item.qty_delivered, created_at = DateTime.Now, updated_at = DateTime.Now }; db.productDeliveredData.Add(pd); } else { //ProductDelivered newPd = new ProductDelivered() { // qty_delivered = item.qty_delivered, // updated_at = item.updated_at //}; pd.qty_delivered = item.qty_delivered; pd.updated_at = DateTime.Now; //db.Entry(pd).CurrentValues.SetValues(newPd); //db.Entry(pd).State = EntityState.Modified; } db.SaveChanges(); } return true; } catch (Exception e) { Log.Error(e); return false; } }