/// <summary> /// UpdateMember method /// - Update Member table row by member information /// </summary> /// <param name="member">Member information</param> /// <returns></returns> public bool UpdateMember(Member member) { try { using (connection) { connection.Open(); int ret = MsSqlDataHelperFactory.Execute(connection, CommandType.StoredProcedure, "Product.dbo.sp_Memberships_Update_Member", MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberName", member.MemberName, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@IsAvailable", member.IsAvailable, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@Email", member.Email, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@PhoneNumber", member.PhoneNumber, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@Address", member.Address, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberID", member.MemberID, ParameterDirection.Input) ); return((ret == 1) ? true : false); } } catch (Exception ex) { throw ex; } }
/// <summary> /// UpdateMember method /// - Update Member table row by member information /// </summary> /// <param name="member">Member information</param> /// <returns></returns> public bool UpdateMember(Member member) { try { using (connection) { connection.Open(); int ret = MsSqlDataHelperFactory.Execute(connection, CommandType.Text, @"UPDATE Product.dbo.Member " + @"SET MemberName = @MemberName, IsAvailable = @IsAvailable, Email = @Email, " + @" PhoneNumber = @PhoneNumber, Address = @Address " + @"WHERE MemberID = @MemberID ", MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberName", member.MemberName, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@IsAvailable", member.IsAvailable, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@Email", member.Email, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@PhoneNumber", member.PhoneNumber, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@Address", member.Address, ParameterDirection.Input), MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberID", member.MemberID, ParameterDirection.Input) ); return((ret == 1) ? true : false); } } catch (Exception ex) { throw ex; } }
/// <summary> /// DeleteMember() method /// - Delete Member table row by memberID /// </summary> /// <param name="memberID">Member ID</param> /// <returns></returns> public bool DeleteMember(int memberID) { try { using (connection) { connection.Open(); int ret = MsSqlDataHelperFactory.Execute(connection, CommandType.StoredProcedure, "Product.dbo.sp_Memberships_Delete_Member_By_MemberID", MsSqlParameterHelperFactory.CreateParameter <SqlDbType>(providerName, "@MemberID", memberID, SqlDbType.Int, ParameterDirection.Input) ); return((ret == 1) ? true : false); } } catch (Exception ex) { throw ex; } }
/// <summary> /// DeleteMember() method /// - Delete Member table row by memberID /// </summary> /// <param name="memberID">Member ID</param> /// <returns></returns> public bool DeleteMember(int memberID) { try { using (connection) { connection.Open(); int ret = MsSqlDataHelperFactory.Execute(connection, CommandType.Text, @"DELETE FROM Product.dbo.Member " + @"WHERE MemberID = @MemberID ", MsSqlParameterHelperFactory.CreateParameter <SqlDbType>(providerName, "@MemberID", memberID, SqlDbType.Int, ParameterDirection.Input) ); return((ret == 1) ? true : false); } } catch (Exception ex) { throw ex; } }