// Funktion to Delete Station
 public void DeleteStation(String station_ID)
 {
     DAL_Model.DataAccessLayer DAL_Model = new DAL_Model.DataAccessLayer();
     DAL_Model.Open();
     SqlParameter[] param = new SqlParameter[1];
     param[0]       = new SqlParameter("@STATION_ID", SqlDbType.NChar, 50);
     param[0].Value = station_ID;
     DAL_Model.ExcuteCommand("DELETE_STATION", param);
     DAL_Model.Close();
 }
        //Funktion to Verify to StationID
        public DataTable VerifyStationID(String station_ID)
        {
            DAL_Model.DataAccessLayer DAL_Model = new DAL_Model.DataAccessLayer();
            DataTable dt = new DataTable();

            SqlParameter[] param = new SqlParameter[1];
            param[0]       = new SqlParameter("@STATION_ID", SqlDbType.NChar, 50);
            param[0].Value = station_ID;
            dt             = DAL_Model.SelectData("VERIFY_STATION_ID", param);
            DAL_Model.Close();
            return(dt);
        }
 // Funktion to Edit Station
 public void EditStation(String station_ID, string date, int target, int actual, int variance)
 {
     DAL_Model.DataAccessLayer DAL_Model = new DAL_Model.DataAccessLayer();
     DAL_Model.Open();
     SqlParameter[] param = new SqlParameter[5];
     param[0]       = new SqlParameter("@STATION_ID", SqlDbType.NChar, 50);
     param[0].Value = station_ID;
     param[1]       = new SqlParameter("@DATE", SqlDbType.NChar, 50);
     param[1].Value = date;
     param[2]       = new SqlParameter("@TARGET", SqlDbType.Int);
     param[2].Value = target;
     param[3]       = new SqlParameter("@ACTUAL", SqlDbType.Int);
     param[3].Value = actual;
     param[4]       = new SqlParameter("@VARIANCE", SqlDbType.Int);
     param[4].Value = variance;
     DAL_Model.ExcuteCommand("UPDATE_STATIONS", param);
     DAL_Model.Close();
 }