Пример #1
0
        public ActionResult Create()
        {
            if (Session["UserId"] != null)
            {
                var model = new Opptys();

                return(View(model));
            }
            else
            {
                return(RedirectToAction("Login", "Account"));
            }
        }
Пример #2
0
 public ActionResult DeleteConfirmed(int id)
 {
     if (Session["UserId"] != null)
     {
         Opptys oppt = db.Opptys1.Find(id);
         db.Opptys1.Remove(oppt);
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     else
     {
         return(RedirectToAction("Login", "Account"));
     }
 }
Пример #3
0
 public ActionResult Edit([Bind(Include = "Id,Customer,Principal,Engineer,Status,Updated,Phone_Number,Email,Program,Application,Part_Number,EAU,Price,Units_Per_Board,Decision_Date,Production_Date,CM,CM_Location,Distributor,Disty_Email,Disty_Phone_Number,Factory_Email,Factory_Phone_Number")] Opptys oppt)
 {
     if (Session["UserId"] != null)
     {
         if (ModelState.IsValid)
         {
             db.Entry(oppt).State = EntityState.Modified;
             db.SaveChanges();
             return(RedirectToAction("Index"));
         }
         return(View(oppt));
     }
     else
     {
         return(RedirectToAction("Login", "Account"));
     }
 }
Пример #4
0
 // GET: Todoes/Delete/5
 public ActionResult Delete(int?id)
 {
     if (Session["UserId"] != null)
     {
         if (id == null)
         {
             return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
         }
         Opptys oppt = db.Opptys1.Find(id);
         if (oppt == null)
         {
             return(HttpNotFound());
         }
         return(View(oppt));
     }
     else
     {
         return(RedirectToAction("Login", "Account"));
     }
 }
Пример #5
0
        // GET: Opptys
        public ActionResult Index(string Groupddl, string Statusddl, string Prinddl, string OSRddl, string Customerddl, string osrsel, string prinsel, string statussel, string groupsel, string customersel,
                                  string statusdrop, string groupnew, string sortOrder, string customerName, string stratvar, string fltstring, Opptys selg)
        {
            if (Session["UserId"] != null)
            {
                //return View(db.Opptys1.ToList());

                Opptys strat = new Opptys();

                int       id            = Int32.Parse(Session["UserId"].ToString()); // Get the user id from the session
                String    em            = db.UserAccounts.Find(id).Email.ToString(); // Use the id to get the associated email address
                EmailList emailListItem = db.EmailLists.First(x => x.Email == em);   // Use the email address to get the associated emaillist object which holds the group

                string perm = emailListItem.Perm;

                if (perm == null)
                {
                    perm = "0";
                }
                ViewData["perm"] = perm;


                // if external
                if (!emailListItem.IntExt)
                {
                    // Create a list to hold the Todos which we will end up showing
                    List <Opptys> list = new List <Opptys>();

                    // this is a foreach loop, it goes through all the Todos returned from db.Todoes.ToList()
                    foreach (Opptys s in db.Opptys1.ToList())
                    {
                        // makes sure that the group of a todo isn't null (empty)
                        if (!String.IsNullOrEmpty(s.Principal))
                        {
                            // checks if the group of the user is equal to the group of the post. if so it adds the todo to the list.
                            if (emailListItem.Group.Equals(s.Principal))
                            {
                                list.Add(s);
                            }
                        }
                    }


                    //ViewBag.CustomerSort = sortOrder == "Name" ? "Name_desc" : "Name";

                    //var model = from t in list
                    //            select t;


                    //switch (sortOrder)
                    //{
                    //    case "Name_desc":
                    //        model = model.OrderByDescending(t => t.Customer);
                    //        break;
                    //    case "Name":
                    //        model = model.OrderBy(t => t.Customer);
                    //        break;
                    //}



                    string        p  = emailListItem.Perm;
                    string        gr = emailListItem.Group;
                    StringBuilder sb = new StringBuilder();
                    sb.Append("SELECT * FROM dbo.Opptys1 WHERE "); //change table name for whatever you need returned
                    foreach (char c in p.ToCharArray())
                    {
                        if (Groupddl == null)
                        {
                            sb.Append("Perm LIKE '%");
                            sb.Append(c);
                            sb.Append("%' OR ");
                        }
                    }
                    sb.Length = sb.Length - 4;


                    if (selg == null)
                    {
                        List <Opptys> list1 = db.Opptys1.SqlQuery(sb.ToString()).ToList(); //change table name
                        return(View(list1));
                    }

                    //else
                    //{
                    //var groups = from g in list
                    //             select g;
                    //var prins = from pr in list
                    //            select pr;
                    ///*  var osrs = from o in db.Strategies
                    //             select o;
                    //  var statuss = from s in db.Strategies
                    //                select s; */



                    //List<SelectListItem> groupListItems = list.Select(w => w.Group).Where(g => g != null).Distinct().Select(g => new SelectListItem { Value = g, Text = g }).ToList();
                    //ViewBag.Groupddl = new SelectList(groupListItems, "Value", "Text").Distinct();

                    //List<SelectListItem> prinListItems = list.Select(w => w.Principal).Where(pr => pr != null).Distinct().Select(pr => new SelectListItem { Value = pr, Text = pr }).ToList();
                    //ViewBag.Prinddl = new SelectList(prinListItems, "Value", "Text").Distinct();

                    //List<SelectListItem> osrListItems = list.Select(w => w.OSR).Where(o => o != null).Distinct().Select(o => new SelectListItem { Value = o, Text = o }).ToList();
                    //ViewBag.OSRddl = new SelectList(osrListItems, "Value", "Text").Distinct();

                    //List<SelectListItem> statusListItems = list.Select(w => w.Status).Where(g => g != null).Distinct().Select(g => new SelectListItem { Value = g, Text = g }).ToList();
                    //ViewBag.Statusddl = new SelectList(statusListItems, "Value", "Text").Distinct();

                    //List<SelectListItem> customerListItems = list.Select(w => w.Customer).Where(c => c != null).Distinct().Select(c => new SelectListItem { Value = c, Text = c }).ToList();
                    //ViewBag.Customerddl = new SelectList(customerListItems, "Value", "Text").Distinct();


                    ////if all filters are null
                    //if (Groupddl == null && stratvar == null && Prinddl == null && OSRddl == null && Statusddl == null && Customerddl == null)
                    //{
                    //    if (sortOrder == null)
                    //    {
                    //        return View(model.ToList());
                    //    }
                    //    else
                    //    {
                    //        return View(model.ToList());
                    //    }
                    //}


                    ////if (prin != null && group != null && osr != null && status != null)
                    //if (Prinddl != null && Groupddl != null && OSRddl != null && Statusddl != null && Customerddl != null)
                    //{
                    //    prins = prins.Where(gpr => gpr.Principal.Contains(Prinddl) && gpr.Group.Contains(Groupddl) && gpr.OSR.Contains(OSRddl) && gpr.Status.Contains(Statusddl) && gpr.Customer.Contains(Customerddl));
                    //    Session["filtprins"] = Prinddl;
                    //    Session["filtgroup"] = Groupddl;
                    //    Session["filtstatus"] = Statusddl;
                    //    Session["filtosr"] = OSRddl;
                    //    Session["filtcustomer"] = Customerddl;

                    //    stratvar = null;

                    //    return View(prins.ToList());
                    //}


                    //return View(model);
                    //}

                    return(View(list));
                }
                else
                {
                    // This is the query building code.
                    string        p  = emailListItem.Perm;
                    string        gr = emailListItem.Group;
                    StringBuilder sb = new StringBuilder();
                    sb.Append("SELECT * FROM dbo.Opptys1 WHERE "); //change table name for whatever you need returned
                    foreach (char c in p.ToCharArray())
                    {
                        if (Groupddl == null)
                        {
                            sb.Append("Perm LIKE '%");
                            sb.Append(c);
                            sb.Append("%' OR ");
                        }
                    }
                    sb.Length = sb.Length - 4;


                    if (selg == null)
                    {
                        List <Opptys> list = db.Opptys1.SqlQuery(sb.ToString()).ToList(); //change table name
                        return(View(list));
                    }

                    else
                    {
                        //var groups = from g in db.Opptys1
                        //             select g;
                        //var prins = from pr in db.Opptys1
                        //            select pr;
                        ///*  var osrs = from o in db.Strategies
                        //             select o;
                        //  var statuss = from s in db.Strategies
                        //                select s; */

                        //List<SelectListItem> groupListItems = db.Strategies.Where(w => w.Group != null).Select(group => new SelectListItem { Value = group.Group, Text = group.Group }).Distinct().ToList();
                        //ViewBag.Groupddl = new SelectList(groupListItems, "Value", "Text").Distinct();

                        //List<SelectListItem> prinListItems = db.Strategies.Where(w => w.Principal != null).Select(prin => new SelectListItem { Value = prin.Principal, Text = prin.Principal }).Distinct().ToList();
                        //ViewBag.Prinddl = new SelectList(prinListItems, "Value", "Text").Distinct();

                        //List<SelectListItem> osrListItems = db.Strategies.Where(w => w.OSR != null).Select(osr => new SelectListItem { Value = osr.OSR, Text = osr.OSR }).Distinct().ToList();
                        //ViewBag.OSRddl = new SelectList(osrListItems, "Value", "Text").Distinct();

                        //List<SelectListItem> statusListItems = db.Strategies.Where(w => w.Status != null).Select(status => new SelectListItem { Value = status.Status, Text = status.Status }).Distinct().ToList();
                        //ViewBag.Statusddl = new SelectList(statusListItems, "Value", "Text").Distinct();

                        //List<SelectListItem> customerListItems = db.Strategies.Where(w => w.Customer != null).Select(cust => new SelectListItem { Value = cust.Customer, Text = cust.Customer }).Distinct().ToList();
                        //ViewBag.Customerddl = new SelectList(customerListItems, "Value", "Text").Distinct();


                        //// Convert sort order
                        //ViewBag.CustomerSort = sortOrder == "Name" ? "Name_desc" : "Name";



                        //var model = from t in db.Strategies
                        //            select t;



                        //switch (sortOrder)
                        //{
                        //    case "Name_desc":
                        //        model = model.OrderByDescending(t => t.Customer);
                        //        break;
                        //    case "Name":
                        //        model = model.OrderBy(t => t.Customer);
                        //        break;
                        //}
                        ////}
                        ////if all filters are null
                        //if (Groupddl == null && stratvar == null && Prinddl == null && OSRddl == null && Statusddl == null && Customerddl == null)
                        //{
                        //    if (sortOrder == null)
                        //    {
                        //        return View(db.Strategies.ToList());
                        //    }
                        //    else
                        //    {
                        //        return View(model.ToList());
                        //    }
                        //}


                        ////if (prin != null && group != null && osr != null && status != null)
                        //if (Prinddl != null && Groupddl != null && OSRddl != null && Statusddl != null && Customerddl != null)
                        //{
                        //    prins = prins.Where(gpr => gpr.Principal.Contains(Prinddl) && gpr.Group.Contains(Groupddl) && gpr.OSR.Contains(OSRddl) && gpr.Status.Contains(Statusddl) && gpr.Customer.Contains(Customerddl));
                        //    Session["filtprins"] = Prinddl;
                        //    Session["filtgroup"] = Groupddl;
                        //    Session["filtstatus"] = Statusddl;
                        //    Session["filtosr"] = OSRddl;
                        //    Session["filtcustomer"] = Customerddl;

                        //    stratvar = null;

                        //    return View(prins.ToList());
                        //}
                        //return View(prins.ToList());
                        return(View(db.Opptys1.ToList()));
                    }
                }
            }
            else
            {
                return(RedirectToAction("Login", "Account"));
            }
        }