///<summary>Gets one email message from the database.</summary> public static EmailMessage GetOne(int msgNum) { string commands = "SELECT * FROM emailmessage WHERE EmailMessageNum = " + POut.PInt(msgNum) + ";SELECT * FROM emailattach WHERE EmailMessageNum = " + POut.PInt(msgNum); DataSet ds = null; try { if (RemotingClient.OpenDentBusinessIsLocal) { ds = GeneralB.GetDataSet(commands); } else { DtoGeneralGetDataSet dto = new DtoGeneralGetDataSet(); dto.Commands = commands; ds = RemotingClient.ProcessQuery(dto); } } catch (Exception e) { MessageBox.Show(e.Message); } DataTable table = ds.Tables[0]; EmailMessage Cur = new EmailMessage(); if (table.Rows.Count == 0) { return(null); } //for(int i=0;i<table.Rows.Count;i++){ Cur.EmailMessageNum = PIn.PInt(table.Rows[0][0].ToString()); Cur.PatNum = PIn.PInt(table.Rows[0][1].ToString()); Cur.ToAddress = PIn.PString(table.Rows[0][2].ToString()); Cur.FromAddress = PIn.PString(table.Rows[0][3].ToString()); Cur.Subject = PIn.PString(table.Rows[0][4].ToString()); Cur.BodyText = PIn.PString(table.Rows[0][5].ToString()); Cur.MsgDateTime = PIn.PDateT(table.Rows[0][6].ToString()); Cur.SentOrReceived = (CommSentOrReceived)PIn.PInt(table.Rows[0][7].ToString()); table = ds.Tables[1]; Cur.Attachments = new List <EmailAttach>(); EmailAttach attach; for (int i = 0; i < table.Rows.Count; i++) { attach = new EmailAttach(); attach.EmailAttachNum = PIn.PInt(table.Rows[i][0].ToString()); attach.EmailMessageNum = PIn.PInt(table.Rows[i][1].ToString()); attach.DisplayedFileName = PIn.PString(table.Rows[i][2].ToString()); attach.ActualFileName = PIn.PString(table.Rows[i][3].ToString()); Cur.Attachments.Add(attach); } return(Cur); }
///<summary>Same as GetDataSet, but will throw exception if query fails instead of displaying message.</summary> public static DataSet GetDataSetEx(string commands) { if (RemotingClient.OpenDentBusinessIsLocal) { return(GeneralB.GetDataSet(commands)); } else { DtoGeneralGetDataSet dto = new DtoGeneralGetDataSet(); dto.Commands = commands; return(RemotingClient.ProcessQuery(dto)); } }
///<summary>This is for multiple queries all concatenated together with ;</summary> public static DataSet GetDataSet(string commands) { try { if (RemotingClient.OpenDentBusinessIsLocal) { return(GeneralB.GetDataSet(commands)); } else { DtoGeneralGetDataSet dto = new DtoGeneralGetDataSet(); dto.Commands = commands; return(RemotingClient.ProcessQuery(dto)); } } catch (Exception e) { MessageBox.Show(e.Message); return(new DataSet()); } }