///<summary></summary> public static int Insert(EmailMessage message) { if (PrefB.RandomKeys) { message.EmailMessageNum = MiscDataB.GetKey("emailmessage", "EmailMessageNum"); } string command = "INSERT INTO emailmessage ("; if (PrefB.RandomKeys) { command += "EmailMessageNum,"; } command += "PatNum,ToAddress,FromAddress,Subject,BodyText," + "MsgDateTime,SentOrReceived) VALUES("; if (PrefB.RandomKeys) { command += "'" + POut.PInt(message.EmailMessageNum) + "', "; } command += "'" + POut.PInt(message.PatNum) + "', " + "'" + POut.PString(message.ToAddress) + "', " + "'" + POut.PString(message.FromAddress) + "', " + "'" + POut.PString(message.Subject) + "', " + "'" + POut.PString(message.BodyText) + "', " + POut.PDateT(message.MsgDateTime) + ", " + "'" + POut.PInt((int)message.SentOrReceived) + "')"; DataConnection dcon = new DataConnection(); if (PrefB.RandomKeys) { dcon.NonQ(command); } else { dcon.NonQ(command, true); message.EmailMessageNum = dcon.InsertID; } //now, insert all the attaches. for (int i = 0; i < message.Attachments.Count; i++) { message.Attachments[i].EmailMessageNum = message.EmailMessageNum; EmailAttachB.Insert(message.Attachments[i]); } return(message.EmailMessageNum); }
///<summary></summary> public static int Update(EmailMessage message) { string command = "UPDATE emailmessage SET " + "PatNum = '" + POut.PInt(message.PatNum) + "' " + ",ToAddress = '" + POut.PString(message.ToAddress) + "' " + ",FromAddress = '" + POut.PString(message.FromAddress) + "' " + ",Subject = '" + POut.PString(message.Subject) + "' " + ",BodyText = '" + POut.PString(message.BodyText) + "' " + ",MsgDateTime = " + POut.PDateT(message.MsgDateTime) + " " + ",SentOrReceived = '" + POut.PInt((int)message.SentOrReceived) + "' " + "WHERE EmailMessageNum = " + POut.PInt(message.EmailMessageNum); DataConnection dcon = new DataConnection(); dcon.NonQ(command); //now, delete all attachments and recreate. command = "DELETE FROM emailattach WHERE EmailMessageNum=" + POut.PInt(message.EmailMessageNum); dcon.NonQ(command); for (int i = 0; i < message.Attachments.Count; i++) { message.Attachments[i].EmailMessageNum = message.EmailMessageNum; EmailAttachB.Insert(message.Attachments[i]); } return(0); }