public ActionResult AddRewards()
{
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
return(View());
}
}
//Search and Delete Tasks
public ActionResult SearchDeleteTasks(SearchDeleteTask data)
{
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
IQueryable <Tasks> x = null;
if (data.Description != null)
{
x = db.Tasks.Where(l => l.Description == data.Description);
}
else
{
x = db.Tasks;
}
if (data.Type != null)
{
x = db.Tasks.Where(l => l.Type == data.Type);
}
data.Lista = x.ToList();
return(View("SearchDeleteTasks", data));
}
}
public ActionResult DoDeleteReward(string Description)
{
Rewards deletedReward = null;
UsersRewards userReward = null;
NoticeRewardsTakes noticeReward = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
deletedReward = db.Rewards.Where(l => l.Description == Description).FirstOrDefault();
userReward = db.UsersRewards.Where(l => l.RewardsID == deletedReward.RewardsID).FirstOrDefault();
noticeReward = db.NoticeRewardsTakes.Where(l => l.RewardsID == deletedReward.RewardsID).FirstOrDefault();
if ((deletedReward != null && userReward != null) || (noticeReward != null) || (userReward != null))
{
TempData["msg"] = "<script>alert('Il Reward non può esere cancellato perchè un impiegato ne è in possesso o è in attesa di essere ricevuto');</script>";
}
else
{
db.Rewards.Remove(deletedReward);
db.SaveChanges();
}
}
return(RedirectToAction("SearchDeleteRewards", new SearchDeleteReward()));
}
public ActionResult InsertNewUsers()
{
List <Users> user = new List <Users>();
List <Roles> role = new List <Roles>();
List <Users> usermanager = new List <Users>();
//Users managerName = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
usermanager = db.Users.Where(l => l.RoleID == 2).ToList();
//var a = new SelectList() new SelectListItem() { Text = "A", Value = "1" } );
//var b = new SelectListItem() { Text = "A", Value = "1" };
// ViewBag.RoleList = new SelectList();
//ViewBag.RoleList = new SelectList(db.Roles.Select(r=> new { Value = r.RoleID.ToString(), Text = r.Role }).ToList(), null);
ViewBag.RoleList = db.Roles.Select(r => new SelectListItem()
{
Value = r.RoleID.ToString(), Text = r.Role
}).ToList();
ViewBag.ManagerList = usermanager.Select(r => new SelectListItem()
{
Value = r.UserID.ToString(), Text = r.Name + " " + r.Surname
}).ToList();
}
return(View());
}
public ActionResult AcceptMission(int TaskID, int UserID)
{
Missions mission = null;
NoticeMissionEnded noticeMission = null;
Tasks task = null;
Users user = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
mission = db.Missions.Where(l => l.TaskID == TaskID && l.UserID == UserID).FirstOrDefault();
noticeMission = db.NoticeMissionEnded.Where(l => l.MissionID == mission.MissionID && l.UserID == UserID).FirstOrDefault();
task = db.Tasks.Where(l => l.TaskID == TaskID).FirstOrDefault();
user = db.Users.Where(l => l.UserID == UserID).FirstOrDefault();
if (mission != null && noticeMission != null)
{
user.UserPoints = user.UserPoints + task.Points;
mission.Status = 1;
task.Finished = true;
noticeMission.Status = 0;
db.SaveChanges();
return(Json(new { message = $"Missione accettata con successo", flag = true }));
}
}
return(Json(new { message = $"Missione non accettata per qualche problema", flag = false }));
}
public ActionResult _DoAddTaskJson(Tasks DatiTask, int TaskID, int UserID)
{
TaskUserView tasksUsers = new TaskUserView();
Tasks task = null;
Users user = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
task = db.Tasks.Where(l => l.TaskID == TaskID).FirstOrDefault();
user = db.Users.Where(l => l.UserID == UserID).FirstOrDefault();
Missions mission = new Missions
{
Tasks = task,
Users = user,
UserID = user.UserID,
TaskID = task.TaskID,
StartDate = DateTime.Now,
EndDate = task.ExpiryDate,
Note = "",
Status = 0
};
db.Missions.Add(mission);
db.SaveChanges();
}
return(Json(new { messaggio = $"Task : {DatiTask.TaskID} assegnato con successo" }));
}
// GET: Amministrator
public ActionResult Index()
{
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
int userID = (int)Session["UserID"];
return(View());
}
}
public ActionResult _PartialDeleteTasks(string Description, string Type)
{
Tasks taskDelete = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
taskDelete = db.Tasks.Where(l => l.Description == Description && l.Type == Type).FirstOrDefault();
}
return(PartialView(taskDelete));
}
public ActionResult _PartialDelete(string Serial, string EMail)
{
Users userDelete = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
userDelete = db.Users.Where(l => l.Serial == Serial && l.EMail == EMail).FirstOrDefault();
}
return(PartialView(userDelete));
}
public ActionResult _PartialUpdateRewards(string Description)
{
Rewards updateReward = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
updateReward = db.Rewards.Where(l => l.Description == Description).FirstOrDefault();
}
return(PartialView(updateReward));
}
public ActionResult _PartialDeleteRewards(string Description)
{
Rewards rewardDelete = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
rewardDelete = db.Rewards.Where(l => l.Description == Description).FirstOrDefault();
}
return(PartialView(rewardDelete));
}
public ActionResult _PartialUpdateView(string Description, string Type)
{
Tasks updateTask = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
updateTask = db.Tasks.Where(l => l.Description == Description && l.Type == Type).FirstOrDefault();
}
return(PartialView(updateTask));
}
public ActionResult Ranking(int UserID)
{
List <Users> userList = new List <Users>();
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
userList = db.Users.OrderByDescending(l => l.UserPoints).ToList();
}
return(View(userList));
}
public ActionResult ListaUsers()
{
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
int userID = (int)Session["UserID"];
List <Users> users = new List <Users>();
users = db.Users.Where(x => x.ManagerUserID == userID).ToList();
return(View(users));
}
}
public ActionResult RefuseRewards(int RewardsID, int UserID)
{
NoticeRewardsTakes noticeRewards = null;
Rewards usersRewards = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
usersRewards = db.Rewards.Where(l => l.RewardsID == RewardsID).FirstOrDefault();
noticeRewards = db.NoticeRewardsTakes.Where(l => l.UserID == UserID && l.RewardsID == usersRewards.RewardsID).FirstOrDefault();
}
return(PartialView(noticeRewards));
}
public ActionResult AcceptRewards(int RewardsID, int UserID)
{
UsersRewards usersRewards = new UsersRewards();
NoticeRewardsTakes noticeRewards = null;
Rewards rewards = null;
Users user = null;
Rewards availabilityReward = new Rewards();
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
rewards = db.Rewards.Where(l => l.RewardsID == RewardsID).FirstOrDefault();
user = db.Users.Where(l => l.UserID == UserID).FirstOrDefault();
//usersRewards = db.UsersRewards.Where(l => l.RewardsID == RewardsID && l.UserID == UserID).FirstOrDefault();
noticeRewards = db.NoticeRewardsTakes.Where(l => l.RewardsID == rewards.RewardsID && l.UserID == UserID).FirstOrDefault();
Users userUpdated = db.Users.Find(UserID);
availabilityReward = db.Rewards.Find(RewardsID);
if (noticeRewards != null)
{
//user.UserPoints = user.UserPoints + task.Points;
//noticeRewards.Status = 0;
//rewards. = true;
//noticeMission.Status = 0;
//db.SaveChanges();
//sottrazione dei punti allo user
userUpdated.UserPoints = userUpdated.UserPoints - rewards.Points;
//diminuzione dell'availability del reward
availabilityReward.Availability = availabilityReward.Availability - 1;
//Inserisco il nuovo reward dell'utente nel db
usersRewards.UserID = user.UserID;
usersRewards.RewardsID = rewards.RewardsID;
usersRewards.RewardsDate = DateTime.Now;
usersRewards.Note = "";
db.UsersRewards.Add(usersRewards);
noticeRewards.Status = 0;
db.SaveChanges();
return(Json(new { message = $"Rewards Aggiunto con successo", flag = true }));
}
}
return(Json(new { message = $"Rewards non accettati per qualche problema", flag = false }));
}
public ActionResult RefuseNote(int TaskID, int UserID)
{
NoticeMissionEnded notice = null;
Missions mission = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
mission = db.Missions.Where(l => l.TaskID == TaskID && l.UserID == UserID).FirstOrDefault();
notice = db.NoticeMissionEnded.Where(l => l.UserID == UserID && l.MissionID == mission.MissionID).FirstOrDefault();
}
return(PartialView(notice));
}
public ActionResult DoRefuseRewards(int RewardsID, int UserID)
{
NoticeRewardsTakes noticeRewards = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
noticeRewards = db.NoticeRewardsTakes.Where(l => l.RewardsID == RewardsID && l.UserID == UserID).FirstOrDefault();
noticeRewards.Status = 1;
db.SaveChanges();
}
return(RedirectToAction("ManagerProfile", noticeRewards.ManagerID));
}
public ActionResult _ChooseRewards(int UserID)
{
//take all the rewards
RewardsForUser rewardsForUser = new RewardsForUser();
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
rewardsForUser.UserPoints = db.Users.Where(l => l.UserID == UserID).Select(l => l.UserPoints).FirstOrDefault();
rewardsForUser.Rewards = db.Rewards.ToList();
}
rewardsForUser.UserID = UserID;
return(PartialView(rewardsForUser));
}
public ActionResult DoRefuse(int MissionID, int UserID)
{
NoticeMissionEnded notice = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
notice = db.NoticeMissionEnded.Where(l => l.MissionID == MissionID && l.UserID == UserID).FirstOrDefault();
notice.Status = 1;
db.SaveChanges();
}
return(RedirectToAction("ManagerProfile", notice.ManagerID));
}
//View The Task
public ActionResult AssegnaTask(int UserID)
{
TaskUserView tasksUsers = new TaskUserView();
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
tasksUsers.task = db.Tasks.ToList();
}
tasksUsers.UsersID = UserID;
return(PartialView(tasksUsers));
}
public ActionResult DoUpdateReward(Rewards data)
{
Rewards updateReward = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
updateReward = db.Rewards.Where(l => l.RewardsID == data.RewardsID).FirstOrDefault();
updateReward.Type = data.Type;
updateReward.Description = data.Description;
updateReward.Availability = data.Availability;
updateReward.Points = data.Points;
db.SaveChanges();
}
return(RedirectToAction("SearchDeleteRewards", new SearchDeleteReward()));
}
//View The Task and Rewards
public ActionResult ManagerTaskandReward()
{
ViewModel viewModel = new ViewModel();
List <Tasks> t = null;
List <Rewards> r = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
t = db.Tasks.ToList();
r = db.Rewards.ToList();
}
viewModel.Task = t;
viewModel.Reward = r;
return(View(viewModel));
}
// GET: Employee
public ActionResult Index(int UserID)
{
Users user = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
//get the user from the db
user = db.Users
.Include(usr => usr.Missions.Select(mis => mis.Tasks))
.Include(usr => usr.UsersRewards.Select(usrrew => usrrew.Rewards))
.Include(usr => usr.Users2)
.Where(l => l.UserID == UserID).FirstOrDefault();
}
return(View(user));
}
//Send email notify to the manager
public ActionResult SendMissionNotify(int TaskID, int UserID)
{
Users userEmail = null;
Users managerEmail = null;
Tasks userTask = null;
Missions mission = null;
NoticeMissionEnded notice = new NoticeMissionEnded();
NoticeMissionEnded controlNotice = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
userEmail = db.Users.Where(l => l.UserID == UserID).FirstOrDefault();
managerEmail = db.Users.Where(l => l.UserID == userEmail.ManagerUserID).FirstOrDefault();
userTask = db.Tasks.Where(l => l.TaskID == TaskID).FirstOrDefault();
mission = db.Missions.Where(l => l.UserID == UserID && l.TaskID == TaskID).FirstOrDefault();
controlNotice = db.NoticeMissionEnded.Where(l => l.MissionID == mission.MissionID && l.UserID == UserID).FirstOrDefault();
if (controlNotice == null)
{
notice.MissionID = mission.MissionID;
notice.UserID = UserID;
notice.Date = DateTime.Now;
notice.Status = 2;
notice.ManagerID = managerEmail.UserID;
db.NoticeMissionEnded.Add(notice);
db.SaveChanges();
}
else
{
return(Json(new { messaggio = $"Richiesta gia inviata!", flag = false }));
}
}
if (Settings.SmtpHost != null)
{
EmailSender.SendEmail(new EmailSender.Email
{
SenderAddress = userEmail.EMail,
Subject = "Richiesta fine missione",
Body = "Richiedo l'accettazione della fine della missione: " + userTask.Description + ".\r\n" +
"Grazie " + userEmail.Name + userEmail.Surname + "."
});
return(Json(new { messaggio = $"Richiesta inviata con successo", flag = true }));
}
else
{
return(Json(new { messaggio = $"Richiesta(senza Email) inviata con successo", flag = true }));
}
}
//Add the Task at Employee
public ActionResult _DoAddTaskJson(Tasks DatiTask, int TaskID, int UserID)
{
TaskUserView tasksUsers = new TaskUserView();
Tasks task = null;
Users user = null;
List <Missions> missions = null;
Missions m = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
task = db.Tasks.Where(l => l.TaskID == TaskID).FirstOrDefault();
user = db.Users.Where(l => l.UserID == UserID).FirstOrDefault();
missions = db.Missions.ToList();
//controllo se il task è stato gia assegnato
m = db.Missions.Where(l => l.TaskID == task.TaskID && l.UserID == user.UserID && l.Status == 0).FirstOrDefault();
if (m != null)
{
return(Json(new { messaggio = $"Il task è stato già assegnato" }));
}
else
{
DateTime start = DateTime.Now.Date;
Missions mission = new Missions
{
Tasks = task,
Users = user,
UserID = user.UserID,
TaskID = task.TaskID,
StartDate = DateTime.Now,
EndDate = task.ExpiryDate,
Note = "",
Status = 0,
DesiredEndDate = start.AddMonths(task.TimeSpan)
};
db.Missions.Add(mission);
db.SaveChanges();
}
}
return(Json(new { messaggio = $"Task : {DatiTask.TaskID} assegnato con successo" }));
}
public ActionResult DoDelete(string Serial, string EMail)
{
Users deletedUser = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
deletedUser = db.Users.Where(l => l.Serial == Serial && l.EMail == EMail).FirstOrDefault();
//elimino(si contrassegna come licenziato) lo user selezionato
if (deletedUser != null)
{
deletedUser.FiredDate = DateTime.Now;
db.SaveChanges();
}
}
return(RedirectToAction("SearchDeleteUser", new SearchDeleteUser()));
}
public ActionResult _JsonInsertNewUsers(Users data)
{
if (!string.IsNullOrEmpty(data.Serial) && !string.IsNullOrEmpty(data.Name) && !string.IsNullOrEmpty(data.Surname) && !string.IsNullOrEmpty(data.EMail) && data.RoleID != 0 && data.ManagerUserID != 0)
{
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
db.Users.Add(data);
db.SaveChanges();
}
return(Json(new { messaggio = $"Users {data.UserID} aggiunto/a con successo", flag = true }));
}
else
{
return(Json(new { messaggio = $"Dati mancanti o non validi", flag = false }));
}
}
public ActionResult _JsonAddRewards(Rewards data)
{
if (!string.IsNullOrEmpty(data.Type) && !string.IsNullOrEmpty(data.Description) && data.Points != 0 && data.Availability != 0)
{
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
db.Rewards.Add(data);
db.SaveChanges();
}
return(Json(new { messaggio = $"Rewards {data.RewardsID} aggiunto/a con successo", flag = true }));
}
else
{
return(Json(new { messaggio = $"Dati mancanti o non validi", flag = false }));
}
}
//Search and Delete Users
public ActionResult SearchDeleteUser(SearchDeleteUser data)
{
//ViewModel viewModel = new ViewModel();
//List<String> manager = new List<String>();
//String managerUser = null;
using (RewardsForYouEntities db = new RewardsForYouEntities())
{
IQueryable <Users> x = null;
if (data.Serial != null)
{
x = db.Users.Where(l => l.Serial == data.Serial);
}
else
{
x = db.Users;
}
if (data.EMail != null)
{
x = db.Users.Where(l => l.EMail == data.EMail);
}
//get the name of the manager
//manager = db.Users.Where(l => l.UserID == l.ManagerUserID).ToList().Select(l=> string.Format("{0} {1}",l.Name,l.Surname)).ToList();
data.Lista = x.ToList();
//controllo se lo user è stato eliminato
foreach (Users item in x)
{
if (item.FiredDate != null)
{
data.Lista.Remove(item);
}
}
return(View("SearchDeleteUser", data));
}
}
