public int InsertClub(clsClub cc)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertClub", cc.ClubName, cc.ClubAbbr, cc.ClubDesc, cc.ClubFamousName, cc.ClubLogoName, cc.ClubLogoFile, cc.ClubPhotoFile, Convert.ToDateTime(cc.ClubEstablishedYear), cc.ActiveFlagId, cc.ShowFlagId, cc.PortalID, cc.CreatedById, cc.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateClub(clsClub cc)
{
int i = 0;
try
{
//CompReg.CreatedBy,
dataProvider.ExecuteNonQuery("usp_UpdateClub", cc.ClubId, cc.ClubName, cc.ClubAbbr, cc.ClubDesc, cc.ClubFamousName, cc.ClubLogoName, cc.ClubLogoFile, cc.ClubPhotoFile, Convert.ToDateTime(cc.ClubEstablishedYear), cc.ActiveFlagId, cc.ShowFlagId, cc.PortalID, cc.ModifiedById);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetClubPhoto(clsClub cc)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_ClubPhoto", cc.ClubId))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}