public async Task <HttpResponseMessage> UpdateAnnouncementFavorite(int userID, int favID, string fav)
{
try
{
AnnouncementDAL dal = new AnnouncementDAL();
JsonResponse response = await dal.UpdateAnnouncementFavorite(userID, favID, fav);
if (response != null && response.Flag)
{
return(Request.CreateResponse <JsonResponse>(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
public async Task <HttpResponseMessage> GetAnnouncementFavorite(int userID, int currentIndex, int maxRows)
{
try
{
AnnouncementDAL dal = new AnnouncementDAL();
List <AnnouncementInfo> data = await dal.GetAnnouncementFavorite(userID, currentIndex, maxRows);
if (data != null)
{
return(Request.CreateResponse <List <AnnouncementInfo> >(HttpStatusCode.OK, data));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
public static void UpdateAnnouncement(string ID, string title, string body, DateTime expiredate, string Attachment, string currentuser)
{
body = body.Replace("\r\n", "");
if (ID == string.Empty)
{
AnnouncementDAL.InsertAnnouncement(title, body, expiredate, currentuser, Attachment);
}
else
{
AnnouncementDAL.UpdateAnnouncement(title, body, expiredate, currentuser, ID, Attachment);
}
}
public async Task <HttpResponseMessage> GetStudentDashboard(int userID, int batchID, string role, int currentIndex, int maxRows)
{
try
{
MIUEntities db = new MIUEntities();
StudentDashboardInfo data = new StudentDashboardInfo();
EventCalendarDAL dal = new EventCalendarDAL();
NewsDAL newsDAL = new NewsDAL();
ResultDAL resultDAL = new ResultDAL();
AnnouncementDAL announcementDAL = new AnnouncementDAL();
ReportAttendanceDAL reportAttendanceDAL = new ReportAttendanceDAL();
data.EventCalendar = await dal.GetAllEventCalendar(userID, role);
data.News = await newsDAL.GetNews(userID, currentIndex, maxRows);
string batchCode = db.Batches.Where(x => x.ID == batchID).Select(x => x.BatchCode).SingleOrDefault();
data.StudentDashboard = await resultDAL.GetResult(userID, batchCode);
data.Announcement = await announcementDAL.GetLatestAnnouncement();
//data.AttRateAndPercent = await reportAttendanceDAL.GetAttRateAndPercent(batchID, userID);
if (data != null)
{
return(Request.CreateResponse <StudentDashboardInfo>(HttpStatusCode.OK, data));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
public async Task <HttpResponseMessage> GetLectureDashboard(int accessorID, string role, int courseID = 0)
{
try
{
MIUEntities db = new MIUEntities();
LectureDashboardInfo data = new LectureDashboardInfo();
StudentDashboardDAL dal = new StudentDashboardDAL();
NewsDAL newsDAL = new NewsDAL();
ResultDAL resultDAL = new ResultDAL();
AnnouncementDAL announcementDAL = new AnnouncementDAL();
EventCalendarDAL eventDAL = new EventCalendarDAL();
//data.AttRateAndPercent = await reportAttendanceDAL.GetAttRateAndPercent(batchID, userID);
data = await dal.GetLectureDashboard(accessorID, courseID);
data.Announcement = await announcementDAL.GetLatestAnnouncement();
data.News = newsDAL.GetNews(accessorID, 1, 5).Result;
data.EventCalendar = eventDAL.GetAllEventCalendar(accessorID, role).Result;
//data.EventCalendar = eventDAL.GetEventCalendar(accessorID, 1, 5).Result;
if (data != null)
{
return(Request.CreateResponse <LectureDashboardInfo>(HttpStatusCode.OK, data));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
public static void DeleteAnnouncement(string IDs)
{
AnnouncementDAL.DeleteAnnouncement(IDs);
}
public static DataSet GetAnnouncementList(string where)
{
return(AnnouncementDAL.GetAnnouncementList(where));
}
public static DataSet GetAnnouncementByID(string id)
{
return(AnnouncementDAL.GetAnnouncementList("ID=" + id));
}
public void ExecuteCommand(GameSession session, ProtobufRequestInfo requestInfo)
{
IPEndPoint clientipe = session.RemoteEndPoint;
session.Logger.Debug("登陆sssionID--------" + session.SessionID);
string fileName = string.Empty; //文件名
string headImg = string.Empty; //头像图片
session.Logger.Debug("登录游戏----------" + DateTime.Now);
var userinfo = SendLogin.ParseFrom(requestInfo.Body);
mjuserinfo usermodel = new mjuserinfo();
mjuserinfo model = new mjuserinfo()
{
nickname = userinfo.Nickname,
openid = userinfo.Openid,
city = userinfo.City,
headimg = userinfo.Headimg,
province = userinfo.Province,
unionid = userinfo.Unionid,
sex = int.Parse(userinfo.Sex),
Oldheadimg = userinfo.Headimg,
is_band = UserType
};
usermodel = AddUser(model, session);
session.Logger.Debug("登录用户openid:" + userinfo.Openid + "|昵称:" + userinfo.Nickname + "----------" + DateTime.Now);
// UserInfo olduser = Gongyong.userlist.Find(u => u.openid == userinfo.Openid);
RedisLoginModel olduser = RedisUtility.Get <RedisLoginModel>(RedisUtility.GetKey(GameInformationBase.COMMUNITYUSERLIST, userinfo.Openid, userinfo.Unionid));
if (olduser == null)
{
NewUserLogin(userinfo, usermodel, session, clientipe, GameInformationBase.serverName, requestInfo);
}
else if (olduser.ServerName.Equals(GameInformationBase.serverName))
{
UserInfo userInfo = Gongyong.userlist.Find(u => u.openid == userinfo.Openid);
// 可能会存在缓存服务器有用户信息，而服务器没有的情况。因此需要再次判断
if (userInfo == null)
{
NewUserLogin(userinfo, usermodel, session, clientipe, GameInformationBase.serverName, requestInfo);
session.Logger.Debug("新登录用户openid:" + userinfo.Openid);
}
else if (userInfo.session.Connected)
{
ReturnLogin log = ReturnLogin.CreateBuilder().SetLoginstat(2).SetUserID(int.Parse(usermodel.id.ToString())).SetUserRoomCard(0).Build();
byte[] msg = log.ToByteArray();
session.TrySend(new ArraySegment <byte>(CreateHead.CreateMessage(GameInformationBase.BASEAGREEMENTNUMBER + 1002, msg.Length, requestInfo.MessageNum, msg)));
session.Logger.Debug("登录游戏失败,当前对象存在----------" + DateTime.Now);
session.Logger.Debug("sssionID--------" + session.SessionID);
}
else
{
session.Logger.Debug("登录游戏成功,当前对象存在----------" + DateTime.Now);
var redisUserInfo = RedisUtility.Get <RedisGameModel>(RedisUtility.GetKey(GameInformationBase.COMMUNITYUSERGAME, userinfo.Openid, userinfo.Unionid));
// UserInfo user = Gongyong.userlist.Find(u => u.openid == userinfo.Openid);
userInfo.city = userinfo.City;
//判断图片是否保存至图片服务器，保存相应头像地址
userInfo.headimg = usermodel.headimg;
userInfo.nickname = userinfo.Nickname;
userInfo.openid = userinfo.Openid;
userInfo.province = userinfo.Province;
userInfo.session = session;
userInfo.sex = userinfo.Sex;
userInfo.unionid = userinfo.Unionid;
userInfo.Lat = userinfo.Latitude;
userInfo.UserID = long.Parse(usermodel.id.ToString());
userInfo.UserIP = clientipe.Address.ToString();
userInfo.GroupID = groupStaffInfoDAL.GetGroupIDByUserID(usermodel.id).ToList();
userInfo.Type = UserType;
//userInfo.GroupID.AddRange(groupInfoDAL.GetGroupIDByUserID(usermodel.id));//因为圈主 不存在圈子成员表中， 所以需要单独再添加一次
RedisUtility.Set(RedisUtility.GetKey(GameInformationBase.COMMUNITYUSERINFO, userinfo.Openid, userinfo.Unionid), new RedisUserInfoModel(userInfo));
// mjuser mju = Gongyong.mulist.Find(u => u.Openid == userinfo.Openid);
bool isSendCL = false;
if (redisUserInfo != null && redisUserInfo.RoomID != 0)
{
//SendCL(session, userinfo.Openid, requestInfo);
isSendCL = RedisUtility.GetServerIP(redisUserInfo.ServerName, requestInfo.MessageNum, session, 2, userinfo.Openid, userinfo.Unionid, true, redisUserInfo.RoomID);//2为有未结束的游戏
}
//UserClient userClient = new UserClient();
//userClient.UpdateUserInfo(new registrationactivitiesModel { GameUserID = userInfo.UserID.ToString(), HeadImgurl = userInfo.headimg, UnionID = userInfo.unionid, LastTime = DateTime.Now, NickName = userInfo.nickname });
//var resultData = JsonConvert.DeserializeObject<ResultData>(userClient.GetGameCurrency(userInfo.unionid)).Data;
long roomCard = 0;
roomCard = UserType == 1 ? UserLongBao : RoomCardUtility.GetRoomCard(userInfo.UserID);
//long.TryParse(resultData == null ? "0" : resultData.ToString(), out roomCard);
userInfo.session = session;
var log = ReturnLogin.CreateBuilder().SetLoginstat(1).SetUserID(int.Parse(usermodel.id.ToString())).SetUserRoomCard(roomCard);
if (!string.IsNullOrEmpty(CerStr))
{
log.SetCertificate(CerStr);//返回证书
log.SetUnionid(userInfo.unionid);
log.SetHeadimg(userInfo.headimg);
log.SetUserName(userInfo.nickname);
}
byte[] msg = log.Build().ToByteArray();
// if(!isSendCL)
session.TrySend(new ArraySegment <byte>(CreateHead.CreateMessage(GameInformationBase.BASEAGREEMENTNUMBER + 1002, msg.Length, requestInfo.MessageNum, msg)));
var list = new AnnouncementDAL().GetAnnouncement();//获取公告列表
var returnAnnouncement = ReturnAnnouncement.CreateBuilder();
foreach (var item in list)
{
returnAnnouncement.AddAnnouncement(AnnouncementInfo.CreateBuilder().SetTitle(item.Title).SetContent(item.Content).Build());
}
var dataInfo = returnAnnouncement.Build().ToByteArray();
session.TrySend(new ArraySegment <byte>(CreateHead.CreateMessage(GameInformationBase.BASEAGREEMENTNUMBER + 8001, dataInfo.Length, requestInfo.MessageNum, dataInfo)));
session.Logger.Debug("登录游戏成功,当前对象存在----------" + DateTime.Now);
}
}
else//如果用户登录的服务器不是当前服务器，则返回登录的服务器IP和端口
{
UserInfo userInfo = Gongyong.userlist.Find(u => u.openid == userinfo.Openid);
var log = ReturnLogin.CreateBuilder().SetLoginstat(1).SetUserID(int.Parse(usermodel.id.ToString())).SetUserRoomCard(0);
if (!string.IsNullOrEmpty(CerStr))
{
log.SetCertificate(CerStr);//返回证书
log.SetUnionid(userInfo.unionid);
log.SetHeadimg(userInfo.headimg);
log.SetUserName(userInfo.nickname);
}
byte[] msg = log.Build().ToByteArray();
session.TrySend(new ArraySegment <byte>(CreateHead.CreateMessage(GameInformationBase.BASEAGREEMENTNUMBER + 1002, msg.Length, requestInfo.MessageNum, msg)));
RedisUtility.GetServerIP(olduser.ServerName, requestInfo.MessageNum, session, 1, userinfo.Openid, userinfo.Unionid);//2为有未结束的游戏
session.Logger.Debug("有未结束的游戏");
}
}
/// <summary>
/// 新用户登录信息保存
/// </summary>
/// <param name="userinfo"></param>
/// <param name="usermodel"></param>
/// <param name="session"></param>
/// <param name="clientipe"></param>
/// <param name="serverName"></param>
/// <param name="requestInfo"></param>
private void NewUserLogin(SendLogin userinfo, mjuserinfo usermodel, GameSession session, IPEndPoint clientipe, string serverName, ProtobufRequestInfo requestInfo)
{
UserInfo user = new UserInfo()
{
city = userinfo.City,
//判断图片是否保存至图片服务器，保存相应头像地址
headimg = usermodel.headimg,
nickname = userinfo.Nickname,
openid = userinfo.Openid,
province = userinfo.Province,
session = session,
sex = userinfo.Sex,
unionid = userinfo.Unionid,
Lat = userinfo.Latitude,
UserID = usermodel.id,
UserIP = clientipe.Address.ToString(),
GroupID = groupStaffInfoDAL.GetGroupIDByUserID(usermodel.id).ToList(),
Type = UserType,
ConnTime = DateTime.Now
};
var redisUserInfo = RedisUtility.Get <RedisGameModel>(RedisUtility.GetKey(GameInformationBase.COMMUNITYUSERGAME, userinfo.Openid, userinfo.Unionid));
//user.GroupID.AddRange(groupInfoDAL.GetGroupIDByUserID(usermodel.id));//因为圈主 不存在圈子成员表中， 所以需要单独再添加一次
// UserClient userClient = new UserClient();
// userClient.UpdateUserInfo(new registrationactivitiesModel { GameUserID = user.UserID.ToString(), HeadImgurl = user.headimg, UnionID = user.unionid, LastTime = DateTime.Now, NickName = user.nickname });
//var resultData = JsonConvert.DeserializeObject <ResultData> (userClient.GetGameCurrency(user.unionid)).Data;
long roomCard = roomCard = UserType == 1 ? UserLongBao : RoomCardUtility.GetRoomCard(user.UserID);
// long.TryParse(resultData == null ?"0":resultData.ToString(), out roomCard); //resultData==null?"0": resultData.ToString()//userClient.GetGameCurrencyList(user.unionid)//resultData ? Convert.ToInt64(resultData.Data) : 0;
Gongyong.userlist.Add(user);
RedisUtility.Set(RedisUtility.GetKey(GameInformationBase.COMMUNITYUSERLIST, userinfo.Openid, userinfo.Unionid), new RedisLoginModel {
Openid = userinfo.Openid, ServerName = serverName, Unionid = userinfo.Unionid
});
RedisUtility.Set(RedisUtility.GetKey(GameInformationBase.COMMUNITYUSERINFO, userinfo.Openid, userinfo.Unionid), new RedisUserInfoModel(user));
var A = RedisUtility.Get <RedisLoginModel>(RedisUtility.GetKey(GameInformationBase.COMMUNITYUSERLIST, userinfo.Openid, userinfo.Unionid));
var log = ReturnLogin.CreateBuilder().SetLoginstat(1).SetUserID(int.Parse(usermodel.id.ToString())).SetUserRoomCard(roomCard);
if (!string.IsNullOrEmpty(CerStr))
{
log.SetCertificate(CerStr);//返回证书
log.SetUnionid(user.unionid);
log.SetHeadimg(user.headimg);
log.SetUserName(user.nickname);
}
byte[] msg = log.Build().ToByteArray();
bool isSendCL = false;
if (redisUserInfo != null && redisUserInfo.RoomID != 0)
{
//SendCL(session, userinfo.Openid, requestInfo);
isSendCL = RedisUtility.GetServerIP(redisUserInfo.ServerName, requestInfo.MessageNum, session, 2, userinfo.Openid, userinfo.Unionid, true, redisUserInfo.RoomID);//2为有未结束的游戏
}
// if (!isSendCL)
session.TrySend(new ArraySegment <byte>(CreateHead.CreateMessage(GameInformationBase.BASEAGREEMENTNUMBER + 1002, msg.Length, requestInfo.MessageNum, msg)));
var list = new AnnouncementDAL().GetAnnouncement();//获取公告列表
var returnAnnouncement = ReturnAnnouncement.CreateBuilder();
foreach (var item in list)
{
returnAnnouncement.AddAnnouncement(AnnouncementInfo.CreateBuilder().SetTitle(item.Title).SetContent(item.Content).Build());
}
var data = returnAnnouncement.Build().ToByteArray();
session.TrySend(new ArraySegment <byte>(CreateHead.CreateMessage(GameInformationBase.BASEAGREEMENTNUMBER + 8001, data.Length, requestInfo.MessageNum, data)));
session.Logger.Debug("登录游戏成功----------" + DateTime.Now);
}
