public int InsertClubMember(clsRegistration cc)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertClubMember", cc.RegistrationId, cc.ClubMemberTypeId, cc.ClubID, cc.ClubMemberDesc, cc.PortalID, cc.CreatedById, cc.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateRegistration(clsRegistration cc)
{
try
{
dataProvider.ExecuteNonQuery("usp_UpdateRegistration", cc.UserId, cc.UserId_Admin, cc.Gender, cc.AddressLine1, cc.AddressLine2, cc.City, cc.State, cc.ZipPostalCode, cc.Country, cc.DateOfBirth, cc.PlaceOfBirth, cc.Height, cc.Weight, cc.ActiveFlagId, cc.ShowFlagId, cc.PortalID, cc.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int InsertTeamMember(clsRegistration cc)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertTeamMember", cc.TeamId, cc.RegistrationId, cc.TeamMemberTypeId, cc.TeamMemberJerseyNo, cc.TeamMemberJerseyName, cc.TeamMemberFamousName, cc.PortalID, cc.CreatedById, cc.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
//public int InsertPlayer(clsRegistration cc)
//{
// try
// {
// dataProvider.ExecuteNonQuery("usp_InsertPlayer", cc.TeamId, cc.RegistrationId, cc.PlayerJerseyNo, cc.PlayerJerseyName, cc.PlayerFamousName, cc.PortalID, cc.CreatedById, cc.ModifiedById, cc.PlayerTypeId,cc.PlayerPhoto);
// }
// catch (Exception ex)
// {
// Exceptions.LogException(ex);
// }
// return 0;
//}
public int InsertTeamPlayer(clsRegistration cc)
{
try
{
return(Convert.ToInt32(dataProvider.ExecuteScalar("usp_InsertTeamPlayer1", cc.RegistrationId, cc.TeamId, cc.PlayerTypeId, cc.CreatedById, cc.PortalID)));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int InsertRegistration(clsRegistration cc)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertRegistration", cc.UserId, cc.UserId_Admin, cc.Gender, cc.AddressLine1, cc.AddressLine2, cc.City, cc.State, cc.ZipPostalCode, cc.Country, Convert.ToDateTime(cc.DateOfBirth), cc.PlaceOfBirth, cc.Height, cc.Weight, cc.PortalID, cc.CreatedById, cc.ModifiedById);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int InsertUser(clsRegistration cc)
{
try
{
dataProvider.ExecuteNonQuery("usp_InsertUser", cc.UserTypeId, cc.UserName, cc.UserPassword, cc.UserPhotoName, cc.UserPhotoFile, cc.FirstName, cc.MiddleName, cc.LastName, cc.SuffixId, cc.EmailId, cc.TelephoneNumber, cc.ActiveFlagId, cc.ShowFlagId, cc.PortalID, cc.CreatedById, cc.ModifiedById, cc.UserRoleId);
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(0);
}
public int UpdateUser(clsRegistration cc)
{
int i = 0;
try
{
dataProvider.ExecuteNonQuery("usp_UpdateUser", cc.UserId, cc.UserTypeId, cc.UserPhotoName, cc.UserPhotoFile, cc.FirstName, cc.MiddleName, cc.LastName, cc.SuffixId, cc.EmailId, cc.TelephoneNumber, cc.ActiveFlagId, cc.ShowFlagId, cc.PortalID, cc.ModifiedById);
}
catch (Exception ex)
{
return(i);
}
return(i);
}
public DataTable GetUserPhotoByUserID(clsRegistration cc)
{
using (DataTable dt = new DataTable())
{
try
{
using (IDataReader reader = dataProvider.ExecuteReader("usp_GetUserPhotoByUserID", cc.UserId))
{
dt.Load(reader);
return(dt);
}
}
catch (Exception ex)
{
Exceptions.LogException(ex);
}
return(dt);
}
}
