public static Model.Patrimonio BuscarPorId(int clienteId)
{
using (MySqlConnection conn = new MySqlConnection(strConection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = @"SELECT * FROM patrimonio WHERE id = ?id";
cmd.Parameters.AddWithValue("?id", clienteId);
MySqlDataReader reader = cmd.ExecuteReader();
Model.Patrimonio retorno = new Model.Patrimonio();
while (reader.Read())
{
retorno.Id = (int)reader["Id"];
retorno.Descricao = (string)reader["descricao"];
retorno.Tipo = (string)reader["tipo"];
retorno.EmManutecao = (bool)reader["emManutencao"];
retorno.TorreId = (int)reader["idTorre"];
retorno.Local = (string)reader["local"];
}
return(retorno);
}
}
}
public ActionResult Create(Model.Patrimonio patrimonio)
{
try
{
Control.PatrimonioDAO.Salvar(patrimonio);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, Model.Patrimonio patrimonio)
{
try
{
// TODO: Add update logic here
Control.PatrimonioDAO.Salvar(patrimonio);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public static void Salvar(Model.Patrimonio patrimonio)
{
using (MySqlConnection conn = new MySqlConnection(strConection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
if (patrimonio.Id == 0)
{
cmd.CommandText = @"INSERT INTO patrimonio
(descricao, emManutencao, local, tipo, idTorre)
VALUES
(?descricao, ?emManutencao, ?local, ?tipo, ?idTorre);";
}
else
{
cmd.CommandText = @"UPDATE patrimonio
SET descricao = ?descricao,
emManutencao = ?emManutencao,
local = ?local,
tipo = ?tipo,
idTorre = ?idTorre,
status = ?status,
idCondominio = ?idCondominio
WHERE id = ?id;";
}
cmd.Parameters.AddWithValue("?descricao", patrimonio.Descricao);
cmd.Parameters.AddWithValue("?emManutencao", patrimonio.EmManutecao);
cmd.Parameters.AddWithValue("?local", patrimonio.Local);
cmd.Parameters.AddWithValue("?tipo", patrimonio.Tipo);
cmd.Parameters.AddWithValue("?idTorre", patrimonio.TorreId);
cmd.Parameters.AddWithValue("?id", patrimonio.Id);
cmd.ExecuteNonQuery();
}
}
}
