private static void AddParms(ref DBAccess db, Dokumenter d)
{
var with_1 = d;
db.AddBit("Aktiv", with_1.Aktiv);
db.AddDateTime("Dato", with_1.Dato);
db.AddDateTime("ExpireDate", with_1.ExpireDate);
db.AddNVarChar("Name", with_1.Name, 250);
db.AddNVarChar("Mime", with_1.Mime, 100);
db.AddNVarChar("Beskrivelse", with_1.Beskrivelse, -1);
db.AddInt("Type", with_1.Type);
db.AddInt("Category", with_1.Category);
db.AddInt("Owner", with_1.Owner);
db.AddInt("MedArbGrpID", with_1.MedArbGrpID);
db.AddNVarChar("Filename", with_1.Filename, 250);
db.AddNVarChar("Ext", with_1.Ext, 50);
db.AddInt("Size", with_1.Size);
db.AddInt("Width", with_1.Width);
db.AddInt("Height", with_1.Height);
db.AddNVarChar("UserID", with_1.UserID, 50);
db.AddBlob("Blob", d.Blob);
db.AddNVarChar("Clob", with_1.Clob, -1);
AddParmsStandard(db, d);
}
public static int UpdateBlob(Dokumenter d)
{
DBAccess db = new DBAccess();
db.AddInt("ID", d.ID);
db.AddBlob("Blob", d.Blob);
return(db.ExecuteNonQuery(_SQLUpdateBlob));
}