public IHttpActionResult PutIn_Ex(int id, In_Ex in_Ex) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != in_Ex.no) { return(BadRequest()); } db.Entry(in_Ex).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!In_ExExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetIn_Ex(int id) { In_Ex in_Ex = db.In_Ex.Find(id); if (in_Ex == null) { return(NotFound()); } return(Ok(in_Ex)); }
public IHttpActionResult PostIn_Ex(In_Ex in_Ex) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.In_Ex.Add(in_Ex); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = in_Ex.no }, in_Ex)); }
public IHttpActionResult DeleteIn_Ex(int id) { In_Ex in_Ex = db.In_Ex.Find(id); if (in_Ex == null) { return(NotFound()); } db.In_Ex.Remove(in_Ex); db.SaveChanges(); return(Ok(in_Ex)); }
public ActionResult Create(receipt receipt) { if (Session["monthleft"] == null) { Session["monthleft"] = 1; } var loans = db.loan.Where(x => x.loancode == receipt.reloan).FirstOrDefault(); if (receipt.rerecive - (loans.loadpermonth * Convert.ToInt32(Session["monthleft"])) >= 0) { if (Convert.ToInt32(Session["monthleft"]) == 1) { loans.loanmonth = loans.loanmonth - 1; } else { loans.loanmonth = loans.loanmonth - Convert.ToInt32(Session["monthleft"]); } loans.loanmoney = loans.loanmoney - (loans.loadpermonth * Convert.ToInt32(Session["monthleft"])); receipt.remoney = loans.loadpermonth * Convert.ToInt32(Session["monthleft"]); var date = DateTime.Now; receipt.recode = date.Day.ToString() + date.Month.ToString() + receipt.reloan.ToString() + db.receipt.Count().ToString(); receipt.redate = DateTime.UtcNow; receipt.rechange = receipt.rerecive - receipt.remoney; receipt.remem = Session["User"].ToString(); loans.loanlastdate = DateTime.UtcNow; In_Ex income = new In_Ex(); income.expenditure = 0; income.income = receipt.remoney; income.date = DateTime.UtcNow; db.In_Ex.Add(income); db.receipt.Add(receipt); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.reloan = new SelectList(db.loan, "loancode", "loanmem", receipt.reloan); return(RedirectToAction("Create", "receipts", new { idcard = Session["idcardgetname"] })); }
public ActionResult Create(loan loan) { if (ModelState.IsValid) { decimal?moneyin = loan.loanmoney * Convert.ToDecimal(loan.loaninterest); decimal?money = loan.loanmoney + moneyin / 100; loan.loadpermonth = money / loan.loanmonth; loan.loanmoney = money; loan.loandate = DateTime.UtcNow; loan.loanlastdate = DateTime.UtcNow; In_Ex expen = new In_Ex(); expen.expenditure = money; expen.income = 0; expen.date = DateTime.UtcNow; db.In_Ex.Add(expen); db.loan.Add(loan); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.loancar = new SelectList(db.car, "carcode", "carbrand", loan.loancar); ViewBag.loanmem = new SelectList(db.member, "memidcard", "memidcard", loan.loanmem); return(View(loan)); }