public void Insert(string idVoucher, string idCustomer, DateTime date, List <DeliveryVoucherInfo> voucherInfos)
{
DeliveryVoucher newVoucher = new DeliveryVoucher();
newVoucher.ID = idVoucher;
newVoucher.Date = date;
newVoucher.IDCustomer = idCustomer;
foreach (var info in voucherInfos)
{
newVoucher.DeliveryVoucherInfoes.Add(info);
}
db.DeliveryVouchers.Add(newVoucher);
db.SaveChanges();
db.Entry(newVoucher).Reference(p => p.Customer).Load();
}
public int DeleteByID(string idDeliveryVoucher)
{
int rowAffected = 0;
DeliveryVoucher voucher = db.DeliveryVouchers.Find(idDeliveryVoucher);
int row = db.DeliveryVoucherInfoes.Count();
if (voucher != null)
{
if (voucher.DeliveryVoucherInfoes.Count > 0)
{
foreach (var info in voucher.DeliveryVoucherInfoes.ToList())
{
voucher.DeliveryVoucherInfoes.Remove(info);
}
}
DeliveryVoucher v = db.DeliveryVouchers.Find(idDeliveryVoucher);
db.DeliveryVouchers.Remove(voucher);
rowAffected = db.SaveChanges();
}
return(rowAffected);
}
public DeliveryVoucher GetByID(string idVoucher)
{
DeliveryVoucher deliveryVouchers = db.DeliveryVouchers.Find(idVoucher);
return(deliveryVouchers);
}
