public void Insert(Faculty faculty)
{
try
{
SqlConnection con = DataBaseConnection("open");
SqlCommand sqlcommand;
string databaseCommand = " INSERT INTO faculty (name) values (" + "'" + faculty.Name + "')";
sqlcommand = new SqlCommand(databaseCommand, con);
sqlcommand.ExecuteNonQuery();
sqlcommand.Dispose();
DataBaseConnection("close");
}
catch (SqlException sqlException)
{
Console.WriteLine("Database error:" + sqlException.ToString());
}
}
protected void btn_guardar_Click(object sender, EventArgs e)
{
FacultyBusiness fb = new FacultyBusiness();
Faculty f = new Faculty(txb_name.Text);
fb.Insert(f);
}
public void Update(Faculty faculty)
{
SqlConnection con = DataBaseConnection("open");
try
{
SqlCommand cmdIns = new SqlCommand("UPDATE Reservation SET Name=@Name", con);
cmdIns.Parameters.Add("@Name", faculty.Name);
cmdIns.ExecuteNonQuery();
cmdIns.Dispose();
cmdIns = null;
}
catch (SqlException ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DataBaseConnection("close");
}
}
public void Update(Faculty faculty)
{
facultyData.Update(faculty);
}
public void Insert(Faculty faculty)
{
facultyData.Insert(faculty);
}
