public void Edit(BookkeepingListViewModel pageData, BookkeepingListViewModel oldData) { oldData.Date = pageData.Date; oldData.Type = pageData.Type; oldData.Amount = pageData.Amount; oldData.Remark = pageData.Remark; }
public ActionResult DeleteConfirmed(int id) { BookkeepingListViewModel bookkeepingListViewModel = _BookkeepingSvc.GetSingle(id); _BookkeepingSvc.Delete(bookkeepingListViewModel); _BookkeepingSvc.Save(); _LogSvc.Add(id, "Delete"); _LogSvc.Save(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Amount,Date,Remark,Type")] BookkeepingListViewModel bookkeepingListViewModel) { var oldData = _BookkeepingSvc.GetSingle(bookkeepingListViewModel.Id); if (oldData != null && ModelState.IsValid) { _BookkeepingSvc.Edit(bookkeepingListViewModel, oldData); _BookkeepingSvc.Save(); _LogSvc.Add(bookkeepingListViewModel.Id, "Edit"); _LogSvc.Save(); return(RedirectToAction("Index")); } return(View(bookkeepingListViewModel)); }
// GET: BookkeepingListViewModels/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BookkeepingListViewModel bookkeepingListViewModel = _BookkeepingSvc.GetSingle(id.Value); if (bookkeepingListViewModel == null) { return(HttpNotFound()); } return(View(bookkeepingListViewModel)); }
public ActionResult Create([Bind(Include = "Id,Amount,Date,Remark,Type")] BookkeepingListViewModel bookkeepingListViewModel) { if (ModelState.IsValid) { _BookkeepingSvc.Add(bookkeepingListViewModel); _BookkeepingSvc.Save(); int recordId = _BookkeepingSvc.GetRecordID(); _LogSvc.Add(recordId, "Create"); _LogSvc.Save(); return(RedirectToAction("Index")); } return(View(bookkeepingListViewModel)); }
public List <BookkeepingListViewModel> GetAllList() { var result = new List <BookkeepingListViewModel>(); const string sqlStatement = "Select pDate,BookType,Amount,Remark From Bookkeeping "; using (var conn = new SqlConnection(this.ConnectionString)) using (var command = new SqlCommand(sqlStatement, conn)) { command.CommandType = CommandType.Text; command.CommandTimeout = 180; if (conn.State != ConnectionState.Open) { conn.Open(); } using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { BookType bType = (reader["BookType"].ToString() == "1") ? BookType.收入 : BookType.支出; var item = new BookkeepingListViewModel { Date = DateTime.Parse(reader["pDate"].ToString()), Type = bType, Amount = int.Parse(reader["Amount"].ToString()), Remark = reader["Remark"].ToString() }; result.Add(item); } } } return(result); }
public ActionResult Index(BookkeepingListViewModel PageData) { return(View(PageData)); }
public void Delete(BookkeepingListViewModel data) { _BookkeepingListRep.Remove(data); }
public void Add(BookkeepingListViewModel bookkeepingList) { _BookkeepingListRep.Create(bookkeepingList); }