/// <summary>
/// 他の会員をフォローする
/// </summary>
/// <param name="followerMemberId">フォローする会員(ログインユーザ)</param>
/// <param name="followingMemberId">フォローされる会員</param>
public static void follow(long followerMemberId, long followingMemberId)
{
try
{
if (followerMemberId <= 0)
throw new Exception("フォローする側の会員IDが不正です。");
if (followingMemberId <= 0)
throw new Exception("フォローされる側の会員IDが不正です。");
if (followerMemberId == followingMemberId)
throw new Exception("フォローする側とされる側の会員IDが同じです。");
using (ComEntities com = new ComEntities())
{
using (var dbContextTransaction = com.Database.BeginTransaction())
{
try
{
FollowList f = new FollowList
{
MemberID = followingMemberId,
FollowerMemberID = followerMemberId,
CreatedDate = DateTime.Now
};
com.FollowList.Add(f);
com.SaveChanges();
//お知らせ配信対象(NoticeDeliverySubject)テーブルにメール送信対象データを登録する。
var noticeId = (from ni in com.NoticeInfo
where ni.MailDelivCondID == 3
select ni.NoticeId).FirstOrDefault();
NoticeDeliverySubject nds = new NoticeDeliverySubject
{
NoticeId = (int)noticeId, //お知らせ(NoticeInfo)のMailDelivCondID = 3 のレコードのお知らせID(NoticeId)を設定
MemberId = (int)followingMemberId, //フォローされた会員ＩＤ
ClassClass = 6, //フォロー
UniqueID = (int)followerMemberId, //ログインユーザの会員ID
AlreadyReadFlg = false,
NoticeDeliveryStatus = 1,
CreatedAccountID = followerMemberId.ToString(),
CreatedDate = DateTime.Now
};
if (nds != null)
{
com.NoticeDeliverySubject.Add(nds);
com.SaveChanges();
}
NoticeInfo noticeInfo = (from ni in com.NoticeInfo
where ni.MailDelivCondID == 3 && ni.NoticeClass == 3
select ni).FirstOrDefault();
string title = noticeInfo.Title;
string body = noticeInfo.Body;
NoticeInfoForMyPage notice = new NoticeInfoForMyPage();
notice.ClassClass = NoticeInfoForMyPage.CLS_FOLLOW;
notice.MemberId = (int)followerMemberId;
notice.Follower = (from m in com.Member where m.MemberId == followerMemberId select m.Nickname).FirstOrDefault();
notice.Follow = (from m in com.Member where m.MemberId == followingMemberId select m.Nickname).FirstOrDefault();
notice.setTitle(NoticeInfoForMyPage.CLS_FOLLOW, title);
notice.setBody(NoticeInfoForMyPage.CLS_FOLLOW, body);
Splg.Areas.MyPage.MyPageCommon.SendMail(followingMemberId, notice.Title, notice.Body);
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// ポイント付与
/// </summary>
/// <param name="notice"></param>
private void setPointGiveInfo(NoticeInfoForMyPage notice)
{
int month = notice.UniqueID; //対象月
int week = (int)notice.UniqueID2; //対象週
int points = (int)notice.UniqueID3; //付与されたポイント
notice.TransitionsURL = "/mypage/";
notice.Month = month;
notice.Week = week;
notice.Points = points;
}
/// <summary>
/// ポイントが精算された場合
/// </summary>
/// <param name="notice"></param>
private void setPointPayoffInfo(NoticeInfoForMyPage notice)
{
int month = notice.UniqueID; //対象月
int week = (int)notice.UniqueID2; //対象週
notice.TransitionsURL = "/mypage/";
notice.Month = month;
notice.Week = week;
}
private void setGroupInfo(NoticeInfoForMyPage notice)
{
notice.TransitionsURL = "/mypage/group/" + notice.UniqueID2 + "/detail";
notice.Group = (from g in com.Groups where g.GroupID == notice.UniqueID2 select g.GroupName).FirstOrDefault();
notice.AddGroup = (from gm in com.Member where gm.MemberId == notice.UniqueID select gm.Nickname).FirstOrDefault();
}
/// <summary>
/// 予想した試合が開始しました！ hh:mm
/// 予想した試合が終了しました！ hh:mm
/// </summary>
/// <param name="notice"></param>
private void setGameInfo(NoticeInfoForMyPage notice)
{
int sportsId = notice.UniqueID;
int gameId = (int)notice.UniqueID2;
GameInfoViewModel game = NpbCommon.GetGameInfoByGameID(sportsId,gameId);
string sportsLetter = "";
if(sportsId == Constants.NPB_SPORT_ID)
sportsLetter = "npb";
if(sportsId == Constants.MLB_SPORT_ID)
sportsLetter = "mlb";
if(sportsId == Constants.JLG_SPORT_ID)
sportsLetter = "jleague";
notice.TransitionsURL = "/" + sportsLetter + "/game/" + gameId + "/";
notice.HomeTeam = game.HomeTeamName;
notice.HomeTeamS = game.HomeTeamNameS;
notice.VisitorTeam = game.VisitorTeamName;
notice.VisitorTeamS = game.VisitorTeamNameS;
notice.Place = game.StadiumName;
if (sportsId == Constants.JLG_SPORT_ID)
{
Splg.Services.Game.JlgService jlsService = new Splg.Services.Game.JlgService();
int occasionNo = jlsService.GetOccasionNo(game.GameDate, game.GameKindID);
string leagueName = "";
string periodStr = "";
switch (game.GameKindID)
{
case Splg.Areas.Jleague.JlgConstants.JLG_GAMEKIND_J1:
leagueName = "J１リーグ";
if (game.Round == 1)
{
periodStr = "1stステージ ";
}
else
{
periodStr = "2ndステージ ";
}
periodStr += "第" + occasionNo + "節";
break;
case Splg.Areas.Jleague.JlgConstants.JLG_GAMEKIND_J2:
leagueName = "J２リーグ";
periodStr = "第" + occasionNo + "節";
break;
case Splg.Areas.Jleague.JlgConstants.JLG_GAMEKIND_NABISCO:
leagueName = "ナビスコC";
if (game.Round == 1)
{
periodStr = "予選リーグ ";
}
else
{
periodStr = "決勝リーグ ";
}
periodStr += "第" + occasionNo + "節";
break;
}
notice.LeagueName = leagueName;
notice.Round = periodStr;
}
else
{
notice.Round = game.Round.ToString();
}
notice.Date = game.GameDate.ToString();
}
private void setFollowInfo(NoticeInfoForMyPage notice)
{
notice.TransitionsURL = "/user/" + notice.UniqueID + "/";
notice.Follower = (from m in com.Member where m.MemberId == notice.UniqueID select m.Nickname).FirstOrDefault();
notice.Follow = (from m in com.Member where m.MemberId == notice.MemberId select m.Nickname).FirstOrDefault();
}
public JsonResult AddGroup(MyPageGroupNewViewModel.AddGroupModel addGroupModel)
{
long loginMemberId = GetLoginMemberId();
var group_name = addGroupModel.GroupName;
try
{
/////////////////////////////////////////////////////////
//入力チェック
if (loginMemberId <= 0 && String.IsNullOrEmpty(group_name) )
{
addGroupModel.ErrorMessage = "グループを作成できません。";
return Json(addGroupModel, JsonRequestBehavior.AllowGet);
}
var group = (from g in com.Groups
where g.GroupName == group_name
&& g.MemberID == loginMemberId
&& g.Status == true
select g).FirstOrDefault();
if (group != null)
{
addGroupModel.ErrorMessage = "同じ名前のグループがすでにあります。";
return Json(addGroupModel, JsonRequestBehavior.AllowGet);
}
/////////////////////////////////////////////////////////
//新規グループを作成する
var newGroup = new Groups
{
GroupName = group_name,
MemberID = loginMemberId,
Status = true, // ０・・無効 1・・有効
CreatedAccountID = loginMemberId.ToString()
};
com.Groups.Add(newGroup);
com.SaveChanges();
var group_id = (from g in com.Groups
where g.GroupName == group_name
&&
g.MemberID == loginMemberId
select g.GroupID).FirstOrDefault();
addGroupModel.GroupID = Convert.ToInt32(group_id);
/////////////////////////////////////////////////////////
//グループメンバーの更新
using (var dbContextTransaction = com.Database.BeginTransaction())
{
try
{
if (addGroupModel.MemberIDs == null)
{
addGroupModel.MemberIDs = new List<long>();
}
//メンバーに自身を追加
addGroupModel.MemberIDs.Add(loginMemberId);
//通知メールのタイトルと本文を取得
NoticeInfo noticeInfo = (from ni in com.NoticeInfo
where ni.MailDelivCondID == 4 && ni.NoticeClass == 3
select ni).FirstOrDefault();
string title = noticeInfo.Title;
string body = noticeInfo.Body;
//追加メンバーの一覧からグループメンバーを新規作成
foreach (var newMemberId in addGroupModel.MemberIDs)
{
var newGroupMember = new GroupMember
{
GroupID = group_id,
MemberID = newMemberId,
CreatedAccountID = loginMemberId.ToString(),
CreatedDate = DateTime.Now
};
com.GroupMember.Add(newGroupMember);
//新規に追加する会員向けにメール通知
if (loginMemberId == newMemberId)
continue;
//追加する会員向けにメール通知
NoticeInfoForMyPage notice = new NoticeInfoForMyPage();
notice.ClassClass = NoticeInfoForMyPage.CLS_GROUP;
notice.AddGroup = (from gm in com.Member where gm.MemberId == loginMemberId select gm.Nickname).FirstOrDefault();
notice.GroupID = group_id.ToString();
notice.Group = (from g in com.Groups where g.GroupID == group_id select g.GroupName).FirstOrDefault();
notice.Nickname = (from gm in com.Member where gm.MemberId == loginMemberId select gm.Nickname).FirstOrDefault();
notice.setTitle(NoticeInfoForMyPage.CLS_GROUP, title);
notice.setBody(NoticeInfoForMyPage.CLS_GROUP, body);
MyPageCommon.SendMail(newMemberId, notice.Title, notice.Body);
//新規に追加する会員向けにお知らせ配信対象を生成
var newNotice = new NoticeDeliverySubject
{
NoticeId = Convert.ToInt32(noticeInfo.NoticeId),
MemberId = Convert.ToInt32(newMemberId),
ClassClass = 7,
UniqueID = Convert.ToInt32(loginMemberId), //グループに入れた会員ＩＤを保存
UniqueID2 = Convert.ToInt32(group_id),
AlreadyReadFlg = false,
NoticeDeliveryStatus = 1,
CreatedAccountID = loginMemberId.ToString(),
CreatedDate = DateTime.Now
};
com.NoticeDeliverySubject.Add(newNotice);
}
com.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
}
catch (Exception ex)
{
throw ex;
}
return Json(addGroupModel, JsonRequestBehavior.AllowGet);
}
public JsonResult UpdateGroup(MyPageGroupEditViewModel.AddGroupModel addGroupModel)
{
long loginMemberId = GetMemberID();
var group_id = addGroupModel.GroupID;
try
{
/////////////////////////////////////////////////////////
//入力チェック
if (loginMemberId <= 0 && group_id <= 0)
{
addGroupModel.ErrorMessage = "グループを編集できません。";
return Json(addGroupModel, JsonRequestBehavior.AllowGet);
}
var group = (from g in com.Groups
where g.GroupID == group_id
select g).FirstOrDefault();
if (group == null)
{
addGroupModel.ErrorMessage = "グループがありません。";
return Json(addGroupModel, JsonRequestBehavior.AllowGet);
}
/////////////////////////////////////////////////////////
//グループ情報を更新する
group.GroupName = addGroupModel.GroupName;
group.ModifiedAccountID = loginMemberId.ToString();
group.ModifiedDate = DateTime.Now;
/////////////////////////////////////////////////////////
//グループメンバーの更新
using (var dbContextTransaction = com.Database.BeginTransaction())
{
try
{
//既存メンバーを一旦削除
//TODO 将来削除対象のみ削除するように変更
var existingMembers = from g in com.GroupMember
where g.GroupID == group_id
select g;
foreach (var gm in existingMembers)
{
com.GroupMember.Remove(gm);
}
com.SaveChanges();
//メンバーに自身を追加
if (addGroupModel.MemberIDs == null)
addGroupModel.MemberIDs = new List<long> { };
if (!addGroupModel.MemberIDs.Contains(loginMemberId))
addGroupModel.MemberIDs.Add(loginMemberId);
//通知メールのタイトルと本文を取得
NoticeInfo noticeInfo = (from ni in com.NoticeInfo
where ni.MailDelivCondID == 4 && ni.NoticeClass == 3
select ni).FirstOrDefault();
string title = noticeInfo.Title;
string body = noticeInfo.Body;
//追加メンバーの一覧からグループメンバーを新規追加
//TODO 将来新規追加対象のみ追加するように変更
foreach (long newMemberId in addGroupModel.MemberIDs)
{
var newGroupMember = new GroupMember
{
GroupID = group_id,
MemberID = newMemberId,
CreatedAccountID = loginMemberId.ToString(),
CreatedDate = DateTime.Now
};
com.GroupMember.Add(newGroupMember);
//新規に追加する会員向けにメール通知
if (!IsNewMember(newMemberId, loginMemberId, existingMembers))
continue;
NoticeInfoForMyPage notice = new NoticeInfoForMyPage();
notice.ClassClass = NoticeInfoForMyPage.CLS_GROUP;
notice.AddGroup = (from gm in com.Member where gm.MemberId == loginMemberId select gm.Nickname).FirstOrDefault();
notice.GroupID = group_id.ToString();
notice.Group = (from g in com.Groups where g.GroupID == group_id select g.GroupName).FirstOrDefault();
notice.Nickname = (from gm in com.Member where gm.MemberId == loginMemberId select gm.Nickname).FirstOrDefault();
notice.setTitle(NoticeInfoForMyPage.CLS_GROUP, title);
notice.setBody(NoticeInfoForMyPage.CLS_GROUP, body);
MyPageCommon.SendMail(newMemberId, notice.Title, notice.Body);
//新規に追加する会員向けにお知らせ配信対象を生成
var newNotice = new NoticeDeliverySubject
{
NoticeId = Convert.ToInt32(noticeInfo.NoticeId),
MemberId = Convert.ToInt32(newMemberId),
ClassClass = 7,
UniqueID = Convert.ToInt32(loginMemberId), //グループに入れた会員ＩＤを保存
UniqueID2 = Convert.ToInt32(group_id),
AlreadyReadFlg = false,
NoticeDeliveryStatus = 1,
CreatedAccountID = loginMemberId.ToString(),
CreatedDate = DateTime.Now
};
com.NoticeDeliverySubject.Add(newNotice);
}
com.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
}
catch (Exception ex)
{
throw ex;
}
return Json(addGroupModel, JsonRequestBehavior.AllowGet);
}
