private SightSeeingTariffDateInfo GetSightSeeingTariffDateValues(DataRow dr) { SightSeeingTariffDateInfo sightseeingtariffdate = new SightSeeingTariffDateInfo(); if (dr["TariffDate"] != DBNull.Value) { sightseeingtariffdate.TariffDate = Convert.ToDateTime(dr["TariffDate"]); } if (dr["NetRate"] != DBNull.Value) { sightseeingtariffdate.NetRate = Convert.ToDecimal(dr["NetRate"]); } if (dr["SightSeeingTariffPriceId"] != DBNull.Value) { sightseeingtariffdate.SightSeeingTariffPriceId = Convert.ToInt32(dr["SightSeeingTariffPriceId"]); } if (dr["SightSeeingTariffOccupancyId"] != DBNull.Value) { sightseeingtariffdate.SightSeeingTariffOccupancyId = Convert.ToInt32(dr["SightSeeingTariffOccupancyId"]); } if (dr["SightSeeingTariffDatesId"] != DBNull.Value) { sightseeingtariffdate.SightSeeingTariffDatesId = Convert.ToInt32(dr["SightSeeingTariffDatesId"]); } return(sightseeingtariffdate); }
public void SaveSightSeeingTariffDurationWithCustomerCategories(List <DateTime> dates, SightSeeingTariffDateInfo sightseeingTariffDate, List <SightSeeingTariffCustomerCategoryInfo> sightseeingCustomerCategories) { foreach (var item in dates) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@SightSeeingTariffPriceId", sightseeingTariffDate.SightSeeingTariffPriceId)); Logger.Debug("SaveSightSeeingTariffDuration SightSeeingTariffPriceId:" + sightseeingTariffDate.SightSeeingTariffPriceId); sqlParams.Add(new SqlParameter("@TariffDate", item)); Logger.Debug("SaveSightSeeingTariffDuration TariffDate:" + item); sqlParams.Add(new SqlParameter("@NetRate", sightseeingTariffDate.NetRate)); Logger.Debug("SaveSightSeeingTariffDuration NetRate:" + sightseeingTariffDate.NetRate); sqlParams.Add(new SqlParameter("@SightSeeingTariffOccupancyId", sightseeingTariffDate.SightSeeingTariffOccupancyId)); Logger.Debug("SaveSightSeeingTariffDuration SightSeeingTariffOccupancyId:" + sightseeingTariffDate.SightSeeingTariffOccupancyId); sightseeingTariffDate.SightSeeingTariffDatesId = Convert.ToInt32(_sqlHelper.ExecuteScalerObj(sqlParams, Storeprocedures.spInsertSightSeeingTariffDate.ToString(), CommandType.StoredProcedure)); foreach (var itm in sightseeingCustomerCategories) { List <SqlParameter> sqlParam = new List <SqlParameter>(); sqlParam.Add(new SqlParameter("@SightSeeingTariffDatesId", sightseeingTariffDate.SightSeeingTariffDatesId)); sqlParam.Add(new SqlParameter("@CustomerCategoryId", itm.CustomerCategoryId)); sqlParam.Add(new SqlParameter("@Margin", itm.GlobalMargin)); sqlParam.Add(new SqlParameter("@CreatedDate", itm.CreatedDate)); sqlParam.Add(new SqlParameter("@CreatedBy", itm.CreatedBy)); sqlParam.Add(new SqlParameter("@UpdatedDate", itm.UpdatedDate)); sqlParam.Add(new SqlParameter("@UpdatedBy", itm.UpdatedBy)); _sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spInsertSightSeeingTariffCustomerCategory.ToString(), CommandType.StoredProcedure); } } }
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(); }