public ActionResult PV_BaseMoney() { List <base_money> bm = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { bm = db.base_money.ToList(); } } return(PartialView(bm)); }
public ActionResult PV_Category() { List <category> categories = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { categories = db.categories.ToList(); } } return(PartialView(categories)); }
public ActionResult PV_TransType() { List <trans_type> types = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { types = db.trans_type.ToList(); } } return(PartialView(types)); }
public ActionResult PV_Detail(int tid) { int aid = ((account)Session["Account"]).acc_id; List <trans_detail> details = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { details = db.trans_detail.Include("base_money").Where(x => x.t_id == tid && x.tran.acc_id == aid).ToList(); } } return(PartialView(details)); }
public ActionResult PV_TableTrans() { int aid = ((account)Session["Account"]).acc_id; List <tran> trans = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { trans = db.trans.Include("trans_type").Include("category").Take(10).OrderByDescending(x => x.t_date).OrderByDescending(x => x.t_id).ToList(); } } return(PartialView(trans)); }
public ActionResult Transaction() { if (Session["Account"] == null) { return(RedirectToAction("Login", "Account")); } // use for script List <base_money> bm = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { bm = db.base_money.ToList(); } } return(View(bm)); }
public ActionResult Login(FormCollection form) { string username = form["acc_username"]; string password = form["acc_password"]; // Check try login if (ModelState.IsValid) { using (var db = new money_managementEntities()) { account acc = db.accounts.FirstOrDefault(x => x.acc_username.Equals(username)); if (acc != null && MD5Cal.VerifyMd5Hash(password, acc.acc_password)) { Session["Account"] = acc; return(RedirectToAction("Index", "Manager")); } } } return(View()); }
public ActionResult AllTransaction(int?page) { if (Session["Account"] == null) { return(RedirectToAction("Login", "Account")); } int aid = ((account)Session["Account"]).acc_id; List <tran> trans = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { trans = db.trans.Include("trans_type").Include("category").Where(x => x.acc_id == aid).OrderByDescending(x => x.t_date).ToList(); } } int pageSize = 10; int pageNumber = (page ?? 1); return(View(trans.ToPagedList(pageNumber, pageSize))); }
// GET: Manager public ActionResult Index() { if (Session["Account"] == null) { return(RedirectToAction("Login", "Account")); } account acc = (account)Session["Account"]; List <account_money> account_Money = null; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { account_Money = db.account_money.Include("base_money").Where(x => x.acc_id == acc.acc_id).ToList(); ViewBag.Balance = db.accounts.FirstOrDefault(x => x.acc_id == acc.acc_id).acc_balance; } } return(View(account_Money)); }
public ActionResult Transaction(FormCollection f) { DateTime date = DateTime.Now; string info = f["info"]; int acc_id = ((account)Session["Account"]).acc_id; int type_id = Convert.ToInt32(f["trans_type"]); int cate_id = Convert.ToInt32(f["category"]); tran t = new tran { t_date = date, t_info = info, acc_id = acc_id, type_id = type_id, c_id = cate_id }; //check quantity validity if (type_id == 2) { if (ModelState.IsValid) { using (var db = new money_managementEntities()) { List <base_money> bm = db.base_money.ToList(); foreach (base_money m in bm) { string name = "Q_" + m.bm_value.ToString(); int tquantity = Convert.ToInt32(f[name]); if (tquantity <= 0) { continue; } int aquantity = Convert.ToInt32(db.account_money.Where(x => x.acc_id == acc_id).FirstOrDefault(x => x.bm_id == m.bm_id).quantity); if (aquantity - tquantity < 0) { ViewBag.Alert = "You don't have enough money."; return(View()); } } } } } if (ModelState.IsValid) { using (var db = new money_managementEntities()) { //trans db.trans.Add(t); db.SaveChanges(); //detail List <base_money> bm = db.base_money.ToList(); foreach (base_money m in bm) { string name = "Q_" + m.bm_value.ToString(); int quantity = Convert.ToInt32(f[name]); if (quantity <= 0) { continue; } trans_detail detail = new trans_detail { t_id = t.t_id, bm_id = m.bm_id, t_quantity = quantity }; db.trans_detail.Add(detail); } db.SaveChanges(); //update quantity db.P_UpdateQuantityAfterTrans(); } } return(RedirectToAction("Index")); }
public ActionResult Register(FormCollection form) { string username = form["acc_username"]; string password = form["acc_password"]; string repassword = form["re_password"]; string email = form["acc_email"]; // Check password confirm if (!password.Equals(repassword)) { ViewBag.Alert = "Password does not match."; return(View()); } // Check username exists if (ModelState.IsValid) { using (var db = new money_managementEntities()) { account acc = db.accounts.FirstOrDefault(x => x.acc_username.Equals(username)); if (acc != null) { ViewBag.Alert = "Username already exists."; return(View()); } } } // Check email exists if (ModelState.IsValid) { using (var db = new money_managementEntities()) { account acc = db.accounts.FirstOrDefault(x => x.acc_email.Equals(email)); if (acc != null) { ViewBag.Alert = "Email already exists."; return(View()); } } } //Create account account new_acc = new account { acc_username = username, acc_password = MD5Cal.GetMd5Hash(password), acc_email = email, acc_balance = 0, acc_create_time = DateTime.Now, acc_verified = false }; if (ModelState.IsValid) { using (var db = new money_managementEntities()) { db.accounts.Add(new_acc); db.SaveChanges(); } } return(RedirectToAction("Login")); }