// GET: AuditPlanningMemorandums/Create
        public ActionResult Create()
        {
            AnnualPlanningServices activity = new AnnualPlanningServices();
            var activities = activity.GetAnnualPlanning().Where(p => p.Approval_Status == "Approve");

            IEnumerable <SelectListItem> activityid = activities
                                                      .Select(d => new SelectListItem
            {
                Value = d.AnnualPlanningID.ToString(),
                Text  = d.Activity.Name
            });


            string apmno = String.Empty;

            AuditPlanningMemorandum apm = db.AuditPlanningMemorandums.OrderByDescending(p => p.AuditPlanningMemorandumID).FirstOrDefault();

            if (apm != null)
            {
                int nomerapm = Convert.ToInt32(apm.NomerAPM.Split('/')[1]) + 1;
                apmno = Convert.ToString("APM/" + nomerapm);
            }
            else
            {
                apmno = Convert.ToString("APM/" + 1);
            }

            ViewBag.apmnomer = apmno;
            return(View());
        }
        // GET: Preliminaries/Create
        public ActionResult Create()
        {
            AnnualPlanningServices activity = new AnnualPlanningServices();
            var activities = activity.GetAnnualPlanning().Where(p => p.Approval_Status == "Approve");

            IEnumerable <SelectListItem> activityid = activities
                                                      .Select(d => new SelectListItem
            {
                Value = d.ActivityID.ToString(),
                Text  = d.Activity.Name
            });

            ViewBag.ActivityID = activityid;

            ActivityServices act = new ActivityServices();
            var acts             = act.GetActivity().Where(p => p.Status == "Approve");

            IEnumerable <SelectListItem> actid = acts
                                                 .Select(d => new SelectListItem
            {
                Value = d.ActivityID.ToString(),
                Text  = d.Name
            });

            ViewBag.UnActivityID = actid;


            string prelimNo = String.Empty;

            Preliminary prelims = db.Preliminaries.OrderByDescending(p => p.PreliminaryID).FirstOrDefault();

            if (prelims != null)
            {
                int nopre = Convert.ToInt32(prelims.NomorPreliminarySurvey.Split('/')[1]) + 1;
                prelimNo = Convert.ToString("Preliminary/" + nopre);
            }
            else
            {
                prelimNo = Convert.ToString("Preliminary/" + 1);
            }

            ViewBag.preliminaryno = prelimNo;

            return(View());
        }
        // GET: Preliminaries/Edit/5
        public ActionResult Edit(int?id)
        {
            //if (id == null)
            //{
            //    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            //}
            Preliminary preliminary = db.Preliminaries.Find(id);

            List <string>         newFilesName = new List <string>();
            List <string>         paths        = new List <string>();
            UrlHelper             url          = Url;
            HttpServerUtilityBase server       = Server;
            var pre      = preliminary.NomorPreliminarySurvey.Split('/')[0];
            var no       = preliminary.NomorPreliminarySurvey.Split('/')[1];
            var getFiles = filesTransact.getFiles(pre + no, out newFilesName, out paths, url, server);

            ViewBag.newFilesName = newFilesName;
            ViewBag.paths        = paths;

            if (preliminary.Type == "Planned")
            {
                AnnualPlanningServices activity = new AnnualPlanningServices();
                var activities = activity.GetAnnualPlanning().Where(p => p.ActivityID == preliminary.ActivityID);

                IEnumerable <SelectListItem> activityid = activities
                                                          .Select(d => new SelectListItem
                {
                    Value = d.ActivityID.ToString(),
                    Text  = d.Activity.Name
                });
                ViewBag.ActivityID = activityid;

                EngagementActivityServices Eng = new EngagementActivityServices();
                var Engs = Eng.GetEngagementActivity().Where(p => p.EngagementID == preliminary.EngagementID);

                IEnumerable <SelectListItem> EngID = Engs
                                                     .Select(d => new SelectListItem
                {
                    Value = d.EngagementID.ToString(),
                    Text  = d.Name
                });
                ViewBag.EngagementID = EngID;
            }
            else
            {
                int enggID = db.EngagementActivities.Find(preliminary.EngagementID).EngagementID;
                ViewBag.EnggaID = enggID;
                string EngName = db.EngagementActivities.Find(preliminary.EngagementID).Name;
                ViewBag.EngagementName = EngName;

                ActivityServices activity = new ActivityServices();
                var activities            = activity.GetActivity().Where(p => p.ActivityID == preliminary.ActivityID);

                IEnumerable <SelectListItem> activityid = activities
                                                          .Select(d => new SelectListItem
                {
                    Value = d.ActivityID.ToString(),
                    Text  = d.Name
                });
                ViewBag.UnActivityID = activityid;

                //ViewBag.UnActivityID = new SelectList(db.Activities, "ActivityID", "Name");
            }

            return(View(preliminary));
        }