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); } }