public async Task <IActionResult> Edit(int id, [Bind("paslaugosId,paslaugosKaina,paslaugosPavadinimas,paslaugosAprasymas")] Paslauga paslauga) { if (id != paslauga.paslaugosId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(paslauga); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PaslaugaExists(paslauga.paslaugosId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(paslauga)); }
public Paslauga getPaslauga(int id) { Paslauga paslauga = new Paslauga(); string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(conn); string sqlquery = @"SELECT a.id, a.pavadinimas, a.aprasymas FROM " + Globals.dbPrefix + @"paslaugos a WHERE a.id= " + id; MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection); mySqlConnection.Open(); MySqlDataAdapter mda = new MySqlDataAdapter(mySqlCommand); DataTable dt = new DataTable(); mda.Fill(dt); mySqlConnection.Close(); foreach (DataRow item in dt.Rows) { paslauga.id = Convert.ToInt32(item["id"]); paslauga.pavadinimas = Convert.ToString(item["pavadinimas"]); paslauga.aprasymas = Convert.ToString(item["aprasymas"]); } return(paslauga); }
public async Task <IActionResult> Create([Bind("paslaugosId,paslaugosKaina,paslaugosPavadinimas,paslaugosAprasymas")] Paslauga paslauga) { if (ModelState.IsValid) { _context.Add(paslauga); await _context.SaveChangesAsync(); //ViewData["CreateSuccess"] = "Paslaugos pridėjimas sėkmingas."; return(RedirectToAction(nameof(Create), new { success = "Paslaugos pridėjimas sėkmingas." })); } return(View(paslauga)); }
public bool updatePaslauga(Paslauga paslauga) { string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(conn); string sqlquery = @"UPDATE " + Globals.dbPrefix + "paslaugos a SET a.pavadinimas=?pavadinimas, a.aprasymas=?aprasymas WHERE a.id=?id"; MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection); mySqlCommand.Parameters.Add("?id", MySqlDbType.VarChar).Value = paslauga.id; mySqlCommand.Parameters.Add("?pavadinimas", MySqlDbType.VarChar).Value = paslauga.pavadinimas; mySqlCommand.Parameters.Add("?aprasymas", MySqlDbType.VarChar).Value = paslauga.aprasymas; mySqlConnection.Open(); mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); return(true); }
public int insertPaslauga(Paslauga paslauga) { int insertedId = -1; string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mySqlConnection = new MySqlConnection(conn); string sqlquery = @"INSERT INTO " + Globals.dbPrefix + "paslaugos(pavadinimas,aprasymas)VALUES(?pavadinimas,?aprasymas);"; MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection); mySqlCommand.Parameters.Add("?pavadinimas", MySqlDbType.VarChar).Value = paslauga.pavadinimas; mySqlCommand.Parameters.Add("?aprasymas", MySqlDbType.VarChar).Value = paslauga.aprasymas; mySqlConnection.Open(); mySqlCommand.ExecuteNonQuery(); mySqlConnection.Close(); insertedId = Convert.ToInt32(mySqlCommand.LastInsertedId); return(insertedId); }