public bool UpdatePromoCodeStatus()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@PromoCodeId", ID);
p[1] = new SqlParameter("@Status", status);
p[2] = new SqlParameter("@ModifiedBy", modifiedBy);
p[3] = new SqlParameter("@Query", "Update");
Res = ObjDAL.fnExecuteStoredProcedure("Sp_PromoCode", p);
return Res;
}
catch (Exception ex)
{
throw ex;
}
}
public bool fnInsertRecord()
{
try
{
_objDataLayer = new clsDataLayer();
//Parameters = {new SqlParameter("","");new SqlParameter("","");}
switch (this.ScreenInd)
{
case Masters.Dmr:
_objDataLayer.fnExecuteStoredProcedure("sp_dmr", new SqlParameter("@TableName", "Insertdmr"),
new SqlParameter("@Amount", this.Amount1),
new SqlParameter("@Date", this.Date),
new SqlParameter("@Accountholdername", this.Accountholdername),
new SqlParameter("@Accountnumber", this.Accountnumber),
new SqlParameter("@IFSCCode", this.IFSCCode),
new SqlParameter("@BankName", this.BankName),
new SqlParameter("@BranchName", this.BranchName),
new SqlParameter("@SenderName", this.SenderName),
new SqlParameter("@MobileNumber", this.MobileNumber),
new SqlParameter("@Status", this.Status),
new SqlParameter("@Createdby", this.CreatedBy),
new SqlParameter("@Extracharges", this.ExtraCharges),
new SqlParameter("@AgentId", this.ID)
);
break;
case Masters.loginDetails:
_objDataLayer.fnExecuteStoredProcedure("sp_LoginDetails", new SqlParameter("@TableName", "insertlogindetails"),
new SqlParameter("@UserID", this.UserID));
break;
case Masters.AgentCommission:
_objDataLayer.fnExecuteStoredProcedure("sp_AgentCommission", new SqlParameter("@TableName", "InsertCommission"),
new SqlParameter("@NetworkName", this.NetworkName),
new SqlParameter("@OperatorType", this.OperatorType),
new SqlParameter("@ID", this.DistributorID),
new SqlParameter("@Type",this.Type),
new SqlParameter("@AgentCommission", this.AgentCommission));
break;
case Masters.ListOfAmounts:
_objDataLayer.fnExecuteStoredProcedure("sp_ListOfAmounts", new SqlParameter("@TableName", "InsertListOfAmount"),
new SqlParameter("@NetworkName", this.NetworkName),
new SqlParameter("@OperatorType", this.OperatorType),
new SqlParameter("@RechargeAmount", this.A_Amount),
new SqlParameter("@TalkTime", this.TalkTime));
break;
case Masters.AddAgentAmount:
_objDataLayer.fnExecuteStoredProcedure("sp_AddAgentAmount",
new SqlParameter("@UserID", this.UserID),
// new SqlParameter("@AgentName",this.Agentname),
new SqlParameter("@Amount", this.A_Amount),
new SqlParameter("@Description", this.Description),
new SqlParameter("@CreatedBy", this.CreatedBy));
break;
case Masters.Agentregistration:
_objDataLayer.fnExecuteStoredProcedure("spAgentMst",
new SqlParameter("@UserID", this.UserID),
new SqlParameter("@EmailID", this.EmailID),
new SqlParameter("@Password", this.Password),
new SqlParameter("@Title", this.Title),
new SqlParameter("@FirstName", this.FirstName),
new SqlParameter("@LastName", this.LastName),
new SqlParameter("@Mobile", this.Mobile),
new SqlParameter("@DOB", this.DOB),
new SqlParameter("@Address", this.Address),
// new SqlParameter("@A_Amount",this.A_Amount),
new SqlParameter("@Pincode", this.Pincode),
new SqlParameter("@Landline", this.Landline),
new SqlParameter("@Fax", this.Fax),
new SqlParameter("@Country", this.CountryName),
new SqlParameter("@State", this.Statename),
new SqlParameter("@City", this.cityname),
new SqlParameter("@UserType",this.UserType),
new SqlParameter("@Status", this.Status),
new SqlParameter("@DistributorID", this.DistributorID)
);
break;
case Masters.Insertcontent:
_objDataLayer.fnExecuteStoredProcedure("sp_updateofferContent", new SqlParameter("@TableName", "InsertContent"),
new SqlParameter("@Content", this.Content),
new SqlParameter("@ImagePath", this.ImageName));
break;
case Masters.Country:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbCountryMst"),
new SqlParameter("@Description", this.Description));
break;
case Masters.State:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbStateMst"),
new SqlParameter("@Description", this.Description),
new SqlParameter("@RefID", this.RefID));
break;
case Masters.CityType:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbCityTypeMst"),
new SqlParameter("@Description", this.Description));
break;
case Masters.City:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbCityMst"),
new SqlParameter("@Description", this.Description),
new SqlParameter("@RefID", this.RefID),
new SqlParameter("@CTTCode", this.CityType));
break;
case Masters.UserMst: _objDataLayer.fnExecuteStoredProcedure("spUserMst",
new SqlParameter("@UserID", this.UserID),
new SqlParameter("@EmailID", this.EmailID),
new SqlParameter("@Password", this.Password),
new SqlParameter("@MobileNumber", this.Mobile_Num),
new SqlParameter("@State", this.Statename),
new SqlParameter("@City", this.cityname),
new SqlParameter("@FirstName", this.FirstName),
new SqlParameter("@PostalCode", this.PostalCode),
new SqlParameter("@Country", this.CountryName),
new SqlParameter("@Address", this.Address)
);
break;
case Masters.Mobile:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbMobile"),
new SqlParameter("@MobileNo", this.Mobile_Num),
new SqlParameter("@RefID", this.UserID),
new SqlParameter("@Type",this.Type),
new SqlParameter("@Provider_Name", this.Provider_Name),
new SqlParameter("@Amount", this.Amount),
new SqlParameter("@E_Mail", this.E_Mail),
new SqlParameter("@Payment", this.Payment),
new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Status", this.Status),
new SqlParameter("@CreatedBy", this.CreatedBy),
new SqlParameter("@ModifiedBy", this.ModifiedBy),
new SqlParameter("@ModifiedDate", this.ModifiedDate)
);
break;
case Masters.Mobilenew:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbMobilefornonREG"),
new SqlParameter("@MobileNo", this.Mobile_Num),
new SqlParameter("@Provider_Name", this.Provider_Name),
new SqlParameter("@Amount", this.Amount),
new SqlParameter("@E_Mail", this.E_Mail),
new SqlParameter("@Payment", this.Payment),
new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@IP", this.IP),
new SqlParameter("@Status", this.Status),
new SqlParameter("@Name", this.Name),
new SqlParameter("@GuestAddress", this.Address),
new SqlParameter("@State", this.Statename),
new SqlParameter("@City", this.cityname),
new SqlParameter("@PostalCode",this.PostalCode),
new SqlParameter("@Country", this.CountryName),
new SqlParameter("@CreatedBy", this.CreatedBy),
new SqlParameter("@ModifiedBy", this.ModifiedBy),
new SqlParameter("@ModifiedDate", this.ModifiedDate)
);
break;
case Masters.D2H:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbD2H"),
new SqlParameter("@Customer_ID", this.Customer_ID),
new SqlParameter("@Provider_Name", this.Provider_Name),
new SqlParameter("@Amount", this.Amount),
new SqlParameter("@E_Mail", this.E_Mail),
new SqlParameter("@Payment", this.Payment),
new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Status", this.Status),
new SqlParameter("@Name", this.Name),
new SqlParameter("@GuestAddress", this.Address),
new SqlParameter("@State", this.Statename),
new SqlParameter("@City", this.cityname),
new SqlParameter("@PostalCode", this.PostalCode),
new SqlParameter("@Country", this.CountryName),
new SqlParameter("@CreatedBy", this.CreatedBy),
new SqlParameter("@ModifiedBy", this.ModifiedBy),
new SqlParameter("@ModifiedDate", this.ModifiedDate)
);
break;
case Masters.D2Hnew:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbD2HRecharge"),
new SqlParameter("@Customer_ID", this.Customer_ID),
new SqlParameter("@Provider_Name", this.Provider_Name),
new SqlParameter("@RefID", this.UserID),
new SqlParameter("@Type", this.Type),
new SqlParameter("@Amount", this.Amount),
new SqlParameter("@E_Mail", this.E_Mail),
new SqlParameter("@Payment", this.Payment),
new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@Commission1", this.Commission1),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Status", this.Status),
new SqlParameter("@CreatedBy", this.CreatedBy));
// new SqlParameter("@ModifiedBy", this.ModifiedBy),
// new SqlParameter("@ModifiedDate", this.ModifiedDate)
break;
case Masters.DataCardnew:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbDataCardforNonReg"),
new SqlParameter("@MobileNo", this.Mobile),
new SqlParameter("@Provider_Name", this.Provider_Name),
new SqlParameter("@RefID", this.UserID),
new SqlParameter("@Amount", this.Amount),
new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@E_Mail", this.E_Mail),
new SqlParameter("@Payment", this.Payment),
new SqlParameter("@Name", this.Name),
new SqlParameter("@GuestAddress", this.Address),
new SqlParameter("@State", this.Statename),
new SqlParameter("@City", this.cityname),
new SqlParameter("@PostalCode", this.PostalCode),
new SqlParameter("@Country", this.CountryName),
//new SqlParameter("@Commission1", this.Commission1),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Status", this.Status),
new SqlParameter("@CreatedBy", this.CreatedBy));
// new SqlParameter("@ModifiedBy", this.ModifiedBy),
// new SqlParameter("@ModifiedDate", this.ModifiedDate)
break;
case Masters.DataCard:
_objDataLayer.fnExecuteStoredProcedure("spInsertMstData", new SqlParameter("@TableName", "tbDataCard"),
new SqlParameter("@MobileNo", this.Mobile),
new SqlParameter("@RefID", this.UserID),
new SqlParameter("@Type", this.Type),
new SqlParameter("@Provider_Name", this.Provider_Name),
new SqlParameter("@Amount", this.Amount),
new SqlParameter("@E_Mail", this.E_Mail),
new SqlParameter("@Payment", this.Payment),
new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Status", this.Status),
new SqlParameter("@CreatedBy", this.CreatedBy));
// new SqlParameter("@ModifiedBy", this.ModifiedBy),
// new SqlParameter("@ModifiedDate", this.ModifiedDate)
break;
case Masters.ImageUpload:
_objDataLayer.fnExecuteStoredProcedure("sp_Insert_Adv_Images", new SqlParameter("@ImageName", this.ImageName),
new SqlParameter("@Image", SqlDbType.Image),
new SqlParameter("@CreatedBy", this.CreatedBy)
);
break;
case Masters.Advertisement:
_objDataLayer.fnExecuteStoredProcedure("sp_Insert_Advertisement", new SqlParameter("@ScreenName", this.ScreenName),
new SqlParameter("@Advertisement", this.Advertisement),
new SqlParameter("@imgID", this.imgID)
);
break;
case Masters.InsertTarrif:
_objDataLayer.fnExecuteStoredProcedure("sp_insertTarrif", new SqlParameter("@OperatorsID", this.OperatorsID),
new SqlParameter("@Denomination", this.Denomination),
new SqlParameter("@TalkTime", this.TalkTime),
new SqlParameter("@Validity", this.Validity),
new SqlParameter("@Description", this.Description)
);
break;
case Masters.LogError:
_objDataLayer.fnExecuteStoredProcedure("sp_insert_LogError", new SqlParameter("@ScreenName", this.ScreenName),
new SqlParameter("@MethodName", this.MethodName),
new SqlParameter("@Time", this.Time),
new SqlParameter("@Exception", this.Exception)
);
break;
case Masters.paymentdetails:
_objDataLayer.fnExecuteStoredProcedure("sprechargepayment", new SqlParameter("@UserID", this.UserID),
new SqlParameter("@MerchantID", this.MerchantID),
new SqlParameter("@SubscriberID", this.SubscriberID),
new SqlParameter("@TrxReferenceNO", this.TrxReferenceNo),
new SqlParameter("@BankReferenceNO", this.BankReferenceNo),
new SqlParameter("@TxnAmount", this.TxnAmount),
new SqlParameter("@BankID", this.BankID),
new SqlParameter("@BankMerchantID", this.BankMerchantID),
new SqlParameter("@TCNTYpe", this.TCNTYpe),
new SqlParameter("@CurrencyName", this.CurrencyName),
new SqlParameter("@ItemCode", this.ItemCode),
new SqlParameter("@SecurityType", this.SecurityType),
new SqlParameter("@SecurityID", this.SecurityID),
new SqlParameter("@SecurityPassword", this.SecurityPassword),
new SqlParameter("@TxnDate", this.TxnDate),
new SqlParameter("@AuthStatus", this.AuthStatus),
new SqlParameter("@SettlementType", this.SettlementType),
new SqlParameter("@AdditionalInfo1", this.AdditionalInfo1),
new SqlParameter("@AdditionalInfo2", this.AdditionalInfo2),
new SqlParameter("@AdditionalInfo3", this.AdditionalInfo3),
new SqlParameter("@AdditionalInfo4", this.AdditionalInfo4),
new SqlParameter("@AdditionalInfo5", this.AdditionalInfo5),
new SqlParameter("@AdditionalInfo6", this.AdditionalInfo6),
new SqlParameter("@AdditionalInfo7", this.AdditionalInfo7),
new SqlParameter("@ErrorStatus", this.ErrorStatus),
new SqlParameter("@ErrorDescription", this.ErrorDescription),
new SqlParameter("@CheckSum", this.CheckSum)
);
break;
case Masters.Operators:
_objDataLayer.fnExecuteStoredProcedure("sp_OperatorsDetails", new SqlParameter("@TableName", "insertOPERATOR"),
new SqlParameter("@NetworkName", this.NetworkName),
new SqlParameter("@OperatorKeyword", this.OperatorKeyword),
new SqlParameter("@OperatorType", this.OperatorType),
new SqlParameter("@TypeOfTransaction",this.TypeOftransactionId)
);
break;
case Masters.EWallet:
_objDataLayer.fnExecuteStoredProcedure("sp_EWallet", new SqlParameter("@UserID", this.UserID),
new SqlParameter("@Parameter", this.Parameter),
new SqlParameter("@OrderID", this.RequestID),
new SqlParameter("@MobileNumber", this.MobileNum),
new SqlParameter("@Amount", this.Amount1)
);
break;
case Masters.Coupon:
_objDataLayer.fnExecuteStoredProcedure("spCouponCodes", new SqlParameter("@Type", "Insert"),
new SqlParameter("@CouponNumber", this.Coupon),
new SqlParameter("@Discount", this.Discount)
);
break;
case Masters.addewalletamounttouser:
_objDataLayer.fnExecuteStoredProcedure("sp_AddEwalletAmounttoUser", new SqlParameter("@UserID", this.UserID),
new SqlParameter("@Parameter","Insert"),
new SqlParameter("@OrderID", this.RequestID),
new SqlParameter("@MobileNumber", this.MobileNum),
new SqlParameter("@Amount", this.Amount1),
new SqlParameter("@ID", this.ID)
);
break;
case Masters.adjustewalletamounttouser:
_objDataLayer.fnExecuteStoredProcedure("sp_AddEwalletAmounttoUser", new SqlParameter("@UserID", this.UserID),
new SqlParameter("@Parameter", "InsertAdjustAmount"),
new SqlParameter("@OrderID", this.RequestID),
new SqlParameter("@MobileNumber", this.MobileNum),
new SqlParameter("@Amount", this.Amount1),
new SqlParameter("@ID", this.ID)
);
break;
}
return true;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
}
public bool fnUserInfo(ref int intUserID)
{
try
{
_objDataLayer = new clsDataLayer();
if (this.strUserInd == "Insert")
{
SqlParameter spUserID = new SqlParameter();
spUserID.ParameterName = "@NewID";
spUserID.SqlDbType = SqlDbType.Int;
spUserID.Direction = ParameterDirection.Output;
_objDataLayer.fnExecuteStoredProcedure("spUserMst", new SqlParameter("@UserID", 0),
new SqlParameter("@UserName", this.strUserName),
new SqlParameter("@Password", this.strPassword),
new SqlParameter("@UserType", this.strUserType),
new SqlParameter("@VBalance", this.intVBalance),
new SqlParameter("@Active", this.intActive),
spUserID);
intUserID = int.Parse(spUserID.Value.ToString());
}
else if (this.strUserInd == "Update")
{
int len = 1;
if (this.strPassword != null)
{
len = len + 1;
}
if (this.strUserType != null)
{
len = len + 1;
}
if (this.intVBalance != -100)
{
len = len + 1;
}
if (this.intActive != -100)
{
len = len + 1;
}
SqlParameter[] _params = new SqlParameter[len];
len = 0;
if (this.strPassword != null)
{
_params[len] = new SqlParameter("@UserID", this.RefID);
len = len + 1;
}
if (this.strUserType != null)
{
_params[len] = new SqlParameter("@UserType", this.strUserType);
len = len + 1;
}
if (this.intVBalance != -100)
{
_params[len] = new SqlParameter("@VBalance", this.intVBalance);
len = len + 1;
}
if (this.intActive != -100)
{
_params[len] = new SqlParameter("@Active", this.intActive);
len = len + 1;
}
_objDataLayer.fnExecuteStoredProcedure("spUserMst", _params);
}
return true;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
}
public bool AddDomesticFlightBookingsegments(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[35];
p[0] = new SqlParameter("@AirEquipType", objFlightBAL.AirEquipType);
p[1] = new SqlParameter("@ArrivalAirportCode", objFlightBAL.ArrivalAirportCode);
p[2] = new SqlParameter("@ArrivalDateTime", objFlightBAL.ArrivalDateTime);
p[3] = new SqlParameter("@DepartureAirportCode", objFlightBAL.DepartureAirportCode);
p[4] = new SqlParameter("@DepartureDateTime", objFlightBAL.DepartureDateTime);
p[5] = new SqlParameter("@FlightNumber", objFlightBAL.FlightNumber);
p[6] = new SqlParameter("@OperatingAirlineCode", objFlightBAL.OperatingAirlineCode);
p[7] = new SqlParameter("@OperatingAirlineFlightNumber", objFlightBAL.OperatingAirlineFlightNumber);
p[8] = new SqlParameter("@RPH", objFlightBAL.RPH);
p[9] = new SqlParameter("@StopQuantity", objFlightBAL.StopQuantity);
p[10] = new SqlParameter("@airlineName", objFlightBAL.airlineName);
p[11] = new SqlParameter("@airportTax", objFlightBAL.airportTax);
p[12] = new SqlParameter("@imageFileName", objFlightBAL.imageFileName);
p[13] = new SqlParameter("@Discount", objFlightBAL.Discount);
p[14] = new SqlParameter("@airportTaxChild", objFlightBAL.airportTaxChild);
p[15] = new SqlParameter("@airportTaxInfant", objFlightBAL.airportTaxInfant);
p[16] = new SqlParameter("@adultTaxBreakUp", objFlightBAL.adultTaxBreakUp);
p[17] = new SqlParameter("@ChildTaxBreakUp", objFlightBAL.ChildTaxBreakUp);
p[18] = new SqlParameter("@InfantTaxBreakUp", objFlightBAL.InfantTaxBreakUp);
p[19] = new SqlParameter("@ocTax", objFlightBAL.ocTax);
p[20] = new SqlParameter("@Availability", (objFlightBAL.Availability == "") ? 0 : Convert.ToInt32(objFlightBAL.Availability));
p[21] = new SqlParameter("@ResBookingCode", objFlightBAL.ResBookingCode);
p[22] = new SqlParameter("@adultFare",(objFlightBAL.adultFare == "") ? 0 : Convert.ToDecimal(objFlightBAL.adultFare));
p[23] = new SqlParameter("@bookingClass", objFlightBAL.bookingClass);
p[24] = new SqlParameter("@ChildFare", (objFlightBAL.ChildFare == "") ? 0 : Convert.ToDecimal(objFlightBAL.ChildFare));
p[25] = new SqlParameter("@ClassType", objFlightBAL.ClassType);
p[26] = new SqlParameter("@farebasisCode", objFlightBAL.farebasisCode);
p[27] = new SqlParameter("@infantFare", (objFlightBAL.infantFare == "" ) ? 0 : Convert.ToDecimal(objFlightBAL.infantFare));
p[28] = new SqlParameter("@Fare_Rule", objFlightBAL.Fare_Rule);
p[29] = new SqlParameter("@adultCommission",(objFlightBAL.adultCommission == "") ? 0 : Convert.ToDecimal(objFlightBAL.adultCommission));
p[30] = new SqlParameter("@childCommission", (objFlightBAL.childCommission == "") ? 0 : Convert.ToDecimal(objFlightBAL.childCommission));
p[31] = new SqlParameter("@CommissionOnTCharge", (objFlightBAL.CommissionOnTCharge == "") ? 0 :Convert.ToDecimal(objFlightBAL.CommissionOnTCharge));
p[32] = new SqlParameter("@FlightBookingID", Convert.ToInt32(objFlightBAL.FlightBookingID));
p[33] = new SqlParameter("@tableName", "InsertDomFlightBookingsements");
p[34] = new SqlParameter("@CreatedBy", objFlightBAL.CreatedBy);
return ObjDAL.fnExecuteStoredProcedure("sp_DomesticFlightBookingsegments", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public bool CancelDomesticFlightBooking(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@tableName", "InsertDomFlightCancel");
p[1] = new SqlParameter("@TransId", objFlightBAL.TransId);
p[2] = new SqlParameter("@Status", objFlightBAL.Status);
p[3] = new SqlParameter("@remarks", objFlightBAL.remarks);
p[4] = new SqlParameter("@TicketDetails", objFlightBAL.TicketDetails);
p[5] = new SqlParameter("@CancelId", objFlightBAL.CancelId);
p[6] = new SqlParameter("@ReferenceNo", objFlightBAL.ReferenceNo);
p[7] = new SqlParameter("@CreatedBy", objFlightBAL.CreatedBy);
p[8] = new SqlParameter("@Reason", objFlightBAL.Reason);
return ObjDAL.fnExecuteStoredProcedure("sp_DomesticFlightCancel", 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 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 bool AddBookings()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[27];
p[0] = new SqlParameter("@ManabusRefNo", manabusRefNo);
p[1] = new SqlParameter("@TicketId", ticketId);
p[2] = new SqlParameter("@APIName", api);
p[3] = new SqlParameter("@TravelName", travelName);
p[4] = new SqlParameter("@BusType", busType);
p[5] = new SqlParameter("@SourceId", sourceId);
p[6] = new SqlParameter("@DestinationId", destionationId);
p[7] = new SqlParameter("@SourceName", sourceName);
p[8] = new SqlParameter("@DestinationName", destinationName);
p[9] = new SqlParameter("@DateOfJourney", dateOFJourney);
p[11] = new SqlParameter("@BoardingPoint", boardingPoint);
p[12] = new SqlParameter("@BookedSeats", bookedSeats);
p[13] = new SqlParameter("@TotalFare", totalFare);
p[14] = new SqlParameter("@FullName", fullName);
p[15] = new SqlParameter("@Age", age);
p[16] = new SqlParameter("@MobileNo", mobileNo);
p[17] = new SqlParameter("@AlternativeMobileNo", alternativeMobileNo);
p[18] = new SqlParameter("@EmailId", emailId);
p[19] = new SqlParameter("@Address", addrress);
p[20] = new SqlParameter("@PassengersNames", passengersName);
p[21] = new SqlParameter("@Gender", gender);
p[22] = new SqlParameter("@DeliveryType", deliveryType);
p[23] = new SqlParameter("@PaymentType", paymentType);
p[24] = new SqlParameter("@CashCouponNo", couponNo);
p[25] = new SqlParameter("@CreatedBy", createdBy);
p[26] = new SqlParameter("@Query", "Insert");
return ObjDAL.fnExecuteStoredProcedure("Sp_Bookings", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddBooking_TicketDetails()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[6];
p[0] = new SqlParameter("@PNRNumber", PNRNumber);
p[1] = new SqlParameter("@PNRTicketIDs", PNRTicketIDs);
p[2] = new SqlParameter("@Message", message);
p[3] = new SqlParameter("@PGMBRefNo", manabusRefNo);
p[4] = new SqlParameter("@Query", "Insert1");
p[5] = new SqlParameter("@APIName", api);
return ObjDAL.fnExecuteStoredProcedure("Sp_TicketBookings", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddBitlaDestinations(string id, string name, string cityId)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@id", id);
p[1] = new SqlParameter("@name", name);
p[2] = new SqlParameter("@cityid", cityId);
p[3] = new SqlParameter("@flag", "Insert");
return ObjDAL.fnExecuteStoredProcedure("sp_BitlaDestinations", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddBitlaRoutes(
string id, string number, string name
, string operator_service_name, string origin, string destination
, string origin_id, string destination_id, string reservation_id
, string operator_route_id, string travel_id, string travels
, string bus_type, string bus_type_id, string dep_time
, string arr_time, string duration, string available_seats
, string total_seats, string seat_type_detail, string fare_str
, string is_cancellable, string commission, string status
, string JourneyDate
)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[26];
p[0] = new SqlParameter("@id", id);
p[1] = new SqlParameter("@number", number);
p[2] = new SqlParameter("@name", name);
p[3] = new SqlParameter("@operator_service_name", operator_service_name);
p[4] = new SqlParameter("@origin", origin);
p[5] = new SqlParameter("@destination", destination);
p[6] = new SqlParameter("@origin_id", origin_id);
p[7] = new SqlParameter("@destination_id", destination_id);
p[8] = new SqlParameter("@reservation_id", reservation_id);
p[9] = new SqlParameter("@operator_route_id", operator_route_id);
p[10] = new SqlParameter("@travel_id", travel_id);
p[11] = new SqlParameter("@travels", travels);
p[12] = new SqlParameter("@bus_type", bus_type);
p[13] = new SqlParameter("@bus_type_id", bus_type_id);
p[14] = new SqlParameter("@dep_time", dep_time);
p[15] = new SqlParameter("@arr_time", arr_time);
p[16] = new SqlParameter("@duration", duration);
p[17] = new SqlParameter("@available_seats", available_seats);
p[18] = new SqlParameter("@total_seats", total_seats);
p[19] = new SqlParameter("@seat_type_detail", seat_type_detail);
p[20] = new SqlParameter("@fare_str", fare_str);
p[21] = new SqlParameter("@is_cancellable", is_cancellable);
p[22] = new SqlParameter("@commission", commission);
p[23] = new SqlParameter("@status", status);
p[24] = new SqlParameter("@JourneyDate", JourneyDate);
p[25] = new SqlParameter("@flag", "Insert");
return ObjDAL.fnExecuteStoredProcedure("sp_BitlaRoutes", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateUser()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[7];
p[0] = new SqlParameter("@ID", ID);
p[1] = new SqlParameter("@UserName", userName);
p[2] = new SqlParameter("@Password", password);
p[3] = new SqlParameter("@Name", name);
p[4] = new SqlParameter("@RoleID", roleId);
p[5] = new SqlParameter("@ModifiedBy", modifiedBy);
p[6] = new SqlParameter("@Query", "Update");
return ObjDAL.fnExecuteStoredProcedure("Sp_Users", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateRole()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Role", role);
p[1] = new SqlParameter("@ModifiedBy", modifiedBy);
p[2] = new SqlParameter("@Query", "Update");
p[3] = new SqlParameter("@ID", ID);
return ObjDAL.fnExecuteStoredProcedure("Sp_RoleMaster", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateRating(int rating, int id)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@Id", id);
p[1] = new SqlParameter("@Rating", rating);
p[2] = new SqlParameter("@Query", "Update");
return ObjDAL.fnExecuteStoredProcedure("Sp_Rating", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool fnInsertRecord()
{
try
{
_objDataLayer = new clsDataLayer();
switch (this.ScreenInd)
{
case blossom.InsertEmployee:
_objDataLayer.fnExecuteStoredProcedure("SP_Employee", new SqlParameter("@Query", "Insert"),
new SqlParameter("@EmpName", this.EmpName),
new SqlParameter("@phoneNo", this.PhoneNo),
new SqlParameter("@Email", this.Email),
new SqlParameter("@Address", this.Address));
break;
case blossom.InsertHotelPolicy:
_objDataLayer.fnExecuteStoredProcedure("SP_HotelPolicy", new SqlParameter("@Query", "Insert"),
new SqlParameter("@Details", this.HotelDetails));
break;
case blossom.InsertCab:
_objDataLayer.fnExecuteStoredProcedure("SP_Cab", new SqlParameter("@Query", "Insert"),
new SqlParameter("@CabType", this.CabType),
new SqlParameter("@Travels", this.Travels),
new SqlParameter("@Price", this.Price),
new SqlParameter("@City", this.City),
new SqlParameter("@HiringFor", this.HiringFor));
break;
case blossom.InsertCity:
_objDataLayer.fnExecuteStoredProcedure("SP_City", new SqlParameter("@Query", "Insert"),
new SqlParameter("@CityName", this.CityName),
new SqlParameter("@CreatedBy", this.CreatedBy));
break;
case blossom.InsertCar:
_objDataLayer.fnExecuteStoredProcedure("SP_Car", new SqlParameter("@Query", "Insert"),
new SqlParameter("@CarName", this.CarName),
new SqlParameter("@CarImagePath",this.carimagepath),
new SqlParameter("@CreatedBy", this.CreatedBy));
break;
case blossom.InsertCarDetailsForCity:
_objDataLayer.fnExecuteStoredProcedure("SP_CarDetailsForCity", new SqlParameter("@Query", "Insert"),
new SqlParameter("@CityId",this.CityId),
new SqlParameter("@CarId",this.CarId),
new SqlParameter("@BasicPrice", this.BasicPrice),
new SqlParameter("@ExtarHours", this.ExtarHours),
new SqlParameter("@ExtarKilometers", this.ExtarKilometers),
new SqlParameter("@Usage",this.usage),
new SqlParameter("@Capacity",this.Limit),
new SqlParameter("@Status",this.Status),
new SqlParameter("@BookingType",this.BookingType),
new SqlParameter("@CreatedBy", this.CreatedBy));
break;
case blossom.InsertPassengerDetails:
_objDataLayer.fnExecuteStoredProcedure("sp_CarProvisional", new SqlParameter("@Query", "Insert"),
new SqlParameter("@TravelDate", this.TravelDate),
new SqlParameter("@CarDetailsId", this.CarDetailsId),
new SqlParameter("@Name", this.Name),
new SqlParameter("@Address", this.Address),
new SqlParameter("@City", this.City),
new SqlParameter("@State", this.State),
new SqlParameter("@ZipCode", this.ZipCode),
new SqlParameter("@Country", this.Country),
new SqlParameter("@EmailId", this.EmailId),
new SqlParameter("@MobileNo", this.MobileNo),
new SqlParameter("@LandMark", this.LandMark),
new SqlParameter("@Status",this.Status),
new SqlParameter("@PickupTime", this.PickUpTime),
new SqlParameter("@CarName", this.CarName),
new SqlParameter("@BasicFare", this.Basicfare),
new SqlParameter("@AgentId", this.AgentId),
new SqlParameter("@AgentName", this.AgentName),
new SqlParameter("@Role", this.Role),
new SqlParameter("@TotalFare",this.TotalFare),
new SqlParameter("@ReferanceId",this.ReferanceId),
new SqlParameter("@CreatedBy", this.CreatedBy));
break;
}
return true;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
}
public bool AddBusHire(string description)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[8];
p[0] = new SqlParameter("@Name", name);
p[1] = new SqlParameter("@EmailId", emailId);
p[2] = new SqlParameter("@MobileNo", mobileNo);
p[3] = new SqlParameter("@Source", sourceName);
p[4] = new SqlParameter("@Destination", destinationName);
p[5] = new SqlParameter("@NoOfSeats", noOfSeats);
p[6] = new SqlParameter("@Query", "Insert");
p[7] = new SqlParameter("@Description", description);
return ObjDAL.fnExecuteStoredProcedure("Sp_BusHire", p);
}
catch (Exception ex)
{
throw ex;
}
}
public bool fnUpdateRecord()
{
try
{
_objDataLayer = new clsDataLayer();
switch (this.ScreenInd)
{
case blossom.UpdateEmployee:
_objDataLayer.fnExecuteStoredProcedure("SP_Employee", new SqlParameter("@Query", "Update"),
new SqlParameter("@EmpId", this.EmpId),
new SqlParameter("@EmpName", this.EmpName),
new SqlParameter("@phoneNo", this.PhoneNo),
new SqlParameter("@Email", this.Email),
new SqlParameter("@Address", this.Address));
break;
case blossom.UpdateHotelPolicy:
_objDataLayer.fnExecuteStoredProcedure("SP_HotelPolicy", new SqlParameter("@Query", "Update"),
new SqlParameter("@HotelId", this.HotelId),
new SqlParameter("@Details", this.HotelDetails));
break;
case blossom.UpdateCab:
_objDataLayer.fnExecuteStoredProcedure("SP_Cab", new SqlParameter("@Query", "Update"),
new SqlParameter("@CabId", this.CarId),
new SqlParameter("@CabType", this.CabType),
new SqlParameter("@Travels", this.Travels),
new SqlParameter("@Price", this.Price),
new SqlParameter("@City", this.City),
new SqlParameter("@HiringFor", this.HiringFor));
break;
case blossom.UpdateCity:
_objDataLayer.fnExecuteStoredProcedure("SP_City", new SqlParameter("@Query", "Update"),
new SqlParameter("@CityName", this.CityName),
new SqlParameter("@CityId", this.CityId),
new SqlParameter("@ModifiedBy", this.ModifiedBy));
break;
case blossom.UpdateCar:
_objDataLayer.fnExecuteStoredProcedure("SP_Car", new SqlParameter("@Query", "Update"),
new SqlParameter("@CarName", this.CarName),
new SqlParameter("@CarImagePath",this.carimagepath),
new SqlParameter("@CarId", this.CarId),
new SqlParameter("@ModifiedBy", this.ModifiedBy));
break;
case blossom.UpdateCarDetailsForCity:
_objDataLayer.fnExecuteStoredProcedure("SP_CarDetailsForCity", new SqlParameter("@Query", "Update"),
new SqlParameter("@CityId", this.CityId),
new SqlParameter("@CarId", this.CarId),
new SqlParameter("@BasicPrice", this.BasicPrice),
new SqlParameter("@ExtarHours", this.ExtarHours),
new SqlParameter("@ExtarKilometers", this.ExtarKilometers),
new SqlParameter("@Usage", this.usage),
new SqlParameter("@Capacity", this.Limit),
new SqlParameter("@CarDetailsId", this.CarDetailsId),
new SqlParameter("@ModifiedBy", this.ModifiedBy));
break;
}
return true;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
}
public bool AddBusOperator(string name, string apiName)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@BusOperatorName", name);
p[1] = new SqlParameter("@Query", "Insert");
p[2] = new SqlParameter("@APIName", apiName);
return ObjDAL.fnExecuteStoredProcedure("Sp_BusOperator", p);
}
catch (Exception ex)
{
throw ex;
}
}
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 AddCancelPolicy()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] q = new SqlParameter[5];
q[0] = new SqlParameter("@APIName", api);
q[1] = new SqlParameter("@CancelPercentage", percentage);
q[2] = new SqlParameter("@Query", "Insert");
q[3] = new SqlParameter("@BeforeTime", beforeTime);
q[4] = new SqlParameter("@OperatorID", ID);
Res = ObjDAL.fnExecuteStoredProcedure("Sp_CancelPolicy", q);
return Res;
}
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);
}
}
public bool AddCashCoupon(ref Label lblMsg)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@CouponNo", couponNo);
p[1] = new SqlParameter("@EmailId", emailId);
p[2] = new SqlParameter("@Amount", Amount);
p[3] = new SqlParameter("@CreatedBy", createdBy);
p[4] = new SqlParameter("@Result", SqlDbType.VarChar, 100);
p[4].Direction = ParameterDirection.Output;
p[5] = new SqlParameter("@Query", "Insert");
p[6] = new SqlParameter("@OperaterName", name);
p[7] = new SqlParameter("@MinAmount", MinAmount);
p[8] = new SqlParameter("@MaxAmount", MaxAmount);
Res = ObjDAL.fnExecuteStoredProcedure("Sp_CashCoupon", p);
lblMsg.Text = Convert.ToString(p[4].Value);
return Res;
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddInternationalFlightSegment(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[44];
p[0] = new SqlParameter("@AirEquipType", objFlightBAL.AirEquipType);
p[1] = new SqlParameter("@ArrivalAirportCode", objFlightBAL.ArrivalAirportCode);
p[2] = new SqlParameter("@ArrivalDateTime", objFlightBAL.ArrivalDateTime);
p[3] = new SqlParameter("@DepartureAirportCode", objFlightBAL.DepartureAirportCode);
p[4] = new SqlParameter("@DepartureDateTime", objFlightBAL.DepartureDateTime);
p[5] = new SqlParameter("@FlightNumber", objFlightBAL.FlightNumber);
p[6] = new SqlParameter("@MarketingAirlineCode", objFlightBAL.MarketingAirlineCode);
p[7] = new SqlParameter("@OperatingAirlineCode", objFlightBAL.OperatingAirlineCode);
p[8] = new SqlParameter("@OperatingAirlineName", objFlightBAL.OperatingAirlineName);
p[9] = new SqlParameter("@OperatingAirlineFlightNumber", objFlightBAL.OperatingAirlineFlightNumber);
p[10] = new SqlParameter("@NumStops", objFlightBAL.NumStops);
p[11] = new SqlParameter("@LinkSellAgrmnt", objFlightBAL.LinkSellAgrmnt);
p[12] = new SqlParameter("@Conx", objFlightBAL.Conx);
p[13] = new SqlParameter("@AirpChg", objFlightBAL.AirpChg);
p[14] = new SqlParameter("@InsideAvailOption", objFlightBAL.InsideAvailOption);
p[15] = new SqlParameter("@GenTrafRestriction", objFlightBAL.GenTrafRestriction);
p[16] = new SqlParameter("@DaysOperates", objFlightBAL.DaysOperates);
p[17] = new SqlParameter("@JrnyTm", objFlightBAL.JrnyTm);
p[18] = new SqlParameter("@EndDt", objFlightBAL.EndDt);
p[19] = new SqlParameter("@StartTerminal", objFlightBAL.StartTerminal);
p[20] = new SqlParameter("@EndTerminal", objFlightBAL.EndTerminal);
p[21] = new SqlParameter("@FltTm", objFlightBAL.FltTm);
p[22] = new SqlParameter("@LSAInd", objFlightBAL.LSAInd);
p[23] = new SqlParameter("@Mile", objFlightBAL.Mile);
p[24] = new SqlParameter("@Availability", objFlightBAL.Availability);
p[25] = new SqlParameter("@BIC", objFlightBAL.BIC);
p[26] = new SqlParameter("@bookingclass", objFlightBAL.bookingClass);
p[27] = new SqlParameter("@classType", objFlightBAL.ClassType);
p[28] = new SqlParameter("@farebasiscode", objFlightBAL.farebasisCode);
p[29] = new SqlParameter("@Fare_Rule", objFlightBAL.Fare_Rule);
p[30] = new SqlParameter("@PsgrType", objFlightBAL.PsgrType);
p[31] = new SqlParameter("@BaseFare", objFlightBAL.BaseFare);
p[32] = new SqlParameter("@psgrTax", objFlightBAL.psgrTax);
p[33] = new SqlParameter("@BagInfo", objFlightBAL.BagInfo);
p[34] = new SqlParameter("@FlightBookingID", objFlightBAL.FlightBookingID);
p[35] = new SqlParameter("@tableName", "InsertIntFlightSegment");
p[36] = new SqlParameter("@ArrivalAirportName", objFlightBAL.ArrivalAirportName);
p[37] = new SqlParameter("@DepartureAirportName", objFlightBAL.DepartureAirportName);
p[38] = new SqlParameter("@Telephone", objFlightBAL.telephone);
p[39] = new SqlParameter("@CustomerDetails", objFlightBAL.Customer_Details);
p[40] = new SqlParameter("@EmailAddress", objFlightBAL.emailAddress);
p[41] = new SqlParameter("@CreatedBy", objFlightBAL.CreatedBy);
p[42] = new SqlParameter("@Address", objFlightBAL.Address);
p[43] = new SqlParameter("@FarePsgrType", objFlightBAL.FarePsgrType);
return ObjDAL.fnExecuteStoredProcedure("sp_InternationalFlightSegments", p);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public bool AddCommission()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Api", api);
p[1] = new SqlParameter("@Percentage", percentage);
p[2] = new SqlParameter("@CreatedBy", createdBy);
p[3] = new SqlParameter("@Query", "Insert");
return ObjDAL.fnExecuteStoredProcedure("Sp_Commission", p);
}
catch (Exception ex)
{
throw ex;
}
}
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 bool AddCusRequest()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@Name", name);
p[1] = new SqlParameter("@EmailId", emailId);
p[2] = new SqlParameter("@TravelName", travelName);
p[3] = new SqlParameter("@BusType", busType);
p[4] = new SqlParameter("@DOJ", dateOFJourney);
p[5] = new SqlParameter("@NoOFSeats", noOfSeats);
p[6] = new SqlParameter("@Address", address);
p[7] = new SqlParameter("@Query", "Insert");
p[8] = new SqlParameter("@PhoneNo", mobileNo);
return ObjDAL.fnExecuteStoredProcedure("Sp_CustomerRequests", 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),
new SqlParameter("@FirstName", this.FirstName),
new SqlParameter("@Address", this.Address),
new SqlParameter("@MobileNumber", this.Mobile),
new SqlParameter("@State", this.Statename),
new SqlParameter("@City", this.cityname),
new SqlParameter("@Country", this.CountryName),
new SqlParameter("@PostalCode", this.PostalCode)
);
break;
case Masters.UpdateAdjustBalance:
_objDataLayer.fnExecuteStoredProcedure("sp_UpdateAdjustBalance", new SqlParameter("@Amount", this.A_Amount),
new SqlParameter("@UserID", this.UserID),
new SqlParameter("@ID", this.ID));
break;
case Masters.UpdateBalance:
_objDataLayer.fnExecuteStoredProcedure("sp_UpdateBalance", new SqlParameter("@Amount", this.A_Amount),
new SqlParameter("@ID", this.ID),
new SqlParameter("@UserID", this.UserID));
break;
case Masters.UpdateStatus:
_objDataLayer.fnExecuteStoredProcedure("sp_UpdatestatusAgent", new SqlParameter("@UserID", this.UserID),
new SqlParameter("@Status", this.Status));
break;
case Masters.deduct:
_objDataLayer.fnExecuteStoredProcedure("spdeductewallectbalance", new SqlParameter("@UserID", this.UserID),
new SqlParameter("@Balance", this.VBalance))
;
break;
case Masters.getrecharge1:
_objDataLayer.fnExecuteStoredProcedure("spgetrechargeinfoforusers", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@UserID",this.UserID),
new SqlParameter("@Amount",this.Amount),
new SqlParameter("@Status",this.Status),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Type", "Mobile"),
new SqlParameter("@ip", this.IP),
new SqlParameter("@Commission", this.AgentCommission),
new SqlParameter("@A_Amount",this.A_Amount),
new SqlParameter("@parameter", this.Parameter))
;
break;
case Masters.getrecharge2:
_objDataLayer.fnExecuteStoredProcedure("spgetrecharge", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Status", this.Status),
new SqlParameter("@Type", "DTH"),
new SqlParameter("@ip", this.IP),
new SqlParameter("@A_Amount", this.A_Amount),
new SqlParameter("@parameter", this.Parameter))
;
break;
//R
case Masters.getrecharge3:
_objDataLayer.fnExecuteStoredProcedure("spgetrechargeinfoforusers", new SqlParameter("@RequestID", this.RequestID),
new SqlParameter("@UserID", this.UserID),
new SqlParameter("@Amount", this.Amount),
new SqlParameter("@Status", this.Status),
new SqlParameter("@TransactionID", this.TransactionID),
new SqlParameter("@Commission",this.AgentCommission),
new SqlParameter("@Type", "DataCard"),
new SqlParameter("@ip", this.IP),
new SqlParameter("@A_Amount", this.A_Amount),
new SqlParameter("@parameter", this.Parameter))
;
break;
case Masters.Country:
_objDataLayer.fnExecuteStoredProcedure("spUpdateMstData", new SqlParameter("@TableName", "tbCountryMst"),
new SqlParameter("@RefID", this.RefID),
new SqlParameter("@Description", this.Description));
break;
case Masters.State:
_objDataLayer.fnExecuteStoredProcedure("spUpdateMstData", new SqlParameter("@TableName", "tbStateMst"),
new SqlParameter("@Description", this.Description),
new SqlParameter("@CTTCode", this.ServiceID),
new SqlParameter("@RefID", this.RefID));
break;
case Masters.CityType:
_objDataLayer.fnExecuteStoredProcedure("spUpdateMstData", new SqlParameter("@TableName", "tbCityTypeMst"),
new SqlParameter("@Description", this.Description),
new SqlParameter("@RefID", this.RefID));
break;
case Masters.City:
_objDataLayer.fnExecuteStoredProcedure("spUpdateMstData", new SqlParameter("@TableName", "tbCityMst"),
new SqlParameter("@Description", this.Description),
new SqlParameter("@RefID", this.RefID),
new SqlParameter("@Commission", this.Commission),
new SqlParameter("@CTTCode", this.City));
break;
case Masters.UserMst: _objDataLayer.fnExecuteStoredProcedure("spUpdateUserDts",
new SqlParameter("@UserId", this.UserID),
new SqlParameter("@Title", this.Title),
new SqlParameter("@FirstName", this.FirstName),
new SqlParameter("@LastName", this.LastName),
new SqlParameter("@DOB", this.DOB),
new SqlParameter("@Address", this.Address),
new SqlParameter("@Pincode", this.Pincode),
new SqlParameter("@Mobile", this.Mobile),
new SqlParameter("@Landline", this.Landline),
new SqlParameter("@Country", this.Country),
new SqlParameter("@State", this.State),
new SqlParameter("@City", this.City)
);
break;
case Masters.Commission: _objDataLayer.fnExecuteStoredProcedure("sp_Update_tbCommPer",
new SqlParameter("@ID", this.ID),
new SqlParameter("@Commission", this.Commission),
new SqlParameter("@TDR", this.TDR),
new SqlParameter("@ServiceTax", this.ServiceTax),
new SqlParameter("@TotalComm", this.TotalComm),
new SqlParameter("@CancelTicket", this.CancelTicket),
new SqlParameter("@CancelTtlComm", this.CancelTtalComm)
);
break;
case Masters.UPMyprofile:
_objDataLayer.fnExecuteStoredProcedure("sp_Updateprofile", new SqlParameter("@TableName", "UserProfile"),
new SqlParameter("@UserID", this.UserID),
new SqlParameter("@FirstName", this.FirstName),
new SqlParameter("@Address", this.Address),
new SqlParameter("@MobileNumber", this.Mobile),
new SqlParameter("@State", this.Statename),
new SqlParameter("@City", this.cityname),
new SqlParameter("@Country", this.CountryName),
new SqlParameter("@PostalCode", this.PostalCode)
);
break;
case Masters.Advertisement:
_objDataLayer.fnExecuteStoredProcedure("sp_Update_Advertisement", new SqlParameter("@ID", this.ID),
new SqlParameter("@ScreenName", this.ScreenName),
new SqlParameter("@Advertisement", this.Advertisement),
new SqlParameter("@imgID", this.imgID)
);
break;
case Masters.Operators:
_objDataLayer.fnExecuteStoredProcedure("sp_OperatorsDetails", new SqlParameter("@TableName", "UPDATEOPERATOR"),
new SqlParameter("@NetworkName", this.NetworkName),
new SqlParameter("@OperatorKeyword", this.OperatorKeyword),
new SqlParameter("@RefId", this.RefID)
);
break;
case Masters.Upstatus:
_objDataLayer.fnExecuteStoredProcedure("sp_Updatestatus", new SqlParameter("@UserID", this.UserID)
);
break;
case Masters.EWallet:
_objDataLayer.fnExecuteStoredProcedure("sp_EWallet", new SqlParameter("@OrderID", this.RequestID),
new SqlParameter("@Parameter", this.Parameter),
new SqlParameter("@Amount", this.amountewallet)
);
break;
case Masters.updateOfferContent:
_objDataLayer.fnExecuteStoredProcedure("sp_updateofferContent", new SqlParameter("@TableName", "Updatecontent"),
new SqlParameter("@ID", this.ID),
new SqlParameter("@Content", this.Content),
new SqlParameter("@ImagePath", this.ImageName));
break;
case Masters.addewalletamounttouser:
_objDataLayer.fnExecuteStoredProcedure("sp_AddEwalletAmounttoUser", new SqlParameter("@Parameter","Update"),
new SqlParameter("@Amount", this.amountewallet),
new SqlParameter("@UserID",this.UserID)
);
break;
case Masters.adjustewalletamounttouser:
_objDataLayer.fnExecuteStoredProcedure("sp_AddEwalletAmounttoUser", new SqlParameter("@Parameter", "UpdateBalance"),
new SqlParameter("@Amount", this.amountewallet),
new SqlParameter("@UserID", this.UserID)
);
break;
}
return true;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
}
public bool fnDeleteRecord()
{
try
{
_objDataLayer = new clsDataLayer();
switch (this.ScreenInd)
{
case blossom.DelectEmployee:
return _objDataLayer.fnExecuteStoredProcedure("SP_Employee", new SqlParameter("@Query", "Delete"),
new SqlParameter("@EmpId", this.EmpId));
break;
case blossom.DeleteCab:
return _objDataLayer.fnExecuteStoredProcedure("SP_Cab", new SqlParameter("@Query", "Delete"),
new SqlParameter("@CabId", this.CabId));
break;
case blossom.DeleteCity:
return _objDataLayer.fnExecuteStoredProcedure("SP_City", new SqlParameter("@Query", "Delete"),
new SqlParameter("@CityId", this.CityId));
break;
case blossom.DeleteCar:
return _objDataLayer.fnExecuteStoredProcedure("SP_Car", new SqlParameter("@Query", "Delete"),
new SqlParameter("@CarId", this.CarId));
break;
case blossom.DeleteCarDetailsForCity:
return _objDataLayer.fnExecuteStoredProcedure("SP_CarDetailsForCity", new SqlParameter("@Query", "Delete"),
new SqlParameter("@CarDetailsId", this.CarDetailsId));
break;
}
return true;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
}
public bool fnDeleteRecord()
{
try
{
_objDataLayer = new clsDataLayer();
switch (this.ScreenInd)
{
case Masters.AgentCommission:
_objDataLayer.fnExecuteStoredProcedure("sp_AgentCommission", new SqlParameter("@TableName", "DeleteCommission"),
new SqlParameter("@ID", this.RefID));
break;
case Masters.ListOfAmounts:
_objDataLayer.fnExecuteStoredProcedure("sp_ListOfAmounts", new SqlParameter("@TableName", "DeleteListOfAmount"),
new SqlParameter("@ID", this.RefID));
break;
case Masters.Country:
_objDataLayer.fnExecuteStoredProcedure("spDeleteMstData", new SqlParameter("@TableName", "tbCountryMst"),
new SqlParameter("@RefID", this.RefID));
break;
case Masters.State:
_objDataLayer.fnExecuteStoredProcedure("spDeleteMstData", new SqlParameter("@TableName", "tbStateMst"),
new SqlParameter("@RefID", this.RefID));
break;
case Masters.CityType:
_objDataLayer.fnExecuteStoredProcedure("spDeleteMstData", new SqlParameter("@TableName", "tbCityTypeMst"),
new SqlParameter("@RefID", this.RefID));
break;
case Masters.City:
_objDataLayer.fnExecuteStoredProcedure("spDeleteMstData", new SqlParameter("@TableName", "tbCityMst"),
new SqlParameter("@RefID", this.RefID));
break;
case Masters.Advertisement:
_objDataLayer.fnExecuteStoredProcedure("spDeleteMstData", new SqlParameter("@TableName", "tbAdvertisement"),
new SqlParameter("@RefID", this.ID));
break;
case Masters.Operators:
_objDataLayer.fnExecuteStoredProcedure("sp_OperatorsDetails", new SqlParameter("@TableName", "DeleteOperator"),
new SqlParameter("@RefID", this.RefID));
break;
}
return true;
}
catch (Exception ex)
{
//Logger.Log(Logger.LogType.Log_In_DB, ex, true);
return false;
}
}
public bool UpdateHMDeliveryStatus()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[5];
p[0] = new SqlParameter("@BookingId", bookingId);
p[1] = new SqlParameter("@DeliveryStatus", status);
p[2] = new SqlParameter("@DeliveredBy", deliveredBy);
p[3] = new SqlParameter("@AmountRecievedBy", amountrecievedBy);
p[4] = new SqlParameter("@Query", "UpdateHomeDelivery");
Res = ObjDAL.fnExecuteStoredProcedure("Sp_TicketBookings", p);
return Res;
}
catch (Exception ex)
{
throw ex;
}
}