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));
}
