public int InsertSport(clsSport cs)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertSport", cs.SportName, cs.SportDesc, cs.SportMainImageFile, cs.SportMainImageDesc, cs.SportLogoImageFile, cs.SportLogoImageDesc, cs.SportSmallImageFile, cs.SportSmallImageDesc, cs.ActiveFlagID, cs.ShowFlagID, cs.PortalID, cs.CreatedByID, cs.ModifiedByID);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateSport(clsSport cs)
{
int i = 0;
try
{
//CompReg.CreatedBy,
dataProvider.ExecuteNonQuery("usp_UpdateSport", cs.SportID, cs.SportName, cs.SportDesc, cs.SportMainImageFile, cs.SportMainImageDesc, cs.SportLogoImageFile, cs.SportLogoImageDesc, cs.SportSmallImageFile, cs.SportSmallImageDesc, cs.ActiveFlagID, cs.ShowFlagID, cs.PortalID, cs.ModifiedByID);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetSportSmallImageBySportID(clsSport cs)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetSportSmallImageBySportID", cs.SportID))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}