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