/*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