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 GetDomAirportCodes()
 {
     try
     {
         ObjDAL = new clsDataLayer();
         SqlParameter[] p = new SqlParameter[1];
         p[0] = new SqlParameter("@tableName", "DomAirportCodes");
         return ObjDAL.fnExecuteDataSet("Sp_IFReports", p);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

 public bool fnForgotPwd()
 {
     try
     {
         _objDataLayer = new clsDataLayer();
         string strQuery = "UPDATE dbo.tbUsers SET Password='" + this.strPassword + "' WHERE UserID=" + this.RefID.ToString();
         _objDataLayer.fnExecuteQuery(strQuery);
         return true;
     }
     catch (Exception ex)
     {
         //Logger.Log(Logger.LogType.Log_In_DB, ex, true);
         return false;
     }
     finally
     {
         _objDataLayer = 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 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 bool fnUpdateRecord()
        {
            try
            {
                _objDataLayer = new clsDataLayer();

                switch (this.ScreenInd)
                {

                    case Masters.Getservices:
                        _objDataLayer.fnExecuteStoredProcedure("sp_Temporaryservices", new SqlParameter("@TableName", "UpdateServices"),
                                                                                 new SqlParameter("@Id", this.ID),
                                                                                   new SqlParameter("@Status", this.Status));
                        break;
                    case Masters.AddAmounttoUsersRechargeFailed:
                        _objDataLayer.fnExecuteStoredProcedure("AddAmounttoUsersRechargeFailed", new SqlParameter("@UserID", this.UserID),
                                                                                   new SqlParameter("@Amount", this.amountewallet));

                        break;

                    case Masters.AgentCommission:
                        _objDataLayer.fnExecuteStoredProcedure("sp_AgentCommission", new SqlParameter("@TableName", "UpdateCommission"),
                                                                                  new SqlParameter("@ID", this.RefID),
                                                                                   new SqlParameter("@NetworkName", this.NetworkName),
                                                                                    new SqlParameter("@OperatorType", this.OperatorType),
                                                                                     new SqlParameter("@AgentCommission", this.AgentCommission));

                        break;
                    case Masters.ListOfAmounts:
                        _objDataLayer.fnExecuteStoredProcedure("sp_ListOfAmounts", new SqlParameter("@TableName", "UpdateListOfAmount"),
                                                                                  new SqlParameter("@ID", this.RefID),
                                                                                   new SqlParameter("@NetworkName", this.NetworkName),
                                                                                    new SqlParameter("@OperatorType", this.OperatorType),
                                                                                     new SqlParameter("@RechargeAmount", this.A_Amount),
                                                                                     new SqlParameter("@TalkTime", this.TalkTime));
                        break;

                    case Masters.deductadminbalance:
                        _objDataLayer.fnExecuteStoredProcedure("spdeductadminbalance", new SqlParameter("@Balance", this.A_Amount))

                          ;
                        break;

                    case Masters.UpdateAdminonlyBalance:
                        _objDataLayer.fnExecuteStoredProcedure("sp_UpdateonlyAdminBalance", new SqlParameter("@Amount", this.A_Amount),
                            new SqlParameter("@ID", this.ID),
                            new SqlParameter("@UserID", this.UserID));
                        break;

                    case Masters.UpdateGuestrecharge3:
                        _objDataLayer.fnExecuteStoredProcedure("spgetrecharge", new SqlParameter("@RequestID", this.RequestID),
                                                                                 new SqlParameter("@TransactionID", this.TransactionID),
                                                                                   new SqlParameter("@Status", this.Status),
                                                                                  new SqlParameter("@Type", "DataCard"),
                                                                              new SqlParameter("@ip", this.IP),
                                                                                new SqlParameter("@A_Amount", this.A_Amount),
                                                                              new SqlParameter("@parameter", this.Parameter))

                          ;
                        break;
                    case Masters.getGuestrecharge1:
                        _objDataLayer.fnExecuteStoredProcedure("spgetrecharge", new SqlParameter("@RequestID", this.RequestID),
                                                                                  new SqlParameter("@TransactionID", this.TransactionID),
                                                                                  new SqlParameter("@Status",this.Status),
                                                                                   new SqlParameter("@Type", "Mobile"),
                                                                               new SqlParameter("@ip", this.IP),
                                                                                new SqlParameter("@A_Amount", this.A_Amount),
                                                                               new SqlParameter("@parameter", this.Parameter))

                           ;
                        break;

                    case Masters.getagentrecharge2:
                        _objDataLayer.fnExecuteStoredProcedure("spgetrechargeinfoforusers", new SqlParameter("@RequestID", this.RequestID),
                                                                                              new SqlParameter("@UserID", this.UserID),
                                                                                                new SqlParameter("@Status", this.Status),
                                                                                           new SqlParameter("@Amount", this.Amount),
                                                                                            new SqlParameter("@TransactionID", this.TransactionID),
                                                                                  new SqlParameter("@Commission",this.AgentCommission),
                                                                                   new SqlParameter("@Type", "DTH"),
                                                                               new SqlParameter("@ip", this.IP),
                                                                               new SqlParameter("@A_Amount",this.A_Amount),
                                                                               new SqlParameter("@parameter", this.Parameter))

                           ;
                        break;

                    case Masters.deductagentbalance:
                        _objDataLayer.fnExecuteStoredProcedure("spdeductagentbalance", new SqlParameter("@UserID", this.UserID),
                                                                              new SqlParameter("@Balance", this.A_Amount),
                                                                              new SqlParameter("@DisComm",this.Amount)
                                                                               )

                          ;
                        break;

                    case Masters.UPAgentprofile:

                        _objDataLayer.fnExecuteStoredProcedure("sp_Updateprofile", new SqlParameter("@TableName", "AgentProfile"),
                                                                                    new SqlParameter("@UserID", this.UserID),
//.........这里部分代码省略.........

        public bool fnInactive()
        {
            try
            {
                _objDataLayer = new clsDataLayer();
                switch (this.ScreenInd)
                {
                    case Masters.UserMst:
                        _objDataLayer.fnExecuteStoredProcedure("spInactiveMstData", new SqlParameter("@TableName", "tbUser"),
                                                                                     new SqlParameter("@RefID", this.RefID));
                        break;
                }

                return true;
            }
            catch (Exception ex)
            {
                // Logger.Log(Logger.LogType.Log_In_DB, ex, true);
                return false;
            }
        }

 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 bool UpdateInternationalFlightBookingStatus(FlightBAL objFlightBAL)
 {
     try
     {
         ObjDAL = new clsDataLayer();
         SqlParameter[] p = new SqlParameter[9];
         p[0] = new SqlParameter("@tableName", "UpdateBookingStatus");
         p[1] = new SqlParameter("@TransId", objFlightBAL.TransId);
         p[2] = new SqlParameter("@Status", objFlightBAL.Status);
         p[3] = new SqlParameter("@ReferenceNo", objFlightBAL.ReferenceNo);
         p[4] = new SqlParameter("@AirlinePNR", objFlightBAL.AirlinePNR);
         p[5] = new SqlParameter("@GDFPNRNo", objFlightBAL.GDFPNRNo);
         p[6] = new SqlParameter("@eticketNo", objFlightBAL.eticketNo);
         p[7] = new SqlParameter("@Flightuid", objFlightBAL.Flightuid);
         p[8] = new SqlParameter("@passuid", objFlightBAL.passuid);
         return ObjDAL.fnExecuteStoredProcedure("sp_InternationalFlightBooking", p);
     }
     catch (Exception ex)
     {
         throw new ArgumentException(ex.Message);
     }
 }

        public bool UpdateDomesticFlightCancelStatus(FlightBAL objFlightBAL)
        {
            try
            {
                ObjDAL = new clsDataLayer();
                SqlParameter[] p = new SqlParameter[9];
                p[0] = new SqlParameter("@tableName", "UpdateCancelStatus");
                p[1] = new SqlParameter("@TransId", objFlightBAL.TransId);
                p[2] = new SqlParameter("@Status", objFlightBAL.Status);
                p[3] = new SqlParameter("@CancellationProcessDateTime", objFlightBAL.CancellationProcessDateTime);
                p[4] = new SqlParameter("@CancellationCharges", objFlightBAL.CancellationCharges);
                p[5] = new SqlParameter("@RefundStatus", objFlightBAL.RefundStatus);
                p[6] = new SqlParameter("@FinalRefundAmount", objFlightBAL.FinalRefundAmount);
                p[7] = new SqlParameter("@RefundDateTime", objFlightBAL.RefundDateTime);
                p[8] = new SqlParameter("@ModifiedBy", objFlightBAL.CreatedBy);

                return ObjDAL.fnExecuteStoredProcedure("sp_DomesticFlightCancel", p);
            }
            catch (Exception ex)
            {
                throw new ArgumentException(ex.Message);
            }
        }

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

 public DataSet GetTransID(string RefNo)
 {
     try
     {
         ObjDAL = new clsDataLayer();
         SqlParameter[] p = new SqlParameter[2];
         p[0] = new SqlParameter("@tableName", "GetTransIdByRefNo");
         p[1] = new SqlParameter("@ReferenceNo", RefNo);
         return ObjDAL.fnExecuteDataSet("sp_DomesticFlightBooking", p);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

 public DataSet GetInternationalFlightDetailsI1(string RefNo)
 {
     try
     {
         ObjDAL = new clsDataLayer();
         SqlParameter[] p = new SqlParameter[2];
         p[0] = new SqlParameter("@tableName", "GetFlights");
         p[1] = new SqlParameter("@FlightBookingID", RefNo);
         return ObjDAL.fnExecuteDataSet("sp_DomesticFlightBookingsegments", p);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

        //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 GetFlightSalesReport()
        {
            try
            {
                ObjDAL = new clsDataLayer();
                SqlParameter[] p = new SqlParameter[4];
                p[0] = new SqlParameter("@Flag", "FlightSalesReport");
                p[1] = new SqlParameter("@FromDate", FromDate);
                p[2] = new SqlParameter("@ToDate", ToDate);
                p[3] = new SqlParameter("@agentId", agentId);

                ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_FlightsSalesReport", p);
                return ObjDataset;
            }
            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 FGetInternationalFlightDetails(string RefNo)
 {
     try
     {
         ObjDAL = new clsDataLayer();
         SqlParameter[] p = new SqlParameter[2];
         p[0] = new SqlParameter("@tableName", "GetFDetails");
         p[1] = new SqlParameter("@ReferenceNo", RefNo);
         return ObjDAL.fnExecuteDataSet("sp_InternationalFlightBooking", p);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

        public bool UpdateInternationalFlightCancelStatus(FlightBAL objFlightBAL)
        {
            try
            {
                ObjDAL = new clsDataLayer();
                SqlParameter[] p = new SqlParameter[3];
                p[0] = new SqlParameter("@tableName", "UpdateCancelStatus");
                p[1] = new SqlParameter("@TransId", objFlightBAL.TransId);
                p[2] = new SqlParameter("@Status", objFlightBAL.Status);

                return ObjDAL.fnExecuteStoredProcedure("sp_InternationalFlightBooking", p);
            }
            catch (Exception ex)
            {
                throw new ArgumentException(ex.Message);
            }
        }

        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 bool UpdateInternationalFlightSegment(FlightBAL objFlightBAL)
        {
            try
            {
                ObjDAL = new clsDataLayer();
                SqlParameter[] p = new SqlParameter[10];

                p[0] = new SqlParameter("@bookingclass", objFlightBAL.bookingClass);
                p[1] = new SqlParameter("@classType", objFlightBAL.ClassType);
                p[2] = new SqlParameter("@farebasiscode", objFlightBAL.farebasisCode);
                p[3] = new SqlParameter("@Fare_Rule", objFlightBAL.Fare_Rule);
                p[4] = new SqlParameter("@PsgrType", objFlightBAL.PsgrType);
                p[5] = new SqlParameter("@BaseFare", objFlightBAL.BaseFare);
                p[6] = new SqlParameter("@psgrTax", objFlightBAL.psgrTax);
                p[7] = new SqlParameter("@BagInfo", objFlightBAL.BagInfo);
                p[8] = new SqlParameter("@FlightBookingID", objFlightBAL.FlightBookingID);
                p[9] = new SqlParameter("@tableName", "UpdateIntFlightSegment");
                return ObjDAL.fnExecuteStoredProcedure("sp_InternationalFlightSegments", p);
            }
            catch (Exception ex)
            {
                throw new ArgumentException(ex.Message);
            }
        }