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