public DataSet GetTicketIdByEmail()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@EmailID", emailId);
p[1] = new SqlParameter("@MBRefNo", manabusRefNo);
// p[2] = new SqlParameter("@Query", "GetByMBRefNo");
return ObjDAL.fnExecuteDataSet("Sp_PartialCancellation1", p);
}
catch (Exception ex)
{
throw ex;
}
}
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 DataTable AddDomesticFlightBooking(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[38];
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("@AdultPax", objFlightBAL.AdultPax);
p[4] = new SqlParameter("@InfantPax", objFlightBAL.InfantPax);
p[5] = new SqlParameter("@ChildPax", objFlightBAL.ChildPax);
p[6] = new SqlParameter("@Origin_Destination_Id", objFlightBAL.Origin_Destination_Id);
p[7] = new SqlParameter("@Origin_Destination_Key", objFlightBAL.Origin_Destination_Key);
p[8] = new SqlParameter("@ActualBasefare", objFlightBAL.ActualBasefare);
p[9] = new SqlParameter("@Tax", objFlightBAL.Tax);
p[10] = new SqlParameter("@STax", objFlightBAL.STax);
p[11] = new SqlParameter("@Scharge", objFlightBAL.Scharge);
p[12] = new SqlParameter("@TDiscount", objFlightBAL.TDiscount);
p[13] = new SqlParameter("@TPartnerCommission", objFlightBAL.TPartnerCommission);
p[14] = new SqlParameter("@TCharge", objFlightBAL.TCharge);
p[15] = new SqlParameter("@TMarkUp", objFlightBAL.TMarkUp);
p[16] = new SqlParameter("@TSDiscount", objFlightBAL.TSDiscount);
p[17] = new SqlParameter("@Customer_Details", objFlightBAL.Customer_Details);
p[18] = new SqlParameter("@telephone", objFlightBAL.telephone);
p[19] = new SqlParameter("@emailAddress", objFlightBAL.emailAddress);
p[20] = new SqlParameter("@tableName", "InsertDomFlightBooking");
p[21] = new SqlParameter("@CreatedBy", objFlightBAL.CreatedBy);
p[22] = new SqlParameter("@TripMode", objFlightBAL.TripMode);
p[23] = new SqlParameter("@address", objFlightBAL.Address);
p[24] = new SqlParameter("@Type", objFlightBAL.Type);
p[25] = new SqlParameter("@id", objFlightBAL.id);
p[26] = new SqlParameter("@key", objFlightBAL.key);
p[27] = new SqlParameter("@ActualBasefareRet", objFlightBAL.ActualBasefareRet);
p[28] = new SqlParameter("@TaxRet", objFlightBAL.TaxRet);
p[29] = new SqlParameter("@STaxRet", objFlightBAL.STaxRet);
p[30] = new SqlParameter("@SchargeRet", objFlightBAL.SchargeRet);
p[31] = new SqlParameter("@TDiscountRet", objFlightBAL.TDiscountRet);
p[32] = new SqlParameter("@TPartnerCommissionRet", objFlightBAL.TPartnerCommissionRet);
p[33] = new SqlParameter("@TChargeRet", objFlightBAL.TChargeRet);
p[34] = new SqlParameter("@TMarkUpRet", objFlightBAL.TMarkUpRet);
p[35] = new SqlParameter("@TSDiscountRet", objFlightBAL.TSDiscountRet);
p[36] = new SqlParameter("@idRet", objFlightBAL.idRet);
p[37] = new SqlParameter("@keyRet", objFlightBAL.keyRet);
return ObjDAL.fnExecuteDataSet("sp_DomesticFlightBooking", p).Tables[0];
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public DataSet GetCarDetaisl(string RefNo,string carid)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@Query", "getpassengerdetails");
p[1] = new SqlParameter("@ReferanceId", RefNo);
p[2] = new SqlParameter("@CarDetailsId", carid);
return ObjDAL.fnExecuteDataSet("sp_CarProvisional", 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 string Upstatus(int UserId, double Amount)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@Flag", "upstatus");
p[1] = new SqlParameter("@UserId", UserId);
p[2] = new SqlParameter("@DepositAmount", Amount);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_AgentDepositRequests", p);
return ObjDataset.ToString();
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public string AddAgentDeposit(int agentId, double amount, string details, int createdBy, string depositType, string transactionNumber, string reason)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@Flag", "InsertAgentBalance");
p[1] = new SqlParameter("@AgentId", agentId);
p[2] = new SqlParameter("@Amount", amount);
p[3] = new SqlParameter("@Details", details);
p[4] = new SqlParameter("@CreatedBy", createdBy);
p[5] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[5].Direction = ParameterDirection.Output;
p[6] = new SqlParameter("@DepositType", depositType);
p[7] = new SqlParameter("@TransactionNumber", transactionNumber);
p[8] = new SqlParameter("@Reason", reason);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_Agents", p);
return Convert.ToString(p[5].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public DataSet GetUsers()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@Query", "Get");
return ObjDAL.fnExecuteDataSet("Sp_Users", p);
}
catch (Exception ex)
{
throw ex;
}
}
public string InsertAgentLogo(int userId, byte[] agentLogo)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Flag", "InsertAgentLogo");
p[1] = new SqlParameter("@AgentId", userId);
p[3] = new SqlParameter("@AgentLogo", agentLogo);
p[2] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[2].Direction = ParameterDirection.Output;
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_Agents", p);
return Convert.ToString(p[2].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public DataSet GetUpdatedCouponDetails()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@PGMBRefNo", manabusRefNo);
p[1] = new SqlParameter("@Query", "UpdateAfterBooking");
return ObjDAL.fnExecuteDataSet("Sp_CashCoupon", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetUserPermissions()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@Query", "Get");
p[1] = new SqlParameter("@UserID", ID);
return ObjDAL.fnExecuteDataSet("Sp_Permissions", p);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetUniqueId()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@Id", SqlDbType.BigInt);
p[0].Direction = ParameterDirection.Output;
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_GetId", p);
return Convert.ToString(p[0].Value.ToString());
}
catch (Exception)
{
throw;
}
}
public DataSet GetTicketIdByTicketrefNo()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@PGMBRefNo", manabusRefNo);
p[1] = new SqlParameter("@Query", "GetByMBRefNo");
return ObjDAL.fnExecuteDataSet("Sp_TicketBookings", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetTicketIdByrefnoforcancel()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@MBRefNo", manabusRefNo);
p[1] = new SqlParameter("@createdBy", createdBy);
return ObjDAL.fnExecuteDataSet("Sp_PartialCancellationAdmin", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet UpdateSource(string status, string originalId, string modifiedId)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Query", "UpdateSource");
p[1] = new SqlParameter("@Status", status);
p[2] = new SqlParameter("@ID", originalId);
p[3] = new SqlParameter("@ModifiedID", modifiedId);
return ObjDAL.fnExecuteDataSet("Sp_Sources", p);
}
catch (Exception ex)
{
throw ex;
}
}
public string InsertEmpRequest(string name, string emailId, string org, string mobileNo, string city, string state, string comments, string District, string Type, string createdby, string appointmentdate, string status, string filename, string pathname, string filename1, string pathname1,string qualification,string address)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[20];
p[0] = new SqlParameter("@Flag", "Insert");
p[2] = new SqlParameter("@Name", name);
p[4] = new SqlParameter("@EmailId", emailId);
p[5] = new SqlParameter("@Organization", org);
p[6] = new SqlParameter("@MobileNo", mobileNo);
p[7] = new SqlParameter("@City", city);
p[8] = new SqlParameter("@State", state);
p[1] = new SqlParameter("@Comments", comments);
p[9] = new SqlParameter("@District", District);
p[10] = new SqlParameter("@Type", Type);
p[11] = new SqlParameter("@CreatedBy", createdby);
p[12] = new SqlParameter("@appointmentdate", appointmentdate);
p[13] = new SqlParameter("@status", status);
p[14] = new SqlParameter("@FileName", filename);
p[15] = new SqlParameter("@FilePath", pathname);
p[16] = new SqlParameter("@DocName", filename1);
p[17] = new SqlParameter("@DocPath", pathname);
p[18] = new SqlParameter("@Qualification", qualification);
p[19] = new SqlParameter("@Address", address);
p[3] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[3].Direction = ParameterDirection.Output;
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_AgentRequests", p);
return Convert.ToString(p[3].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public DataSet UpdateSourceStatus(string status, string id)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@Query", "UpdateStatus");
p[1] = new SqlParameter("@Status", status);
p[2] = new SqlParameter("@ID", id);
return ObjDAL.fnExecuteDataSet("Sp_Sources", p);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet SearchAgentBookedTicketsForAdminUser(int? userId)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[12];
p[0] = new SqlParameter("@DOJ", dateOFJourney);
p[1] = new SqlParameter("@DOI", dateOFBooking);
p[2] = new SqlParameter("@SourceName", sourceName);
p[3] = new SqlParameter("@DestinationName", destinationName);
p[4] = new SqlParameter("@EmailId", emailId);
p[5] = new SqlParameter("@OnewayMBRefNo", manabusRefNo);
p[6] = new SqlParameter("@TravelOpName", travelName);
p[7] = new SqlParameter("@ContactNo", mobileNo);
p[8] = new SqlParameter("@FullName", fullName);
p[9] = new SqlParameter("@Flag", "SearchAgentBookedTicketsForAdminUser");
p[10] = new SqlParameter("@AgentId", userId);
p[11] = new SqlParameter("@Status", status);
return ObjDAL.fnExecuteDataSet("sp_Agents", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public string AddAgent(string agentName, string type, DateTime dateOfBirth, string city, string state, string address, string pinCode
, string mobileNo, string alternateMobileNo, string landlineNo, string emailId, string panNo, string details, string status, string username
, string password, int createdBy, int modifiedBy, int commisionPercentage, string Role, string Country, string DomesticFlights, string InterNationalFlights, string Buses, string Hotels, string Recharge, string District)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[29];
p[0] = new SqlParameter("@AgentName", agentName);
p[1] = new SqlParameter("@Type", type);
p[2] = new SqlParameter("@DateOfBirth", dateOfBirth);
p[3] = new SqlParameter("@City", city);
p[4] = new SqlParameter("@State", state);
p[5] = new SqlParameter("@Address", address);
p[6] = new SqlParameter("@PinCode", pinCode);
p[7] = new SqlParameter("@MobileNo", mobileNo);
p[8] = new SqlParameter("@AlternateMobileNo", alternateMobileNo);
p[9] = new SqlParameter("@LandlineNo", landlineNo);
p[10] = new SqlParameter("@EmailId", emailId);
p[11] = new SqlParameter("@PANNo", panNo);
p[12] = new SqlParameter("@Details", details);
p[13] = new SqlParameter("@Status", status);
p[14] = new SqlParameter("@Username", username);
p[15] = new SqlParameter("@Password", password);
p[16] = new SqlParameter("@CreatedBy", createdBy);
p[17] = new SqlParameter("@ModifiedBy", modifiedBy);
p[18] = new SqlParameter("@Flag", "Insert");
p[19] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[19].Direction = ParameterDirection.Output;
p[20] = new SqlParameter("@CommisionPercentage", commisionPercentage);
p[21] = new SqlParameter("@Role", Role);
p[22] = new SqlParameter("@Country", Country);
p[23] = new SqlParameter("@DomesticFlights", DomesticFlights);
p[24] = new SqlParameter("@InterNationalFlights", InterNationalFlights);
p[25] = new SqlParameter("@Buses", Buses);
p[26] = new SqlParameter("@Hotels", Hotels);
p[27] = new SqlParameter("@Recharge", Recharge);
p[28] = new SqlParameter("@District", District);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_Agents", p);
return Convert.ToString(p[19].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public string UpdateAgentByAgent(string agentName, string type, DateTime dateOfBirth, string city, string state, string address, string pinCode
, string mobileNo, string alternateMobileNo, string landlineNo, string emailId, string panNo, string details, string status
, string password, int agentId, int modifiedBy, int commisionPercentage)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[21];
p[0] = new SqlParameter("@AgentName", agentName);
p[1] = new SqlParameter("@Type", type);
p[2] = new SqlParameter("@DateOfBirth", dateOfBirth);
p[3] = new SqlParameter("@City", city);
p[4] = new SqlParameter("@State", state);
p[5] = new SqlParameter("@Address", address);
p[6] = new SqlParameter("@PinCode", pinCode);
p[7] = new SqlParameter("@MobileNo", mobileNo);
p[8] = new SqlParameter("@AlternateMobileNo", alternateMobileNo);
p[9] = new SqlParameter("@LandlineNo", landlineNo);
p[10] = new SqlParameter("@EmailId", emailId);
p[11] = new SqlParameter("@PANNo", panNo);
p[12] = new SqlParameter("@Details", details);
p[13] = new SqlParameter("@Status", status);
p[14] = new SqlParameter("@Username", "");
p[15] = new SqlParameter("@Password", password);
p[16] = new SqlParameter("@AgentId", agentId);
p[17] = new SqlParameter("@ModifiedBy", modifiedBy);
p[18] = new SqlParameter("@Flag", "UpdateAgentByAgent");
p[19] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[19].Direction = ParameterDirection.Output;
p[20] = new SqlParameter("@CommisionPercentage", commisionPercentage);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_Agents", p);
return Convert.ToString(p[19].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public DataSet AddCancellation()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[11];
p[0] = new SqlParameter("@BookingId", bookingId);
p[1] = new SqlParameter("@TentativeId", tentativeId);
p[2] = new SqlParameter("@CancelledSeats", cancelSeats);
p[3] = new SqlParameter("@EmailId", emailId);
p[4] = new SqlParameter("@RefundAmount", refundAmount);
p[5] = new SqlParameter("@CancellationCharges", cancellationCharges);
p[6] = new SqlParameter("@CouponNo", couponNo);
p[7] = new SqlParameter("@Query", "Insert");
p[8] = new SqlParameter("@CreatedBy", createdBy);
p[9] = new SqlParameter("@APIName", APIName);
p[10] = new SqlParameter("@Time", Hours);
return ObjDAL.fnExecuteDataSet("Sp_Cancellation", p);
}
catch (Exception ex)
{
throw ex;
}
}
public string Updatecancelstatus(string Id,string status)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Query", "updatestatus");
p[1] = new SqlParameter("@ReferanceId", Id);
p[2] = new SqlParameter("@Status", status);
p[3] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[3].Direction = ParameterDirection.Output;
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_CarProvisional", p);
return Convert.ToString(p[3].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
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 string UpdateDepositRequest(int agentId, double depositAmount, string transactionId, string type, string depositBank,
string chequeDrawnBank, DateTime? chequeIssueDate, string chequeNo, int createdBy, int DepositedId, string details, string status)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[15];
p[0] = new SqlParameter("@Flag", "UpdateStatus");
p[1] = new SqlParameter("@AgentId", agentId);
p[2] = new SqlParameter("@DepositAmount", depositAmount);
p[3] = new SqlParameter("@TransactionId", transactionId);
p[4] = new SqlParameter("@Type", type);
p[5] = new SqlParameter("@DepositBank", depositBank);
p[6] = new SqlParameter("@ChequeDrawnBank", chequeDrawnBank);
p[7] = new SqlParameter("@ChequeIssueDate", chequeIssueDate);
p[8] = new SqlParameter("@ChequeNo", chequeNo);
p[9] = new SqlParameter("@CreatedBy", createdBy);
p[10] = new SqlParameter("@ModifiedBy", createdBy);
p[11] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[11].Direction = ParameterDirection.Output;
p[12] = new SqlParameter("@Id", DepositedId);
p[13] = new SqlParameter("@Details", details);
p[14] = new SqlParameter("@Status", status);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_AgentDepositRequests", p);
return Convert.ToString(p[11].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
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;
}
}
public string Updatedmr(int Id, string status)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@TableName", "Updatedmrstatus");
p[1] = new SqlParameter("@Id", Id);
p[2] = new SqlParameter("@Status", status);
p[3] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[3].Direction = ParameterDirection.Output;
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_dmr", p);
return Convert.ToString(p[3].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public DataTable AddDInternationalFlightBooking(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[24];
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("@AdultPax", objFlightBAL.AdultPax);
p[4] = new SqlParameter("@InfantPax", objFlightBAL.InfantPax);
p[5] = new SqlParameter("@ChildPax", objFlightBAL.ChildPax);
p[6] = new SqlParameter("@Origin_Destination_Id", objFlightBAL.Origin_Destination_Id);
p[7] = new SqlParameter("@Origin_Destination_Key", objFlightBAL.Origin_Destination_Key);
p[8] = new SqlParameter("@ActualBasefare", objFlightBAL.ActualBasefare);
p[9] = new SqlParameter("@Tax", objFlightBAL.Tax);
p[10] = new SqlParameter("@STax", objFlightBAL.STax);
p[11] = new SqlParameter("@Scharge", objFlightBAL.Scharge);
p[12] = new SqlParameter("@TDiscount", objFlightBAL.TDiscount);
p[13] = new SqlParameter("@TPartnerCommission", objFlightBAL.TPartnerCommission);
p[14] = new SqlParameter("@TCharge", objFlightBAL.TCharge);
p[15] = new SqlParameter("@TMarkUp", objFlightBAL.TMarkUp);
p[16] = new SqlParameter("@TSDiscount", objFlightBAL.TSDiscount);
p[17] = new SqlParameter("@tableName", "InsertIntFlightBooking");
p[18] = new SqlParameter("@CreatedBy", objFlightBAL.CreatedBy);
p[19] = new SqlParameter("@TripMode", objFlightBAL.TripMode);
p[20] = new SqlParameter("@Octax", objFlightBAL.ocTax);
p[21] = new SqlParameter("@Return1", objFlightBAL.Return);
p[22] = new SqlParameter("@id", objFlightBAL.id);
p[23] = new SqlParameter("@Key", objFlightBAL.key);
//p[18] = new SqlParameter("@FlightBookingID",SqlDbType.Int);
//p[18].Direction = ParameterDirection.Output;
return ObjDAL.fnExecuteDataSet("sp_InternationalFlightBooking", p).Tables[0];
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public void updaterc(string Id)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@Flag", "updaterc");
p[1] = new SqlParameter("@Id", Id);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_AgentRequests", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
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 DataSet GetTicketGooseDestinations(string sourceId)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@SourceId", sourceId);
return ObjDAL.fnExecuteDataSet("sp_GetTicketGooseDestinations", p);
}
catch (Exception ex)
{
throw ex;
}
}
