public List <Category> GetCategoryList(string userid) { List <Category> catListModel = new List <Category>(); if (userid != null) { using (var db = new Expense_ManagerEntities()) { int id = int.Parse(userid); int count = db.category.Where(m => m.user_id == id).Count(); List <category> catListDAL = new List <category>(); catListDAL = db.category.Where(m => m.user_id == id).ToList(); foreach (var item in catListDAL) { Category catModel = new Category(); catModel.id = item.id; catModel.category_name = item.category_name; catModel.user_id = item.user_id; catListModel.Add(catModel); } catListModel.Reverse(); //i am reversing it to display the latest added data on top } } return(catListModel); }
public bool IsCategoryExist(category Category) { bool result; using (var db = new Expense_ManagerEntities()) { category cat = new category(); result = db.category.Where(x => x.category_name == Category.category_name && x.user_id == Category.user_id).Any(); } return(result); }
public int CheckUsernameIsExist(string email) { int result = 0; using (var db = new Expense_ManagerEntities()) { bool isvalid = db.user_info.Any(x => x.email == email); if (isvalid) { result = 1; } } return(result); }
public int DeleteCategory(int ctgryId) { int result = 0; if (ctgryId > 0) { using (var db = new Expense_ManagerEntities()) { var a = db.category.Find(ctgryId); db.category.Remove(a); db.SaveChanges(); result = 1; } } return(result); }
public int EditCategory(int id, string name) { int result = 0; if (id > 0 && name != null) { using (var db = new Expense_ManagerEntities()) { var a = db.category.FirstOrDefault(x => x.id == id); if (a != null) { a.category_name = name; db.SaveChanges(); result = 1; } } } return(result); }
public int AddRecord(Models.Records rec) { int result = 0; using (var db = new Expense_ManagerEntities()) { record recDAL = new record(); recDAL.userid = rec.userid; recDAL.expense_income = rec.expense_income; recDAL.amount = rec.amount; recDAL.category = rec.category; recDAL.date = rec.date; recDAL.notes = rec.notes; db.record.Add(recDAL); db.SaveChanges(); result = 1; } return(result); }
public int Register(Models.UserInfo info) { int result = 0; using (var db = new Expense_ManagerEntities()) { user_info DALInfo = new user_info(); DALInfo.firstname = info.firstname; DALInfo.lastname = info.lastname; DALInfo.email = info.email; DALInfo.password = info.password; DALInfo.confirm_password = info.confirm_password; DALInfo.profile_pic_path = info.profile_pic_path; db.user_info.Add(DALInfo); db.SaveChanges(); result = 1; } return(result); }
public int AddCategory(Models.Category Category) { int result = 0; using (var db = new Expense_ManagerEntities()) { if (Category.category_name != null) { category cat = new category(); cat.category_name = Category.category_name; cat.user_id = Category.user_id; if (IsCategoryExist(cat)) { return(2); } db.category.Add(cat); db.SaveChanges(); result = 1; } } return(result); }
public Models.UserInfo FetchUserInfo(Models.Login info) { Models.UserInfo BALinfo = new Models.UserInfo(); using (var db = new Expense_ManagerEntities()) { bool isvalid = db.user_info.Any(x => x.email == info.email && x.password == info.password); if (isvalid) { DAL.user_info DALinfo = db.user_info.Where(x => x.email == info.email && x.password == info.password).FirstOrDefault(); BALinfo.id = DALinfo.id; BALinfo.firstname = DALinfo.firstname; BALinfo.lastname = DALinfo.lastname; BALinfo.email = DALinfo.email; BALinfo.password = DALinfo.password; BALinfo.confirm_password = DALinfo.confirm_password; BALinfo.month_start_date = DALinfo.month_start_date; BALinfo.profile_pic_path = DALinfo.profile_pic_path; //var userdetail2 = from s in db.user_info where s.email == info.email && s.password == info.password select s; } } return(BALinfo); }
public int IsUserExistWithUsernamePass(Models.Login info) { int result = 1; using (var db = new Expense_ManagerEntities()) { bool isUserexist = db.user_info.Any(x => x.email == info.email); bool isCorrectPass = false; if (isUserexist) { isCorrectPass = db.user_info.Any(x => x.email == info.email && x.password == info.password); if (!isCorrectPass) { result = -1; } } else { result = -2; } } return(result); }