public List <KYCCommon> GetAgentList(KycFilterCommon model)
{
var KycDetails = new List <KYCCommon>();
string sql = "sproc_kyc_manage @flag ='list' ";
sql += string.IsNullOrEmpty(model.KycStatus)? "" : ", @kyc_status =" + DAO.FilterString(model.KycStatus);
sql += string.IsNullOrEmpty(model.Email)? "" : ", @email_address =" + DAO.FilterString(model.Email);
sql += string.IsNullOrEmpty(model.MobileNumber)? "" : ", @mobile_no =" + DAO.FilterString(model.MobileNumber);
sql += string.IsNullOrEmpty(model.FromDate)? "" : ", @from_date =" + DAO.FilterString(model.FromDate);
sql += string.IsNullOrEmpty(model.ToDate)? "" : ", @to_date =" + DAO.FilterString(model.ToDate);
var dbres = DAO.ExecuteDataTable(sql);
if (dbres != null)
{
foreach (DataRow dr in dbres.Rows)
{
KYCCommon KycDetail = new KYCCommon();
KycDetail.AgentId = dr["AgentId"].ToString();
KycDetail.MobileNo = dr["Mobile"].ToString();
KycDetail.EmailAddress = dr["Email"].ToString();
KycDetail.SubmittedDate = DateTime.Parse(dr["SubmittedDate"].ToString()).ToLongDateString();
KycDetail.KycStatus = dr["KYCStatus"].ToString();
KycDetails.Add(KycDetail);
}
}
return(KycDetails);
}
public ActionResult Index(KycFilterModel model)
{
model.KycStatusList = ApplicationUtilities.SetDDLValue(LoadDropdownList("kycstatus") as Dictionary <string, string>, model.KycStatus, "--Status--");
KycFilterCommon filterCommon = new KycFilterCommon();
filterCommon = model.MapObject <KycFilterCommon>();
List <KYCCommon> kycCommon = _kyc.GetAgentList(filterCommon);
if (kycCommon == null || kycCommon.Count == 0)
{
ViewBag.EmptyMessage = "True";
return(View(model));
}
List <KYCModel> kycModel = kycCommon.MapObjects <KYCModel>();
foreach (var item in kycModel)
{
#region kycStatus
if (item.KycStatus.ToUpper().Equals("PENDING"))
{
item.KycStatus = "<span class='badge badge-warning'>Pending</span>";
}
else if (item.KycStatus.ToUpper().Equals("APPROVED"))
{
item.KycStatus = "<span class='badge badge-success'>Approved</span>";
}
else if (item.KycStatus.ToUpper().Equals("REJECTED"))
{
item.KycStatus = "<span class='badge badge-danger'>Rejected</span>";
}
else
{
item.KycStatus = "<span class='badge badge-info'>Not Filled</span>";
}
#endregion
item.Action = StaticData.GetActions(ControllerName, item.AgentId.EncryptParameter(), this, "", "", "");
}
//Column Creator
IDictionary <string, string> param = new Dictionary <string, string>();
//param.Add("AgentId", "Agent Id");
param.Add("MobileNo", "Mobile No");
param.Add("EmailAddress", "Email");
param.Add("SubmittedDate", "Submitted Date");
param.Add("KycStatus", "Status");
param.Add("Action", "Action");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(kycModel, "hidebreadcrumb", "", 10, false, "", "", "", "KYC", "", "KYC");
ViewData["grid"] = grid;
ViewBag.EmptyMessage = "False";
return(View(model));
//return View(kycModel);
}
public List <KYCCommon> GetAgentList(KycFilterCommon model)
{
return(_repo.GetAgentList(model));
}
