public ActionResult MCQ_Report(MCQReportModel objMCQReportModel) { objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); MCQ_REPORT_DTO objMCQ_REPORT_DTO = new MCQ_REPORT_DTO(); objMCQ_REPORT_DTO.StartDate = Convert.ToDateTime(objMCQReportModel.From_Date); objMCQ_REPORT_DTO.EndDate = Convert.ToDateTime(objMCQReportModel.To_Date); objMCQ_REPORT_DTO.EmployeeId = objMCQReportModel.EmployeeId; objMCQ_REPORT_DTO.Name = objMCQReportModel.Name; objMCQ_REPORT_DTO.Designation = objMCQReportModel.Designation; objMCQ_REPORT_DTO.Department = objMCQReportModel.Department; objMCQ_REPORT_DTO.MCQ_Status = objMCQReportModel.MCQ_Status; List <MCQ_REPORT_DTO> objMCQ_REPORT_DTOList = new List <MCQ_REPORT_DTO>(); using (var objMCQSL = new MCQSL()) { objMCQ_REPORT_DTOList = objMCQSL.GetMCQReportList(objLoginUserDetails.CompanyDBConnectionString, objMCQ_REPORT_DTO).ToList(); } if (objMCQ_REPORT_DTOList.Count == 0) { ModelState.AddModelError("Error", Common.Common.getResource("usr_msg_54159")); } ExportReport(Convert.ToString(objMCQReportModel.From_Date), Convert.ToString(objMCQReportModel.To_Date), ToDataTable(objMCQ_REPORT_DTOList)); PopulateCombo(); return(View(objMCQReportModel)); }
private Hashtable AutoCompleteSearchParameters(MCQ_REPORT_DTO rlm) { Hashtable HT_SearchParam = new Hashtable(); HT_SearchParam.Add("Action", rlm.Action); HT_SearchParam.Add("EmployeeId", rlm.EmployeeId); HT_SearchParam.Add("Name", rlm.Name); HT_SearchParam.Add("Department", rlm.Department); HT_SearchParam.Add("Designation", rlm.Designation); return(HT_SearchParam); }
private MCQ_REPORT_DTO[] GeSearchResult(string Action, string term) { MCQ_REPORT_DTO[] matching = null; MCQ_REPORT_DTO mCQ_REPORTListModel = new MCQ_REPORT_DTO(); LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); mCQ_REPORTListModel.Action = Action; switch (Action) { case "SEARCH_BY_EMPLOYEEID": mCQ_REPORTListModel.EmployeeId = term; break; case "SEARCH_BY_NAME": mCQ_REPORTListModel.Name = term; break; case "SEARCH_BY_DEPARTMENT": mCQ_REPORTListModel.Department = term; break; case "SEARCH_BY_DESIGNATION": mCQ_REPORTListModel.Designation = term; break; default: Console.WriteLine("Default case"); break; } using (var objMCQSL = new MCQSL()) { matching = String.IsNullOrEmpty(term) ? objMCQSL.AutoCompleteListSL(objLoginUserDetails.CompanyDBConnectionString, AutoCompleteSearchParameters(mCQ_REPORTListModel)).ToArray() : objMCQSL.AutoCompleteListSL(objLoginUserDetails.CompanyDBConnectionString, AutoCompleteSearchParameters(mCQ_REPORTListModel)).ToArray(); } return(matching); }
public IEnumerable <MCQ_REPORT_DTO> GetMCQReportList(string i_sConnectionString, MCQ_REPORT_DTO i_objMCQ_REPORT_DTO) { IEnumerable <MCQ_REPORT_DTO> objMCQ_REPORT_DTO = null; try { using (var objMCQDAL = new InsiderTradingDAL.MCQDAL()) { objMCQ_REPORT_DTO = objMCQDAL.GetMCQReportList(i_sConnectionString, i_objMCQ_REPORT_DTO); } } catch (Exception exp) { throw exp; } return(objMCQ_REPORT_DTO); }