public int InsertDuration(DurationInfo duration)
{
duration.DurationId = Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInDuration(duration), Storeprocedures.spInsertSightSeeingTariffDuration.ToString(), CommandType.StoredProcedure));
InsertDurationDates(duration);
return(duration.DurationId);
}
public void InsertDurationDates(DurationInfo duration)
{
var Dates = duration.Dates.Split(',');
var Days = duration.Day.Split(',');
foreach (var item in Dates.Zip(Days, (a, b) => new { date = a, day = b }))
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (duration.SightSeeingDateDetailsId != 0)
{
sqlParam.Add(new SqlParameter("SightSeeingDateDetailsId", duration.SightSeeingDateDetailsId));
}
else
{
sqlParam.Add(new SqlParameter("CreatedDate", duration.CreatedDate));
sqlParam.Add(new SqlParameter("CreatedBy", duration.CreatedBy));
}
sqlParam.Add(new SqlParameter("@DurationId", duration.DurationId));
Logger.Debug("SightSeeingTariff Controller DurationId: " + duration.DurationId);
sqlParam.Add(new SqlParameter("@SightSeeingTariffId", duration.SightSeeingTariffId));
Logger.Debug("SightSeeingTariff Controller SightSeeingTariffId: " + duration.SightSeeingTariffId);
sqlParam.Add(new SqlParameter("@Date", item.date));
Logger.Debug("SightSeeingTariff Controller Date: " + item.date);
sqlParam.Add(new SqlParameter("@Day", item.day));
Logger.Debug("SightSeeingTariff Controller Day: " + item.day);
sqlParam.Add(new SqlParameter("@NetRate", duration.NetRate));
Logger.Debug("SightSeeingTariff Controller NetRate: " + duration.NetRate);
sqlParam.Add(new SqlParameter("@UpdatedDate", duration.UpdatedDate));
sqlParam.Add(new SqlParameter("@UpdatedBy", duration.UpdatedBy));
_sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spInsertSightSeeingTariffDurationDate.ToString(), CommandType.StoredProcedure);
}
}
public List <SqlParameter> SetValuesInDuration(DurationInfo duration)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (duration.DurationId != 0)
{
sqlParam.Add(new SqlParameter("DurationId", duration.DurationId));
}
else
{
sqlParam.Add(new SqlParameter("CreatedDate", duration.CreatedDate));
sqlParam.Add(new SqlParameter("CreatedBy", duration.CreatedBy));
}
sqlParam.Add(new SqlParameter("@SightSeeingTariffId", duration.SightSeeingTariffId));
Logger.Debug("SightSeeingTariff Controller SightSeeingTariffId: " + duration.SightSeeingTariffId);
sqlParam.Add(new SqlParameter("@FromDate", duration.FromDate));
Logger.Debug("SightSeeingTariff Controller FromDate: " + duration.FromDate);
sqlParam.Add(new SqlParameter("@ToDate", duration.ToDate));
Logger.Debug("SightSeeingTariff Controller ToDate: " + duration.ToDate);
sqlParam.Add(new SqlParameter("@OperationalDays", duration.OperationalDays));
Logger.Debug("SightSeeingTariff Controller OperationalDays: " + duration.OperationalDays);
sqlParam.Add(new SqlParameter("@UpdatedDate", duration.UpdatedDate));
sqlParam.Add(new SqlParameter("@UpdatedBy", duration.UpdatedBy));
return(sqlParam);
}
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();
}
