public void Create(DataModels.Serie serie)
        {
            serie.date_created = DateTime.Now;
            serie.date_updated = DateTime.Now;

            series.createSerie(serie);
        }
 private void BtnAdd_Click(object sender, EventArgs e)
 {
     DataModels.Serie serie = new DataModels.Serie();
     serie.Name             = tbName.Text;
     serie.Episode          = Convert.ToInt32(numericUpDownEpisode.Value);
     serie.Season           = Convert.ToInt32(numericUpDownSeason.Value);
     serie.Categorie_idType = cmbCategorie.SelectedIndex + 1;
     serie.Rating_idRating  = cmbRating.SelectedIndex + 1;
     serie.Status_idStatus  = cmbStatus.SelectedIndex + 1;
     homeController.Create(serie);
     Close();
 }
        public DataModels.Serie getSerie(string serie)
        {
            DataModels.Serie _serie = new DataModels.Serie();
            int id = Convert.ToInt32(serie.Substring(0, serie.IndexOf(" ")));

            foreach (DataRow item in db.getSerie(id).Rows)
            {
                _serie.idSeries       = Convert.ToInt32(item["idSeries"]);
                _serie.Name           = item["Name"].ToString();
                _serie.Season         = Convert.ToInt32(item["Season"]);
                _serie.Episode        = Convert.ToInt32(item["Episode"]);
                _serie.Categorie_Type = item["serieCategorie"].ToString();
                _serie.Status_status  = item["serieStatus"].ToString();
                _serie.Rating_Rating  = item["rating"].ToString();
            }
            return(_serie);
        }
        public List <DataModels.Serie> getAllSeries(string status)
        {
            List <DataModels.Serie> series = new List <DataModels.Serie>();

            foreach (DataRow Dserie in db.getAllSeries(status).Rows)
            {
                DataModels.Serie serie = new DataModels.Serie();
                serie.idSeries       = Convert.ToInt32(Dserie["idSeries"]);
                serie.Name           = Dserie["Name"].ToString();
                serie.Season         = Convert.ToInt32(Dserie["Season"]);
                serie.Episode        = Convert.ToInt32(Dserie["episode"]);
                serie.Categorie_Type = Dserie["serieCategorie"].ToString();
                serie.Status_status  = Dserie["serieStatus"].ToString();
                serie.Rating_Rating  = Dserie["rating"].ToString();
                series.Add(serie);
            }
            return(series);
        }
 public void createSerie(DataModels.Serie serie)
 {
     db.createSerie(serie.Name, serie.Season, serie.Episode, serie.date_updated, serie.date_created, serie.Categorie_idType, serie.Rating_idRating, serie.Status_idStatus);
 }