public JsonResult BookKeeper(Models.BookKeeper bookkeeper) { Models.BookServices bookService = new Models.BookServices(); var result = bookService.GetBookKeeper(bookkeeper); return(Json(result)); }
public List <Models.BookKeeper> GetBookKeeper(Models.BookKeeper BookKeeper) { DataTable dt = new DataTable(); string sql = @"Select * From [dbo].[MEMBER_M] "; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(dt); conn.Close(); } return(this.MapBookKeeperDataToList(dt)); }