public ActionResult Login(LoginViewModel loginviewmodel)
{
if (string.IsNullOrEmpty(loginviewmodel.Username) || string.IsNullOrEmpty(loginviewmodel.Password))
{
ViewBag.error = "შეავსეთ ყველა ველი";
return(RedirectToAction("Login"));
}
string passwordHash = AccountHelper.GetHash256ByString(loginviewmodel.Password + AccountHelper.AuthSecret);
User user = null;
using (var db = new DbConnectionDataContext())
{
user = db.Users.SingleOrDefault(x => x.Username == loginviewmodel.Username && x.PasswordHash == passwordHash);
}
if (user == null)
{
ViewBag.error = "ასეთი მონაცემებით მომხმარებელი არ არსებობს";
return(View());
}
else
{
Session["user"] = user;
return(RedirectToAction("Organize", "Home"));
}
}
public ActionResult DeleteNote(int id)
{
var user = Session["user"] as User;
using (var db = new DbConnectionDataContext())
{
var note = db.Notes.SingleOrDefault(t => t.ID == id);
db.Notes.DeleteOnSubmit(note);
db.SubmitChanges();
}
return(new EmptyResult());
}
public ActionResult EditTask(EditTaskRequest editTaskRequest)
{
var user = Session["user"] as User;
using (var db = new DbConnectionDataContext())
{
var task = db.Tasks.SingleOrDefault(t => t.ID == editTaskRequest.TaskId);
task.IsDone = editTaskRequest.IsDone;
db.SubmitChanges();
}
return(new EmptyResult());
}
public ActionResult OrganizeNotes(string searchValue)
{
var model = new NotesViewModel();
using (var db = new DbConnectionDataContext())
{
var notes = db.Notes.Where(note => note.Description.ToLower().Contains(string.IsNullOrEmpty(searchValue) ? string.Empty : searchValue)).Select(note => new NoteViewModel
{
Id = note.ID,
Description = note.Description,
}).ToList();
model.Notes = notes;
}
return(PartialView("~/Views/Shared/_OrganizeNotes.cshtml", model));
}
public ActionResult OrganizeToday(string searchValue)
{
var model = new TasksViewModel();
using (var db = new DbConnectionDataContext())
{
var tasks = db.Tasks.Where(t => t.Description.ToLower().Contains(string.IsNullOrEmpty(searchValue) ? string.Empty : searchValue)).Select(task => new TaskViewModel
{
Id = task.ID,
Description = task.Description,
IsDone = task.IsDone
}).ToList();
model.Tasks = tasks;
}
return(PartialView("~/Views/Shared/_OrganizeToday.cshtml", model));
}
public ActionResult AddNote(AddNoteRequest addNoteRequest)
{
var user = Session["user"] as User;
Note note;
using (var db = new DbConnectionDataContext())
{
note = new Note
{
Description = addNoteRequest.Description,
UserId = user.ID,
};
db.Notes.InsertOnSubmit(note);
db.SubmitChanges();
}
return(Json(new { id = note.ID }));
}
public ActionResult AddTask(AddTaskRequest addTaskRequest)
{
var user = Session["user"] as User;
Task task;
using (var db = new DbConnectionDataContext())
{
task = new Task
{
IsDone = false,
ProjectId = null,
Description = addTaskRequest.Description,
UserId = user.ID
};
db.Tasks.InsertOnSubmit(task);
db.SubmitChanges();
}
return(Json(new { id = task.ID }));
}
public ActionResult Registration(RegistrationViewModel registrationViewModel)
{
if (string.IsNullOrEmpty(registrationViewModel.Name) ||
string.IsNullOrEmpty(registrationViewModel.Lastname) ||
string.IsNullOrEmpty(registrationViewModel.Username) ||
string.IsNullOrEmpty(registrationViewModel.Password) ||
string.IsNullOrEmpty(registrationViewModel.RepeatPassword))
{
ViewBag.error = "შეავსე ყველა ველი";
return(View());
}
if (registrationViewModel.Password != registrationViewModel.RepeatPassword)
{
ViewBag.error = "პაროლები არ ემთხვევა";
return(View());
}
// კონფირმაციის გასვლამდე გავლილი რეგისტრაცია
var notConfirmedUser = new User()
{
Username = registrationViewModel.Username,
Name = registrationViewModel.Name,
Lastname = registrationViewModel.Lastname,
CreateDate = DateTime.Now,
PasswordHash = AccountHelper.GetHash256ByString(registrationViewModel.Password + AccountHelper.AuthSecret),
};
using (var db = new DbConnectionDataContext())
{
db.Users.InsertOnSubmit(notConfirmedUser);
db.SubmitChanges();
}
return(RedirectToAction("Login"));
}
