package cashfree;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Date;

import group_head_package.DataBaseIncomeExpense;
import main_package.BankInfo;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;



public class CashfreeSettingRepository {
	
	

	public static boolean addCreditBackend(
	        int branchId,
	        String bankName,
	        double amount,
	        Date date,
	        String description,
	        String paymentMode,
	        String chequeNo,
	        Date chequeDate,
	        String submittedBankName) throws IOException
	{
	    Connection conn = null;
	    
	
	    try
	    {
	        conn = DataBaseConnection.JAVAConnection();
	
	        BankInfo bankInfo =
	                new DataBaseMethods().obtainBankInfoById(bankName, conn);
	
	        String bankBranch = bankInfo.getBank_branch();
	        String address = bankInfo.getAddress();
	        String accNo = bankInfo.getAcc_no();
	        
	//	    double remainingAmountInBank =
	//        new DataBaseMethods().currentBankBalance(bankName, conn);
	
	        int n = new DataBaseIncomeExpense().addCurrentAssetBankCredit(
	                branchId,
	                bankName,
	                bankBranch,
	                accNo,
	                address,
	                amount,
	                date,
	                description,
	                paymentMode,
	                chequeNo,
	                chequeDate,
	                submittedBankName
	        );
	
	        if(n >= 1)
	        {
	            new DataBaseMethods().decreaseBankBalance(
	                    bankName,
	                    amount,
	                    conn
	            );
	
	            new DataBaseMethods().increaseBankBalance(
	                    submittedBankName,
	                    amount,
	                    conn
	            );
	
	            return true;
	        }
	
	        return false;
	    }
	    catch(Exception e)
	    {
	        e.printStackTrace();
	        return false;
	    }
	    finally
	    {
	        try
	        {
	            if(conn != null)
	                conn.close();
	        }
	        catch(Exception e)
	        {
	            e.printStackTrace();
	        }
	    }
	}

	public static CashfreeSetting findActiveCashfreeBankSetting(){

	    String query = "SELECT cashfree_bank_id, cashfree_linked_account_bank_id "
	            + "FROM cashfree_setting "
	            + "WHERE is_active = 1 "
	            + "LIMIT 1";

	    try (Connection conn = DataBaseConnection.JAVAConnection();
	         PreparedStatement ps = conn.prepareStatement(query);
	         ResultSet rs = ps.executeQuery()) {

	        if (rs.next()) {

	            CashfreeSetting setting = new CashfreeSetting();

	            setting.setCashfreeBankId(
	                    rs.getLong("cashfree_bank_id"));

	            setting.setCashfreeLinkedAccountBankId(
	                    rs.getLong("cashfree_linked_account_bank_id"));

	            return setting;
	        }

	    } catch (Exception e) {
	        e.printStackTrace();
	    }

	    return null;
	}
	
}
