public MainWindow() { if (File.Exists("Sql.json")) { SqlDataAccess sqlDataAccess = new SqlDataAccess(); if (sqlDataAccess.Connection() == false) { InitializeComponent(); SqlViewModel sqlViewModel = new SqlViewModel(this); DataContext = sqlViewModel; } else { Welcome welcome = new Welcome(); welcome.Show(); this.Close(); } } else { InitializeComponent(); SqlViewModel sqlViewModel = new SqlViewModel(this); DataContext = sqlViewModel; } }
public SqlViewModel DashBoard(SqlViewModel sqlView) { var conn = dataContext.Database.GetDbConnection().ConnectionString; using (SqlConnection connection = new SqlConnection(conn)) { connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(sqlView.SqlCommand, connection); DataSet ds = new DataSet(); adapter.Fill(ds); foreach (DataTable dt in ds.Tables) { foreach (DataColumn column in dt.Columns) { sqlView.ColumName.Add(column.ColumnName); } foreach (DataRow row in dt.Rows) { // получаем все ячейки строки var cells = row.ItemArray; sqlView.RowName.Add(cells); } } connection.Close(); } return(sqlView); }
public static void ActualEntitiesView(this DbMigration migration, SqlViewModel queryModel) { var operartions = migration.Operations as IList <MigrationOperation>; if (operartions != null) { operartions.Add(new ActualEntitiesViewMigrationOperation(queryModel)); } }
protected void ActualView(MigrationActionType action, string tableName, string viewName, string[] properties, string[] keys, Func <SqlViewModel, SqlViewModel> sqlAction = null, bool isRegister = false, bool isSimple = false) { if (action == MigrationActionType.Up) { var viewModel = new SqlViewModel(viewName.GetViewName()).Init(tableName, properties, keys, isRegister, isSimple, true); this.ActualEntitiesView(sqlAction != null ? sqlAction(viewModel) : viewModel); } else { this.DropView(tableName.GetViewName()); } }
// GET: Member public ActionResult Index(string param = null) { DataTable dt = new DataTable(); string constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["NorthwindConnectionString1"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { string query = "SELECT [CustomerID],[CompanyName] FROM Customers"; using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { sda.Fill(dt); } } } var result = new List <SqlViewModel>(); foreach (DataRow x in dt.Rows) { var item = new SqlViewModel(); item.CompanyName = x["CompanyName"].ToString(); item.CustomerID = x["CustomerID"].ToString(); result.Add(item); } return(View(result)); // var result = new MemberViewModel // { // Name = "機器人", // Email = "*****@*****.**", // Phone = "0912345678", // Car = new List<string> // { // "toyota","benz","benzz" // } // }; // return View(result); }
public IActionResult GetAdminDash(SqlViewModel select) { var result = adminRepository.DashBoard(select); return(View(result)); }
public Ok(SqlViewModel sqlViewModel) { this.sqlViewModel = sqlViewModel; }
public ActualEntitiesViewMigrationOperation(SqlViewModel queryModel) : base(null) { _queryModel = queryModel; }