public static void ApplyJoinClub(int userID, string userName, int clubID)
{
var ah = new ApplyHistory();
ah.Userid = userID;
ah.UserName = userName;
ah.ClubUid = clubID;
ah.ApplyDate = DateTime.Now;
ClubLogic.SaveApplyHistory(ah);
ClubSysPrivateMessage.SendMessage(clubID, userName, ClubSysMessageType.ApplyJoinClub);
}
public static void ApplyJoinClub(int userID, string userName, int clubID)
{
var ah = new ApplyHistory();
ah.Userid = userID;
ah.UserName = userName;
ah.ClubUid = clubID;
ah.ApplyDate = DateTime.Now;
ClubLogic.SaveApplyHistory(ah);
ClubSysPrivateMessage.SendMessage(clubID, userName, ClubSysMessageType.ApplyJoinClub);
}
internal static void SaveApplyHistory(ApplyHistory ah)
{
using (var con = SQLConn.GetConnection())
{
var com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "[dbo].[SaveApplyHistory]";
com.Parameters.Add(new SqlParameter("@ID", ParseNullableParam(ah.ID)));
com.Parameters.Add(new SqlParameter("@userID", ah.Userid));
com.Parameters.Add(new SqlParameter("@userName", ah.UserName));
com.Parameters.Add(new SqlParameter("@clubUid", ah.ClubUid));
com.Parameters.Add(new SqlParameter("@applyDate", ah.ApplyDate));
com.Parameters.Add(new SqlParameter("@isAccepted", ParseNullableParam(ah.IsAccepted)));
con.Open();
com.ExecuteNonQuery();
//con.Close();
}
}
internal static void SaveApplyHistory(ApplyHistory ah)
{
using (var con = SQLConn.GetConnection())
{
var com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "[dbo].[SaveApplyHistory]";
com.Parameters.Add(new SqlParameter("@ID", ParseNullableParam(ah.ID)));
com.Parameters.Add(new SqlParameter("@userID", ah.Userid));
com.Parameters.Add(new SqlParameter("@userName", ah.UserName));
com.Parameters.Add(new SqlParameter("@clubUid", ah.ClubUid));
com.Parameters.Add(new SqlParameter("@applyDate", ah.ApplyDate));
com.Parameters.Add(new SqlParameter("@isAccepted", ParseNullableParam(ah.IsAccepted)));
con.Open();
com.ExecuteNonQuery();
//con.Close();
}
}
