public VehicleTariffViewModel()
{
FriendlyMessage = new List <FriendlyMessage>();
Pager = new PaginationInfo();
VehicleTariff = new VehicleTariffInfo();
VehicleTariffs = new List <VehicleTariffInfo>();
VehicleTariffFilter = new VehcileTariffFilter();
VehicleTariffPriceDetail = new VehicleTariffPriceDetailsInfo();
VehicleTariffPriceDetails = new List <VehicleTariffPriceDetailsInfo>();
VehicleTariffCustomerCategory = new VehicleTariffCustomerCategoryDetailsInfo();
VehicleTariffCustomerCategories = new List <VehicleTariffCustomerCategoryDetailsInfo>();
Vendor = new VendorInfo();
Vendors = new List <VendorInfo>();
Vehicle = new VehicleInfo();
Vehicles = new List <VehicleInfo>();
CustomerCategory = new CustomerCategoryInfo();
CustomerCategories = new List <CustomerCategoryInfo>();
}
public List <SqlParameter> SetValuesInCustomerCategory(CustomerCategoryInfo customerCategory)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (customerCategory.CustomerCategoryId != 0)
{
sqlParam.Add(new SqlParameter("@CustomerCategoryId", customerCategory.CustomerCategoryId));
}
else
{
sqlParam.Add(new SqlParameter("@CreatedDate", customerCategory.CreatedDate));
sqlParam.Add(new SqlParameter("@CreatedBy", customerCategory.CreatedBy));
}
sqlParam.Add(new SqlParameter("@CustomerCategoryName", customerCategory.CustomerCategoryName));
Logger.Debug("CustomerCategory Controller CustomerCategoryName:" + customerCategory.CustomerCategoryName);
sqlParam.Add(new SqlParameter("@Margin", customerCategory.Margin));
Logger.Debug("CustomerCategory Controller Margin:" + customerCategory.Margin);
sqlParam.Add(new SqlParameter("@IsActive", customerCategory.IsActive));
Logger.Debug("CustomerCategory Controller IsActive:" + customerCategory.IsActive);
sqlParam.Add(new SqlParameter("@UpdatedBy", customerCategory.UpdatedBy));
sqlParam.Add(new SqlParameter("@UpdatedDate", customerCategory.UpdatedDate));
return(sqlParam);
}
public CustomerCategoryInfo GetCustomerCategoryValues(DataRow dr)
{
CustomerCategoryInfo Val = new CustomerCategoryInfo();
Val.CustomerCategoryId = Convert.ToInt32(dr["CustomerCategoryId"]);
Val.CustomerCategoryName = Convert.ToString(dr["CustomerCategoryName"]);
return(Val);
}
private CustomerCategoryInfo GetCustomerCategoryDetailsValues(DataRow dr)
{
CustomerCategoryInfo CustomerCategoryDetails = new CustomerCategoryInfo();
CustomerCategoryDetails.CustomerCategoryId = Convert.ToInt32(dr["CustomerCategoryId"]);
CustomerCategoryDetails.CustomerCategoryName = Convert.ToString(dr["CustomerCategoryName"]);
CustomerCategoryDetails.Margin = Convert.ToDecimal(dr["Margin"]);
return(CustomerCategoryDetails);
}
public CustomerCategoryViewModel()
{
CustomerCategory = new CustomerCategoryInfo();
Filter = new CustomerCategoryFilter();
CustomerCategories = new List <CustomerCategoryInfo>();
Pager = new PaginationInfo();
FriendlyMessage = new List <FriendlyMessage>();
}
private CustomerCategoryInfo GetCustomerCategoryValues(DataRow dr)
{
CustomerCategoryInfo CustomerCategory = new CustomerCategoryInfo();
CustomerCategory.CustomerCategoryId = Convert.ToInt32(dr["CustomerCategoryId"]);
if (!dr.IsNull("CustomerCategoryName"))
{
CustomerCategory.CustomerCategoryName = Convert.ToString(dr["CustomerCategoryName"]);
}
if (!dr.IsNull("Margin"))
{
CustomerCategory.Margin = Convert.ToDecimal(dr["Margin"]);
}
if (!dr.IsNull("IsActive"))
{
CustomerCategory.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
return(CustomerCategory);
}
public HotelTariffViewModel()
{
HotelTariff = new HotelTariffInfo();
HotelTariffs = new List <HotelTariffInfo>();
Vendors = new List <VendorInfo>();
Hotels = new List <HotelInfo>();
RoomTypes = new List <RoomTypeInfo>();
Meals = new List <MealInfo>();
Occupancies = new List <OccupancyInfo>();
Filter = new HotelTariffFilter();
Pager = new PaginationInfo();
FriendlyMessage = new List <FriendlyMessage>();
//for date details
HotelTariffDate = new HotelTariffDateDetailsInfo();
HotelTariffDates = new List <HotelTariffDateDetailsInfo>();
//for duration
HotelTariffDuration = new HotelTariffDurationDetailsInfo();
HotelTariffDurations = new List <HotelTariffDurationDetailsInfo>();
HotelTariffDurationFilter = new HotelTariffDurationFilter();
//for price
HotelTariffPrice = new HotelTariffPriceDetailsInfo();
HotelTariffPrices = new List <HotelTariffPriceDetailsInfo>();
HotelTariffPriceFilter = new HotelTariffPriceFilter();
//for room
HotelTariffRoom = new HotelTariffRoomDetailsInfo();
HotelTariffRooms = new List <HotelTariffRoomDetailsInfo>();
HotelTariffRoomFilter = new HotelTariffRoomFilter();
//for room Occupancy
HotelTariffRoomOccupancy = new HotelTariffRoomOccupancyInfo();
HotelTariffRoomOccupancies = new List <HotelTariffRoomOccupancyInfo>();
HotelTariffRoomOccupancyFilter = new HotelTariffRoomOccupancyFilter();
//For tax formula
LstStandardCharges = new List <ChargesInfo>();
LstTaxFormula = new List <TaxFormulaInfo>();
LstTaxFormulaCharges = new List <TaxFormulaChargesInfo>();
//for Customer Category
HotelTariffCustomerCategory = new HotelTariffCustomerCategoryDetailsInfo();
HotelTariffCustomerCategories = new List <HotelTariffCustomerCategoryDetailsInfo>();
CustomerCategory = new CustomerCategoryInfo();
CustomerCategories = new List <CustomerCategoryInfo>();
HotelTariffCustomerCategoryFilter = new HotelTariffCustomerCategoryFilter();
}
public int Insert(CustomerCategoryInfo CustomerCategory)
{
return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInCustomerCategory(CustomerCategory), Storeprocedures.spInsertCustomerCategory.ToString(), CommandType.StoredProcedure)));
}
public void Update(CustomerCategoryInfo customerCategory)
{
_sqlHelper.ExecuteNonQuery(SetValuesInCustomerCategory(customerCategory), Storeprocedures.spUpdateCustomerCategory.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();
}
