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