private void Search(string query = "")
{
//clear entries if any
ClientListBox.Items.Clear();
//Then start a fresh search
string searchStr = SearchTB.Text;
Boolean IncLost = IncLostCheck.Checked;
ClientListBox.DisplayMember = "Name";
ClientListBox.ValueMember = "crmid";
SqlDataReader xlReader = null;
if (query == "")
{
query = "Select clientcode + ' - ' + name, crmID from Client where ((ClientCode like '%" + searchStr + "%') Or (Name Like '%" + searchStr + "%'))";
if (!IncLost)
{
query += " and status in ('New', 'Active')";
}
query += " order by name";
}
xlReader = XLSQL.ReaderQuery(query);
if (xlReader == null)
{
MessageBox.Show("Unable to connect to database.");
}
else
{
if (xlReader.HasRows)
{
while (xlReader.Read())
{
EntityCouplet newEntity = new EntityCouplet();
newEntity.crmID = xlReader.NiceString("CRMId");
newEntity.name = xlReader.NiceString("Name");
ClientListBox.Items.Add(newEntity);
}
}
else
{
MessageBox.Show("No Records found");
}
}
}
public static string FileLocation(Outlook.MailItem email)
{
try
{
string loc = "";
string[] sArray = email.Headers("Message-ID");
//Should only ever be 1 message-ID!
string id = "";
if (sArray.Length == 1)
{
id = sArray[0];
MessageBox.Show(id);
}
else
{
MessageBox.Show("Unable to find message Id");
}
DataTable fileid = XLSQL.ReturnTable("Select fileid + '-' + version from VCMailID where MailID = '" + id + "'");
string filename = "";
if (fileid != null)
{
filename = fileid.Rows[0][0].ToString();
MessageBox.Show(filename);
}
else
{
MessageBox.Show("Unable to find file ID");
}
string folder = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Virtual Cabinet\\Edited documents\\";
loc = folder + filename;
return(loc);
}
catch (Exception ex)
{
MessageBox.Show("Unable to get file location");
XLtools.LogException("FileLocation", ex.ToString());
return(null);
}
}
