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 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));
}
// 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 MessageDistribution()
{
MessageGroupsModel model = 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));
}
