public bool AddManufacturer(Manufacturer m)
{
bool error = false;
string consulta = "INSERT INTO Manufacturer (ManufacturerName, ManufacturerCountry)" +
" VALUES (@ManufacturerName, @ManufacturerCountry);";
using (SqlConnection conn = GetConnection())
{
SqlCommand cmd = new SqlCommand(consulta, conn);
cmd.Parameters.AddWithValue("@ManufacturerName", m.ManufacturerName);
cmd.Parameters.AddWithValue("@ManufacturerCountry", m.ManufacturerCountry);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
error = true;
}
}
return error;
}
public Manufacturer GetManufacturerByID(int id)
{
Manufacturer ma = null;
string consulta = "SELECT ManufacturerID, ManufacturerName," +
" ManufacturerCountry, ManufacturerEmail, ManufacturerWebsite" +
" FROM Manufacturer WHERE ManufacturerID = @ManufacturerID";
using (SqlConnection conn = GetConnection())
{
SqlCommand cmd = new SqlCommand(consulta, conn);
cmd.Parameters.AddWithValue("@ManufacturerID", id);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ma = new Manufacturer
{
ManufacturerName = reader.GetString(reader.GetOrdinal("ManufacturerName")),
ManufacturerCountry = reader.GetString(reader.GetOrdinal("ManufacturerCountry")),
ManufacturerEmail = reader.GetString(reader.GetOrdinal("ManufacturerEmail")),
ManufacturerWebsite = reader.GetString(reader.GetOrdinal("ManufacturerWebsite")),
};
}
}
reader.Close();
}
return ma;
}
// GET: /Manufacturer/Guardar
public ActionResult Guardar(Manufacturer m)
{
ViewData["Manufacturer"] = string.Format("Nombre: {0}, Country: {1}",
m.ManufacturerName, m.ManufacturerCountry);
return View();
}