public void Save(GmConnection conn, DbTransaction trans)
{
GmCommand cmd = conn.CreateCommand(trans);
cmd.AddInt("Id", id);
cmd.AddDateTime("Date", date);
cmd.AddInt("UserId", userId);
cmd.AddInt("DocumentTypeId", (int)documentTypeId);
cmd.AddBoolean("Completed", completed);
cmd.AddInt("StorekeeperId", storekeeperId);
cmd.AddInt("NDays", nDays);
cmd.AddString("DocumentData", documentData.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into Documents values (@Date,@UserId,@DocumentTypeId,@Completed,@StorekeeperId,@NDays,@DocumentData) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Documents set Date=@Date,UserId=@UserId,DocumentTypeId=@DocumentTypeId,Completed=@Completed,StorekeeperId=@StorekeeperId,NDays=@NDays,DocumentData=@DocumentData where Id=@Id";
cmd.ExecuteNonQuery();
}
}
