コード例 #1
0
        public ActionResult update23(FormCollection form)
        {
            Config         cf   = dc.Configs.OrderByDescending(c => c.BuildDate).ToList().First();
            RequestModel   rq   = new RequestModel();
            RequestModel22 rq22 = new RequestModel22();
            Employee       e    = (Employee)Session["Employee"];
            Employee       e1   = dc.Employees.Where(ee => ee.EmployeeNumber == e.RegistrationNumber).ToList().First();
            Employee       e2   = dc.Employees.Where(ee => ee.EmployeeNumber == e.RegistrationNumber).ToList().First();

            ViewData["lst1"] = rq22.Listrq2().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("2")) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("6") && r.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            string From        = cf.MailName;
            string To          = e1.Email;
            string cc          = e2.Email;
            string type        = cf.Type;
            int    post        = Convert.ToInt32(cf.Ports);
            string mailnetword = cf.MailNetwork;
            string pass        = cf.Password;
            string Subject     = "Sent To Director Request " + form["rname"].ToString();
            string Message     = "<span><b>From:</b> " + e.FullName + "</span><br/>" + "<b>Date Dispatch:</b> " + form["dd"].ToString() + "<br/>" + "<b>Content:</b> " + form["rc"].ToString() + "<br/>" + "<b>Description:</b> " + form["dt"].ToString();

            if (rq.Send1(From, To, cc, Subject, Message, type, post, mailnetword, pass))
            {
                rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
                Session["email"] = 1;
            }
            else
            {
                Session["email"] = 2;
            }
            //
            rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
            return(RedirectToAction("MyRequest10"));
        }
コード例 #2
0
        //
        public ActionResult Search1(string id)
        {
            RequestModel22 rq22 = new RequestModel22();
            Employee       e    = (Employee)Session["Employee"];

            if (id != null)
            {
                List <RequestModel22> ls = rq22.search(id).Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
                string chuoi             = "";

                foreach (RequestModel22 s in ls)
                {
                    chuoi += "<tr>";
                    // chuoi += "<td>" + s.RId1 + "</td>";
                    chuoi += "<td>" + s.Rname1 + "</td>";
                    chuoi += "<td>" + s.CRQName1 + "</td>";
                    chuoi += "<td>" + s.DDispatch1 + "</td>";
                    //  chuoi += "<td>" + s.Arise + "</td>";
                    chuoi += "<td>" + s.DApprove1 + "</td>";
                    chuoi += "<td>" + s.RContent1 + "</td>";
                    //("Select","DetailRQ4/"+rq.RId1,"Default1")
                    chuoi += "<td><a href='/Default1/DetailRQ4/" + s.RId1 + "'>Select</a></td>";
                    chuoi += "</tr>";
                }

                Response.Write(chuoi);
            }
            else
            {
                List <RequestModel22> ls = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
                string chuoi             = "";

                foreach (RequestModel22 s in ls)
                {
                    chuoi += "<tr>";
                    // chuoi += "<td>" + s.RId1 + "</td>";
                    chuoi += "<td>" + s.Rname1 + "</td>";
                    chuoi += "<td>" + s.CRQName1 + "</td>";
                    chuoi += "<td>" + s.DDispatch1 + "</td>";
                    //  chuoi += "<td>" + s.Arise + "</td>";
                    chuoi += "<td>" + s.DApprove1 + "</td>";
                    chuoi += "<td>" + s.RContent1 + "</td>";
                    //("Select","DetailRQ4/"+rq.RId1,"Default1")
                    chuoi += "<td><a href='/Default1/DetailRQ4/" + s.RId1 + "'>Select</a></td>";
                    chuoi += "</tr>";
                }

                Response.Write(chuoi);
            }

            return(null);
        }
コード例 #3
0
        //
        //

        //
        public ActionResult MyRequest10()
        {
            //Session["ac"] = id;
            if (Session["Employee"] == null)
            {
                return(RedirectToAction("Login"));
            }
            RequestModel   rq   = new RequestModel();
            RequestModel22 rq22 = new RequestModel22();
            Employee       e    = (Employee)Session["Employee"];

            //my newrequest/
            ViewData["lst"] = rq22.Listrq2().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("1") && r.Acc1 == true || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("5") && r.Acc1 == true)) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("5") && r.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //Request Approved/
            ViewData["lst1"] = rq22.Listrq2().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("2")) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("9") && r.Acc1 == false) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("6") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("6") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("66") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("66") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("7") && r.Acc1 == false) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("7") && r.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();

            //My Accept/
            ViewData["lst2"] = rq.ListRQ().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("4") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("7") && r.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //My Reject/
            ViewData["lst3"] = rq.ListRQ().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("4") && r.Acc1 == false) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("8") && r.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();

            //Request No Approved/
            ViewData["lst4"] = rq22.Listrq2().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("3")) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("6") && r.Acc1 == false) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("6") && r.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //New Request
            ViewData["lst5"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst55"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true) || (r1.Stte1.Equals("5") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //Withdraw Request/
            ViewData["lst6"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == false) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("5") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst66"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == false) || (r1.Stte1.Equals("5") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //Cancel Request/
            ViewData["lst7"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("2") && r1.Acc1 == false) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("7") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst77"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("2") && r1.Acc1 == false) || (r1.Stte1.Equals("7") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //Accept Request/
            ViewData["lst8"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("4") && r1.Acc1 == true) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("7") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst88"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("4") && r1.Acc1 == true) || (r1.Stte1.Equals("7") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();


            return(View("myrequest10"));
        }
コード例 #4
0
        public ActionResult update55(FormCollection form)
        {
            Config cf = dc.Configs.OrderByDescending(c => c.BuildDate).ToList().First();
            RequestModel22 rq22 = new RequestModel22();
            RequestModel rq = new RequestModel();
            Employee e = (Employee)Session["Employee"];
            Employee e1 = (Employee)Session["eplo1"];//nb req
            Employee e2 = dc.Employees.Where(ee => ee.EmployeeNumber == e1.RegistrationNumber).ToList().First();
            ViewData["lst7"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("2") && r1.Acc1 == false) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("7") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            string From = cf.MailName;
            string To = e1.Email;
            string cc = e2.Email;
            string type = cf.Type;
            int post = Convert.ToInt32(cf.Ports);
            string mailnetword = cf.MailNetwork;
            string pass = cf.Password;
            string Subject = "No Approved (Request Rject) " + form["rname"].ToString();
            string Message = "<span><b>From:</b> " + e.FullName + "</span><br/>" + "<b>Date Dispatch:</b> " + form["dd"].ToString() + "<br/>" + "<b>Content:</b> " + form["rc"].ToString() + "<br/>" + "<b>Description:</b> " + form["dt"].ToString();
            if (form["st6"].Equals("7"))
            {
                if (rq.Send1(From, To, cc, Subject, Message, type, post, mailnetword, pass))
                {

                    rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
                    Session["email"] = 1;
                }
                else
                    Session["email"] = 2;
            }
            else
            {
                if (rq.Send(From, To, Subject, Message, type, post, mailnetword, pass))
                {
                    rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
                    Session["email"] = 1;
                }
                else
                    Session["email"] = 2;
            }
            return RedirectToAction("MyRequest10");
        }
コード例 #5
0
        public ActionResult update4(FormCollection form)
        {
            Request_StationeryModel rm1 = new Request_StationeryModel();

            List<Stationery> lstr = dc.Stationeries.ToList();
            Config cf = dc.Configs.OrderByDescending(c => c.BuildDate).ToList().First();
            RequestModel rq = new RequestModel();
            StationeryModel stmd = new StationeryModel();
            Employee e = (Employee)Session["Employee"];
            Employee e1 = (Employee)Session["eplo"];
            Employee e2 = dc.Employees.Where(ee => ee.EmployeeNumber == e1.RegistrationNumber).ToList().First();
            RequestModel22 rq22 = new RequestModel22();
               // Employee e1 = dc.Employees.Where(ee => ee.EmployeeNumber == e.RegistrationNumber).ToList().First();
            ViewData["lst5"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true) || (r1.Stte1.Equals("5") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            string From = cf.MailName;
            string To = e1.Email;
            string cc = e2.Email;
            string type = cf.Type;
            int post = Convert.ToInt32(cf.Ports);
            string mailnetword = cf.MailNetwork;
            string pass = cf.Password;
            string Subject = "Approved Request " + form["rname"].ToString();
            string Message = "<span><b>From:</b> " + e.FullName + "</span><br/>" + "<b>Date Dispatch:</b> " + form["dd"].ToString() + "<br/>" + "<b>Content:</b> " + form["rc"].ToString() + "<br/>" + "<b>Description:</b> " + form["dt"].ToString();
            //mail
            List<Request_Stationery> rqs = dc.Request_Stationeries.Where(s => s.RequestId == Convert.ToInt32(form["requestid"])).ToList();
            string str = " ";
            Session["result"] = true;
            //test
            foreach (Stationery st in lstr)
            {
                foreach (Request_Stationery rs in rqs)
                {

                    if (st.ProductId == rs.ProductId && rs.Quantity > st.Quantity)
                    {
                        Session["result"] = false;
                        break;
                    }

                }

            }
            //
            //print item
            if (Convert.ToBoolean(Session["result"]) == false)
            {
                foreach (Stationery st in lstr)
                {
                    foreach (Request_Stationery rs in rqs)
                    {
                        if (st.ProductId == rs.ProductId && rs.Quantity > st.Quantity)
                        {
                            str = str + st.ProductName.ToString() + "&nbsp_&nbsp";
                        }
                    }
                }
            }
            else if (Convert.ToBoolean(Session["result"]) == true)
            {
                if (form["st3"].Equals("5"))
                {
                    if (rq.Send1(From, To, cc, Subject, Message, type, post, mailnetword, pass))
                    {
                        //////
                        List<Stationery> stnr = dc.Stationeries.ToList();
                        List<Request_Stationery> listrq = dc.Request_Stationeries.Where(l => l.RequestId == Convert.ToInt32(form["requestid"])).ToList();
                        //
                        foreach (Stationery s in stnr)
                       {
                           foreach (Request_Stationery v in listrq)
                           {
                               if (s.ProductId == v.ProductId)
                                   stmd.EditST_RQ(v.ProductId, Convert.ToInt32(s.Quantity - v.Quantity));
                           }
                        }

                        //
                        rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));

                        Session["email"] = 1;
                    }
                    else
                        Session["email"] = 2;
                    //

                }
                else
                {
                    if (rq.Send(From, To, Subject, Message, type, post, mailnetword, pass))
                    {
                        List<Stationery> stnr = dc.Stationeries.ToList();
                        List<Request_Stationery> listrq = dc.Request_Stationeries.Where(l => l.RequestId == Convert.ToInt32(form["requestid"])).ToList();
                        //
                        foreach (Stationery s in stnr)
                        {
                            foreach (Request_Stationery v in listrq)
                            {
                                if(s.ProductId==v.ProductId)
                                stmd.EditST_RQ(v.ProductId, Convert.ToInt32(s.Quantity-v.Quantity));
                            }
                        }

                        rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
                        Session["email"] = 1;
                    }
                    else
                        Session["email"] = 2;
                }
            }
            //mail
            Session["qty"] = str;
            //

            return RedirectToAction("MyRequest10");
        }
コード例 #6
0
        //
        public ActionResult Search1(string id)
        {
            RequestModel22 rq22 = new RequestModel22();
            Employee e = (Employee)Session["Employee"];
            if (id != null)
            {
                List<RequestModel22> ls = rq22.search(id).Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
                string chuoi = "";

                foreach (RequestModel22 s in ls)
                {
                    chuoi += "<tr>";
                    // chuoi += "<td>" + s.RId1 + "</td>";
                    chuoi += "<td>" + s.Rname1 + "</td>";
                    chuoi += "<td>" + s.CRQName1 + "</td>";
                    chuoi += "<td>" + s.DDispatch1 + "</td>";
                    //  chuoi += "<td>" + s.Arise + "</td>";
                    chuoi += "<td>" + s.DApprove1 + "</td>";
                    chuoi += "<td>" + s.RContent1 + "</td>";
                    //("Select","DetailRQ4/"+rq.RId1,"Default1")
                    chuoi += "<td><a href='/Default1/DetailRQ4/" + s.RId1 + "'>Select</a></td>";
                    chuoi += "</tr>";
                }

                Response.Write(chuoi);
            }
            else
            {
                List<RequestModel22> ls = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
                string chuoi = "";

                foreach (RequestModel22 s in ls)
                {
                    chuoi += "<tr>";
                    // chuoi += "<td>" + s.RId1 + "</td>";
                    chuoi += "<td>" + s.Rname1 + "</td>";
                    chuoi += "<td>" + s.CRQName1 + "</td>";
                    chuoi += "<td>" + s.DDispatch1 + "</td>";
                    //  chuoi += "<td>" + s.Arise + "</td>";
                    chuoi += "<td>" + s.DApprove1 + "</td>";
                    chuoi += "<td>" + s.RContent1 + "</td>";
                    //("Select","DetailRQ4/"+rq.RId1,"Default1")
                    chuoi += "<td><a href='/Default1/DetailRQ4/" + s.RId1 + "'>Select</a></td>";
                    chuoi += "</tr>";
                }

                Response.Write(chuoi);
            }

            return null;
        }
コード例 #7
0
        //
        //
        //
        public ActionResult MyRequest10()
        {
            //Session["ac"] = id;
            if (Session["Employee"] == null)
            {
                return RedirectToAction("Login");
            }
            RequestModel rq = new RequestModel();
            RequestModel22 rq22 = new RequestModel22();
            Employee e = (Employee)Session["Employee"];
            //my newrequest/
            ViewData["lst"] = rq22.Listrq2().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("1") && r.Acc1 == true || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("5") && r.Acc1==true)) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("5")&& r.Acc1==true)).OrderByDescending(r => r.DDispatch1).ToList();
            //Request Approved/
            ViewData["lst1"] = rq22.Listrq2().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("2")) ||(e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("9") && r.Acc1==false)|| (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("6") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("6") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("66") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("66") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("7") && r.Acc1 == false) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("7") && r.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();

            //My Accept/
            ViewData["lst2"] = rq.ListRQ().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("4") && r.Acc1 == true) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("7") && r.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
               //My Reject/
            ViewData["lst3"] = rq.ListRQ().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("4") && r.Acc1 == false) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("8") && r.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();

            //Request No Approved/
            ViewData["lst4"] = rq22.Listrq2().Where(r => (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("3")) || (e.EmployeeNumber.Equals(r.RNumber1) && r.Stte1.Equals("6") && r.Acc1 == false) || (e.EmployeeNumber.Equals(r.ENumber1) && r.Stte1.Equals("6") && r.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //New Request
            ViewData["lst5"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst55"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true) || (r1.Stte1.Equals("5") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //Withdraw Request/
            ViewData["lst6"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == false) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("5") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst66"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == false) || (r1.Stte1.Equals("5") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
               //Cancel Request/
            ViewData["lst7"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("2") && r1.Acc1 == false) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("7") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst77"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("2") && r1.Acc1 == false) || (r1.Stte1.Equals("7") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            //Accept Request/
            ViewData["lst8"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("4") && r1.Acc1 == true) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("7") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            ViewData["lst88"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("4") && r1.Acc1 == true) || (r1.Stte1.Equals("7") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();

            return View("myrequest10");
        }
コード例 #8
0
        public ActionResult update5(FormCollection form)
        {
            Config         cf   = dc.Configs.OrderByDescending(c => c.BuildDate).ToList().First();
            RequestModel22 rq22 = new RequestModel22();
            RequestModel   rq   = new RequestModel();
            Employee       e    = (Employee)Session["Employee"];
            Employee       e1   = (Employee)Session["eplo1"];//nb req
            Employee       e2   = dc.Employees.Where(ee => ee.EmployeeNumber == e1.RegistrationNumber).ToList().First();

            ViewData["lst7"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("2") && r1.Acc1 == false) || (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("7") && r1.Acc1 == false)).OrderByDescending(r => r.DDispatch1).ToList();
            string From        = cf.MailName;
            string To          = e1.Email;
            string cc          = e2.Email;
            string type        = cf.Type;
            int    post        = Convert.ToInt32(cf.Ports);
            string mailnetword = cf.MailNetwork;
            string pass        = cf.Password;
            string Subject     = "Approved (Request Rject) " + form["rname"].ToString();
            string Message     = "<span><b>From:</b> " + e.FullName + "</span><br/>" + "<b>Date Dispatch:</b> " + form["dd"].ToString() + "<br/>" + "<b>Content:</b> " + form["rc"].ToString() + "<br/>" + "<b>Description:</b> " + form["dt"].ToString();

            if (form["st5"].Equals("7"))
            {
                if (rq.Send1(From, To, cc, Subject, Message, type, post, mailnetword, pass))
                {
                    StationeryModel           stmd   = new StationeryModel();
                    List <Stationery>         stnr   = dc.Stationeries.ToList();
                    List <Request_Stationery> listrq = dc.Request_Stationeries.Where(l => l.RequestId == Convert.ToInt32(form["requestid"])).ToList();
                    //
                    foreach (Stationery s in stnr)
                    {
                        foreach (Request_Stationery v in listrq)
                        {
                            if (s.ProductId == v.ProductId)
                            {
                                stmd.EditST_RQ(v.ProductId, Convert.ToInt32(s.Quantity + v.Quantity));
                            }
                        }
                    }
                    //
                    rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
                    Session["email"]  = 1;
                    Session["email1"] = 1;
                }
                else
                {
                    Session["email"] = 2;
                }
            }
            else
            {
                if (rq.Send(From, To, Subject, Message, type, post, mailnetword, pass))
                {
                    //
                    StationeryModel           stmd   = new StationeryModel();
                    List <Stationery>         stnr   = dc.Stationeries.ToList();
                    List <Request_Stationery> listrq = dc.Request_Stationeries.Where(l => l.RequestId == Convert.ToInt32(form["requestid"])).ToList();
                    //
                    foreach (Stationery s in stnr)
                    {
                        foreach (Request_Stationery v in listrq)
                        {
                            if (s.ProductId == v.ProductId)
                            {
                                stmd.EditST_RQ(v.ProductId, Convert.ToInt32(s.Quantity + v.Quantity));
                            }
                        }
                    }
                    //
                    rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
                    Session["email1"] = 1;
                    Session["email"]  = 1;
                }
                else
                {
                    Session["email"] = 2;
                }
            }
            return(RedirectToAction("MyRequest10"));
        }
コード例 #9
0
        public ActionResult update4(FormCollection form)
        {
            Request_StationeryModel rm1 = new Request_StationeryModel();

            List <Stationery> lstr = dc.Stationeries.ToList();
            Config            cf   = dc.Configs.OrderByDescending(c => c.BuildDate).ToList().First();
            RequestModel      rq   = new RequestModel();
            StationeryModel   stmd = new StationeryModel();
            Employee          e    = (Employee)Session["Employee"];
            Employee          e1   = (Employee)Session["eplo"];
            Employee          e2   = dc.Employees.Where(ee => ee.EmployeeNumber == e1.RegistrationNumber).ToList().First();
            RequestModel22    rq22 = new RequestModel22();

            // Employee e1 = dc.Employees.Where(ee => ee.EmployeeNumber == e.RegistrationNumber).ToList().First();
            ViewData["lst5"] = rq22.Listrq2().Where(r1 => (e.EmployeeNumber.Equals(r1.RNumber1) && r1.Stte1.Equals("1") && r1.Acc1 == true) || (r1.Stte1.Equals("5") && r1.Acc1 == true)).OrderByDescending(r => r.DDispatch1).ToList();
            //
            string From        = cf.MailName;
            string To          = e1.Email;
            string cc          = e2.Email;
            string type        = cf.Type;
            int    post        = Convert.ToInt32(cf.Ports);
            string mailnetword = cf.MailNetwork;
            string pass        = cf.Password;
            string Subject     = "Approved Request " + form["rname"].ToString();
            string Message     = "<span><b>From:</b> " + e.FullName + "</span><br/>" + "<b>Date Dispatch:</b> " + form["dd"].ToString() + "<br/>" + "<b>Content:</b> " + form["rc"].ToString() + "<br/>" + "<b>Description:</b> " + form["dt"].ToString();
            //mail
            List <Request_Stationery> rqs = dc.Request_Stationeries.Where(s => s.RequestId == Convert.ToInt32(form["requestid"])).ToList();
            string str = " ";

            Session["result"] = true;
            //test
            foreach (Stationery st in lstr)
            {
                foreach (Request_Stationery rs in rqs)
                {
                    if (st.ProductId == rs.ProductId && rs.Quantity > st.Quantity)
                    {
                        Session["result"] = false;
                        break;
                    }
                }
            }
            //
            //print item
            if (Convert.ToBoolean(Session["result"]) == false)
            {
                foreach (Stationery st in lstr)
                {
                    foreach (Request_Stationery rs in rqs)
                    {
                        if (st.ProductId == rs.ProductId && rs.Quantity > st.Quantity)
                        {
                            str = str + st.ProductName.ToString() + "&nbsp_&nbsp";
                        }
                    }
                }
            }
            else if (Convert.ToBoolean(Session["result"]) == true)
            {
                if (form["st3"].Equals("5"))
                {
                    if (rq.Send1(From, To, cc, Subject, Message, type, post, mailnetword, pass))
                    {
                        //////
                        List <Stationery>         stnr   = dc.Stationeries.ToList();
                        List <Request_Stationery> listrq = dc.Request_Stationeries.Where(l => l.RequestId == Convert.ToInt32(form["requestid"])).ToList();
                        //
                        foreach (Stationery s in stnr)
                        {
                            foreach (Request_Stationery v in listrq)
                            {
                                if (s.ProductId == v.ProductId)
                                {
                                    stmd.EditST_RQ(v.ProductId, Convert.ToInt32(s.Quantity - v.Quantity));
                                }
                            }
                        }



                        //
                        rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));

                        Session["email"] = 1;
                    }
                    else
                    {
                        Session["email"] = 2;
                    }
                    //
                }
                else
                {
                    if (rq.Send(From, To, Subject, Message, type, post, mailnetword, pass))
                    {
                        List <Stationery>         stnr   = dc.Stationeries.ToList();
                        List <Request_Stationery> listrq = dc.Request_Stationeries.Where(l => l.RequestId == Convert.ToInt32(form["requestid"])).ToList();
                        //
                        foreach (Stationery s in stnr)
                        {
                            foreach (Request_Stationery v in listrq)
                            {
                                if (s.ProductId == v.ProductId)
                                {
                                    stmd.EditST_RQ(v.ProductId, Convert.ToInt32(s.Quantity - v.Quantity));
                                }
                            }
                        }


                        rq.update(Convert.ToInt32(form["requestid"]), form["rname"].ToString(), form["st"].ToString(), Convert.ToDateTime(form["dd"]), DateTime.Now, Convert.ToBoolean(form["acc"]), form["rc"].ToString(), form["en"].ToString(), form["dt"].ToString(), Convert.ToInt32(form["ctid"]));
                        Session["email"] = 1;
                    }
                    else
                    {
                        Session["email"] = 2;
                    }
                }
            }
            //mail
            Session["qty"] = str;
            //

            return(RedirectToAction("MyRequest10"));
        }