public static void GenerateVoucher() { List <Dmg_Goods_Dtl> VoucherForDmg = model.Dmg_Goods_Dtl.Where(x => x.Details == "pending").ToList();; var xy = model.Dmg_Goods_Dtl.Where(x => x.Details == "pending").GroupBy(x => new { x.Item_number }).Select(x => new { x.Key.Item_number, v = x.Sum(y => y.Damage_Qnty) }).ToList(); List <Voucher> Voucherlist = xy.Select(x => new Voucher(x.Item_number, (int)x.v)).ToList <Voucher>(); if (Voucherlist.Count != 0) { foreach (var item in Voucherlist) { Voucher_details newVoucher = new Voucher_details(); newVoucher.Item_Number = item.Item_Number; newVoucher.Approve_ID = "STR001"; newVoucher.Voucher_Date = System.DateTime.Now; newVoucher.Quantity = item.DmgQuantity; newVoucher.Amount = item.DmgQuantity * GetItemPrice(item.Item_Number); newVoucher.Status = "Pending"; model.Voucher_details.Add(newVoucher); model.SaveChanges(); } } foreach (Dmg_Goods_Dtl dmg in VoucherForDmg) { dmg.Details = "done"; } SendVoucher(); }
public static void createVoucher(string description, int quantity, Employee emp) { Voucher_details newVoucher = new Voucher_details(); newVoucher.Employee_ID = "STR003"; //newVoucher.Damage_ID = (from x in model.Dmg_Goods_Dtl select x.Dmg_ID).Last(); newVoucher.Voucher_Date = System.DateTime.Today; newVoucher.Amount = 34; model.Voucher_details.Add(newVoucher); model.SaveChanges(); }