public int InsertSeason(clsSeason cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertSeason", cs.CountryID, cs.SeasonName, cs.SeasonDesc, Convert.ToDateTime(cs.StartDate), Convert.ToDateTime(cs.EndDate), cs.SeasonLogoName, cs.SeasonLogoFile, cs.ActiveFlagID, cs.ShowFlagID, cs.PortalID, cs.CreatedByID, cs.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateSeason(clsSeason cs)
{
int i = 0;
try
{
//CompReg.CreatedBy,
dataProvider.ExecuteNonQuery("usp_UpdateSeason", cs.SeasonID, cs.CountryID, cs.SeasonName, cs.SeasonDesc, Convert.ToDateTime(cs.StartDate), Convert.ToDateTime(cs.EndDate), cs.SeasonLogoName, cs.SeasonLogoFile, cs.ActiveFlagID, cs.ShowFlagID, cs.PortalID, cs.ModifiedById);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetSeasonLogoBySeasonID(clsSeason cs)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetSeasonLogoBySeasonID", cs.SeasonID))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}