public List <InterviewPanelModel> GetInterviewPanelSearch(string Technology, string Level, string DeptId, string Designation, string BusinessVertical, string Skill) { List <InterviewPanelModel> objIPList = new List <InterviewPanelModel>(); InterviewPanelModel objIP; using (var result = new RMS_Entities()) { var GetIPList = result.USP_IP_GetInterviewPanelSearch(Convert.ToInt32(Technology), Convert.ToInt32(Level), Convert.ToInt32(DeptId), Convert.ToInt32(Designation), Convert.ToInt32(BusinessVertical) , Skill).ToList <USP_IP_GetInterviewPanelSearch_Result>(); foreach (var obj in GetIPList) { objIP = new InterviewPanelModel(); objIP.PanelId = obj.PANELID; objIP.PanelIdEncr = CommonRepository.Encode(obj.PANELID.ToString()); objIP.EmpId = Convert.ToInt32(obj.EMPID); objIP.EmpName = obj.EMPNAME; objIP.DesignationName = obj.DesignationName; objIP.LINEMANAGER = obj.LINEMANAGER; objIP.BusinessVertical = obj.BUSINESSVERTICAL; objIP.EmpSecondarySkill = obj.SECONDARYSKILL; objIP.PrimarySkillName = obj.PRIMARYSKILLNAME; objIP.CandidateDeptId = Convert.ToInt32(obj.CANDIDATEDEPTID); objIP.DEPTName = obj.DEPTNAME; objIP.CandidateDesignations = obj.CANDIDATEDESIGNATIONS; objIP.CandidateDesignationName = obj.CANDIDATEDESIGNATIONNAME; objIP.SecondarySkills = obj.SECONDARYSKILLS; objIP.SecondarySkillname = obj.SECONDARYSKILLNAME; objIP.LevelIds = obj.LEVELIDS; objIP.levelidName = obj.LEVELIDNAME; objIP.Inducted = Convert.ToInt32(obj.INDUCTED); objIP.InductedName = obj.INDUCTEDNAME; objIP.TrainingAttended = Convert.ToInt32(obj.TRAININGATTENDED); objIP.TrainingAttendedName = obj.TRAININGATTENDEDNAME; objIP.PageMode = "S"; objIPList.Add(objIP); } } return(objIPList); }
//public List<InterviewPanelModel> GetInterviewPanel(InterviewPanelModel objIP) public List <InterviewPanelModel> GetInterviewPanel(int PanelId, int Empid) { List <InterviewPanelModel> objIPList = new List <InterviewPanelModel>(); InterviewPanelModel objIP; using (var result = new RMS_Entities()) { var GetIPList = result.USP_IP_GetInterviewPanel(Convert.ToInt32(PanelId), Convert.ToInt32(Empid)).ToList <USP_IP_GetInterviewPanel_Result>(); foreach (var obj in GetIPList) { objIP = new InterviewPanelModel(); objIP.PanelId = obj.panelid; objIP.PanelIdEncr = CommonRepository.Encode(obj.panelid.ToString()); objIP.EmpId = Convert.ToInt32(obj.empid); objIP.EmpIdEncr = CommonRepository.Encode(obj.empid.ToString()); objIP.EmpName = obj.EmpName; objIP.DesignationName = obj.DesignationName; objIP.LINEMANAGER = obj.LINEMANAGER; objIP.PrimarySkillName = obj.PrimarySkillName; objIP.CandidateDeptId = Convert.ToInt32(obj.CandidateDeptId); //objIP.DEPTName = obj.DEPTName; objIP.CandidateDesignations = obj.CandidateDesignations; objIP.CandidateDesignationName = obj.CandidateDesignationName; objIP.SecondarySkills = obj.SecondarySkills; objIP.SecondarySkillname = obj.SecondarySkillname; objIP.LevelIds = obj.levelids; objIP.levelidName = obj.levelidName; objIP.Inducted = Convert.ToInt32(obj.Inducted); objIP.InductedName = obj.InductedName; objIP.TrainingAttended = Convert.ToInt32(obj.TrainingAttended); objIP.TrainingAttendedName = obj.TrainingAttendedName; objIP.EmpSecondarySkill = obj.SecondarySkill; objIP.BusinessVertical = obj.BusinessVertical; objIP.PageMode = "V"; objIPList.Add(objIP); } } return(objIPList); }