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