public List <SeriesEntity> GetAllSeries()
{
List <SeriesEntity> listCollection = new List <SeriesEntity>();
DataTable dataItems = ExecuteDataTable("spr_GetAllSeries");
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
SeriesEntity item = new SeriesEntity();
item.ID = dataItems.Rows[i].Field <int>("SeriesID");
item.SeriesName = dataItems.Rows[i].Field <string>("SeriesName");
item.SeriesDefinition = dataItems.Rows[i].Field <string>("SeriesDefinition");
item.OccupationalInformation = dataItems.Rows[i].Field <string>("SeriesOccupationalInformation");
item.PayPlanID = dataItems.Rows[i].Field <int>("PayPlanID");
item.TypeOfWorkID = dataItems.Rows[i].IsNull("TypeOfWorkID") ? -1 : dataItems.Rows[i].Field <int>("TypeOfWorkID");
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a SeriesEntity collection from a null data table.");
}
return(listCollection);
}
public async Task <int> Create(CreateSeriesEntityViewModel model)
{
var name = $"{model.Name} - S_{model.Season} - Ep_{model.Episode}";
var seriesEntity = new SeriesEntity()
{
Name = name,
Episode = model.Episode,
Season = model.Season,
Poster = model.Poster,
Trailer = model.Trailer,
SeriesId = model.SeriesId
};
await this._repository.Add(seriesEntity);
await this._repository.SaveChangesAsync();
return(seriesEntity.Id);
}
public SeriesEntity GetSeriesBySeriesID(int seriesID)
{
SeriesEntity entity;
DataTable dt = ExecuteDataTable("spr_GetSeriesBySeriesID", seriesID);
if (dt != null && dt.Rows.Count > 0)
{
entity = new SeriesEntity();
entity.ID = dt.Rows[0].Field <int>("SeriesID");
entity.SeriesName = dt.Rows[0].Field <string>("SeriesName");
entity.SeriesDefinition = dt.Rows[0].Field <string>("SeriesDefinition");
entity.OccupationalInformation = dt.Rows[0].Field <string>("SeriesOccupationalInformation");
entity.PayPlanID = dt.Rows[0].Field <int>("PayPlanID");
entity.TypeOfWorkID = dt.Rows[0].IsNull("TypeOfWorkID") ? -1 : dt.Rows[0].Field <int>("TypeOfWorkID");
}
else
{
throw new Exception("You cannot create a SeriesEntity object from a null data table.");
}
return(entity);
}