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