/// <summary>
/// </summary>
private void btnExportCode_Click(object sender, EventArgs e)
{
string q = GenUtil.SafeTrim(txtQuery.Text);
q = q.Replace("\"", "\"\"");
q = Regex.Replace(q, "( ){2,}", " ");
q = GenUtil.RemoveWhiteSpace(q);
q = Regex.Replace(q, "> <", "><");
if (formChooser.appMode != Chooser.AppMode.UseSOM)
{
q = GenUtil.WrapWSQuery(q);
}
string v = GenUtil.SafeTrim(txtViewFields.Text);
v = v.Replace("\"", "\"\"");
v = Regex.Replace(v, "( ){2,}", " ");
v = GenUtil.RemoveWhiteSpace(v);
v = Regex.Replace(v, "> <", "><");
string va = GenUtil.SafeTrim(txtViewAttributes.Text);
va = va.Replace("\"", "\"\"");
va = Regex.Replace(va, "( ){2,}", " ");
va = GenUtil.RemoveWhiteSpace(va);
va = Regex.Replace(va, "> <", "><");
string rl = GenUtil.SafeToNum(txtRowLimit.Text).ToString();
StringBuilder sb = new StringBuilder();
sb.AppendLine(string.Format("string sQuery = @\"{0}\";", q));
sb.AppendLine(string.Format("string sViewFields = @\"{0}\";", v));
sb.AppendLine(string.Format("string sViewAttrs = @\"{0}\";", va));
sb.AppendLine(string.Format("uint iRowLimit = {0};", rl));
sb.AppendLine();
sb.AppendLine("var oQuery = new SPQuery();");
sb.AppendLine("oQuery.Query = sQuery;");
sb.AppendLine("oQuery.ViewFields = sViewFields;");
sb.AppendLine("oQuery.ViewAttributes = sViewAttrs;");
sb.AppendLine("oQuery.RowLimit = iRowLimit;");
sb.AppendLine();
sb.AppendLine("SPListItemCollection collListItems = oList.GetItems(oQuery);");
sb.AppendLine();
sb.AppendLine("foreach (SPListItem oListItem in collListItems)");
sb.AppendLine("{");
sb.AppendLine("}");
Clipboard.SetText(sb.ToString());
MessageBox.Show("Generated C# Code Copied to Clipboard.");
}
/// <summary>
/// </summary>
private void btnSubmit_Click(object sender, EventArgs e)
{
if ((rbUseWSCustCreds.Checked || rbUseWSOffice365.Checked) &&
(GenUtil.IsNull(txtUsername.Text) || GenUtil.IsNull(txtPassword.Text)))
{
MessageBox.Show("Username and Password are required.", "ERROR");
return;
}
if (rbUseSOM.Checked)
{
appMode = AppMode.UseWSCreds;
}
else if (rbUseWSCustCreds.Checked)
{
appMode = AppMode.UseWSCreds;
}
else if (rbUseWSImpers.Checked)
{
appMode = AppMode.UseWSDef;
}
else if (rbUseWSOffice365.Checked)
{
appMode = AppMode.UseWSOffice365;
}
credUsername = GenUtil.SafeTrim(txtUsername.Text);
credPassword = GenUtil.SafeTrim(txtPassword.Text);
credDomain = GenUtil.SafeTrim(txtDomain.Text);
if (form1 == null)
{
form1 = new Form1();
form1.StartPosition = FormStartPosition.CenterScreen;
form1.formChooser = this;
}
form1.ShowHideListViews(rbUseSOM.Checked);
this.Hide();
form1.Show();
form1.Activate();
}
/// <summary>
/// </summary>
private void SaveCurrentSessionInfo()
{
if (GenUtil.SafeToBool(ConfigurationManager.AppSettings["disableSession"]))
{
return;
}
StreamWriter sw = null;
try
{
string iniPath = AppDomain.CurrentDomain.BaseDirectory.TrimEnd(new char[] { '\\' }) + "\\" + "session.ini";
sw = new StreamWriter(iniPath, false);
var sso = new SessionObject();
sso.txtQuery = GenUtil.NormalizeEol(txtQuery.Text);
sso.txtRowLimit = GenUtil.SafeTrim(txtRowLimit.Text);
sso.txtSiteUrl = GenUtil.SafeTrim(txtSiteUrl.Text);
sso.txtViewAttributes = GenUtil.NormalizeEol(txtViewAttributes.Text);
sso.txtViewFields = GenUtil.NormalizeEol(txtViewFields.Text);
sso.txtUsername = formChooser.credUsername;
sso.txtPassword = formChooser.credPassword;
sso.txtDomain = formChooser.credDomain;
sso.appMode = ((int)formChooser.appMode).ToString();
var xml = XmlSerialization.Serialize(sso);
sw.Write(xml);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (sw != null)
{
sw.Dispose();
}
}
}
/// <summary>
/// </summary>
public static string RemoveWhiteSpace(object s)
{
return(Regex.Replace(GenUtil.SafeTrim(s), "[\\t\\r\\n]", ""));
}
/// <summary>
/// </summary>
private void ExportGrid(DataGridView gv, string type)
{
var saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
saveFileDialog1.Filter = "Csv file (*.csv)|*.csv|All Files (*.*)|*.*";
saveFileDialog1.FilterIndex = 1;
saveFileDialog1.AddExtension = true;
saveFileDialog1.FileName = "export.csv";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
toolStripStatusLabel1.Text = "Running...";
statusStrip1.Refresh();
picLogoWait.Visible = true;
picLogoWait.Refresh();
System.IO.StreamWriter streamWriter = null;
try
{
streamWriter = new System.IO.StreamWriter(saveFileDialog1.FileName);
string strHeader = "";
for (int i = 0; i < gv.Columns.Count; i++)
{
string curval = GenUtil.SafeTrim(gv.Columns[i].HeaderText);
if (curval.Contains(",") && !curval.StartsWith("\""))
{
strHeader += "\"" + curval + "\"" + ",";
}
else
{
strHeader += curval + ",";
}
}
streamWriter.WriteLine(strHeader);
for (int m = 0; m < gv.Rows.Count; m++)
{
string strRowValue = "";
for (int n = 0; n < gv.Columns.Count; n++)
{
string curval = GenUtil.SafeTrim(gv.Rows[m].Cells[n].Value);
if (curval.Contains(",") && !curval.StartsWith("\""))
{
strRowValue += "\"" + curval.Replace("\"", "'") + "\"" + ",";
}
else
{
strRowValue += curval.Replace("\"", "'") + ",";
}
}
streamWriter.WriteLine(strRowValue);
}
}
catch (Exception ex)
{
MessageBox.Show("ERROR: see status window below for details.", "ERROR");
GenUtil.LogIt(txtStatus, string.Format("ERROR: cannot export to CSV: {0}", ex.ToString()));
}
finally
{
if (streamWriter != null)
{
streamWriter.Close();
}
}
toolStripStatusLabel1.Text = oldStatusText;
statusStrip1.Refresh();
picLogoWait.Visible = false;
picLogoWait.Refresh();
}
}