public ActionResult Details(int?id)
{
var viewdata = new MAsterWork_Details
{
Work = db.FirstOrDefault <MasterWork>("Select WorkID,WorkName,UnitName,Rate from Work w Inner Join Units u on w.UnitID =u.UnitID where WorkID = @0", id),
WorkDets = db.Fetch <MasterWorkDetails>("Select * From WorkDetails wd inner join Item i on wd.ItemID = i.ItemID inner join Units u on i.UnitID = u.UnitID Where WorkID = @0", id)
};
ViewBag.UnitID = new SelectList(db.Fetch <Unit>("Select UnitID,UnitName from Units"), "UnitID", "UnitName");
ViewBag.WorkID = id;
return(View("Details", viewdata));
}
public ActionResult RateAdditionDetails(int?id)
{
var viewdata = new MAsterWork_Details
{
Work = db.FirstOrDefault <MasterWork>("Select WorkID,WorkName,UnitName,Rate from Work w Inner Join Units u on w.UnitID =u.UnitID where WorkID = @0", id),
WorkDets = db.Fetch <MasterWorkDetails>("Select * From WorkDetails wd inner join RateAdditions l on wd.RateAdditionID = l.RateAdditionID Where WorkID = @0", id)
};
ViewBag.RateAdditionID = new SelectList(db.Fetch <RateAddition>("Select RateAdditionID,RateAdditionDesc from RateAdditions"), "RateAdditionID", "RateAdditionDesc");
ViewBag.WorkID = id;
return(View("RateAdditionDetails", viewdata));
}
public ActionResult LabourDetails(int?id)
{
var viewdata = new MAsterWork_Details
{
Work = db.FirstOrDefault <MasterWork>("Select WorkID,WorkName,UnitName,Rate from Work w Inner Join Units u on w.UnitID =u.UnitID where WorkID = @0", id),
WorkDets = db.Fetch <MasterWorkDetails>("Select * From WorkDetails wd inner join Labour l on wd.LabourID = l.LabourID Where WorkID = @0", id)
};
ViewBag.LabourID = new SelectList(db.Fetch <Labour>("Select LabourID,LabourName from Labour"), "LabourID", "LabourName");
ViewBag.WorkID = id;
return(View("LabourDetails", viewdata));
}
public ActionResult ManageDetails(int?id)
{
ViewBag.WorkDets = base.BaseCreateEdit <WorkDetail>(id, "WorkDetailID");
ViewBag.WorkName = db.FirstOrDefault <string>("Select itemName From WorkDetails wd inner join Item as i on wd.ItemID = i.ItemID where WorkDetailID= @0", id);
var viewdata = new MAsterWork_Details
{
Work = db.FirstOrDefault <MasterWork>("Select WorkID,WorkName,UnitName,Rate from Work w Inner Join Units u on w.UnitID =u.UnitID where WorkID = @0", id),
WorkDets = db.Fetch <MasterWorkDetails>("Select * From WorkDetails wd inner join Item i on wd.ItemID = i.ItemID inner join Units u on i.UnitID = u.UnitID Where WorkID = @0", id)
};
return(View("Details", viewdata));
}
public ActionResult RateAdditionManageDetails(int?id)
{
ViewBag.WorkDets = base.BaseCreateEdit <WorkDetail>(id, "WorkDetailID");
ViewBag.WorkName = db.FirstOrDefault <string>("Select RateAdditionDesc From WorkDetails wd inner join RateAdditions as l on wd.RateAdditionID = l.RateAdditionID where WorkDetailID= @0", id);
var viewdata = new MAsterWork_Details
{
Work = db.FirstOrDefault <MasterWork>("Select WorkID,WorkName,UnitName,Rate from Work w Inner Join Units u on w.UnitID =u.UnitID where WorkID = @0", id),
WorkDets = db.Fetch <MasterWorkDetails>("Select * From WorkDetails wd inner join RateAdditions l on l.RateAdditionID = wd.RateAdditionID Where WorkID = @0", id)
};
return(View("RateAdditionDetails", viewdata));
}
