public static OleDbCommand SaveFatureDalje(FatureDalje fatureDalje)
{
return(new OleDbCommand("INSERT INTO Fature_Dalje (NoFature, Data, KlientiID, PunetorID) " +
"VALUES (" +
"'" + fatureDalje.NoFature + "', " +
"'" + fatureDalje.Date + "', " +
"'" + fatureDalje.Klienti.ID + "', " +
"'" + fatureDalje.Puntori.ID + "'" +
")"
));
}
public static List <FatureDalje> GetAllFaturat()
{
List <FatureDalje> fatura = new List <FatureDalje>();
try
{
string getNArtikujt = "SELECT * FROM Fature_Dalje";
var tb = connection.Read(getNArtikujt);
foreach (DataRow row in tb.Rows)
{
fatura.Add(FatureDalje.Map(row));
}
}
catch (Exception e)
{
}
return(fatura);
}
public bool _Save()
{
List <OleDbCommand> oleDbCommands = new List <OleDbCommand>();
try
{
oleDbCommands.Add(FatureDalje.SaveFatureDalje(this.fature));
foreach (var artikull in this.artikujt)
{
oleDbCommands.AddRange(ArtikullFature.SaveArtikullFature(artikull));
}
return(conn.UpdateInsert(oleDbCommands));
}
catch (Exception e)
{
return(false);
}
}
