internal static int AddCLoginUserClub(CLoginUserClub userClub)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
string sql = "insert into " + database2 + @".C_LoginUserClub(UserId,ClubId,JoinDate) values(@UserId,@ClubId,'" + DateTime.Now + "')";
cn.Open();
cn.Query <Resource>(sql, userClub);
return(1);
}
}
internal static int DeleteCLoginUserClub(CLoginUserClub userClub)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
string sql = "delete from " + database2 + @".C_LoginUserClub where UserId =@UserId and ClubId=@ClubId";
cn.Open();
cn.Query <Resource>(sql, userClub);
return(1);
}
}
public static bool DeleteCLoginUserClub(CLoginUserClub userClub)
{
return(ClubDAL.DeleteCLoginUserClub(userClub) > 0);
}
public static bool AddCLoginUserClub(CLoginUserClub userClub)
{
return(ClubDAL.AddCLoginUserClub(userClub) > 0);
}
