using System;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;



namespace ChortKeh
{
	/// <summary>
	/// Summary description for DataAccessClass.
	/// </summary>
	public class data_access
    {
        
      

		public OleDbConnection	  con;
		public OleDbDataAdapter	  dAdapter;
		public DataSet				  dSet;
        public string conString = @"Provider=SQLNCLI.1;Data Source=" + Environment.MachineName + ";Integrated Security=SSPI;Initial Catalog=myBank";
        //***************************************************************************************
        public bool fnGetDataConnection()
        {
            try
            {
                con = new OleDbConnection(conString);
                dAdapter = new OleDbDataAdapter();
                dSet = new DataSet();

            }
            catch (Exception ex)
            {
                MessageBox.Show("Error : " + ex.Message);
                return false;
            }//try-catch	   
            //connection ok!
            return true;
        }
        //************************************************************************************
        //***********************************************************************************
        public bool fnDataReader(string sqlcmd,string tblname)
        {
            
            try
            {
                if (con.State.ToString().Equals("Closed")) con.Open();
                dAdapter.SelectCommand = new OleDbCommand(sqlcmd,con);
                dAdapter.Fill(dSet,tblname);
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error : " + ex.Message);
                return false;
            }//try-catch	   
            return true;
        }
        //******************************************************************
        public void fnDataSetClear()
        {
                dSet.Clear();
        }
        //******************************************************************
        public void fnRunCommand(string cmd)//string status, string name, string family, string id1, string cardno)
        {
            
                OleDbCommand Cmd = new OleDbCommand(cmd);
                Cmd.Connection = con;
                Cmd.CommandText = cmd;
                if(con.State.ToString().Equals("Closed")) con.Open();
                Cmd.ExecuteNonQuery();
                con.Close();
            
        }
        //**********************************************************************
        public Boolean fnIsDataSetEmpty()
        {
            if (dSet.Tables.Count != 0)
            {
                if (dSet.Tables[0].Rows.Count == 0)
                    return true;
                else
                    return false;
            }
            else
                return false;
        }
	}//class
}//namespace