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