package group_head_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;

import main_package.CenterInfo;
import main_package.DataBaseConnection;
import main_package.DataBaseMethods;

@ManagedBean(name="centerTableDsaUpdate")
@ViewScoped
public class CenterTableDsaUpdate implements Serializable
{
	public void dsaUpdateMethod(int branchId)
	{
		DataBaseMethods obj=new DataBaseMethods();
		Connection conn=DataBaseConnection.JAVAConnection();
		ArrayList<CenterInfo> list=obj.allCenterInfo(branchId,"all",conn);
		for(CenterInfo cc: list)
		{
			String dsaCode=dsaCodeFromGroupLoanTable(cc.getId(), conn);
			if(!dsaCode.equalsIgnoreCase(""))
			{
				updateInCenterTable(cc.getId(),dsaCode ,conn);
			}
		}
	}
	
	
	private void updateInCenterTable(String id, String dsaCode, Connection conn) 
	{
		Statement st=null;
		try
		{
	         st=conn.createStatement();
		     String query="update center set dsacode='"+dsaCode+"' where id='"+id+"' ";	
		     st.executeUpdate(query);
		} 
		catch (Exception e) 
		{
			 e.printStackTrace();
		}
		finally
		{
			try {
				if(st!=null)
				{
					st.close();
				}
			} catch (Exception e2) {
				// TODO: handle exception
			}
		}
	}

	private String dsaCodeFromGroupLoanTable(String id, Connection conn) 
	{
		try
		{
			Statement st=conn.createStatement();
			String qq="select dsacode from grouploan where center='"+id+"' ";
			ResultSet rr=st.executeQuery(qq);
			if(rr.next())
			{
				return rr.getString("dsacode");
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return "";
	}
}
