public void UpdateSightSeeingTariffPrice(SightSeeingTariffPriceInfo sightseeingtariffprice) { _sqlHelper.ExecuteNonQuery(SetValuesInSightSeeingTariffPrice(sightseeingtariffprice), Storeprocedures.spUpdateSightSeeingTariffPrice.ToString(), CommandType.StoredProcedure); DeleteSightSeeingTariffCharges(sightseeingtariffprice); InsertPriceChargesDetails(sightseeingtariffprice); }
public void DeleteSightSeeingTariffCharges(SightSeeingTariffPriceInfo sightseeingtariffprice) { List <SqlParameter> sqlParam = new List <SqlParameter>(); sqlParam.Add(new SqlParameter("SightSeeingTariffPriceId", sightseeingtariffprice.SightSeeingTariffPriceId)); _sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spDeleteSightSeeingTariffCharges.ToString(), CommandType.StoredProcedure); }
public int InsertSightSeeingTariffPrice(SightSeeingTariffPriceInfo sightseeingtariffprice) { sightseeingtariffprice.SightSeeingTariffPriceId = Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInSightSeeingTariffPrice(sightseeingtariffprice), Storeprocedures.spInsertSightSeeingTariffPrice.ToString(), CommandType.StoredProcedure)); InsertPriceChargesDetails(sightseeingtariffprice); return(sightseeingtariffprice.SightSeeingTariffPriceId); }
private List <SqlParameter> SetValuesInSightSeeingTariffPrice(SightSeeingTariffPriceInfo sightseeingtariffprice) { List <SqlParameter> sqlParams = new List <SqlParameter>(); if (sightseeingtariffprice.SightSeeingTariffPriceId != 0) { sqlParams.Add(new SqlParameter("@SightSeeingTariffPriceId", sightseeingtariffprice.SightSeeingTariffPriceId)); } else { sqlParams.Add(new SqlParameter("@CreatedDate", sightseeingtariffprice.CreatedDate)); sqlParams.Add(new SqlParameter("@CreatedBy", sightseeingtariffprice.CreatedBy)); } sqlParams.Add(new SqlParameter("@SightSeeingTariffOccupancyId", sightseeingtariffprice.SightSeeingTariffOccupancyId)); Logger.Debug("SightSeeing Controller SightSeeingTariffOccupancyId:" + sightseeingtariffprice.SightSeeingTariffOccupancyId); sqlParams.Add(new SqlParameter("@PublishPrice", sightseeingtariffprice.PublishPrice)); Logger.Debug("SightSeeing Controller PublishPrice:" + sightseeingtariffprice.PublishPrice); sqlParams.Add(new SqlParameter("@SpecialPrice", sightseeingtariffprice.SpecialPrice)); Logger.Debug("SightSeeing Controller SpecialPrice:" + sightseeingtariffprice.SpecialPrice); sqlParams.Add(new SqlParameter("@CommissionPrice", sightseeingtariffprice.CommissionPrice)); Logger.Debug("SightSeeing Controller CommissionPrice:" + sightseeingtariffprice.CommissionPrice); sqlParams.Add(new SqlParameter("@FormulaId", sightseeingtariffprice.FormulaId)); Logger.Debug("SightSeeing Controller FormulaId:" + sightseeingtariffprice.FormulaId); sqlParams.Add(new SqlParameter("@TotalTaxPrice", sightseeingtariffprice.TotalTaxPrice)); Logger.Debug("SightSeeing Controller TotalTaxPrice:" + sightseeingtariffprice.TotalTaxPrice); sqlParams.Add(new SqlParameter("@NetRate", sightseeingtariffprice.NetRate)); Logger.Debug("SightSeeing Controller NetRate:" + sightseeingtariffprice.NetRate); sqlParams.Add(new SqlParameter("@Color", sightseeingtariffprice.Color)); Logger.Debug("SightSeeing Controller Color:" + sightseeingtariffprice.Color); sqlParams.Add(new SqlParameter("@UpdatedDate", sightseeingtariffprice.UpdatedDate)); sqlParams.Add(new SqlParameter("@UpdatedBy", sightseeingtariffprice.UpdatedBy)); return(sqlParams); }
public SightSeeingTariffPriceInfo GetSightSeeingTariffPriceById(int sightseeingTariffPriceId) { SightSeeingTariffPriceInfo sightseeingTariffPrice = new SightSeeingTariffPriceInfo(); List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@SightSeeingTariffPriceId", sightseeingTariffPriceId)); DataTable dt = _sqlHelper.ExecuteDataTable(sqlParams, Storeprocedures.spGetSightSeeingTariffPriceById.ToString(), CommandType.StoredProcedure); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { sightseeingTariffPrice = GetPriceValues(dr); } } return(sightseeingTariffPrice); }
public void InsertPriceChargesDetails(SightSeeingTariffPriceInfo sightseeingtariffprice) { foreach (var item in sightseeingtariffprice.SightSeeingTariffCharges) { List <SqlParameter> sqlParam = new List <SqlParameter>(); if (item.SightSeeingTariffChargesId != 0) { sqlParam.Add(new SqlParameter("@SightSeeingTariffChargesId", item.SightSeeingTariffChargesId)); } sqlParam.Add(new SqlParameter("@SightSeeingTariffPriceId", sightseeingtariffprice.SightSeeingTariffPriceId)); sqlParam.Add(new SqlParameter("@ChargesId", item.ChargesId)); sqlParam.Add(new SqlParameter("@Percentage", item.Percentage)); sqlParam.Add(new SqlParameter("@CalculatedPrice", item.CalculatedPrice)); _sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spInsertSightSeeingTariffCharges.ToString(), CommandType.StoredProcedure); } }
private SightSeeingTariffPriceInfo GetPriceValues(DataRow dr) { SightSeeingTariffPriceInfo SightSeeingTariffPrice = new SightSeeingTariffPriceInfo(); SightSeeingTariffPrice.SightSeeingTariffPriceId = Convert.ToInt32(dr["SightSeeingTariffPriceId"]); SightSeeingTariffPrice.SightSeeingTariffOccupancyId = Convert.ToInt32(dr["SightSeeingTariffOccupancyId"]); SightSeeingTariffPrice.SpecialPrice = Convert.ToDecimal(dr["SpecialPrice"]); SightSeeingTariffPrice.PublishPrice = Convert.ToDecimal(dr["PublishPrice"]); SightSeeingTariffPrice.CommissionPrice = Convert.ToDecimal(dr["CommissionPrice"]); SightSeeingTariffPrice.FormulaId = Convert.ToInt32(dr["FormulaId"]); SightSeeingTariffPrice.TotalTaxPrice = Convert.ToDecimal(dr["TotalTaxPrice"]); SightSeeingTariffPrice.NetRate = Convert.ToDecimal(dr["NetRate"]); SightSeeingTariffPrice.Color = Convert.ToString(dr["Color"]); return(SightSeeingTariffPrice); }
public SightSeeingTariffViewModel() { //For Sight Seeing Tariff SightSeeingTariff = new SightSeeingTariffInfo(); SightSeeingTariffs = new List <SightSeeingTariffInfo>(); Filter = new SightSeeingTariffFilter(); Vendors = new List <VendorInfo>(); SightSeeings = new List <SightSeeingInfo>(); Meals = new List <MealInfo>(); Occupancies = new List <OccupancyInfo>(); Pager = new PaginationInfo(); FriendlyMessage = new List <FriendlyMessage>(); //for date details SightSeeingTariffDate = new SightSeeingTariffDateInfo(); SightSeeingTariffDates = new List <SightSeeingTariffDateInfo>(); //For Duration Durations = new List <DurationInfo>(); Duration = new DurationInfo(); DurationFilter = new DurationFilter(); //for sight seeing duration SightSeeingTariffDuration = new SightSeeingTariffDurationInfo(); SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>(); SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter(); //For Sight Seeing Tariff Occupancy SightSeeingTariffOccupancy = new SightSeeingTariffOccupancyInfo(); SightSeeingTariffOccupancies = new List <SightSeeingTariffOccupancyInfo>(); SightSeeingTariffOccupancyFilter = new SightSeeingTariffOccupancyFilter(); //For tax formula LstStandardCharges = new List <ChargesInfo>(); LstTaxFormula = new List <TaxFormulaInfo>(); LstTaxFormulaCharges = new List <TaxFormulaChargesInfo>(); //For Sight Seeing Details SightSeeingDetails = new List <SightSeeingDetailInfo>(); SightSeeingDetail = new SightSeeingDetailInfo(); SightSeeingDetailFilter = new SightSeeingDetailFilter(); //For Sight Seeing Tariff Price SightSeeingTariffPrice = new SightSeeingTariffPriceInfo(); SightSeeingTariffPrices = new List <SightSeeingTariffPriceInfo>(); SightSeeingTariffPriceFilter = new SightSeeingTariffPriceFilter(); //For Sight Seeing Tariff Duration SightSeeingTariffDuration = new SightSeeingTariffDurationInfo(); SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>(); SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter(); //for Customer Category SightSeeingTariffCustomerCategory = new SightSeeingTariffCustomerCategoryInfo(); SightSeeingTariffCustomerCategories = new List <SightSeeingTariffCustomerCategoryInfo>(); CustomerCategory = new CustomerCategoryInfo(); CustomerCategories = new List <CustomerCategoryInfo>(); SightSeeingTariffCustomerCategoryFilter = new SightSeeingTariffCustomerCategoryFilter(); }