public void Insert(Laboratory laboratory)
{
try
{
SqlConnection con = DataBaseConnection("open");
SqlCommand sqlcommand;
string databaseCommand = " INSERT INTO laboratory (name,capacity,type,id_Faculty) values (" + "'" + laboratory.Name + "'" + "," + "" + laboratory.Capacity + "" + "," + "'" + laboratory.Type + "'" + "," + "'" + laboratory.FacultyId + "'" + ")";
sqlcommand = new SqlCommand(databaseCommand, con);
sqlcommand.ExecuteNonQuery();
sqlcommand.Dispose();
DataBaseConnection("close");
}
catch (SqlException sqlException)
{
Console.WriteLine("Database error:" + sqlException.ToString());
}
}
public void Update(Laboratory laboratory)
{
SqlConnection con = DataBaseConnection("open");
try
{
SqlCommand cmdIns = new SqlCommand("UPDATE laboratory SET name=@name ,capacity=@capacity,type=@type,facultyId=@facultyId", con);
cmdIns.Parameters.Add("@name", laboratory.Name);
cmdIns.Parameters.Add("@capacity", laboratory.Capacity);
cmdIns.Parameters.Add("@type", laboratory.Type);
cmdIns.Parameters.Add("@facultyId", laboratory.FacultyId);
cmdIns.ExecuteNonQuery();
cmdIns.Dispose();
cmdIns = null;
}
catch (SqlException ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DataBaseConnection("close");
}
}
public void Insert(Laboratory laboratory)
{
laboratoryData.Insert(laboratory);
}
public void Update(Laboratory laboratory)
{
laboratoryData.Update(laboratory);
}
protected void btn_guardar_Click(object sender, EventArgs e)
{
LaboratoryBusiness lb = new LaboratoryBusiness();
Laboratory l = new Laboratory(txb_name.Text,Int32.Parse(txb_capacity.Text),txb_type.Text,Int32.Parse(ddl_faculties.SelectedValue));
lb.Insert(l);
}
