public ActionResult Create(Budget budget)
{
string currentUser = Session["UserId"].ToString();
int uid = Int32.Parse(currentUser);
List <Budget> budgetList = db.GetBudgetList();
if (Session["UserName"] == null)
{
return(RedirectToAction("Login", "Authentication"));
}
else
{
if (ModelState.IsValid)
{
budget.UserId = int.TryParse(Session["UserId"].ToString(), out var result) ? result : -1;
if (budgetList.Where(a => a.UserId == uid).Count() >= 1)
{
//Wyciagniecie 2 wstecz
//var _budget = budgetList.Where(a => a.UserId == uid).OrderByDescending(a => a.BudgetId).Take(2).OrderBy(a => a.BudgetId).FirstOrDefault();
var _budget = budgetList.Where(a => a.UserId == uid).OrderByDescending(a => a.BudgetId).FirstOrDefault();
_budget.EndBudgetDate = budget.SalaryDate.Value.AddDays(-1);
}
db.Budgets.Add(budget);
db.SaveChanges();
return(RedirectToAction("List", "Budget"));
}
return(View(budget));
}
}
public ActionResult Create(Expense expense)
{
if (ModelState.IsValidField("Typ") && ModelState.IsValidField("Nazwa wydatku") && ModelState.IsValidField("Data zrealizowania wydatku"))
{
expense.UserId = int.TryParse(Session["UserId"].ToString(), out var result) ? result : -1;
db.Expenses.Add(expense);
db.SaveChanges();
return(RedirectToAction("List", "Expense"));
}
return(View(expense));
}
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
string data1 = user.Password;
string data2 = user.ConfirmPassword;
user.Password = helper.EncryptedPassword(data1, "h@sheD");
user.ConfirmPassword = helper.EncryptedPassword(data2, "h@sheD");
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public static void saveNewTodoItem(TodoItem oTodoItem)
{
using (var db = new OrganizerDBContext()){
db.TodoItems.Add(oTodoItem);
db.Entry(oTodoItem).State = System.Data.EntityState.Added;
db.SaveChanges();
}
}
public static void updateTodoItem(TodoItem oTodoItem)
{
using (var db = new OrganizerDBContext())
{
db.TodoItems.Attach(oTodoItem);
db.Entry(oTodoItem).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
public static void deleteTodoItemById(int id)
{
TodoItem todoItem = getAppUserByUserName(HttpContext.Current.User.Identity.Name).ThingsTodo.FirstOrDefault(p => p.Id == id);
using (var db = new OrganizerDBContext()){
db.Entry(todoItem).State = System.Data.EntityState.Deleted;
db.SaveChanges();
}
}
public static void saveTodoItem(TodoItemDTO todoItemDTO)
{
using (var db = new OrganizerDBContext()){
AppUser appUser =
db.
AppUsers.
Include("ThingsTodo").
Single(p => p.UserName == HttpContext.Current.User.Identity.Name);
appUser.ThingsTodo.Add(
new TodoItem {
CategoryId = todoItemDTO.SelectedCategoryId, Title = todoItemDTO.Title, Completed = false
}
);
db.AppUsers.Attach(appUser);
db.Entry(appUser).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
public static bool registerUser(RegisterDTO oDTO)
{
if (!isUserNameUnique(oDTO.UserName))
{
return(false);
}
using (var db = new OrganizerDBContext())
{
AppUser oAppUser = new AppUser();
oAppUser.UserName = oDTO.UserName;
oAppUser.Password = PasswordHash.CreateHash(oDTO.Password);
db.AppUsers.Add(oAppUser);
db.Entry(oAppUser).State = System.Data.EntityState.Added;
db.SaveChanges();
}
return(true);
}
public static void EditTodoItem(TodoItemDTO todoItemDTO, int todoItemId)
{
TodoItem todoItem =
getAppUserByUserName(HttpContext.Current.User.Identity.Name).
ThingsTodo.
FirstOrDefault(p => p.Id == todoItemId);
if (todoItem == null)
{
throw new Exception("Access denied");
}
todoItem.CategoryId = todoItemDTO.SelectedCategoryId;
todoItem.Completed = todoItemDTO.SelectedCompletedId == 0 ? false : true;
todoItem.Title = todoItemDTO.Title;
using (var db = new OrganizerDBContext())
{
db.TodoItems.Attach(todoItem);
db.Entry(todoItem).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
