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> SetValuesInVehicleTariffPriceDetails(VehicleTariffPriceDetailsInfo vehicletariffprice)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (vehicletariffprice.VehicleTariffPriceDetailsId != 0)
{
sqlParam.Add(new SqlParameter("VehicleTariffPriceDetalsId", vehicletariffprice.VehicleTariffPriceDetailsId));
}
else
{
sqlParam.Add(new SqlParameter("CreatedDate", vehicletariffprice.CreatedDate));
sqlParam.Add(new SqlParameter("CreatedBy", vehicletariffprice.CreatedBy));
}
sqlParam.Add(new SqlParameter("@VehicleTariffId", vehicletariffprice.VehicleTariffId));
Logger.Debug("VehicleTariff Controller VehicleTariffId:" + vehicletariffprice.VehicleTariffId);
sqlParam.Add(new SqlParameter("@VehicleId", vehicletariffprice.VehicleId));
Logger.Debug("VehicleTariff Controller VehicleId:" + vehicletariffprice.VehicleId);
sqlParam.Add(new SqlParameter("@VehicleType", vehicletariffprice.VehicleTypeName));
Logger.Debug("VehicleTariff Controller VehicleType:" + vehicletariffprice.VehicleTypeName);
sqlParam.Add(new SqlParameter("@SeatingCapacity", vehicletariffprice.SeatingCapacity));
Logger.Debug("VehicleTariff Controller SeatingCapacity:" + vehicletariffprice.SeatingCapacity);
sqlParam.Add(new SqlParameter("@FreeKms", vehicletariffprice.FreeKms));
Logger.Debug("VehicleTariff Controller FreeKms:" + vehicletariffprice.FreeKms);
sqlParam.Add(new SqlParameter("@KmAmount", vehicletariffprice.KmAmount));
Logger.Debug("VehicleTariff Controller KmAmount:" + vehicletariffprice.KmAmount);
sqlParam.Add(new SqlParameter("@RupeesPerExtraKm", vehicletariffprice.RupeesPerExtraKm));
Logger.Debug("VehicleTariff Controller RupeesPerExtraKm:" + vehicletariffprice.RupeesPerExtraKm);
sqlParam.Add(new SqlParameter("@Duration", vehicletariffprice.Duration));
Logger.Debug("VehicleTariff Controller Duration:" + vehicletariffprice.Duration);
sqlParam.Add(new SqlParameter("@HoursAmount", vehicletariffprice.HoursAmount));
Logger.Debug("VehicleTariff Controller HoursAmount:" + vehicletariffprice.HoursAmount);
sqlParam.Add(new SqlParameter("@RupeesPerExtraHours", vehicletariffprice.RupeesPerExtraHours));
Logger.Debug("VehicleTariff Controller RupeesPerExtraHours:" + vehicletariffprice.RupeesPerExtraHours);
sqlParam.Add(new SqlParameter("@Source", vehicletariffprice.Source));
Logger.Debug("VehicleTariff Controller Source:" + vehicletariffprice.Source);
sqlParam.Add(new SqlParameter("@Destination", vehicletariffprice.Destination));
Logger.Debug("VehicleTariff Controller Destination:" + vehicletariffprice.Destination);
sqlParam.Add(new SqlParameter("@PackageAmount", vehicletariffprice.PackageAmount));
Logger.Debug("VehicleTariff Controller PackageAmount:" + vehicletariffprice.PackageAmount);
sqlParam.Add(new SqlParameter("@TransferType", vehicletariffprice.TransferType));
Logger.Debug("VehicleTariff Controller Transfer Type:" + vehicletariffprice.TransferType);
sqlParam.Add(new SqlParameter("@TransferSource", vehicletariffprice.TransferSource));
Logger.Debug("VehicleTariff Controller Transfer Source:" + vehicletariffprice.TransferSource);
sqlParam.Add(new SqlParameter("@TransferDestination", vehicletariffprice.TransferDestination));
Logger.Debug("VehicleTariff Controller Transfer Destination:" + vehicletariffprice.TransferDestination);
sqlParam.Add(new SqlParameter("@TransferPackageAmount", vehicletariffprice.TransferPackageAmount));
Logger.Debug("VehicleTariff Controller Transfer PackageAmount:" + vehicletariffprice.TransferPackageAmount);
sqlParam.Add(new SqlParameter("@UpdatedDate", vehicletariffprice.UpdatedDate));
sqlParam.Add(new SqlParameter("@UpdatedBy", vehicletariffprice.UpdatedBy));
return(sqlParam);
}
public void UpdateVehicleTariffPrice(VehicleTariffPriceDetailsInfo vehicletariffprice)
{
_sqlHelper.ExecuteNonQuery(SetValuesInVehicleTariffPriceDetails(vehicletariffprice), Storeprocedures.spUpdateVehicleTariffPriceDetails.ToString(), CommandType.StoredProcedure);
}
public int InsertVehicleTariffPriceDetails(VehicleTariffPriceDetailsInfo vehicletariffprice)
{
return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInVehicleTariffPriceDetails(vehicletariffprice), Storeprocedures.spInsertVehicleTariffPriceDetails.ToString(), CommandType.StoredProcedure)));
}
