C# clsDataLayer.fnExecuteStoredProcedure方法代码示例

        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));
//.........这里部分代码省略.........

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