public ActionResult Notes()
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
using (var db = new CepNotEntities())
{
IQueryable <Tasks> query = null;
query = db.Tasks.Where(x => 1 == 1);
List <Tasks> tasklist = query.ToList();
mylist.Tags = db.Tags.ToList();
mylist.Users = db.Users.Where(x => x.Role == 3).ToList();
ViewBag.VBTasksList = new SelectList(tasklist, "TaskID", "Title");
ViewBag.VBTagsList = new SelectList(mylist.Tags, "TagID", "Title");
ViewBag.VBSList = new SelectList(mylist.Users, "UserID", "Name", mylist.Users.OrderByDescending(x => x.UserID).Where(y => y.IsDeleted == false).First().UserID);
return(View());
}
}
}
public ActionResult UserDelete(Users user)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
Users userdelete = null;
using (var db = new CepNotEntities())
{
userdelete = db.Users.Where(d => d.UserID == user.UserID).First();
userdelete.Name = user.Name;
userdelete.Age = user.Age;
userdelete.Gender = user.Gender;
userdelete.Mail = user.Mail;
userdelete.Password = user.Password;
userdelete.Role = user.Role;
userdelete.IsDeleted = true;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public ActionResult Index(Users userModel)
{
using (var db = new CepNotEntities())
{
var userLogin1 = db.Users.SingleOrDefault(x => x.Mail == userModel.Mail && x.Password == userModel.Password && x.Role == 1 && x.IsDeleted == false);
var userLogin2 = db.Users.SingleOrDefault(x => x.Mail == userModel.Mail && x.Password == userModel.Password && x.Role == 3 && x.IsDeleted == false);
if (userLogin1 != null)
{
Session["UserId"] = userLogin1.UserID;
Session["Name"] = userLogin1.Name;
ViewBag.Mesaj = "Hoşgeldiniz Yetkili!";
return(RedirectToAction("TaskManager", "Home"));
}
else if (userLogin2 != null)
{
Session["UserId"] = userLogin2.UserID;
Session["Name"] = userLogin2.Name;
ViewBag.Mesaj = "Hoşgeldiniz Yetkili!";
return(RedirectToAction("Index", "Student"));
}
else
{
ViewBag.Mesaj = "Hatalı kullanıcı adı ya da şifre!";
return(View());
}
}
}
public ActionResult TaskDelete(Tasks task)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
Tasks taskdelete = null;
using (var db = new CepNotEntities())
{
taskdelete = db.Tasks.Where(d => d.TaskID == task.TaskID).First();
taskdelete.Title = task.Title;
taskdelete.Description = task.Description;
taskdelete.Date = task.Date;
taskdelete.Type = task.Type;
taskdelete.CreatedDate = task.CreatedDate;
taskdelete.SId = task.SId;
taskdelete.AId = task.AId;
taskdelete.IsActive = task.IsActive;
taskdelete.IsDeleted = true;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public JsonResult TaskManSave(TaskManagerDetail taskManagerDetail)
{
ReturnValue ret = new ReturnValue();
Tasks taskadd = new Tasks();
if (Shared.CheckSession() == false)
{
ret.requiredLogin = true;
ret.message = "Lütfen giriş yapınız.";
ret.success = false;
return(Json(ret));
}
try
{
using (var db = new CepNotEntities())
{
if (taskManagerDetail.TaskID != 0)
{
taskadd = db.Tasks.Where(x => x.TaskID == taskManagerDetail.TaskID).FirstOrDefault();
}
taskadd.AId = taskManagerDetail.AId;
taskadd.SId = taskManagerDetail.SId;
taskadd.Title = taskManagerDetail.Title;
taskadd.Description = taskManagerDetail.Description;
taskadd.Date = taskManagerDetail.Date;
taskadd.Type = taskManagerDetail.Type;
taskadd.CreatedDate = taskManagerDetail.CreatedDate;
taskadd.CreatedUser = taskManagerDetail.CreatedUser;
taskadd.IsActive = taskManagerDetail.IsActive;
taskadd.IsDeleted = taskManagerDetail.IsDeleted;
if (taskManagerDetail.TaskID == 0)
{
db.Tasks.Add(taskadd);
}
db.SaveChanges();
ret.retObject = taskManagerDetail;
}
ret.message = "Başarıyla kaydedildi.";
ret.success = true;
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.AddTaskMan");
ret.success = false;
ret.message = ex.Message;
}
return(Json(ret));
}
public JsonResult GetUserList()
{
ReturnValue ret = new ReturnValue();
using (var db = new CepNotEntities())
{
var userdata = db.Users.Select(x => new { x.Name }).ToList();
ret.retObject = userdata;
}
return(Json(ret));
} // kullanılmıyor şu an
} // kullanılmıyor şu an
public JsonResult TaskManGet(int TaskID)
{
ReturnValue ret = new ReturnValue();
TaskManagerDetail taskManDetail = new TaskManagerDetail();
if (Shared.CheckSession() == false)
{
ret.requiredLogin = true;
ret.message = "Lütfen giriş yapınız.";
ret.success = false;
return(Json(ret));
}
try
{
using (var db = new CepNotEntities())
{
var TaskObject = db.Tasks.Where(x => x.TaskID == TaskID).Select(x => new
{
x.TaskID,
x.Title,
x.SId,
x.AId,
x.Description,
x.Date,
x.Type
}).FirstOrDefault();
taskManDetail.TaskID = TaskObject.TaskID;
taskManDetail.Title = TaskObject.Title;
taskManDetail.SId = TaskObject.SId;
taskManDetail.AId = TaskObject.AId;
taskManDetail.Description = TaskObject.Description;
taskManDetail.Date = TaskObject.Date;
taskManDetail.Type = TaskObject.Type;
}
ret.retObject = taskManDetail;
return(Json(taskManDetail));
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.GetTaskMan");
ret.success = false;
ret.message = ex.Message;
}
ret.retObject = taskManDetail;
return(Json(ret));
}
public ActionResult Tasks(int?p, string filter)
{
if (p == null)
{
p = 1;
}
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
//Görevleri alıyoruz
using (var db = new CepNotEntities())
{
//Filter
IQueryable <Tasks> query = null;
if (string.IsNullOrEmpty(filter))
{
query = db.Tasks.Where(x => 1 == 1);
}
else
{
query = db.Tasks.Where(x => x.Title.Contains(filter));
}
mylist.Tags = db.Tags.ToList();
mylist.Users = db.Users.Where(x => x.Role == 3).ToList();
mylist.Roles = db.Roles.ToList();
mylist.Tasks = query.OrderByDescending(x => x.TaskID).Skip(defaultPageSize * (p.Value - 1)).Take(defaultPageSize).ToList();
mylist.CurrentPage = p.Value;
mylist.TotalCount = query.Count();
if ((mylist.TotalCount % defaultPageSize) == 0)
{
mylist.TotalPage = mylist.TotalCount / defaultPageSize;
}
else
{
mylist.TotalPage = (mylist.TotalCount / defaultPageSize) + 1;
}
ViewBag.VBTagsList = new SelectList(mylist.Tags, "TagID", "Title");
ViewBag.VBSList = new SelectList(mylist.Users, "UserID", "Name");
ViewBag.VBRolesList = new SelectList(mylist.Roles, "RoleID", "RoleName");
}
return(View(mylist));
}
}
//Veritabanına log ekler.
public static void AddToDBLog(this Exception exc, string MethodName, string Message = "")
{
Logs logum = new Logs();
using (var db = new CepNotEntities())
{
logum.CreatedDate = DateTime.Now;
logum.CreatedUser = Convert.ToInt32(HttpContext.Current.Session["UserId"]);
logum.ExMessage = exc.ToString();
logum.MethodName = MethodName;
logum.Message = Message;
db.Logs.Add(logum);
db.SaveChanges();
}
}
public ActionResult UserProfile(int id)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
Users userdetail = null;
using (var db = new CepNotEntities())
{
userdetail = db.Users.Where(d => d.UserID == id).First();
}
return(View(userdetail));
}
}
public ActionResult UserUpdateO(Users user)
{
Users userupdate = null;
using (var db = new CepNotEntities())
{
userupdate = db.Users.Where(d => d.UserID == user.UserID).First();
userupdate.Name = user.Name;
userupdate.Age = user.Age;
userupdate.Gender = user.Gender;
userupdate.Mail = user.Mail;
userupdate.Password = user.Password;
db.SaveChanges();
}
return(RedirectToAction("UserProfileO", new { id = user.UserID }));
}
public JsonResult GetName()
{
ReturnValue ret = new ReturnValue();
if (Shared.CheckSession() == false)
{
ret.requiredLogin = true;
ret.message = "Lütfen giriş yapınız.";
ret.success = false;
return(Json(ret));
}
using (TransactionScope scope = new TransactionScope())
{
try
{
using (var db = new CepNotEntities())
{
var namedata = db.Users.Where(x => x.Role == 3).Select(x => new { UserID = x.UserID, Name = x.Name }).ToList();
if (namedata == null)
{
ret.requiredLogin = false;
ret.message = "Lütfen işlem giriniz.";
ret.success = false;
return(Json(ret));
}
ret.retObject = namedata;
ret.message = "Başarıyla kaydedildi.";
ret.success = true;
scope.Complete();
return(Json(namedata));
}
}
catch (Exception ex)
{
ret.success = false;
ret.message = ex.Message;
ex.AddToDBLog("HomeController.GetName");
scope.Dispose();
}
return(Json(ret));
}
}
public ActionResult NewStudent()
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
using (var db = new CepNotEntities())
{
mylist.Tags = db.Tags.ToList();
}
ViewBag.VBTagsList = new SelectList(mylist.Tags, "TagID", "Title");
}
return(View());
}
public ActionResult TaskEdit(int id)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
Tasks taskedit = null;
using (var db = new CepNotEntities())
{
taskedit = db.Tasks.Where(d => d.TaskID == id).First();
}
return(View(taskedit));
}
}
public ActionResult UserAdder(Users user)
{
Users useradd = new Users();
using (var db = new CepNotEntities())
{
useradd.Name = user.Name;
useradd.Age = null;
useradd.Gender = user.Gender;
useradd.Mail = user.Mail;
useradd.Password = user.Name;
useradd.IsDeleted = false;
useradd.Role = user.Role;
db.Users.Add(useradd);
db.SaveChanges();
}
return(RedirectToAction("TaskManager", "Home"));
}
// GET: Student
public ActionResult Index(int?p, string filter)
{
if (p == null)
{
p = 1;
}
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
int userid = Convert.ToInt32(Session["UserId"]);
//Görevleri alıyoruz
using (var db = new CepNotEntities())
{
//Filter
IQueryable <Tasks> query = null;
if (string.IsNullOrEmpty(filter))
{
query = db.Tasks.Where(x => 1 == 1 && x.SId == userid);
}
else
{
query = db.Tasks.Where(x => x.Title.Contains(filter) && x.SId == userid);
}
mylist.CurrentPage = p.Value;
mylist.TotalCount = query.Count();
if ((mylist.TotalCount % defaultPageSize) == 0)
{
mylist.TotalPage = mylist.TotalCount / defaultPageSize;
}
else
{
mylist.TotalPage = (mylist.TotalCount / defaultPageSize) + 1;
}
mylist.Tasks = query.OrderByDescending(x => x.TaskID).Skip(defaultPageSize * (p.Value - 1)).Take(defaultPageSize).ToList();
}
}
return(View(mylist));
}
public JsonResult GetAllTask()
{
ReturnValue ret = new ReturnValue();
List <TaskManagerDetail> taskManDetail = new List <TaskManagerDetail>();
if (Shared.CheckSession() == false)
{
ret.requiredLogin = true;
ret.message = "Lütfen giriş yapınız.";
ret.success = false;
return(Json(ret));
}
try
{
using (var db = new CepNotEntities())
{
taskManDetail = db.Tasks.Select(x => new TaskManagerDetail
{
TaskID = x.TaskID,
SId = x.SId,
SName = db.Users.Where(y => y.UserID == x.SId).FirstOrDefault().Name,
AId = x.AId,
AName = db.Users.Where(z => z.UserID == x.AId).FirstOrDefault().Name,
Title = x.Title,
Date = x.Date
}).Where(x => 1 == 1).ToList();
}
ret.retObject = taskManDetail;
return(Json(taskManDetail, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.GetAllTask");
ret.success = false;
ret.message = ex.Message;
}
ret.retObject = taskManDetail;
return(Json(ret, JsonRequestBehavior.AllowGet));
}
public ActionResult TaskAdder(Tasks task)
{
Tasks taskadd = new Tasks();
using (var db = new CepNotEntities())
{
taskadd.Title = task.Title;
taskadd.Description = task.Description;
taskadd.Date = task.Date;
taskadd.Type = task.Type;
taskadd.CreatedDate = task.CreatedDate;
taskadd.IsActive = true;
taskadd.IsDeleted = false;
taskadd.SId = task.SId;
taskadd.AId = task.AId;
db.Tasks.Add(taskadd);
db.SaveChanges();
}
return(RedirectToAction("Tasks", "Home"));
}
public ActionResult TaskUpdate(Tasks task)
{
Tasks taskupdate = null;
using (var db = new CepNotEntities())
{
taskupdate = db.Tasks.Where(d => d.TaskID == task.TaskID).First();
taskupdate.Title = task.Title;
taskupdate.Description = task.Description;
taskupdate.Date = task.Date;
taskupdate.Type = task.Type;
taskupdate.CreatedDate = task.CreatedDate;
taskupdate.IsActive = task.IsActive;
taskupdate.IsDeleted = task.IsDeleted;
taskupdate.SId = task.SId;
taskupdate.AId = task.AId;
db.SaveChanges();
}
return(RedirectToAction("TaskDetail", new { id = task.TaskID }));
}
public ActionResult Index()
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
HavaDurumuGetir();
using (var db = new CepNotEntities())
{
mylist.Tags = db.Tags.ToList();
mylist.Users = db.Users.Where(x => x.Role == 3).ToList();
mylist.Roles = db.Roles.ToList();
}
ViewBag.VBTagsList = new SelectList(mylist.Tags, "TagID", "Title");
ViewBag.VBSList = new SelectList(mylist.Users, "UserID", "Name");
ViewBag.VBRolesList = new SelectList(mylist.Roles, "RoleID", "RoleName");
}
return(View());
}