public List<Remark> GetAll()
        {
            List<Remark> remarks = new List<Remark>();
            try
            {
                SqlConnectionObj.Open();
                string query = String.Format("Select * From tbl_Remark");
                SqlCommandObj.CommandText = query;
                SqlDataReader dataReader = SqlCommandObj.ExecuteReader();
                while (dataReader.Read())
                {
                    Remark aRemark = new Remark();
                    aRemark.Id = Convert.ToInt32(dataReader["ID"]);
                    aRemark.Name = dataReader["Name"].ToString();
                    remarks.Add(aRemark);

                }
            }
            catch(Exception ex)
            {
                throw new Exception("Remarks can not loaded from your system",ex);
            }
            finally
            {
                if (SqlCommandObj !=null && SqlConnectionObj.State==ConnectionState.Open)
                {
                    SqlConnectionObj.Close();
                }
            }
            return remarks;
        }
        public Remark GetRemark(int remarkId)
        {
            try
            {

            SqlConnectionObj.Open();
            string query = string.Format("Select * From tbl_Remark where ID = " + remarkId);

            SqlCommandObj.CommandText = query;
            SqlDataReader dataReader = SqlCommandObj.ExecuteReader();
            Remark aRemark = new Remark();
            while (dataReader.Read())
            {
                aRemark.Id = Convert.ToInt32(dataReader["ID"]);
                aRemark.Name = dataReader["Name"].ToString();
            }
            return aRemark;
            }
            catch (Exception ex)
            {
                throw new Exception("Remarks can not loaded from your system", ex);
            }
            finally
            {
                if (SqlCommandObj != null && SqlConnectionObj.State == ConnectionState.Open)
                {
                    SqlConnectionObj.Close();
                }
            }
        }
 public bool Save(Remark aRemark, out string saveMessage)
 {
     if (aRemark.Name == string.Empty)
     {
         saveMessage = "Remark data is missing";
         return false;
     }
     else if (remarkGateway.HasThisRemarkName(aRemark.Name))
     {
         saveMessage = "Your system already has this remark data. Try again.";
         return false;
     }
     else
     {
         saveMessage = "Remark has been saved.";
         return remarkGateway.Save(aRemark);
     }
 }
        public bool Save(Remark remark)
        {
            try
            {SqlConnectionObj.Open();
                string query = string.Format("Insert into tbl_Remark values('{0}')", remark.Name);
                SqlCommandObj.CommandText = query;
                SqlCommandObj.ExecuteNonQuery();

            }
            catch (Exception ex)
            {
                throw new Exception("Remark couldn't saved", ex);
            }
            finally
            {
                if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open)
                {
                    SqlConnectionObj.Close();
                }
            }
            return true;
        }