/*insert into v2_Debitor(Navn, Adresse, PostNr, [By], KundeType, TLF, Kundenr)
* values('Jens Holger', 'KoldingVej',7545, 'Vejle', 'P', '75412356', 'KO4575')*/
public DebitorObj FindDebitor(string debitorTlf)//Michael
{
/* DebitorObj is assigned null and will remain null
* unless an occurrence,@param debitorTlf ,is found in the database.*/
DebitorObj debitorObj = null;
string sqlCmdText = $"select * from v2_Debitor where Tlf ='{debitorTlf}'";
SqlCommand comm = new SqlCommand(sqlCmdText, conn);
comm.Connection.Open();
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
debitorObj = new DebitorObj(
Convert.ToString(reader["Navn"]),
Convert.ToString(reader["Adresse"]),
Convert.ToInt32(reader["Postnr"]),
Convert.ToString(reader["By"]),
Convert.ToString(reader["manr"]),
Convert.ToString(reader["dnr"]),
Convert.ToString(reader["Kundetype"]),
Convert.ToString(reader["TLF"]),
Convert.ToString(reader["Kundenr"])
);
break;
}
reader.Close();
comm.Connection.Close();
return(debitorObj);
}
public void UpdateDebitor(DebitorObj debitorObj)//Michael
{
string sqlCmdText = $"Update v2_Debitor set " +
$" Navn='{debitorObj.Navn}'," +
$" Adresse='{debitorObj.Adresse}'," +
$" PostNr={debitorObj.PostNr}, " +
$" [By]='{debitorObj.By}', " +
$" KundeType='{debitorObj.KundeType}', " +
$" TLF='{debitorObj.Tlf}', " +
$" Kundenr='{debitorObj.KundeNr}'" +
$" where TLF = '{debitorObj.Tlf}'";
/*Initalizing SqlCommand object comm with two paramerets:
* @parm conn, gives comm connection abilities.
* @param sqlCmdText, QueryText to be executed at Database server.*/
SqlCommand comm = new SqlCommand(sqlCmdText, conn);
comm.Connection.Open();
comm.ExecuteNonQuery();
comm.Connection.Close();
}
public void InserDebitor(DebitorObj debitorObj)//Michael
{
string sqlCmdText = $"insert into v2_Debitor ( Navn, Adresse, Postnr, [By], manr, Kundetype, TLF, Kundenr) " +
$"values ('{debitorObj.Navn}'," +
$" '{debitorObj.Adresse}'," +
$" {debitorObj.PostNr}," +
$" '{debitorObj.By}'," +
$" '{debitorObj.MedarbejderNr}'," +
$" '{debitorObj.KundeType}'," +
$" {debitorObj.Tlf}," +
$" '{debitorObj.KundeNr}')";
/*Initalizing SqlCommand object comm with two paramerets:
* @parm conn, gives comm connection abilities.
* @param sqlCmdText, QueryText to be executed at Database server.*/
SqlCommand comm = new SqlCommand(sqlCmdText, conn);
comm.Connection.Open();
comm.ExecuteNonQuery();
comm.Connection.Close();
}
}//Michael
public void HentDebitor(string debitorTlf)
{
DebitorObj debitorObj = connection.FindDebitor(debitorTlf);
debitor.Add(debitorObj);
}//Michael
}//Michael
public void UpdatetDebitor(string navn, string adresse, int postNr, string by, string medarbejderNr, string debitorNr, string kundeType, string tlf, string kundeNr)
{
DebitorObj debitorObj = new DebitorObj(navn, adresse, postNr, by, medarbejderNr, debitorNr, kundeType, tlf, kundeNr);
connection.UpdateDebitor(debitorObj);
}//Michael
