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);
}
