public ENT.Dashboard GetDashboardData(Guid userid, COM.MyEnumration.Userlevel userlevel) { try { objDashboard = new ENT.Dashboard(); objDashboard = objDalDashboard.GetDashboardData(userid, userlevel); return(objDashboard); } catch (Exception ex) { throw; } }
public List <ENT.UserProfile> GetList(string search, COM.MyEnumration.Userlevel userlevel) { try { parFields.Clear(); if (userlevel == COM.MyEnumration.Userlevel.APIUSER) { QueryDisctionery.SelectPart = "select U.up_id,U.CreatedDateTime,U.Status,u.up_address,u.up_email,u.up_mobile,u.up_username,u.up_userid,RO.Name as UserLevelName,ISNULL(S.slabname,'NA') AS slabname,A.TwoFactorEnabled"; QueryDisctionery.TablePart = @"from AspNetUsers as A inner join UserProfile as U on (A.id=U.up_userid) inner join AspNetUserRoles as R on(A.id=R.userid) inner join AspNetRoles as RO on(RO.Id=R.roleid) left join Slab as S on(U.slabid=S.slabid)"; if (!string.IsNullOrWhiteSpace(search)) { QueryDisctionery.ParameterPart = "where RO.Name = 'apiuser' AND U.up_username like '%" + search + "%' OR U.up_mobile like '%" + search + "%'"; } else { QueryDisctionery.ParameterPart = " where RO.Name = 'apiuser'"; } QueryDisctionery.OrderPart = "order by U.CreatedDateTime desc"; //Execute Query and get SQLDataReader } else if (userlevel == COM.MyEnumration.Userlevel.MD) { QueryDisctionery.SelectPart = "select U.up_id,U.CreatedDateTime,U.Status,u.up_address,u.up_email,u.up_mobile,u.up_username,u.up_userid,RO.Name as UserLevelName,ISNULL(S.slabname,'NA') AS slabname "; QueryDisctionery.TablePart = @"from AspNetUsers as A inner join UserProfile as U on (A.id=U.up_userid) inner join AspNetUserRoles as R on(A.id=R.userid) inner join AspNetRoles as RO on(RO.Id=R.roleid) left join Slab as S on(U.slabid=S.slabid)"; if (!string.IsNullOrWhiteSpace(search)) { QueryDisctionery.ParameterPart = "where RO.Name = 'masterdistributor' AND U.up_username like '%" + search + "%' OR U.up_mobile like '%" + search + "%'"; } else { QueryDisctionery.ParameterPart = " where RO.Name = 'masterdistributor'"; } QueryDisctionery.OrderPart = "order by U.CreatedDateTime desc"; } using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.UserProfile>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(lstEntity); }
public ENT.Dashboard GetDashboardData(Guid userid, COM.MyEnumration.Userlevel userlevel) { ENT.Dashboard objDashBoardModels = new ENT.Dashboard(); SqlConnection sqlCon = new SqlConnection(); sqlCon = COM.MySqlConnection.GetConnection.GetDBConnection(); try { SqlCommand cmd = new SqlCommand("GET_DASHBOARD_COUNT", sqlCon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@userlevel", SqlDbType.Int).Value = userlevel; cmd.Parameters.Add("@userid", SqlDbType.UniqueIdentifier).Value = userid; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { objDashBoardModels.TotalCustomers = string.Format("{0:n0}", Convert.ToInt32(dr[0])); objDashBoardModels.TotalBalance = string.Format("{0:n0}", Convert.ToInt32(dr[1])); objDashBoardModels.TotalTodayRequests = string.Format("{0:n0}", Convert.ToInt32(dr[2])); objDashBoardModels.TotalSuccess = string.Format("{0:n0}", Convert.ToInt32(dr[3])); objDashBoardModels.TotalFailed = string.Format("{0:n0}", Convert.ToInt32(dr[4])); objDashBoardModels.DMTtotalSuccess = string.Format("{0:n0}", Convert.ToInt32(dr[5])); objDashBoardModels.DMTtotalFailed = string.Format("{0:n0}", Convert.ToInt32(dr[6])); objDashBoardModels.DMTinproccess = string.Format("{0:n0}", Convert.ToInt32(dr[7])); objDashBoardModels.WalletRequests = string.Format("{0:n0}", Convert.ToInt32(dr[8])); objDashBoardModels.LoginActivity = string.Format("{0:n0}", Convert.ToInt32(dr[9])); } } } catch (Exception ex) { throw; } finally { sqlCon.Close(); } return(objDashBoardModels); }
public List <ENT.UserProfile> GetAllUnderUserList(string search, Guid userid, COM.MyEnumration.Userlevel userlevel) { lstEntity = new List <ENT.UserProfile>(); lstEntity = clsDAL.GetUnderList(search, userid, userlevel); return(lstEntity); }
public List <ENT.LedgerReportApiView> GetListSearchListApi(int ddrange, DateTime fromdate, DateTime todate, int ddData, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { List <ENT.LedgerReportApiView> lstEntity = new List <ENT.LedgerReportApiView>(); try { parFields.Clear(); if (userlevel > 0) { QueryDisctionery.SelectPart = @"SELECT *,(U.up_username+'('+(CASE U.up_userlevel WHEN 2 THEN 'SD' WHEN 1 THEN 'MD' WHEN 3 THEN 'R' WHEN 0 THEN 'ADMIN' WHEN 4 THEN 'APIUSER' END)+')') AS UserName "; QueryDisctionery.TablePart = @"FROM VW_LEDGERREPORT AS LD INNER JOIN UserProfile AS U ON (LD.userid=U.up_userid)"; QueryDisctionery.ParameterPart = "WHERE LD.userid='" + userid + "' AND U.up_userlevel=" + (int)userlevel; if (ddrange == 0) { QueryDisctionery.ParameterPart += "AND (LD.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and LD.SystemDateTime < dateadd(d, datediff(d, 0, getdate())+1, 0)) "; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += "AND (LD.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } if (!String.IsNullOrEmpty(search)) { QueryDisctionery.ParameterPart += " AND LD.remakrs like '%" + search + "%'"; } QueryDisctionery.OrderPart += " ORDER BY LD.SystemDateTime DESC"; } using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.LedgerReportApiView>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(lstEntity); }
public List <ENT.LedgerReportApiView> GetAllSearchApi(int ddrange, DateTime fromdate, DateTime todate, int ddData, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { List <ENT.LedgerReportApiView> lstEntity = new List <ENT.LedgerReportApiView>(); lstEntity = clsDAL.GetListSearchListApi(ddrange, fromdate, todate, ddData, search, userlevel, userid); return(lstEntity); }
public List <ENT.RofferDetailReport> GetAll(int ddrange, DateTime fromdate, DateTime todate, int ddData, Guid ddUsername, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { try { parFields.Clear(); if (userlevel == 0) { QueryDisctionery.SelectPart += "select rd.rofferdetailid,ra.title,up.up_username,rd.callcount,rd.SystemDateTime,rd.url,rd.Status,(case when rd.apitype=1 then 'Roffer' when rd.apitype=2 then 'Simple' when rd.apitype=3 then 'Dth Plan' when rd.apitype=4 then 'Dth info' end) as apitypename"; QueryDisctionery.SelectPart += " from RofferDetails as rd inner join RofferAPI as ra on(rd.rofferid=ra.rofferid) inner join UserProfile as up on(rd.userid=up.up_userid)"; if (ddrange == 0) { QueryDisctionery.SelectPart += " AND rd.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and rd.SystemDateTime<dateadd(d, datediff(d, 0, getdate())+1, 0)"; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.SelectPart += " AND (rd.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } QueryDisctionery.OrderPart += "order by rd.SystemDateTime desc"; } else if (userlevel > 0) { QueryDisctionery.SelectPart += "select rd.rofferdetailid,ra.title,up.up_username,rd.callcount,rd.SystemDateTime,rd.url,rd.Status,(case when rd.apitype=1 then 'Roffer' when rd.apitype=2 then 'Simple' when rd.apitype=3 then 'Dth Plan' when rd.apitype=4 then 'Dth info' end) as apitypename"; QueryDisctionery.SelectPart += " from RofferDetails as rd inner join RofferAPI as ra on(rd.rofferid=ra.rofferid) inner join UserProfile as up on(rd.userid=up.up_userid)"; QueryDisctionery.SelectPart += " where rd.userid='" + userid + "'"; if (ddrange == 0) { QueryDisctionery.SelectPart += " AND rd.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and rd.SystemDateTime<dateadd(d, datediff(d, 0, getdate())+1, 0)"; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.SelectPart += " AND (rd.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } QueryDisctionery.OrderPart += "order by rd.SystemDateTime desc"; } using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.RofferDetailReport>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(lstEntity); }
public List <ENT.DMT_MoneyRemittance> GetBySearch(int ddrange, DateTime fromdate, DateTime todate, int ddData, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { try { parFields.Clear(); //Add Query in to string builder object QueryDisctionery.SelectPart = "select * "; QueryDisctionery.TablePart = @"from DMT_MoneyRemittance as MR"; if (userlevel == 0) { QueryDisctionery.ParameterPart = "Where 1 = 1"; if (ddrange == 0) { QueryDisctionery.ParameterPart += " AND (MR.CreatedDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and MR.CreatedDateTime < dateadd(d, datediff(d, 0, getdate())+1, 0)) "; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += " AND (MR.CreatedDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } } else { QueryDisctionery.ParameterPart = "Where MR.userid='" + userid + "'"; if (ddrange == 0) { QueryDisctionery.ParameterPart += " AND (MR.CreatedDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and MR.CreatedDateTime < dateadd(d, datediff(d, 0, getdate())+1, 0)) "; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += " AND (MR.CreatedDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } } //Execute Query and get SQLDataReader using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.DMT_MoneyRemittance>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(lstEntity); }
public List <ENT.WalletRequestApiView> GetAllSearchApi(int ddrange, DateTime fromdate, DateTime todate, int ddData, COM.MyEnumration.Userlevel userlevel, Guid userid) { List <ENT.WalletRequestApiView> lstEntity = new List <ENT.WalletRequestApiView>(); try { parFields.Clear(); QueryDisctionery.SelectPart += "SELECT w.wr_id,u.up_username as UserName,W.wr_status,(case W.wr_status when 0 then 'Pending' else 'Approved' end) as WalletStatus,w.wr_bankname,w.wr_accountno,w.wr_amount,(case w.wr_mode when 1 then 'NEFT' when 2 then 'IMPS' when 3 then 'CASH' else 'NONE' end) as Mode,w.wr_refrenceid,w.wr_remakrs,(CASE w.wr_userlevel WHEN 2 THEN 'SD' WHEN 1 THEN 'MD' WHEN 3 THEN 'R' WHEN 0 THEN 'ADMIN' WHEN 4 THEN 'APIUSER' END) AS UserLevel,w.SystemDateTime"; QueryDisctionery.TablePart += " FROM WalletRequest as w inner join UserProfile as u on(w.wr_userid=u.up_userid)"; QueryDisctionery.ParameterPart += " where w.wr_upperid='" + userid + "' AND w.wr_status = 0"; if (ddrange == 0) { QueryDisctionery.ParameterPart += " AND w.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and w.SystemDateTime<dateadd(d, datediff(d, 0, getdate())+1, 0)"; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += " AND (w.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } QueryDisctionery.OrderPart += " order by w.SystemDateTime desc"; using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.WalletRequestApiView>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(lstEntity); }
public List <ENT.FundReportApiView> GetListSearchListApi(int ddrange, DateTime fromdate, DateTime todate, int ddData, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { List <ENT.FundReportApiView> lstEntity = new List <ENT.FundReportApiView>(); try { parFields.Clear(); if (userlevel == 0) { QueryDisctionery.SelectPart += "SELECT F.fundid,(CASE z.up_userlevel WHEN 2 THEN 'SD' WHEN 1 THEN 'MD' WHEN 3 THEN 'R' WHEN 0 THEN 'ADMIN' WHEN 4 THEN 'APIUSER' END) AS UserLevel,z.up_username+'['+z.up_mobile+']' as 'UserName',U.up_username as 'Transby',F.credit,F.debit,F.tooldbal,F.toclosebal,F.fromoldbal,F.FromCLOSEBAL,F.SystemDateTime,F.reqvia,F.remarks"; QueryDisctionery.TablePart += " FROM UserProfile U,fundTransfer F ,UserProfile Z"; QueryDisctionery.ParameterPart += " WHERE F.FundFrom=U.up_userid and z.up_userid=F.FundTo AND U.up_userid IN(select URID from GETDOWNLINE('" + userid + "',1))"; QueryDisctionery.ParameterPart += " AND (Z.up_username LIKE (CASE WHEN '" + search + "' <> '' THEN '%'+ '" + search + "' + '%' ELSE Z.up_username END) OR Z.up_mobile LIKE (CASE WHEN '" + search + "' <> '' THEN '%'+ '" + search + "' + '%' ELSE Z.up_mobile END))"; // QueryDisctionery.SelectPart += " AND Z.up_userlevel = (CASE WHEN " + ddUserType + " <> -1 THEN " + ddUserType + " ELSE Z.up_userlevel END)"; if (ddrange == 0) { QueryDisctionery.ParameterPart += " AND F.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and F.SystemDateTime<dateadd(d, datediff(d, 0, getdate())+1, 0)"; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += " AND (F.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } QueryDisctionery.OrderPart += " ORDER BY F.SystemDateTime DESC"; } else if (userlevel > 0) { QueryDisctionery.SelectPart += "SELECT F.fundid,(SELECT TOP 1 Z.up_username FROM UserProfile z WHERE z.up_userid=F.FundFrom)AS 'Transby',(CASE U.up_userlevel WHEN 2 THEN 'SD' WHEN 1 THEN 'MD' WHEN 3 THEN 'R' WHEN 0 THEN 'ADMIN' WHEN 4 THEN 'APIUSER' END) AS UserLevel,U.up_username as UserName,F.credit,F.debit,F.tooldbal,F.toclosebal,0 as fromoldbal,0 as FromCLOSEBAL,F.SystemDateTime,F.reqvia,F.remarks"; QueryDisctionery.TablePart += " FROM UserProfile U,fundTransfer F"; QueryDisctionery.ParameterPart += " WHERE F.FundTo=U.up_userid "; QueryDisctionery.ParameterPart += " AND U.up_userid IN(select URID from GETDOWNLINE('" + userid + "',1))"; QueryDisctionery.ParameterPart += " AND (U.up_username LIKE (CASE WHEN '" + search + "' <> '' THEN '%'+ '" + search + "' + '%' ELSE U.up_username END) OR U.up_mobile LIKE (CASE WHEN '" + search + "' <> '' THEN '%'+ '" + search + "' + '%' ELSE U.up_mobile END))"; // QueryDisctionery.SelectPart += " AND U.up_userlevel = (CASE WHEN " + ddUserType + " <> -1 THEN " + ddUserType + " ELSE U.up_userlevel END)"; if (ddrange == 0) { QueryDisctionery.ParameterPart += " AND F.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and F.SystemDateTime<dateadd(d, datediff(d, 0, getdate())+1, 0)"; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += " AND (F.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } QueryDisctionery.OrderPart += " ORDER BY F.SystemDateTime DESC"; } using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.FundReportApiView>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(lstEntity); }
public List <ENT.RechargeReportApiView> GetAllSearchApi(int ddrange, DateTime fromdate, DateTime todate, int ddData, string search, COM.MyEnumration.Userlevel userlevel, Guid userid, int status, int operatorcode) { List <ENT.RechargeReportApiView> lstEntity = new List <ENT.RechargeReportApiView>(); try { parFields.Clear(); if (userlevel == 0) { QueryDisctionery.SelectPart += "SELECT r.rechargeid,r.userid,o.operatorname,r.SystemDateTime,r.operatorcode,r.numbertorecharge,r.amount,r.txid,r.status,r.countrycode,r.beforebalance,r.balance,r.reqvia,r.proccessdate,r.webusername,r.accountref,r.requestid,r.ipaddress,u.up_mobile,u.up_userlevel,u.up_username,r.commimd,r.commisd,r.commir,r.charge,(case when r.rechargemethod=0 then (select top 1 apititle from Apis where apiid=r.routeid) when r.rechargemethod=3 then (select top 1 smartmobile from SmartMobile where mobileid=r.routeid) else (select top 1 name from machine where machineid=r.routeid) end) as ApiTitle,(CASE WHEN R.reqtype = 0 THEN 'NORMAL' ELSE 'SPECIAL'END) AS reqtype"; QueryDisctionery.TablePart += " FROM Recharge as r inner join Operators as o on(r.operatorcode = o.operatorcode) inner join UserProfile as u on(r.userid = u.up_userid)"; QueryDisctionery.ParameterPart += " WHERE "; QueryDisctionery.ParameterPart += " (r.numbertorecharge LIKE(CASE WHEN '" + search + "' <> '' THEN '%' + '" + search + "' + '%' ELSE r.numbertorecharge END) OR U.up_username LIKE (CASE WHEN '" + search + "' <> '' THEN '%'+ '" + search + "' + '%' ELSE U.up_username END))"; QueryDisctionery.ParameterPart += " AND (R.STATUS = (CASE WHEN " + status + " <> '-1' THEN " + status + " ELSE R.STATUS END)) "; QueryDisctionery.ParameterPart += " AND (R.operatorcode = (CASE WHEN " + operatorcode + " <> '-1' THEN " + operatorcode + " ELSE R.operatorcode END)) "; if (ddrange == 0) { QueryDisctionery.ParameterPart += " AND (r.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and r.SystemDateTime < dateadd(d, datediff(d, 0, getdate())+1, 0)) "; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += " AND (r.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } QueryDisctionery.OrderPart += "order by r.SystemDateTime desc"; } else if (userlevel > 0) { QueryDisctionery.SelectPart += "SELECT r.rechargeid,r.userid,o.operatorname,r.SystemDateTime,r.operatorcode,r.numbertorecharge,r.amount,r.txid,r.countrycode,r.status,r.beforebalance,r.balance,r.reqvia,r.proccessdate,r.webusername,r.accountref,r.requestid,r.ipaddress,u.up_mobile,u.up_userlevel,u.up_username,r.commimd,r.commisd,r.commir,r.charge,(case when r.rechargemethod=0 then (select top 1 apititle from Apis where apiid=r.routeid) when r.rechargemethod=3 then (select top 1 smartmobile from SmartMobile where mobileid=r.routeid) else (select top 1 name from machine where machineid=r.routeid) end) as ApiTitle,(CASE WHEN R.reqtype = 0 THEN 'NORMAL' ELSE 'SPECIAL'END) AS reqtype"; QueryDisctionery.TablePart += " FROM Recharge as r inner join Operators as o on(r.operatorcode = o.operatorcode) inner join UserProfile as u on(r.userid = u.up_userid)"; QueryDisctionery.ParameterPart += " WHERE "; QueryDisctionery.ParameterPart += " r.userid='" + userid + "' AND u.up_userlevel=" + (int)userlevel + " "; QueryDisctionery.ParameterPart += " AND (r.numbertorecharge LIKE(CASE WHEN '" + search + "' <> '' THEN '%' + '" + search + "' + '%' ELSE r.numbertorecharge END)) "; QueryDisctionery.ParameterPart += " AND (R.STATUS = (CASE WHEN " + status + " <> '-1' THEN " + status + " ELSE R.STATUS END)) "; QueryDisctionery.ParameterPart += " AND (R.operatorcode = (CASE WHEN " + operatorcode + " <> '-1' THEN " + operatorcode + " ELSE R.operatorcode END)) "; if (ddrange == 0) { QueryDisctionery.ParameterPart += " AND (r.SystemDateTime >= dateadd(d,datediff(d, 0, getdate()), 0) and r.SystemDateTime < dateadd(d, datediff(d, 0, getdate())+1, 0)) "; } else { if (!(String.IsNullOrEmpty(fromdate.ToString()) && String.IsNullOrEmpty(todate.ToString()))) { QueryDisctionery.ParameterPart += " AND (r.SystemDateTime BETWEEN '" + Convert.ToDateTime(fromdate).ToString("yyyy-MM-dd") + " 00:00:01" + "' AND '" + Convert.ToDateTime(todate).ToString("yyyy-MM-dd") + " 23:59:59" + "')"; } } QueryDisctionery.OrderPart += "order by r.SystemDateTime desc"; } using (SqlDataReader dr = objDBHelper.ExecuteReaderQuery(QueryDisctionery, parFields, objEntity)) { lstEntity = COM.DBHelper.CopyDataReaderToEntity <ENT.RechargeReportApiView>(dr); objDBHelper.Disposed(); } } catch (Exception) { throw; } finally { parFields.Clear(); } return(lstEntity); }
public List <ENT.WalletRequestApiView> GetAllSearchApi(int ddrange, DateTime fromdate, DateTime todate, int ddData, COM.MyEnumration.Userlevel userlevel, Guid userid) { List <ENT.WalletRequestApiView> lstEntity = new List <ENT.WalletRequestApiView>(); lstEntity = clsDAL.GetAllSearchApi(ddrange, fromdate, todate, ddData, userlevel, userid); return(lstEntity); }
public List <ENT.RofferDetailReport> GetAllSearch(int ddrange, DateTime fromdate, DateTime todate, int ddData, Guid ddUsername, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { lstEntity = new List <ENT.RofferDetailReport>(); lstEntity = clsDAL.GetAll(ddrange, fromdate, todate, ddData, ddUsername, search, userlevel, userid); return(lstEntity); }
public List <ENT.DMT_MoneyRemittance> GetBySearch(int ddrange, DateTime fromdate, DateTime todate, int ddData, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { lstEntity = new List <ENT.DMT_MoneyRemittance>(); lstEntity = clsDAL.GetBySearch(ddrange, fromdate, todate, ddData, search, userlevel, userid); return(lstEntity); }
public List <ENT.RechargeReportApiView> GetAllSearchApi(int ddrange, DateTime fromdate, DateTime todate, int ddData, string search, COM.MyEnumration.Userlevel userlevel, Guid userid, int status, int operatorcode) { List <ENT.RechargeReportApiView> lstEntity = new List <ENT.RechargeReportApiView>(); lstEntity = clsDAL.GetAllSearchApi(ddrange, fromdate, todate, ddData, search, userlevel, userid, status, operatorcode); return(lstEntity); }
public List <ENT.FundReport> GetAllSearch(int ddrange, DateTime fromdate, DateTime todate, int ddData, int ddUserType, string search, COM.MyEnumration.Userlevel userlevel, Guid userid) { lstEntity = new List <ENT.FundReport>(); lstEntity = clsDAL.GetListSearchList(ddrange, fromdate, todate, ddData, ddUserType, search, userlevel, userid); return(lstEntity); }