public ActionResult Details(int?id) { var viewdata = new Suplier_Bill { SuplierDets = db.FirstOrDefault <SuppDet>("Select SBillID,SupplierName,Tdate,TDSperc from SupplierBill as sb Inner Join Supplier as s on sb.SupplierID =s.SupplierID where SBillID = @0", id), SuplierBillDets = db.Fetch <SuppBillDet>("Select * From SupplierBillDetail sbd inner join Labour l on sbd.LabourID = l.LabourID Where SBillID = @0", id) }; ViewBag.LabourID = new SelectList(db.Fetch <Labour>("Select LabourID,LabourName from Labour"), "LabourID", "LabourName"); ViewBag.tds = db.FirstOrDefault <decimal>("Select TDSperc from Config"); ViewBag.SBillID = id; return(View("Details", viewdata)); }
public ActionResult ManageDetails(int?id) { ViewBag.SupBillDets = base.BaseCreateEdit <SupplierBillDetail>(id, "SBillDetailID"); ViewBag.LabourName = db.FirstOrDefault <SuppBillDet>("Select LabourName From SupplierBillDetail sbd inner join labour as l on sbd.LabourID = l.LabourID where SBillDetailID= @0", id).LabourName; ViewBag.tds = db.FirstOrDefault <decimal>("Select TDSperc from Config"); var viewdata = new Suplier_Bill { SuplierDets = db.FirstOrDefault <SuppDet>("Select SBillID,SupplierName,Tdate,TDSperc from SupplierBill as sb Inner Join Supplier as s on sb.SupplierID =s.SupplierID where SBillID = @0", id), SuplierBillDets = db.Fetch <SuppBillDet>("Select * From SupplierBillDetail Where SBillID = @0", id) }; return(View("Details", viewdata)); }