public DEB HentDEB(long cprCvr) { DEB deb = new DEB(); try { conn = new SqlConnection(Connection()); string SelectSqlString = $"Select * from DEB where cprCvr = {cprCvr}"; conn.Open(); SqlCommand comselect = new SqlCommand(SelectSqlString, conn); SqlDataReader myReader = comselect.ExecuteReader(); while (myReader.Read()) { deb = new DEB(Convert.ToInt64(myReader["cprCvr"].ToString()), myReader["navn"].ToString(), myReader["gade"].ToString(), Convert.ToInt32(myReader["postnr"].ToString()), myReader["byen"].ToString(), Convert.ToInt32(myReader["tlf"].ToString()), myReader["email"].ToString(), myReader["ansvarlig"].ToString()); } } catch (SqlException ex) { MessageBox.Show("Der er sket en fejl i din SQL\n" + ex.Message + "\n" + com.CommandText); } finally { conn.Close(); } return(deb); }
public DEB HentDEB(long cprCvr) { DEB deb = new DEB(); string SelectSqlString = $"Select * from DEB where cprCvr = {cprCvr}"; SqlConnection conn = new SqlConnection(Connection()); conn.Open(); SqlCommand comselect = new SqlCommand(SelectSqlString, conn); SqlDataReader myReader = comselect.ExecuteReader(); while (myReader.Read()) { deb = new DEB(Convert.ToInt64(myReader["cprCvr"].ToString()), myReader["navn"].ToString(), myReader["gade"].ToString(), Convert.ToInt32(myReader["postnr"].ToString()), myReader["byen"].ToString(), Convert.ToInt32(myReader["tlf"].ToString()), myReader["email"].ToString(), myReader["ansvarlig"].ToString()); } myReader.Close(); conn.Close(); return(deb); }
public void IndsætDEB(DEB deb) { try { string InsertSqlString = $"Insert into DEB(cprCvr, navn, gade, postnr, byen, email, tlf, ansvarlig)" + $"values({deb.CprCvr},'{deb.Navn}','{deb.Gade}',{deb.Postnr},'{deb.By}','{deb.Email}',{deb.Tlf},'{deb.Ansvarlig}')"; Console.WriteLine(InsertSqlString); conn = new SqlConnection(Connection()); conn.Open(); com = new SqlCommand(InsertSqlString, conn); com.ExecuteNonQuery(); conn.Close(); } catch (SqlException ex) { Console.WriteLine("Der er sket en fejl i din SQL"); //Udskriver fejltypen: Console.WriteLine(ex.Message); //Udskriver kommandoen: Console.WriteLine(com.CommandText); } finally { conn.Close(); } }
public void UpdateDEB(DEB deb) { string UpdateSqlString = $"Update DEB set cprCvr = '{deb.CprCvr}', " + $"navn = '{deb.Navn}', gade = '{deb.Gade}', postnr = {deb.Postnr}, byen = '{deb.By}', tlf = {deb.Tlf}," + $" email = '{deb.Email}', ansvarlig = '{deb.Ansvarlig}' where cprCvr = {deb.CprCvr}"; Console.WriteLine(UpdateSqlString); SqlConnection conn = new SqlConnection(Connection()); conn.Open(); SqlCommand com = new SqlCommand(UpdateSqlString, conn); com.ExecuteNonQuery(); conn.Close(); }
private void fillByToolStripButton_Click(object sender, EventArgs e) { long cprCvr = Convert.ToInt64(cprCvrToolStripTextBox.Text); DEB deb = c.HentDEB(cprCvr); textBoxNavn.Text = deb.Navn; textBoxGade.Text = deb.Gade; textBoxPostNr.Text = deb.Postnr.ToString(); textBoxBy.Text = deb.By; textBoxTlf.Text = deb.Tlf.ToString(); textBoxEmail.Text = deb.Email; textBoxAnsvarlig.Text = deb.Ansvarlig; try { this.lejeOrdreTableAdapter1.FillBy(this.delpinasDataSet1.LejeOrdre, new System.Nullable <long>(((long)(System.Convert.ChangeType(cprCvrToolStripTextBox.Text, typeof(long)))))); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } }
//Bruges ikke, da det ikke er muligt at slette en DEB i øjeblikket. //public void SletDEB(long cprCvr) //{ // try // { // string DeleteSqlString = $"Delete from LejeOrdreLinjer where cprCvr" + // $"Delete from DEB where cprCvr = {cprCvr}"; // Console.WriteLine(DeleteSqlString); // conn = new SqlConnection(Connection()); // conn.Open(); // SqlCommand com = new SqlCommand(DeleteSqlString, conn); // com.ExecuteNonQuery(); // } // catch (SqlException ex) // { // MessageBox.Show("Der er sket en fejl i din SQL\n" + // ex.Message + "\n" + com.CommandText); // } // finally // { // conn.Close(); // } //} public void UpdateDEB(DEB deb) { try { string UpdateSqlString = $"Update DEB set cprCvr = '{deb.CprCvr}', " + $"navn = '{deb.Navn}', gade = '{deb.Gade}', postnr = {deb.Postnr}, byen = '{deb.By}', tlf = {deb.Tlf}," + $" email = '{deb.Email}', ansvarlig = '{deb.Ansvarlig}' where cprCvr = {deb.CprCvr}"; Console.WriteLine(UpdateSqlString); conn = new SqlConnection(Connection()); conn.Open(); SqlCommand com = new SqlCommand(UpdateSqlString, conn); com.ExecuteNonQuery(); } catch (SqlException ex) { MessageBox.Show("Der er sket en fejl i din SQL\n" + ex.Message + "\n" + com.CommandText); } finally { conn.Close(); } }
public void UpdateDEB(long cprCvr, string navn, string gade, int postnr, string by, int tlf, string email, string ansvarlig) { DEB deb = new DEB(cprCvr, navn, gade, postnr, by, tlf, email, ansvarlig); dbm.UpdateDEB(deb); }
public DEB HentDEB(long cprCvr) { DEB deb = dbm.HentDEB(cprCvr); return(deb); }
public void GemDEB(long cprCvr, string navn, string gade, int postnr, string by, int tlf, string email, string ansvarlig) { DEB deb = new DEB(cprCvr, navn, gade, postnr, by, tlf, email, ansvarlig); DBM.IndsætDEB(deb); }