Exemplo n.º 1
0
        public CellphoneModel UpdateCellphone(CellphoneModel cellphoneModel)
        {
            DataTable dt = new DataTable();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(CellphoneStringsMySql.UpdateCellphone(cellphoneModel));
            }
            foreach (DataRow ms in dt.Rows)
            {
                cellphoneModel = CellphoneModel.ToObject(ms);
            }

            return(cellphoneModel);
        }
        public List <CellphoneModel> GetAllCellphones()
        {
            DataTable dt = new DataTable();

            using (OleDbCommand command = new OleDbCommand())
            {
                dt = GetMultipleQuery(CellphoneStringsInner.GetAllCellphones());
            }

            List <CellphoneModel> arrCellphone = new List <CellphoneModel>();

            foreach (DataRow ms in dt.Rows)
            {
                arrCellphone.Add(CellphoneModel.ToObject(ms));
            }

            return(arrCellphone);
        }
        public CellphoneModel GetOneBeforeCellphone(string beforeCellphone)
        {
            DataTable dt = new DataTable();

            if (beforeCellphone.Equals(string.Empty) || beforeCellphone.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            CellphoneModel cellphoneModel = new CellphoneModel();

            using (OleDbCommand command = new OleDbCommand())
            {
                dt = GetMultipleQuery(CellphoneStringsInner.GetOneBeforeCellphone(beforeCellphone));
            }

            foreach (DataRow ms in dt.Rows)
            {
                cellphoneModel = CellphoneModel.ToObject(ms);
            }

            return(cellphoneModel);
        }