public ActionResult DeleteWorker(int id)
        {
            if (Session["Admin"] != null)
            {
                worker_Portfolio          worker = ctx.worker_Portfolio.First(x => x.Id.Equals(id));
                List <Availability_Slots> li     = worker.Availability_Slots.ToList();

                foreach (Availability_Slots slot in li)
                {
                    ctx.Availability_Slots.Remove(slot);
                }


                ctx.worker_Portfolio.Remove(worker);
                try
                {
                    ctx.SaveChanges();
                }
                catch (Exception e)
                {
                    String abc = e.ToString();
                }
                return(RedirectToAction("viewWorker"));
            }
            else
            {
                return(RedirectToAction("Index"));
            }
        }
        public ActionResult EditWorker(int id)
        {
            if (Session["Admin"] != null)
            {
                worker_Portfolio worker = ctx.worker_Portfolio.First(x => x.Id.Equals(id));

                return(View(worker));
            }
            else
            {
                return(RedirectToAction("/Index"));
            }
        }
 public ActionResult EditWorkerinDb(worker_Portfolio worker)
 {
     if (Session["Admin"] != null)
     {
         worker_Portfolio w = ctx.worker_Portfolio.FirstOrDefault(x => x.Id == worker.Id);
         w.name        = worker.name;
         w.cnic        = worker.cnic;
         w.contact1    = worker.contact1;
         w.contact2    = worker.contact2;
         w.address     = worker.address;
         w.experience_ = worker.experience_;
         //ctx.Entry(worker) = System.Data.Entity.EntityState.Modified;
         ctx.SaveChanges();
         return(RedirectToAction("viewWorker"));
     }
     else
     {
         return(RedirectToAction("Index"));
     }
 }
 public ActionResult addworker(worker_Portfolio worker)
 {
     if (Session["Admin"] != null)
     {
         if (ctx.worker_Portfolio.Any(x => x.cnic == worker.cnic))
         {
             ViewBag.message = "CNIC number already exist";
             ViewBag.s       = "failed";
             return(View());
         }
         else
         {
             ctx.worker_Portfolio.Add(worker);
             ctx.SaveChanges();
             ViewBag.message2 = "You are Successfully Registered";
             ViewBag.s        = "Success";
             return(View());
         }
     }
     else
     {
         return(RedirectToAction("/Index"));
     }
 }
        public void saveworker(worker_Portfolio a)
        {
            ctx.worker_Portfolio.Add(a);
            try
            {
                ctx.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }


            Availability_Slots slot = new Availability_Slots();

            slot.Availability_Slots1 = "10am - 11am";
            slot.wid         = a.Id;
            slot.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot);
            Availability_Slots slot1 = new Availability_Slots();

            slot1.Availability_Slots1 = "11am - 12pm";
            slot1.wid         = a.Id;
            slot1.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot1);

            Availability_Slots slot2 = new Availability_Slots();

            slot2.Availability_Slots1 = "12pm-1pm";
            slot2.wid         = a.Id;
            slot2.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot2);

            Availability_Slots slot3 = new Availability_Slots();

            slot3.Availability_Slots1 = "1pm-2pm";
            slot3.wid         = a.Id;
            slot3.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot3);

            Availability_Slots slot4 = new Availability_Slots();

            slot4.Availability_Slots1 = "2pm-3pm";
            slot4.wid         = a.Id;
            slot4.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot4);

            Availability_Slots slot5 = new Availability_Slots();

            slot5.Availability_Slots1 = "3pm-4pm";
            slot5.wid         = a.Id;
            slot5.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot5);

            Availability_Slots slot6 = new Availability_Slots();

            slot6.Availability_Slots1 = "4pm-5pm";
            slot6.wid         = a.Id;
            slot6.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot6);

            Availability_Slots slot7 = new Availability_Slots();

            slot7.Availability_Slots1 = "5pm-6pm";
            slot7.wid         = a.Id;
            slot7.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot7);

            Availability_Slots slot8 = new Availability_Slots();

            slot8.Availability_Slots1 = "6pm-7pm";
            slot8.wid         = a.Id;
            slot8.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot8);

            Availability_Slots slot9 = new Availability_Slots();

            slot9.Availability_Slots1 = "7pm-8pm";
            slot9.wid         = a.Id;
            slot9.IsAvailable = 0;
            ctx.Availability_Slots.Add(slot9);


            try
            {
                ctx.SaveChanges();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }



            for (int i = 0; i < Request.Files.Count; i++)
            {
                try
                {
                    HttpPostedFileBase file = Request.Files[i];
                    file.SaveAs(Server.MapPath(@"~\worker_" + a.Id + ".jpeg"));
                }
                catch (Exception ex)
                {
                }
                break;
            }
            Response.Redirect("/Admin/Main");
        }