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