/// <summary>
/// menampilkan status produk yang tiba
/// </summary>
/// <returns></returns>
public DeliveredInfo getDeliveredInfo()
{
try
{
DeliveredInfo di = db.deliveredInfoData.FirstOrDefault(p => p.po == _po);
if (di == null)
{
di = new DeliveredInfo();
}
return di;
}
catch (Exception e)
{
Log.Error(e);
return new DeliveredInfo();
}
}
/// <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;
}
}
