public ActionResult Add(view_Expense UpdatedExpenses) { AssignmentEntities db = new AssignmentEntities(); Expense expenses = new Expense(); expenses.Description = UpdatedExpenses.Description; expenses.Date = UpdatedExpenses.Date; expenses.Amount = UpdatedExpenses.Amount; Category category = db.Categories.Where(x => x.CategoryName == UpdatedExpenses.CategoryName).FirstOrDefault(); if (category == null) { Category new_category = new Category(); new_category.CategoryName = UpdatedExpenses.CategoryName; db.Categories.Add(new_category); db.SaveChanges(); category = db.Categories.Where(x => x.CategoryName == UpdatedExpenses.CategoryName).FirstOrDefault(); } expenses.CategoryId = category.CategoryId; db.Expenses.Add(expenses); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }
// GET: Category public ActionResult Index() { AssignmentEntities db = new AssignmentEntities(); List <Category> categories = db.Categories.ToList(); return(View(categories)); }
public ActionResult Delete(int id) { AssignmentEntities db = new AssignmentEntities(); view_Expense expences2 = db.view_Expense.Where(x => x.ExpenseId == id).FirstOrDefault(); db.Dispose(); return(View(expences2)); }
// GET: Money public ActionResult Index() { AssignmentEntities db = new AssignmentEntities(); List <view_Expense> expences = db.view_Expense.ToList(); db.Dispose(); return(View(expences)); }
public ActionResult Delete(int id) { AssignmentEntities db = new AssignmentEntities(); Category categery = db.Categories.Where(x => x.CategoryId == id).FirstOrDefault(); db.Dispose(); return(View(categery)); }
public ActionResult Add(Category categery) { AssignmentEntities db = new AssignmentEntities(); db.Categories.Add(categery); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }
public ActionResult Remove(view_Expense UpdatedExpenses) { AssignmentEntities db = new AssignmentEntities(); Expense expences = db.Expenses.Where(x => x.ExpenseId == UpdatedExpenses.ExpenseId).FirstOrDefault(); db.Expenses.Remove(expences); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }
public ActionResult Remove(Category categoryEdited) { AssignmentEntities db = new AssignmentEntities(); Category category = db.Categories.Where(x => x.CategoryId == categoryEdited.CategoryId).FirstOrDefault(); db.Categories.Remove(category); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }
//public static List<RegistrationModel> GetAllUsers() //{ // try // { // using (var context = new AssignmentEntities()) // { // var AllUsers = (context.Users.Select(a => new RegistrationModel() { UId = a.Id, FName = a.FirstName, LName = a.LastName, Email = a.EmailId, _Gender = a.GenderTable.GenderType, DOB = a.DOB }).ToList()); // return AllUsers; // } // } // catch (Exception e) // { // return null; // } //} public static string ForgotPassword(string email) { try { using (var context = new AssignmentEntities()) { var password = context.Users.Where(a => a.EmailId == email).Select(u => u.Password).FirstOrDefault(); if (password != null) { return(password.ToString()); } else { return(null); } } } catch (Exception e) { return(null); } }
public ProductController() { assignmentEntities = new AssignmentEntities(); }
public AssignmentEntities Init() { return(dbContext ?? (dbContext = new AssignmentEntities())); }