public ProjectViewModelBuilder GetViewModelIndex()
        {
            var viewModelBuilder = new ProjectViewModelBuilder
            {
                Countries     = new SelectList(this._contextSub.V3_GetCountryDDL(), "Id", "NameNice"),
                Client        = new SelectList(this._contextSub.V3_GetProjectClientDDL(), "Id", "Name"),
                Suppervisor   = new SelectList(this._contextSub.V3_GetWorkerDDL(), "vWorkerID", "Suppervisor"),
                StatusProject = new SelectList(this.GetLookUp("projectstatus"), "LookUpValue", "LookUpValue"),
                Projects      = new SelectList(this._contextSub.V3_GetProjectDDL(), "Id", "vProjectID")
            };

            return(viewModelBuilder);
        }
        public ProjectViewModelBuilder GetViewModelItemBuilder(int?id)
        {
            var project = new WAMS_PROJECT();

            if (id.HasValue)
            {
                project = _contextSub.WAMS_PROJECT.FirstOrDefault(m => m.Id == id);
            }

            var projectViewModelBuilder = new ProjectViewModelBuilder
            {
                Project       = project,
                Countries     = new SelectList(this._contextSub.V3_GetCountryDDL(), "Id", "NameNice"),
                Client        = new SelectList(this._contextSub.V3_GetProjectClientDDL(), "Id", "Name"),
                Suppervisor   = new SelectList(this._contextSub.V3_GetWorkerDDL(), "vWorkerID", "Suppervisor"),
                StatusProject = new SelectList(this.GetLookUp("projectstatus"), "LookUpValue", "LookUpValue")
            };

            return(projectViewModelBuilder);
        }
        public ProjectViewModelBuilder GetViewModelBuilder(int page, int size, string projectId, int country, string status, int client, string fd, string td)
        {
            var output = new ObjectParameter("ItemCount", typeof(int));
            var data   = this._contextSub.V3_Project_GetList(page, size, projectId, country, status, client, fd, td, output).ToList();

            var totalRecord = output.Value;
            var totalTemp   = Convert.ToDecimal(totalRecord) / Convert.ToDecimal(size);
            var totalPages  = Convert.ToInt32(Math.Ceiling(totalTemp));

            var viewModel = new ProjectViewModelBuilder
            {
                ProjectGetListResults = data,
                TotalRecords          = Convert.ToInt32(totalRecord),
                TotalPages            = totalPages,
                CurrentPage           = page,
                PageSize = size
            };

            return(viewModel);
        }