public bool fnCheckAgent()
{
try
{
dsUserInfo = new DataSet();
SqlParameter spUserID = new SqlParameter();
spUserID.ParameterName = "@Result";
spUserID.SqlDbType = SqlDbType.VarChar;
spUserID.Size = 20;
spUserID.Direction = ParameterDirection.Output;
_objDataLayer = new clsDataLayer();
dsUserInfo = _objDataLayer.fnExecuteDataset("spCheckAgent", new SqlParameter("@EmailID", this.strEmailID),
new SqlParameter("@Password", this.strPassword), spUserID);
if (spUserID.Value.ToString() == "VALID USER")
{
if (dsUserInfo.Tables[0].Rows.Count > 0)
{
HttpContext.Current.Session["RechargeUserID"] = dsUserInfo.Tables[0].Rows[0]["UserID"].ToString();
HttpContext.Current.Session["RechargeUserType"] = dsUserInfo.Tables[0].Rows[0]["UserType"].ToString();
HttpContext.Current.Session["RechargeEmailID"] = dsUserInfo.Tables[0].Rows[0]["EmailID"].ToString();
//HttpContext.Current.Session["TravelTotalComm"] = dsUserInfo.Tables[1].Rows[0]["TotalComm"].ToString();
//HttpContext.Current.Session["TravelCancelComm"] = dsUserInfo.Tables[1].Rows[0]["CancelTtlComm"].ToString();
HttpContext.Current.Session["Status"] = dsUserInfo.Tables[0].Rows[0]["Status"].ToString();
//if (dsUserInfo.Tables[1].Rows.Count > 0)
//{
// HttpContext.Current.Session["APRBusCom"] = dsUserInfo.Tables[1].Rows[0][3].ToString();
//}
return true;
}
else
{
return false;
}
}
else if (spUserID.Value.ToString() == "INVALID USER")
{
return false;
}
else
{
return false;
}
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
finally
{
_objDataLayer = null;
dsUserInfo.Dispose();
}
}
public DataSet fnGetData()
{
try
{
_objDataLayer = new clsDataLayer();
SqlParameter[] _params = new SqlParameter[0];
switch (this.ScreenInd)
{
case Masters.Dmr:
return _objDataLayer.fnExecuteDataset("sp_dmr", new SqlParameter("@TableName", "Getdmr"),
new SqlParameter("@UserID", this.UserID),
new SqlParameter("@ToDate", this.To12),
new SqlParameter("@FromDate", this.From12));
#region distributors
case Masters.loginDetails:
return _objDataLayer.fnExecuteDataset("sp_LoginDetails", new SqlParameter("@TableName", "getlogindetails"),
new SqlParameter("@UserID", this.UserID),
new SqlParameter("@ToDate", this.To12),
new SqlParameter("@LoginTime", this.From12));
case Masters.GetAdminCommission:
return _objDataLayer.fnExecuteDataset("sp_AgentCommission", new SqlParameter("@TableName", "getAdminCommission"),
new SqlParameter("@OperatorsName", this.NetworkName));
case Masters.getdisCommission:
return _objDataLayer.fnExecuteDataset("sp_AgentCommission", new SqlParameter("@TableName", "getDisCommission"),
new SqlParameter("@NetworkName", this.NetworkName),
new SqlParameter("@Type", this.Type));
case Masters.GetDistributorsList:
return _objDataLayer.fnExecuteDataset("sp_GetdistributorsList", new SqlParameter("@TableName", this.Parameter),
new SqlParameter("@DistributorID", this.DistributorID));
case Masters.Distributorswisereports:
return _objDataLayer.fnExecuteDataset("SpDistributorReports", new SqlParameter("@UserID", this.ID),
new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
#endregion
case Masters.getimages:
return _objDataLayer.fnExecuteDataset("sp_getimages", _params);
case Masters.Getservices:
return _objDataLayer.fnExecuteDataset("sp_Temporaryservices", new SqlParameter("@TableName","GetServices"));
case Masters.GetOpeartorByMobileSeries:
return _objDataLayer.fnExecuteDataset("Sp_MobileNoSeries",new SqlParameter("@Prefix",this.Parameter));
case Masters.getticket:
return _objDataLayer.fnExecuteDataset("SP_GetDetails", new SqlParameter("@PGMBRefNo", this.BankReferenceNo));
case Masters.GetAgentAllReports:
return _objDataLayer.fnExecuteDataset("SpGetAgentAllReports", new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To),
new SqlParameter("@UserID", this.UserID));
case Masters.getadds:
return _objDataLayer.fnExecuteDataset("sp_getadds", _params);
case Masters.getewalletusers:
return _objDataLayer.fnExecuteDataset("sp_GetEwalletUsers", _params);
case Masters.GetAdminReports:
return _objDataLayer.fnExecuteDataset("sp_GetAdminReports", new SqlParameter("@Tablename", this.Parameter),
new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To),
new SqlParameter("@UserID", this.UserID));
case Masters.GetAgentOnly:
return _objDataLayer.fnExecuteDataset("sp_GetMobileDetailsOfAgentBySearch", new SqlParameter("@Tablename", this.Parameter),
new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To),
new SqlParameter("@UserID", this.UserID));
case Masters.GetCommisionByNetwork:
return _objDataLayer.fnExecuteDataset("sp_AgentCommission", new SqlParameter("@TableName", "GetCommissionByNetwork"),
new SqlParameter("@OperatorsName",this.NetworkName),
new SqlParameter("@Type", this.Type));
case Masters.AgentCommission:
return _objDataLayer.fnExecuteDataset("sp_AgentCommission", new SqlParameter("@TableName", "GetCommission"),
new SqlParameter("@Type",this.Type),
new SqlParameter("@ID",this.DistributorID));
case Masters.GetRechargeAmount:
return _objDataLayer.fnExecuteDataset("sp_ListOfAmounts", new SqlParameter("@TableName", "GetRechargeAmount"),
new SqlParameter("@NetworkName", this.NetworkName));
case Masters.GetNetworkName:
return _objDataLayer.fnExecuteDataset("sp_ListOfAmounts", new SqlParameter("@TableName", "GetNetwork"),
new SqlParameter("@OperatorsType",this.OperatorType));
case Masters.ListOfAmounts:
return _objDataLayer.fnExecuteDataset("sp_ListOfAmounts", new SqlParameter("@TableName", "getListOfAmount"));
case Masters.getoperators:
return _objDataLayer.fnExecuteDataset("sp_Getoperators", _params);
case Masters.AgentReportBYIDDTH:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfAgentsBYID", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@UserID", this.ID),
new SqlParameter("@Parameter", this.Parameter));
case Masters.AgentReportBYIDDatacard:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfAgentsBYID", new SqlParameter("@From", this.From12),
new SqlParameter("@UserID", this.ID),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.AgentReportBYID:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfAgentsBYID", new SqlParameter("@UserID", this.ID),
new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.AgentReportDatacard:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfAgents", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Type", this.Type),
new SqlParameter("@Parameter", this.Parameter));
case Masters.AgentReportdth:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfAgents", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Type", this.Type),
new SqlParameter("@Parameter", this.Parameter));
case Masters.AgentReport:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfAgents", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Type", this.Type),
new SqlParameter("@Parameter", this.Parameter));
case Masters.AgentForgotpwd:
return _objDataLayer.fnExecuteDataset("spCheckUserName", new SqlParameter("@TableName", "AgentForgotpwd"),
new SqlParameter("@EmailID", this.EmailID));
case Masters.getadmintotalbalance:
return _objDataLayer.fnExecuteDataset("sp_getadminTotalbalance", _params)
;
case Masters.getguestDatacardrecharge:
return _objDataLayer.fnExecuteDataset("spgetrecharge", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@Type", "DataCard"),
new SqlParameter("@parameter", this.Parameter))
;
case Masters.getagentDatacardrecharge:
return _objDataLayer.fnExecuteDataset("spgetrechargeinfoforusers", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@Type", "DataCard"),
new SqlParameter("@parameter", this.Parameter))
;
case Masters.getrechargeD2Hagent:
return _objDataLayer.fnExecuteDataset("spgetrechargeinfoforusers", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@Type", "DTH"),
new SqlParameter("@parameter", this.Parameter))
;
case Masters.AgentPassword:
return _objDataLayer.fnExecuteDataset("spCheckPassword", new SqlParameter("@TableName", "Agentpassword"),
new SqlParameter("@EmailID", this.EmailID));
case Masters.GetAgentProfile:
return _objDataLayer.fnExecuteDataset("sp_GetAgentprofile", new SqlParameter("@UserID", this.UserID));
case Masters.getbalanceAgent:
return _objDataLayer.fnExecuteDataset("sp_GetBalanceAgent");
case Masters.getbalance:
return _objDataLayer.fnExecuteDataset("sp_GetBalance", new SqlParameter("@UserID", this.UserID));
case Masters.GetAmount:
return _objDataLayer.fnExecuteDataset("sp_GetAmount", new SqlParameter("@UserID", this.UserID));
case Masters.GetAgentApprovedList:
return _objDataLayer.fnExecuteDataset("sp_GetAgentApprovedList", _params);
case Masters.getRequestID:
return _objDataLayer.fnExecuteDataset("sp_GetRequestsID", new SqlParameter("@UserID", this.UserID));
case Masters.GetRequests:
return _objDataLayer.fnExecuteDataset("sp_GetRequests", _params);
case Masters.AgentName:
return _objDataLayer.fnExecuteDataset("spCheckAgentName", new SqlParameter("@EmailID", this.EmailID));
case Masters.bindcontent:
return _objDataLayer.fnExecuteDataset("sp_updateofferContent", new SqlParameter("@TableName", "getcontent"));
case Masters.gettopcontent:
return _objDataLayer.fnExecuteDataset("sp_updateofferContent", new SqlParameter("@TableName", "TopContent"));
case Masters.getrechargeforusers:
return _objDataLayer.fnExecuteDataset("spgetrechargeinfoforusers", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@Type", "Mobile"),
new SqlParameter("@parameter", this.Parameter))
;
case Masters.Identify1:
return _objDataLayer.fnExecuteDataset("sp_IdentifyRechargeofUsers", new SqlParameter("@OrderID", this.RequestID)
);
;
case Masters.Identify:
return _objDataLayer.fnExecuteDataset("sp_IdentifyRecharge", new SqlParameter("@OrderID", this.RequestID)
);
;
case Masters.GetFlights:
return _objDataLayer.fnExecuteDataset("sp_InternationalFlightSegments", new SqlParameter("@tableName", "GetFlights"),
new SqlParameter("@FlightBookingID", this.RequestID)
);
;
case Masters.GetFlights1:
return _objDataLayer.fnExecuteDataset("sp_DomesticFlightBooking", new SqlParameter("@tableName", "GetFlights"),
new SqlParameter("@ReferenceNo", this.RequestID)
);
;
case Masters.getrecharge:
return _objDataLayer.fnExecuteDataset("spgetrecharge", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@Type", "Mobile"),
new SqlParameter("@parameter", this.Parameter))
;
case Masters.getrechargeD2H:
return _objDataLayer.fnExecuteDataset("spgetrecharge", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@Type", "DTH"),
new SqlParameter("@parameter", this.Parameter))
;
case Masters.gettime:
return _objDataLayer.fnExecuteDataset("gettime", new SqlParameter("@MobileNO", this.MobileNum),
new SqlParameter("@Parameter", this.Parameter)
);
case Masters.gettimeforusers:
return _objDataLayer.fnExecuteDataset("gettime", new SqlParameter("@MobileNO", this.MobileNum),
new SqlParameter("@Parameter", this.Parameter)
);
case Masters.Getreqdtls:
return _objDataLayer.fnExecuteDataset("sp_Getreqdtls", new SqlParameter("@UserID", this.UserID));
case Masters.Getreqdtls1:
return _objDataLayer.fnExecuteDataset("sp_Getreqdtlsforprofile", new SqlParameter("@UserID", this.UserID));
case Masters.GetUserReqd:
return _objDataLayer.fnExecuteDataset("sp_getUserEmail", new SqlParameter("@UserID", this.UserID));
case Masters.GetTopRechargersofDTH:
return _objDataLayer.fnExecuteDataset("spgettoprechargersofDTH", new SqlParameter("@Type", this.From)
);
case Masters.GetTopRechargersofDataCard:
return _objDataLayer.fnExecuteDataset("spgettoprechargersofDataCard", new SqlParameter("@Type", this.From)
);
case Masters.GetMRDByServiceSearch:
return _objDataLayer.fnExecuteDataset("spGetTotalTopRechargers", new SqlParameter("@Type", this.From)
);
case Masters.GetMRDByAdminSearch:
return _objDataLayer.fnExecuteDataset("sp_GetMobileDetailsByAdminSearch", new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To));
case Masters.GetMRByID:
return _objDataLayer.fnExecuteDataset("sp_GetMobileRechargeByID", new SqlParameter("@ID", this.ID));
case Masters.GetD2HBySearch:
return _objDataLayer.fnExecuteDataset("sp_GetD2HDetailsBySearch", new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To),
new SqlParameter("@Parameter", this.Parameter),
new SqlParameter("@UserID", this.UserID));
case Masters.GetMRDBySearch:
return _objDataLayer.fnExecuteDataset("sp_GetMobileDetailsBySearch", new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To),
new SqlParameter("@UserID", this.UserID));
case Masters.GetMRByUserID:
return _objDataLayer.fnExecuteDataset("sp_Getmobiledetailsbyid", new SqlParameter("@UserID", this.UserID));
case Masters.getmobrechargebyID:
return _objDataLayer.fnExecuteDataset("sp_GetmobrechargedtlsByName", new SqlParameter("@TableName", "getmobrechargebyID"),
new SqlParameter("@ID", this.ID));
case Masters.SubServices:
return _objDataLayer.fnExecuteDataset("sp_Getuserdetails", new SqlParameter("@TableName", "GetUser"));
case Masters.GetImage:
return _objDataLayer.fnExecuteDataset("sp_GetImage", new SqlParameter("TableName", "Mobile"));
case Masters.GetDTH:
return _objDataLayer.fnExecuteDataset("sp_GetImage", new SqlParameter("TableName", "DTH"));
case Masters.GetData:
return _objDataLayer.fnExecuteDataset("sp_GetImage", new SqlParameter("TableName", "DataCard"));
case Masters.GetTarrif:
return _objDataLayer.fnExecuteDataset("sp_GetTarrif", new SqlParameter("@OperatorsID", this.OperatorsID));
case Masters.Commission:
return _objDataLayer.fnExecuteDataset("spGetCommPer", _params);
case Masters.Failurereport:
return _objDataLayer.fnExecuteDataset("spGetMobRechargeFDtls", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.Failurereport1:
return _objDataLayer.fnExecuteDataset("spGetMobRechargeFDtls", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.Failurereport2:
return _objDataLayer.fnExecuteDataset("spGetMobRechargeFDtls", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.Guestreport:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfGuests", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.Guestreport1:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfGuests", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.Guestreport2:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfGuests", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.UserReport:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfUsers", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.UserReport1:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfUsers", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.UserReport2:
return _objDataLayer.fnExecuteDataset("SpGetMobileRechargeDetailsOfUsers", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.operatorsname:
return _objDataLayer.fnExecuteDataset("sp_OperatorsName", new SqlParameter("@TableName", "Mobile"));
case Masters.operatorsname1:
return _objDataLayer.fnExecuteDataset("sp_OperatorsName", new SqlParameter("@TableName", "DTH"));
case Masters.operatorsname2:
return _objDataLayer.fnExecuteDataset("sp_OperatorsName", new SqlParameter("@TableName", "NetConnect"));
case Masters.postpaid:
return _objDataLayer.fnExecuteDataset("sp_OperatorsName", new SqlParameter("@TableName", "PostPaid"));
case Masters.landline:
return _objDataLayer.fnExecuteDataset("sp_OperatorsName", new SqlParameter("@TableName", "LandLine"));
case Masters.Country:
return _objDataLayer.fnExecuteDataset("spGetCountryMst", _params);
case Masters.State:
return _objDataLayer.fnExecuteDataset("spGetStateMst", _params);
case Masters.State1:
return _objDataLayer.fnExecuteDataset("spGetStateMstOnly", _params);
case Masters.CityType:
return _objDataLayer.fnExecuteDataset("spGetCityType", _params);
case Masters.City:
return _objDataLayer.fnExecuteDataset("spGetCityMst", _params);
case Masters.UserMst:
return _objDataLayer.fnExecuteDataset("spGetUserMst", new SqlParameter("@UserId", this.UserID));
case Masters.Gain1:
return _objDataLayer.fnExecuteDataset("spGrid", _params);
case Masters.Gain:
return _objDataLayer.fnExecuteDataset("spGetGainGrid", new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To),
new SqlParameter("@ID", this.UserID),
new SqlParameter("@UT1", this.UserType),
new SqlParameter("@UT", this.UT1));
case Masters.UserID:
return _objDataLayer.fnExecuteDataset("spGetUserID_UserMst", _params);
case Masters.State_CountryCode:
return _objDataLayer.fnExecuteDataset("spGetState_CountryCode", new SqlParameter("@Country", this.Country));
case Masters.City_StateCode:
return _objDataLayer.fnExecuteDataset("spGetCity_StateCode", new SqlParameter("@State", this.State), new SqlParameter("@Country", this.Country));
//R
case Masters.UserName:
return _objDataLayer.fnExecuteDataset("spCheckUserName", new SqlParameter("@TableName", "UserForgotpwd"),
new SqlParameter("@EmailID", this.EmailID));
case Masters.Password:
return _objDataLayer.fnExecuteDataset("spCheckPassword", new SqlParameter("@TableName", "Userpassword"),
new SqlParameter("@EmailID", this.EmailID));
case Masters.CityGrid:
return _objDataLayer.fnExecuteDataset("spGetCityGrid", _params);
case Masters.GetUserName:
return _objDataLayer.fnExecuteDataset("spGetUserName", _params);
case Masters.GainMobile:
return _objDataLayer.fnExecuteDataset("spGetMobileGrid", new SqlParameter("@From", this.From),
new SqlParameter("@To", this.To),
new SqlParameter("@EmailID", this.EmailID),
new SqlParameter("@UT1", this.UserType),
new SqlParameter("@UT", this.UT1));
case Masters.EWallet:
return _objDataLayer.fnExecuteDataset("sp_EWallet", new SqlParameter("@OrderID", this.RequestID),
new SqlParameter("@Parameter", this.Parameter));
case Masters.GetD2Hdetails:
return _objDataLayer.fnExecuteDataset("sp_GetD2Hdetails", _params);
case Masters.GetDataCardDetails:
return _objDataLayer.fnExecuteDataset("sp_GetDataCardDetails", _params);
case Masters.GetMobileDetails:
return _objDataLayer.fnExecuteDataset("sp_Getmobrechargedtls", _params);
case Masters.Mobile:
return _objDataLayer.fnExecuteDataset("spGetMobile", _params);
case Masters.MobileNumCheck:
return _objDataLayer.fnExecuteDataset("spGetMobileRecharge", _params);
case Masters.D2H:
return _objDataLayer.fnExecuteDataset("spGetD2HRecharge", _params);
case Masters.Advertisement:
return _objDataLayer.fnExecuteDataset("sp_Get_Advertisement", new SqlParameter("@TableName", "All"));
case Masters.GetAdvertisement:
return _objDataLayer.fnExecuteDataset("sp_Get_Advertisement", new SqlParameter("@TableName", "Advertisement"),
new SqlParameter("@Advertisement", this.Advertisement));
case Masters.Adv_Images:
return _objDataLayer.fnExecuteDataset("sp_Get_Adv_Images", _params);
case Masters.citilist:
return _objDataLayer.fnExecuteDataset("spGetCitilist", _params);
case Masters.Operators:
return _objDataLayer.fnExecuteDataset("sp_OperatorsDetails", new SqlParameter("TableName", "GetOperator"));
case Masters.GetInfo:
return _objDataLayer.fnExecuteDataset("spGetDtls", new SqlParameter("@TableName", "UserName"),
new SqlParameter("@UserID", this.UserID));
case Masters.GetInfo1:
return _objDataLayer.fnExecuteDataset("spGetDtls", new SqlParameter("@TableName", "Balance"),
new SqlParameter("@UserID", this.UserID));
case Masters.bindUsers:
return _objDataLayer.fnExecuteDataset("sp_BindUsers", _params);
case Masters.bindIp:
return _objDataLayer.fnExecuteDataset("sp_GetIp", _params);
case Masters.DashBoardUser:
return _objDataLayer.fnExecuteDataset("sp_GetRechargesTop", new SqlParameter("@UserID", this.UserID));
case Masters.Coupon:
return _objDataLayer.fnExecuteDataset("spCouponCodes", new SqlParameter("@Type", "Get"));
case Masters.VisitorsReport:
return _objDataLayer.fnExecuteDataset("SpVisitorsOfGuestsMobileRecharge", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.VisitorsReportd2h:
return _objDataLayer.fnExecuteDataset("SpVisitorsOfGuestsMobileRecharge", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.VisitorsReportDatacard:
return _objDataLayer.fnExecuteDataset("SpVisitorsOfGuestsMobileRecharge", new SqlParameter("@From", this.From12),
new SqlParameter("@To", this.To12),
new SqlParameter("@Parameter", this.Parameter));
case Masters.DailyReports:
return _objDataLayer.fnExecuteDataset("SpGetDailyReports", new SqlParameter("@From", this.From12));
// new SqlParameter("@Parameter", this.Parameter));
case Masters.Ewalletbyrequestid:
return _objDataLayer.fnExecuteDataset("sp_Ewalletbyrequestid", new SqlParameter("@OrderID", this.RequestID)
);
;
}
return null;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return null;
}
}
public DataSet GetOpeartorByMobileSeries(string Prefix)
{
try
{
_objDataLayer = new clsDataLayer();
return _objDataLayer.fnExecuteDataset("Sp_MobileNoSeries",new SqlParameter("@Prefix",Prefix));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetIgnoreList(int ProviderID)
{
try
{
_objDataLayer = new clsDataLayer();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@ProviderId", ProviderID);
return _objDataLayer.fnExecuteDataset("SP_IgnoreOpr", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetCitiesTours(string Consumerkey, string Consumersecretkey,int value)
{
try
{
_objDataLayer = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@ConsumerKey", Consumerkey);
p[1] = new SqlParameter("@ConsumerSecret", Consumersecretkey);
p[2] = new SqlParameter("@Query", value);
return _objDataLayer.fnExecuteDataset("SP_WebAPI_GetCities", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetAgentFlightSearch(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[13];
p[0] = new SqlParameter("@Source", objFlightBAL.Source);
p[1] = new SqlParameter("@Destinations", objFlightBAL.Destinations);
p[2] = new SqlParameter("@DateOfJourney", objFlightBAL.DateOfJourney);
p[3] = new SqlParameter("@DateOfIssue", objFlightBAL.DateOfIssue);
p[4] = new SqlParameter("@Name", objFlightBAL.Name);
p[5] = new SqlParameter("@EmailId", objFlightBAL.EmailId);
p[6] = new SqlParameter("@RefNo", objFlightBAL.RefNo);
p[7] = new SqlParameter("@Operator", objFlightBAL.Operator);
p[8] = new SqlParameter("@ContactNo", objFlightBAL.ContactNo);
p[9] = new SqlParameter("@Status", objFlightBAL.Status);
//p[10] = new SqlParameter("@PageSize", objFlightBAL.PageSize);
p[10] = new SqlParameter("@TableName", objFlightBAL.TableName);
p[11] = new SqlParameter("@FlightName", objFlightBAL.FlightName);
p[12] = new SqlParameter("@userid", objFlightBAL.CreatedBy);
return ObjDAL.fnExecuteDataset("SP_GetAgentReport", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetAgentFlights(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@TableName", objFlightBAL.FlightName);
p[1] = new SqlParameter("@userid", objFlightBAL.CreatedBy);
return ObjDAL.fnExecuteDataset("SP_GetAgentReport", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public DataSet CarSearch(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[6];
p[0] = new SqlParameter("@ReferenceId ", objFlightBAL.RefNo);
p[1] = new SqlParameter("@AgentName", objFlightBAL.Name);
p[2] = new SqlParameter("@DateOfJourney", objFlightBAL.DateOfJourney);
p[3] = new SqlParameter("@DateOfIssue", objFlightBAL.DateOfIssue);
p[4] = new SqlParameter("@Query", objFlightBAL.TableName);
p[5] = new SqlParameter("@AgentId", objFlightBAL.agentId);
//p[10] = new SqlParameter("@PageSize", objFlightBAL.PageSize);
//p[5] = new SqlParameter("@userid", objFlightBAL.CreatedBy);
return ObjDAL.fnExecuteDataset("sp_CarProvisional", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet UpdateDomesticFlightBooking(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@ReferenceNo", objFlightBAL.ReferenceNo);
p[1] = new SqlParameter("@TransId", objFlightBAL.TransId);
p[2] = new SqlParameter("@Status", objFlightBAL.Status);
p[3] = new SqlParameter("@tableName", "UpdateDomFlightBooking");
return ObjDAL.fnExecuteDataset("sp_DomesticFlightBooking", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
//Get Airport Codes from Database
public DataSet GetGuestReports(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@DateOfJourney", objFlightBAL.DateOfJourney);
p[1] = new SqlParameter("@RefNo", objFlightBAL.RefNo);
p[2] = new SqlParameter("@TableName", objFlightBAL.TableName);
p[3] = new SqlParameter("@DateOfIssue", objFlightBAL.DateOfIssue);
return ObjDAL.fnExecuteDataset("sp_AllGuestReports", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet fnGetData()
{
try
{
_objDataLayer = new clsDataLayer();
SqlParameter[] _params = new SqlParameter[0];
switch (this.ScreenInd)
{
case blossom.GetCabDetails:
return _objDataLayer.fnExecuteDataset("SP_PassengerDetails", new SqlParameter("@Query", "SelectAll"),
new SqlParameter("@ReferanceId", this.ReferanceId));
case blossom.SelectEmployee:
return _objDataLayer.fnExecuteDataset("SP_Employee", new SqlParameter("@Query", "Select"),
new SqlParameter("@EmpId", this.EmpId));
case blossom.AllSelectRecord:
return _objDataLayer.fnExecuteDataset("SP_Employee", new SqlParameter("@Query", "AllSelect"));
case blossom.SelectHotelPolicy:
return _objDataLayer.fnExecuteDataset("SP_HotelPolicy", new SqlParameter("@Query", "Select"));
case blossom.SelectCab:
return _objDataLayer.fnExecuteDataset("SP_Cab", new SqlParameter("@Query", "Select"),
new SqlParameter("@CabId", this.CarId));
case blossom.SelectAllCab:
return _objDataLayer.fnExecuteDataset("SP_Cab", new SqlParameter("@Query", "AllSelect"));
case blossom.SelectCityName:
return _objDataLayer.fnExecuteDataset("SP_City", new SqlParameter("@Query", "Select"));
case blossom.SelectAllCitys:
return _objDataLayer.fnExecuteDataset("SP_City", new SqlParameter("@Query", "SelectALL"));
case blossom.SelectCar:
return _objDataLayer.fnExecuteDataset("SP_Car", new SqlParameter("@Query", "Select"));
case blossom.SelectAllCars:
return _objDataLayer.fnExecuteDataset("SP_Car", new SqlParameter("@Query", "AllSelect"));
case blossom.SelectCarDetails:
return _objDataLayer.fnExecuteDataset("SP_CarDetailsForCity", new SqlParameter("@Query", "Select"),
new SqlParameter("@CabId", this.CarId));
case blossom.SelectAllCarDetailsForCity:
return _objDataLayer.fnExecuteDataset("SP_CarDetailsForCity", new SqlParameter("@Query", "SelectAll"));
case blossom.SelectCarResult:
return _objDataLayer.fnExecuteDataset("SP_CarDetailsForCity", new SqlParameter("@Query", "CarResult"),
new SqlParameter("@CityId", this.CityId));
case blossom.SelectPsgDtls:
return _objDataLayer.fnExecuteDataset("SP_PassengerDetails", new SqlParameter("@Query", "SelectAll"));
case blossom.SelectGetMailDetails:
return _objDataLayer.fnExecuteDataset("SP_PassengerDetails", new SqlParameter("@Query", "GetMailDetails"),
new SqlParameter("@ReferanceId",this.ReferanceId));
case blossom.GetCarTicketDetais:
return _objDataLayer.fnExecuteDataset("sp_CarProvisional", new SqlParameter("@Query", "GetCarProvisonal"));
case blossom.GetAgentTicketDetaisl:
return _objDataLayer.fnExecuteDataset("sp_CarProvisional", new SqlParameter("@Query", "GetAgentBookings"));
case blossom.GetUserTicketDetaisl:
return _objDataLayer.fnExecuteDataset("sp_CarProvisional", new SqlParameter("@Query", "GetUserBookings"));
case blossom.GetGuestTicketDetail:
return _objDataLayer.fnExecuteDataset("sp_CarProvisional", new SqlParameter("@Query", "GetGuestBookings"));
case blossom.GetIndividualAgentTicketDetaisl:
return _objDataLayer.fnExecuteDataset("sp_CarProvisional", new SqlParameter("@Query", "Individual Agent Bookings"),
new SqlParameter("@Role", this.Role),
new SqlParameter("@AgentId", this.AgentId));
case blossom.GetCancellationdetails:
return _objDataLayer.fnExecuteDataset("sp_CarProvisional", new SqlParameter("@Query", "Cancellation"),
new SqlParameter("@ReferenceId", this.ReferanceId),
new SqlParameter("@EmailId", this.EmailId));
case blossom.CarDetails:
return _objDataLayer.fnExecuteDataset("SP_CarDetailsForCity", new SqlParameter("@Query", "CarDetails"),
new SqlParameter("@CarDetailsId", this.CarDetailsId));
}
return null;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return null;
}
}
public DataSet GetCommissionSlab(string role, string serviceName, string operatorName)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@tablename", "Getdata");
p[1] = new SqlParameter("@Role", role);
p[2] = new SqlParameter("@ServiceName", serviceName);
p[3] = new SqlParameter("@OperatorName", operatorName);
return ObjDAL.fnExecuteDataset("SP_CommissionSlab", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
//public DataSet GetCommisssions1(string strtablename)
//{
// try
// {
// ObjDAL = new clsDataLayer();
// SqlParameter[] p = new SqlParameter[1];
// p[0] = ~ew SqlParameter("@tablename", strtablename);
// return ObjDAL.fnExecuteDataset("SP_CommissionSlab", p);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//bindu
public DataSet GetAirlineNames(string type)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@Flag", "GetAirlineNames");
p[1] = new SqlParameter("@Type", type);
return ObjDAL.fnExecuteDataset("sp_Agents", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public string CheckUser()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[5];
p[0] = new SqlParameter("@UserName", userName);
p[1] = new SqlParameter("@Password", password);
p[2] = new SqlParameter("@Result", SqlDbType.VarChar, 100);
p[2].Direction = ParameterDirection.Output;
p[3] = new SqlParameter("@Query", "CheckUser");
p[4] = new SqlParameter("@Role", SqlDbType.VarChar, 100);
p[4].Direction = ParameterDirection.Output;
ObjDataset = ObjDAL.fnExecuteDataset("Sp_Users", p);
if (ObjDataset != null)
{
if (ObjDataset.Tables[0].Rows.Count > 0)
{
System.Web.HttpContext.Current.Session["UserID"] = ObjDataset.Tables[0].Rows[0]["ID"].ToString();
System.Web.HttpContext.Current.Session["UserName"] = ObjDataset.Tables[0].Rows[0]["UserName"].ToString();
System.Web.HttpContext.Current.Session["Name"] = ObjDataset.Tables[0].Rows[0]["Name"].ToString();
System.Web.HttpContext.Current.Session["Role"] = ObjDataset.Tables[0].Rows[0]["Role"].ToString();
}
else
{
System.Web.HttpContext.Current.Session["UserID"] = null;
System.Web.HttpContext.Current.Session["UserName"] = null;
System.Web.HttpContext.Current.Session["Name"] = null;
}
}
string role = p[4].Value.ToString();
//if (role != null && role != "")
//{
// System.Web.HttpContext.Current.Session["Role"] = role;
//}
//else
//{
// System.Web.HttpContext.Current.Session["Role"] = null;
//}
return Convert.ToString(p[2].Value.ToString());
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet AllReports(string strservicename, int AgentID, DateTime fromdate, DateTime todate, string Agent, string RefNo)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[6];
p[0] = new SqlParameter("@AgentId", AgentID);
p[1] = new SqlParameter("@tablename", strservicename);
p[2] = new SqlParameter("@FromDate", fromdate);
p[3] = new SqlParameter("@ToDate", todate);
p[4] = new SqlParameter("@Agent", Agent);
p[5] = new SqlParameter("@RefNo", RefNo);
return ObjDAL.fnExecuteDataset("SP_ALLReports", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet fnGetData()
{
try
{
_objDataLayer = new clsDataLayer();
SqlParameter[] _params = new SqlParameter[0];
switch (this.ScreenInd)
{
case Master123.GetRemainder:
return _objDataLayer.fnExecuteDataset("Sp_Remainder", new SqlParameter("@Query", "Get")
);
case Master123.GetNotices:
return _objDataLayer.fnExecuteDataSet("Sp_Notices", new SqlParameter("@Query", "get")
);
case Master123.GetMarkup:
return _objDataLayer.fnExecuteDataSet("Sp_Markupmanagement", new SqlParameter("@Query", "Get")
);
case Master123.GetHotelPolicy:
return _objDataLayer.fnExecuteDataSet("Sp_HotelPolicy", new SqlParameter("@Query", "Get")
);
case Master123.GetCarPolicy:
return _objDataLayer.fnExecuteDataSet("Sp_CarPolicy", new SqlParameter("@Query", "Get")
);
case Master123.GetType:
return _objDataLayer.fnExecuteDataSet("Sp_Flights", new SqlParameter("@Query", "GetFlightsType")
);
case Master123.GetNationalFlights:
return _objDataLayer.fnExecuteDataSet("Sp_Flights", new SqlParameter("@Query", "GetDomesticFlights")
);
case Master123.GetInterNationalFlights:
return _objDataLayer.fnExecuteDataSet("Sp_Flights", new SqlParameter("@Query", "GetInternationalFlights")
);
case Master123.GetCheckBalance:
return _objDataLayer.fnExecuteDataSet("SP_AgentCheckBalance", new SqlParameter("@AgentId", this.id)
);
case Master123.GetAgentMarkup:
return _objDataLayer.fnExecuteDataset("sp_AgentMarkup1", new SqlParameter("@Query", "get"),
new SqlParameter("@AgentID", this.Agentid)
);
case Master123.gettopmarkup:
return _objDataLayer.fnExecuteDataset("sp_AgentMarkup1", new SqlParameter("@Query", "topmarkup"),
new SqlParameter("@AgentID", this.Agentid),
new SqlParameter("@Type", this.Type)
);
case Master123.GetAgentMarkup1:
return _objDataLayer.fnExecuteDataset("sp_AgentMarkup1", new SqlParameter("@Query", "getMark")
);
case Master123.GetAdminNotice:
return _objDataLayer.fnExecuteDataSet("Sp_AdminNotices", new SqlParameter("@Query", "Get")
);
case Master123.GetAdminRemainder:
return _objDataLayer.fnExecuteDataset("Sp_AdminRemainder", new SqlParameter("@Query", "get")
);
case Master123.GetDashBoard:
return _objDataLayer.fnExecuteDataSet("Sp_DashBoard", new SqlParameter("@Query", "Get")
);
case Master123.GetDynamicGraph:
return _objDataLayer.fnExecuteDataset("Sp_DynamicGraph", new SqlParameter("@Query", "Get")
);
case Master123.GetAdminMarkup:
return _objDataLayer.fnExecuteDataset("sp_AgentMarkup1", new SqlParameter("@Query", "Get")
);
case Master123.GetRole:
return _objDataLayer.fnExecuteDataSet("Sp_RoleMaster", new SqlParameter("@Query", "Get")
);
case Master123.GetPromocode:
return _objDataLayer.fnExecuteDataSet("Sp_PomocodeMaster", new SqlParameter("@Query", "get")
);
case Master123.GetCashCoupon:
return _objDataLayer.fnExecuteDataSet("Sp_CashCoupon1", new SqlParameter("@Query", "get")
);
case Master123.GetHotel:
return _objDataLayer.fnExecuteDataSet("sp_AgentMarkup1", new SqlParameter("@Query", "getHotel"),
new SqlParameter("@Type","Hotel")
);
case Master123.GetBus:
return _objDataLayer.fnExecuteDataSet("sp_AgentMarkup1", new SqlParameter("@Query", "getBus")
);
case Master123.GetInterNationalFlight:
return _objDataLayer.fnExecuteDataSet("sp_AgentMarkup1", new SqlParameter("@Query", "getFlights")
);
case Master123.GetBusMark:
return _objDataLayer.fnExecuteDataSet("Sp_DomesticFlights", new SqlParameter("@Query", "Get"),
new SqlParameter("@AgentId",this.id)
);
case Master123.GetAllMark1:
return _objDataLayer.fnExecuteDataSet("sp_AgentMarkup1", new SqlParameter("@Query", "getstaticmarkups")
);
case Master123.GetAllMark2:
return _objDataLayer.fnExecuteDataSet("sp_AgentMarkup1", new SqlParameter("@Query", "getmarkupsbyagentwise"),
new SqlParameter("@AgentId", this.Agentid),
new SqlParameter("@Type", this.Type)
);
}
return null;
}
catch (Exception ex)
{
////Logger.Log(Logger.LogType.Log_In_DB, ex, true);"
return null;
}
}