public ActionResult SearchJob(string SearchJob) { dynamic listTicPO = new ExpandoObject(); dynamic listTicPOn = new ExpandoObject(); QueryCRUD qr = new QueryCRUD(); List <T_Po> listTic = qr.SearchT_PoJOB(SearchJob); listTicPO.T_Po = listTic; listTicPO.T_Job = qr.listjob(); if (SearchJob == "") { TempData["SearchJob"] = ""; listTicPOn.T_Po = qr.GetT_Po(); listTicPOn.T_Job = qr.listjob(); return(View("ShowPo", listTicPOn)); } return(View("ShowPo", listTicPO)); }
public ActionResult Search(string Search) { dynamic listTicPO = new ExpandoObject(); QueryCRUD qr = new QueryCRUD(); List <T_Po> listTic = qr.SearchT_Po(Search); listTicPO.T_Po = listTic; listTicPO.T_Job = qr.listjob(); if (Search == "") { dynamic listTicPOn = new ExpandoObject(); List <T_Po> listTicPo = qr.GetT_Po(); listTicPOn.T_Po = listTicPo; listTicPOn.T_Job = qr.listjob(); return(View("ShowPo", listTicPOn)); } ViewBag.Po = Search; return(View("ShowPo", listTicPO)); }
public ActionResult SearchJobPR(string SearchJob) { dynamic listTicPR = new ExpandoObject(); dynamic listTicPRn = new ExpandoObject(); QueryCRUD qr = new QueryCRUD(); List <T_PR> listTic = qr.SearchT_PoJOBPR(SearchJob); listTicPR.T_Pr = listTic; listTicPR.T_Job = qr.listjobPR(); if (SearchJob == "") { TempData["SearchJob"] = ""; listTicPRn.T_Pr = qr.GetT_PR(); listTicPRn.T_Job = qr.listjobPR(); return(View("ShowPR", listTicPRn)); } return(View("ShowPR", listTicPR)); }
public ActionResult LoginIndex(T_Admin t_Admin) { QueryCRUD query = new QueryCRUD(); bool chk = query.CheckLogin(t_Admin.User_name, t_Admin.Password); List <T_Admin> listTic = new List <T_Admin>(); QueryCRUD qr = new QueryCRUD(); listTic = qr.T_Admins(t_Admin.User_name, t_Admin.Password); if (chk == true) { TempData["User_name"] = t_Admin.User_name; Session["User_name"] = t_Admin.User_name; Session["Type"] = listTic; return(RedirectToAction("Index", "Show")); } else { TempData["message"] = "User And Password Invalid"; return(View()); } }
public ActionResult ApprovedPR(PRandPRApp prandpra) { QueryCRUD qr = new QueryCRUD(); if (qr.EditPR(prandpra)) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult ReJectPR(PRandPRApp prandpra) { QueryCRUD qr = new QueryCRUD(); if (qr.RejectPR(prandpra)) { return(RedirectToAction("ShowPR")); } return(View()); }
public ActionResult ShowPR() { ViewBag.PR = "Search"; dynamic listTicPR = new ExpandoObject(); QueryCRUD qr = new QueryCRUD(); List <T_PR> listTic = qr.GetT_PR(); listTicPR.T_Pr = listTic; listTicPR.T_Job = qr.listjobPR(); return(View(listTicPR)); }
public ActionResult ShowPR() { ViewBag.PR = "Search"; List <T_PR> listTic = new List <T_PR>(); QueryCRUD qr = new QueryCRUD(); listTic = qr.GetT_PR(); return(View(listTic)); }
public ActionResult ShowPo() { ViewBag.Po = "Search"; dynamic listTicPO = new ExpandoObject(); QueryCRUD qr = new QueryCRUD(); List <T_Po> listTic = qr.GetT_Po(); listTicPO.T_Po = listTic; listTicPO.T_Job = qr.listjob(); return(View(listTicPO)); }
public ActionResult HoldingPR(PRandPRApp prandPRApp) { QueryCRUD qr = new QueryCRUD(); if (qr.HoldingPR(prandPRApp)) { return(RedirectToAction("ShowPR")); } return(View()); }
public ActionResult Holding(PoandPoApp poandPoApp) { QueryCRUD qr = new QueryCRUD(); if (qr.Holding(poandPoApp)) { return(RedirectToAction("ShowPo")); } return(View()); }
public ActionResult ReJectPO(PoandPoApp poandPoApp) { QueryCRUD qr = new QueryCRUD(); if (qr.RejectPo(poandPoApp)) { return(RedirectToAction("ShowPo")); } return(View()); }
public ActionResult Approved(PoandPoApp poandPoApp) { QueryCRUD qr = new QueryCRUD(); if (qr.EditDt(poandPoApp)) { return(RedirectToAction("Index")); } return(View()); }
public ActionResult LoginIndex(T_Admin t_Admin) { QueryCRUD query = new QueryCRUD(); bool chk = query.CheckLogin(t_Admin.User_name, t_Admin.Password); List <T_Admin> listTic = new List <T_Admin>(); QueryCRUD qr = new QueryCRUD(); bool chkadmin = query.CheckAdmin(t_Admin.User_name, t_Admin.Password); if (t_Admin.User_name != null) { if (t_Admin.Password != null) { if (chk == true) { if (chkadmin == true) { TempData["User_name"] = t_Admin.User_name; Session["User_name"] = t_Admin.User_name; Session["Type"] = listTic; } else { Session["User_name2"] = t_Admin.User_name; } return(RedirectToAction("Index", "Show")); } else { TempData["message"] = "User And Password Invalid"; return(View()); } } else { TempData["mgs"] = "Please Input Data !!!"; return(View()); } } else { TempData["mgs"] = "Please Input Data !!!"; return(View()); } }
public ActionResult ApprovedPR(PRandPRApp prandpra, T_Admin t_Admin) { QueryCRUD qr = new QueryCRUD(); T_Admin t_Admins = new T_Admin(); if (Session["User_name"] != null) { t_Admin.User_name = Session["User_name"].ToString(); t_Admins = qr.Get_T_Admins(t_Admin.User_name); int byid = t_Admins.User_ID; if (qr.EditPR(prandpra, byid)) { return(RedirectToAction("ShowPR")); } } return(View()); }
public ActionResult SearchPR(string Search) { List <T_PR> listTic = new List <T_PR>(); QueryCRUD qr = new QueryCRUD(); listTic = qr.SearchT_PR(Search); if (Search == "") { ViewBag.PR = "Search"; listTic = qr.GetT_PR(); return(View("ShowPR", listTic)); } ViewBag.PR = Search; return(View("ShowPR", listTic)); }
public ActionResult SearchPR(string Search) { if (Search == "") { ViewBag.PR = "Search"; dynamic listTicPR = new ExpandoObject(); QueryCRUD qr = new QueryCRUD(); List <T_PR> listTic = qr.GetT_PR(); listTicPR.T_Pr = listTic; listTicPR.T_Job = qr.listjobPR(); return(View("ShowPR", listTicPR)); } else { dynamic listTicPR = new ExpandoObject(); QueryCRUD qr = new QueryCRUD(); List <T_PR> listTic = qr.SearchT_PR(Search); listTicPR.T_Pr = listTic; listTicPR.T_Job = qr.listjobPR(); return(View("ShowPR", listTicPR)); } }
public ActionResult ReJectPO(string PoNo) { QueryCRUD qr = new QueryCRUD(); return(PartialView(qr.GetT_PoandPoApp().Find(ID => ID.PoNo == PoNo))); }
public ActionResult ReJectPR(string PR_no) { QueryCRUD qr = new QueryCRUD(); return(PartialView(qr.GetT_PRandPrApp().Find(ID => ID.PR_no == PR_no))); }
// GET: Show public ActionResult Index() { List <T_PoJoinPR> listTic = new List <T_PoJoinPR>(); List <HoldingPO> listTic2 = new List <HoldingPO>(); List <HoldingPR> listTic3 = new List <HoldingPR>(); List <RejectPO> listTic4 = new List <RejectPO>(); List <RejectPR> listTic5 = new List <RejectPR>(); QueryCRUD qr = new QueryCRUD(); listTic = qr.GetTPO(); listTic2 = qr.GetTPOHolding(); listTic3 = qr.GetT_PRHolding(); listTic4 = qr.GetTPO_Reject(); listTic5 = qr.GetTPR_Reject(); if (listTic.Count == 0) { ViewBag.sumpo = "0"; ViewBag.sumpr = "0"; } listTic.ForEach((l) => { if (l.T_Po != null) { ViewBag.sumpo = l.T_Po; if (l.T_Po == "") { ViewBag.sumpo = "0"; } } if (l.T_PR != null) { ViewBag.sumpr = l.T_PR; if (l.T_PR == "") { ViewBag.sumpr = "0"; } } }); try { if (listTic2.Count == 0) { ViewBag.sumhopo = "0"; } listTic2.ForEach((i) => { if (i.Area != null) { ViewBag.sumhopo = i.Area; } }); if (listTic3.Count == 0) { ViewBag.sumhopr = "0"; } listTic3.ForEach((li) => { if (li.Area != null) { ViewBag.sumhopr = li.Area; } }); } catch { return(View()); } try { if (listTic4.Count == 0) { ViewBag.sumrepo = "0"; } listTic4.ForEach((s) => { if (s.Area != null) { ViewBag.sumrepo = s.Area; } }); if (listTic5.Count == 0) { ViewBag.sumrepr = "0"; } listTic5.ForEach((si) => { if (si.Area != null) { ViewBag.sumrepr = si.Area; } }); } catch { return(View()); } return(View(listTic)); }