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