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);
}
