/* *******************************************************
* AddUserToGroup
* Parameter: string userID
********************************************************/
public void AddUserToGroup(SubscriberGroupVM subGroup, out string errMsg)
{
// TO DO: server side validation & client side validation
var now = DateTime.UtcNow;
OneListEntitiesCore db = new OneListEntitiesCore();
SuscriberGroup sGroup = db.SuscriberGroups.Where(a => a.SuscriberGroupID == subGroup.SubscriberGroupID).FirstOrDefault();
SuscriberGroupUser newGroupUser = new SuscriberGroupUser();
newGroupUser.UserID = subGroup.UserID;
newGroupUser.SuscriberGroupID = subGroup.SubscriberGroupID;
newGroupUser.UserTypeID = DEFAULT_USER_TYPE;
newGroupUser.ListUserStatus = DEFAULT_STATUS;
newGroupUser.SuscriptionDate = now.ToShortDateString();
newGroupUser.SuscriberGroup = sGroup; //Add subscriberGroup property !important
var query = db.SuscriberGroupUsers.Add(newGroupUser);
SuscriberGroupUser existingUser = db.SuscriberGroupUsers
.Where(a =>
a.SuscriberGroupID == subGroup.SubscriberGroupID &&
a.UserID == subGroup.UserID
).FirstOrDefault();
// Check if the user currently exist in the table
if (existingUser == null)
{
db.SaveChanges();
errMsg = "User Added.";
}
else
{
errMsg = "User Already Exist.";
}
}
public ActionResult EditSubscriberGroup(int id)
{
if (Request.IsAuthenticated)
{
SubscriberRepo subscriberRepo = new SubscriberRepo();
SubscriberGroupVM subscriberGroup = subscriberRepo.GetGroupDetails(id);
return(View(subscriberGroup));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
/* *******************************************************
* GetGroupDetails
* Parameter: int GroupID
* return: SubscriberGroupVM
********************************************************/
public SubscriberGroupVM GetGroupDetails(int id)
{
OneListEntitiesCore db = new OneListEntitiesCore();
SuscriberGroup groupToBeUpdated = db.SuscriberGroups
.Where(a =>
a.SuscriberGroupID == id
).FirstOrDefault();
SubscriberGroupVM sg = new SubscriberGroupVM();
sg.SubscriberGroupID = groupToBeUpdated.SuscriberGroupID;
sg.SubscriberGroupName = groupToBeUpdated.SuscriberGroupName;
sg.UserList = GetAllUsers();
sg.allSubscribedUsers = GetAllSubscribedUsers(id);
return(sg);
}
public ActionResult AddSubscriberGroup(SubscriberGroupVM subscriberGroup)
{
subscriberGroup.UserID = FindUserID();
if (ModelState.IsValid)
{
SuscriberGroup sg = new SuscriberGroup();
sg.SuscriberGroupName = subscriberGroup.SubscriberGroupName;
sg.UserID = subscriberGroup.UserID;
OneListEntitiesCore Core = new OneListEntitiesCore();
Core.SuscriberGroups.Add(sg);
Core.SaveChanges();
}
else
{
ViewBag.ErrorMsg = "Cannot add Subscriber Group.";
}
return(View());
}
/* *******************************************************
* UpdateGroup
* Return: bool
********************************************************/
public bool UpdateGroup(SubscriberGroupVM subscriberGroup)
{
try {
OneListEntitiesCore db = new OneListEntitiesCore();
SuscriberGroup groupUpdated = db.SuscriberGroups
.Where(a =>
a.SuscriberGroupID == subscriberGroup.SubscriberGroupID
).FirstOrDefault();
groupUpdated.SuscriberGroupName = subscriberGroup.SubscriberGroupName;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult EditSubscriberGroup(SubscriberGroupVM group)
{
SubscriberRepo subscriberRepo = new SubscriberRepo();
SubscriberGroupVM subscriberGroup = subscriberRepo.GetGroupDetails(group.SubscriberGroupID);
if (ModelState.IsValid)
{
if (subscriberRepo.UpdateGroup(group))
{
ViewBag.success = "Updated successfully!";
}
else
{
ViewBag.fail = "Cannot update!";
}
return(View(subscriberGroup));
}
else
{
return(View(subscriberGroup));
}
}
public ActionResult AddSubscriberToGroup(SubscriberGroupVM subGroup)
{
if (Request.IsAuthenticated)
{
string errMsg = "";
SubscriberRepo subscriberRepo = new SubscriberRepo();
if (ModelState.IsValid)
{
subscriberRepo.AddUserToGroup(subGroup, out errMsg);
TempData["EditMsg"] = errMsg;
}
else
{
TempData["EditMsg"] = "Cannot add user to group.";
}
SubscriberGroupVM subscriberGroup = subscriberRepo.GetGroupDetails(subGroup.SubscriberGroupID);
return(RedirectToAction("EditSubscriberGroup", new { id = subGroup.SubscriberGroupID }));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
