public ActionResult DeleteConfirmed(int id) { tbl_Expense tbl_expense = db.tbl_Expense.Find(id); db.tbl_Expense.Remove(tbl_expense); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "expense_id,employee_id,expense_category,expense_amount,data,year,expense_discription,user_id,ex_category_id")] tbl_Expense tbl_expense) { if (ModelState.IsValid) { db.Entry(tbl_expense).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ex_category_id = new SelectList(db.tbl_expense_category, "ex_category_id", "category_name", tbl_expense.ex_category_id); ViewBag.user_id = new SelectList(db.tbl_user, "user_id", "user_name", tbl_expense.user_id); return(View(tbl_expense)); }
// GET: /Expense/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Expense tbl_expense = db.tbl_Expense.Find(id); if (tbl_expense == null) { return(HttpNotFound()); } return(View(tbl_expense)); }
public void Save() { using (var context = new CashCarryEntities3()) { tbl_Expense objExp = new tbl_Expense() { ExType = ExType, ExName = ExName, Description = Description, Date = Date, Amount = Amount }; context.tbl_Expense.Add(objExp); context.SaveChanges(); } }
// GET: /Expense/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Expense tbl_expense = db.tbl_Expense.Find(id); if (tbl_expense == null) { return(HttpNotFound()); } ViewBag.ex_category_id = new SelectList(db.tbl_expense_category, "ex_category_id", "category_name", tbl_expense.ex_category_id); ViewBag.user_id = new SelectList(db.tbl_user, "user_id", "user_name", tbl_expense.user_id); return(View(tbl_expense)); }
protected async void btnAddExpense_Click(object sender, EventArgs e) { tbl_Expense objExpense = new tbl_Expense(); Guid id = Guid.NewGuid(); objExpense.ExpenseID = id.ToString(); objExpense.ItemName = txtItemName.Text.Trim(); objExpense.Category = ddlCategory.SelectedValue; objExpense.Quantity = Convert.ToInt32(txtQuantity.Text.Trim()); objExpense.Price = Convert.ToDecimal(txtPrice.Text.Trim()); objExpense.Amount = Convert.ToInt32(txtQuantity.Text.Trim()) * Convert.ToDecimal(txtPrice.Text.Trim()); objExpense.PaymentType = ddlPaymentType.SelectedValue; objExpense.Currency = ddlCurrency.SelectedValue; objExpense.Date = Convert.ToDateTime(expenseDate.Value); objExpense.Description = txtDescription.Text.Trim(); try { var json = JsonConvert.SerializeObject(objExpense); var content = new StringContent(json, Encoding.UTF8, "application/json");//using System.Text; for Encoding var httpClient = new HttpClient(); var request = await httpClient.PostAsync("http://localhost:3333/itc/addExpense", content); request.EnsureSuccessStatusCode(); //ClientScript.RegisterStartupScript //find in online } catch (Exception ex) { lblResult.Text = "Fail : " + ex; } finally { Response.Redirect(Request.RawUrl); } }