public JsonResult Load_MessageMembers(string GroupName) { string jsonString = string.Empty; try { MessageGroups messageGroup = new MessageGroups(); MessageGroupsModel messageGroupModel = new MessageGroupsModel(); List <MessageGroupsModel> messageGroupList = new List <MessageGroupsModel>(); messageGroup.GroupName = GroupName; actionResult = messagesAction.MessageGroups_LoadByGroupName(messageGroup); if (actionResult.IsSuccess && actionResult.dtResult.Rows.Count > 0) { for (int i = 0; i < actionResult.dtResult.Rows.Count; i++) { jsonString += " <option value = " + actionResult.dtResult.Rows[i]["ID"] + " > " + actionResult.dtResult.Rows[i]["FullName"] + " </ option >"; } } } catch (Exception) { jsonString = "-1"; return(Json(jsonString, JsonRequestBehavior.AllowGet)); } return(Json(jsonString, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadMessageDistribution() { string jsonString = string.Empty; try { MessageGroups messageGroup = new MessageGroups(); MessageGroupsModel messageGroupModel = new MessageGroupsModel(); List <MessageGroupsModel> messageGroupList = new List <MessageGroupsModel>(); actionResult = messagesAction.MessageGroups_LoadDistinctGroupName(); //messageGroupList = (from DataRow row in actionResult.dtResult.Rows // select new MessageGroupsModel // { // GroupName = row["GroupName"] != DBNull.Value ? row["GroupName"].ToString() : "", // }).ToList(); //messageGroupModel.MessageGroupsList = messageGroupList; if (actionResult.IsSuccess && actionResult.dtResult.Rows.Count > 0) { for (int i = 0; i < actionResult.dtResult.Rows.Count; i++) { jsonString += " <option value = " + actionResult.dtResult.Rows[i]["GroupName"] + " onclick = \"Fillgroup('" + actionResult.dtResult.Rows[i]["GroupName"] + "'); \" > " + actionResult.dtResult.Rows[i]["GroupName"] + " </ option >"; } } } catch (Exception) { jsonString = "-1"; return(Json(jsonString, JsonRequestBehavior.AllowGet)); } return(Json(jsonString, JsonRequestBehavior.AllowGet)); }
public DateTimeOffset?GetLatestMessageDateByIp(string sentFromIp, MessageGroups messageGroup) { DateTimeOffset?result = db .Messages .AsNoTracking() .Where(x => x.SentFromIP == sentFromIp && x.MessageGroupId == messageGroup) .Max(x => x.SentDate); return(result); }
// GET: Messages/Messages #region Message Index public ActionResult Index(int?messageID = 0) { MessagesModel model = new MessagesModel(); List <MessagesModel> messagesList = new List <MessagesModel>(); MessageGroups messageGroup = new MessageGroups(); MessageGroupsModel messageGroupModel = new MessageGroupsModel(); List <MessageGroupsModel> msgGroupList = new List <MessageGroupsModel>(); actionResult = messagesAction.MessageGroups_LoadDistinctGroupName(); if (actionResult.IsSuccess) { msgGroupList = (from DataRow row in actionResult.dtResult.Rows select new MessageGroupsModel { GroupName = row["GroupName"] != DBNull.Value ? row["GroupName"].ToString() : "" }).ToList(); } model.msgGroupList = msgGroupList; if (messageID.Value > 0) { messages.MessageID = messageID.Value; actionResult = messagesAction.Message_LoadByID(messages); if (actionResult.IsSuccess && actionResult.dtResult.Rows.Count > 0) { DataRow row = actionResult.dtResult.Rows[0]; model.MessageID = row["MessageID"] != DBNull.Value ? Convert.ToInt32(row["MessageID"]) : 0; model.Description = row["Description"] != DBNull.Value ? row["Description"].ToString() : ""; model.MessageText = row["MessageText"] != DBNull.Value ? row["MessageText"].ToString() : ""; } } //MessageGroupsModel msgGroupModel = new MessageGroupsModel(); List <UserModel> userList = new List <UserModel>(); UserModel userModel = new UserModel(); actionResult = adminAction.Users_LoadAll(); userList = (from DataRow row in actionResult.dtResult.Rows select new UserModel { UserID = row["ID"] != DBNull.Value ? row["ID"].ToString() : "", UserName = row["UserName"] != DBNull.Value ? row["UserName"].ToString() : "", FirstName = row["FirstName"] != DBNull.Value ? row["FirstName"].ToString() : "", FullName = row["FullName"] != DBNull.Value ? row["FullName"].ToString() : "", }).ToList(); model.userList = userList; return(View(model)); }
public ActionResult Message_Received(MessageGroups messageGroups) { actionResult = new ActionResult(); try { actionResult.dtResult = messageDL.Message_Received(messageGroups); if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0) { actionResult.IsSuccess = true; } } catch (Exception ex) { } return(actionResult); }
public ActionResult MessageGroups_DeleteByGroupName(MessageGroups mssageGroups) { actionResult = new ActionResult(); try { actionResult.dtResult = messageDL.MessageGroups_DeleteByGroupName(mssageGroups); if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0) { actionResult.IsSuccess = true; } } catch (Exception ex) { } return(actionResult); }
public DataTable Message_Received(MessageGroups messageGroups) { dtContainer = new DataTable(); dsContainer = new DataSet(); try { MyParameter[] myParams = { new MyParameter("@UserID", messageGroups.U_ID) }; Common.Set_Procedures("Messages_Received"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { throw ex; } return(dtContainer); }
public DataTable MessageGroups_DeleteByGroup(MessageGroups messageGroups) { dtContainer = new DataTable(); dsContainer = new DataSet(); try { MyParameter[] myParams = { new MyParameter("@GroupName", messageGroups.GroupName) }; Common.Set_Procedures("MessageGroups_DeleteByGroup"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { throw ex; } return(dtContainer); }