コード例 #1
0
        public int DeleteTelephone(string beforeTelephone)
        {
            int i = 0;

            using (MySqlCommand command = new MySqlCommand())
            {
                i = ExecuteNonQuery(TelephoneStringsMySql.DeleteTelephone(beforeTelephone));
            }

            return(i);
        }
コード例 #2
0
        public TelephoneModel UpdateTelephone(TelephoneModel telephoneModel)
        {
            DataTable dt = new DataTable();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(TelephoneStringsMySql.UpdateTelephone(telephoneModel));
            }
            foreach (DataRow ms in dt.Rows)
            {
                telephoneModel = TelephoneModel.ToObject(ms);
            }
            return(telephoneModel);
        }
コード例 #3
0
        public List <TelephoneModel> GetAllTelephones()
        {
            DataTable dt = new DataTable();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(TelephoneStringsMySql.GetAllTelephones());
            }

            List <TelephoneModel> arrTelephone = new List <TelephoneModel>();

            foreach (DataRow ms in dt.Rows)
            {
                arrTelephone.Add(TelephoneModel.ToObject(ms));
            }
            return(arrTelephone);
        }
コード例 #4
0
        public TelephoneModel GetOneBeforeTelephone(string beforeTelephone)
        {
            DataTable dt = new DataTable();

            if (beforeTelephone.Equals(string.Empty) || beforeTelephone.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            TelephoneModel telephoneModel = new TelephoneModel();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(TelephoneStringsMySql.GetOneBeforeTelephone(beforeTelephone));
            }

            foreach (DataRow ms in dt.Rows)
            {
                telephoneModel = TelephoneModel.ToObject(ms);
            }
            return(telephoneModel);
        }