//Generates Sales Invoice public ActionResult SalesInvoice(int?id) { ASITPOSDBEntities db = new ASITPOSDBEntities(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var _sales = slsrepo.GetSales(id); //check if id supplied is present or not. if (_sales == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { var salitm = new List <SalesInvRpt>(); //foreach (var item in _sales.SalesItems) //{ // var sal = new SalesInvRpt { // ID = item.ID, // Amount = item.Amount, // Qty = item.Qty, // Rate = item.Rate, // SalesID = item.SalesID, // StockID = item.StockID }; // salitm.Add(sal); //} salitm = (from sitem in _sales.SalesItems join stocks in db.Stocks on sitem.StockID equals stocks.ID join item in db.Items on stocks.ItemID equals item.ItemID into subtbl from sub2 in subtbl.DefaultIfEmpty() select new SalesInvRpt() { ID = sitem.ID, Amount = sitem.Amount, Qty = sitem.Qty, Rate = sitem.Rate, Proname = sub2.Name, SalesID = sitem.SalesID, StockID = sitem.StockID }).ToList(); //var query = from person in people // join pet in pets on person equals pet.Owner into gj // from subpet in gj.DefaultIfEmpty() // select new { person.FirstName, PetName = (subpet == null ? String.Empty : subpet.Name) }; LocalReport rpt = new LocalReport(); rpt = RptSetupClass.GetLocalReport("Sales.POSSalesInv01", salitm, null, null); RptRDLCPDF(rpt); return(View()); } }
public Sales GetSales(int?salesId) { return(repo.GetSales(salesId)); }