private SightSeeingTariffCustomerCategoryInfo GetSightSeeingTariffCustomerCategoryValues(DataRow dr) { SightSeeingTariffCustomerCategoryInfo sightseeingtariffcustomercategory = new SightSeeingTariffCustomerCategoryInfo(); if (dr["Margin"] != DBNull.Value) { sightseeingtariffcustomercategory.TariffMargin = Convert.ToDecimal(dr["Margin"]); } if (dr["CustomerCategoryName"] != DBNull.Value) { sightseeingtariffcustomercategory.CustomerCategoryName = Convert.ToString(dr["CustomerCategoryName"]); } if (dr["CustomerCategoryId"] != DBNull.Value) { sightseeingtariffcustomercategory.CustomerCategoryId = Convert.ToInt32(dr["CustomerCategoryId"]); } if (dr["SightSeeingTariffDatesId"] != DBNull.Value) { sightseeingtariffcustomercategory.SightSeeingTariffDatesId = Convert.ToInt32(dr["SightSeeingTariffDatesId"]); } if (dr["SightSeeingTariffOccupancyId"] != DBNull.Value) { sightseeingtariffcustomercategory.SightSeeingTariffOccupancyId = Convert.ToInt32(dr["SightSeeingTariffOccupancyId"]); } return(sightseeingtariffcustomercategory); }
private SightSeeingTariffCustomerCategoryInfo GetCustomerCategoriesValues(DataRow dr) { SightSeeingTariffCustomerCategoryInfo CustomerCategory = new SightSeeingTariffCustomerCategoryInfo(); if (dr["CustomerCategoryId"] != DBNull.Value) { CustomerCategory.CustomerCategoryId = Convert.ToInt32(dr["CustomerCategoryId"]); } CustomerCategory.CustomerCategoryName = Convert.ToString(dr["CustomerCategoryName"]); if (dr["GlobalMargin"] != DBNull.Value) { CustomerCategory.GlobalMargin = Convert.ToInt32(dr["GlobalMargin"]); } return(CustomerCategory); }
private List <SqlParameter> SetValuesInSightSeeingTariffCustomerCategory(SightSeeingTariffCustomerCategoryInfo customercategory) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@SightSeeingTariffDatesId", customercategory.SightSeeingTariffDatesId)); sqlParams.Add(new SqlParameter("@CreatedDate", customercategory.CreatedDate)); sqlParams.Add(new SqlParameter("@CreatedBy", customercategory.CreatedBy)); sqlParams.Add(new SqlParameter("@CustomerCategoryId", customercategory.CustomerCategoryId)); Logger.Debug("SightSeeingTariff Controller CustomerCategoryId:" + customercategory.CustomerCategoryId); sqlParams.Add(new SqlParameter("@Margin", customercategory.TariffMargin)); Logger.Debug("SightSeeingTariff Controller Margin:" + customercategory.TariffMargin); sqlParams.Add(new SqlParameter("@UpdatedDate", customercategory.UpdatedDate)); sqlParams.Add(new SqlParameter("@UpdatedBy", customercategory.UpdatedBy)); return(sqlParams); }
public void UpdateCustomerCategory(SightSeeingTariffCustomerCategoryInfo customercategory) { _sqlHelper.ExecuteNonQuery(SetValuesInSightSeeingTariffCustomerCategory(customercategory), Storeprocedures.spUpdateSightSeeingTariffCustomerCategory.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(); }