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()));
}
