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