package com.m2i.bprm.dao;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import com.m2i.bprm.servies.entity.Coupon;

import java.util.List;

public class CouponDAO {
	DriverManagerDataSource dataSource = new DriverManagerDataSource(
			"org.postgresql.Driver", "jdbc:postgresql://localhost/bprm",
			"postgres", "postgres");
	JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

	public void insertCoupon(Coupon coupon) {

		Object[] params = { coupon.getCouponName(),
				coupon.getCouponDescription(), coupon.getCouponAmount(),
				coupon.getCouponCode(), coupon.getStartDate(),
				coupon.getEndDate(), coupon.getCouponMinimumOrder(),
				coupon.getFreeShipping() };
		jdbcTemplate
				.update("insert into coupon(coupon_name,coupon_description,coupon_amount,coupon_code,start_date,end_date,coupon_minimumorder,free_shipping) values (?,?,?,?,?,?,?,?)",
						params);

	}
}