public object GetDropdownListByRoleName(string roleName) { try { string query = null; TextCaseConversion convert = new TextCaseConversion(); if ((roleName == "Admin") || (roleName == "System Admin") || (roleName == "Super Admin")) { query = "Select Name as Label, Id as Value from " + mainDbUser.DbUser + "role"; } else { query = "Select Name as Label, Id as Value from " + mainDbUser.DbUser + "role where Name in ('Branch Teller','Branch KYC Maker','Branch KYC Checker')"; } using (var connection = this.GetConnection()) { var list = connection.Query <DropdownListModel>(query); this.CloseConnection(connection); return(list); } } catch (Exception) { throw; } }
public object GetGlobalSearchResult(string option, string criteria, string filter) { try { using (var connection = this.GetConnection()) { TextCaseConversion convert = new TextCaseConversion(); string query; switch (option) { case "Transaction": if (criteria == "Mphone") { query = "Select Trans_no, Trans_date, Trans_From, trans_To,ROUND(pay_amt,3) as pay_amount from " + dbUser + "gl_trans_mst where Trans_From like '%" + filter + "%' or trans_To like '%" + filter + "%' order by trans_date desc "; } else { query = "Select Trans_no, Trans_date, Trans_From, trans_To,ROUND(pay_amt,3) as pay_amount from " + dbUser + "gl_trans_mst where Trans_no like '%" + filter + "%' order by trans_date desc "; } break; case "Message": query = "Select mphone,out_msg,out_time from " + dbUser + "outbox where " + convert.ToPascalCase(criteria) + " like '%" + filter + "%' and out_time is not null order by out_time desc"; break; case "RegInfo": query = "select mphone, Reg_date, ROUND(Balance_M,3) as Balance_M, Name, mphone as Details from " + dbUser + "regInfo where " + convert.ToPascalCase(criteria) + " like '%" + filter + "%' order by reg_date desc"; break; default: query = "select mphone, Reg_date, ROUND(Balance_M,3) as Balance_M, Name, mphone as Details from " + dbUser + "regInfo where " + convert.ToPascalCase(criteria) + " like '%" + filter + "%' and cat_Id='" + option + "' order by reg_date desc"; break; } var result = connection.Query(query); this.CloseConnection(connection); return(result); } } catch (Exception ex) { throw; } }