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