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