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