package other_package;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;

// This class is create for testing work
public class insery
{
	public static void main(String[] args)
	 {
		
		// universal 
		
	  ArrayList<SchemeTypeInfo> userNo1=new ArrayList<>();
	  userNo1=type();  //Method type Set
	  for(SchemeTypeInfo ff:userNo1)
	  {
		  usersList(ff.getUserno(), ff.getType());
	  }
	   
	 }
		
		
	public static String usersList(String userNo,String schemeType)
	{
	   
		try(Connection conn=DataBaseConnection.JAVAConnection())
		{
			Statement st=conn.createStatement();	
			String qq="update payment_receipt set scheme_type='"+schemeType+"' where  SUBSTRING(user_no,4,CHARACTER_LENGTH(user_no))='"+userNo+"'";
			System.out.println(qq);
			st.executeUpdate(qq);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	return null;
	}	
	
	public static ArrayList<SchemeTypeInfo> type()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
	     ArrayList<SchemeTypeInfo> list= new ArrayList<>();
		try(Connection conn=DataBaseConnection.JAVAConnection())
		{
			Statement st=conn.createStatement();	
			String qq="SELECT * from customer_info where branch_id='"+branchId+"'";
			ResultSet rr=st.executeQuery(qq);
			while(rr.next())
			{
				SchemeTypeInfo cate = new SchemeTypeInfo();
				String temp[]=rr.getString("user_no").split("-");
				cate.setUserno(temp[1]);
				cate.setType(rr.getString("scheme_type"));
			
				list.add(cate);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	return list;
	}
	
	
	
	
}



//Update return_amount_info_table
/*package particular;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import finance.DataBaseConnection;


public class insery
{
public static void main(String[] args)
 {
	// perticular
	
	
	
	
  ArrayList<String> userno= new ArrayList<>();
  
  String schemeType;
  userno=type();
  System.out.println(userno);
  for(int i=0;i<userno.size();i++)
  {
	  String[] temp=userno.get(i).split("-");
      String tp=userno.get(i).substring(  userno.get(i).length() - 6);
	  System.out.println(tp);
	 schemeType=schemeType(tp);
	 System.out.println(schemeType);
	 usersList(userno.get(i), schemeType);
  }
   
 }
	
public static String usersList(String userNo,String schemeType)
{
	String uno="";
	if(schemeType.equals("RD"))
	{
		uno="NMDS-"+userNo.substring(userNo.length() - 6);
	}
	else 
		if(schemeType.equals("DD"))
		{
			uno="NDDS-"+userNo.substring(userNo.length() - 6);
		}
		else
		{
			uno="NFDS-"+userNo.substring(userNo.length() - 6);
		}
	try(Connection conn=DataBaseConnection.JAVAConnection())
	{
		
		Statement st=conn.createStatement();	
		String qq="update returned_amount_info  set user_no='"+uno+"' where  user_no='"+userNo+"'";
		System.out.println(qq);
		st.executeUpdate(qq);
	}
	catch(Exception e)
	{
		e.printStackTrace();
	}
return null;
}	

public static ArrayList<String> type()
{
ArrayList<String> list= new ArrayList<>();
	try(Connection conn=DataBaseConnection.JAVAConnection())
	{
		Statement st=conn.createStatement();	
		String qq="SELECT  * from returned_amount_info";
		System.out.println(qq);
		ResultSet rr=st.executeQuery(selectQueWithBranch(qq,branchId));
		while(rr.next())
		{
			list.add(rr.getString("user_no"));
		}
	}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	
return list;
}

public static String  schemeType(String userNo)
{
	try(Connection conn=DataBaseConnection.JAVAConnection())
	{
		Statement st=conn.createStatement();	
		String qq="SELECT * from customer_info where SUBSTRING(user_no,6,CHARACTER_LENGTH(user_no))='"+userNo+"'";
		System.out.println(qq);
		ResultSet rr=st.executeQuery(selectQueWithBranch(qq,branchId));
		if(rr.next())
		{
			return rr.getString("scheme_type");
		}
	}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	
return null;
}
	

}*/
	



