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