private static void AddToLucene(string pathTemplate, string saveFile) { LuceneParser lucene = new LuceneParser(Path.Combine(pathTemplate, "luceneIdx")); try { lucene.AddFile(saveFile); } catch (IndexDamagedException) { lucene.addFolder(pathTemplate); } lucene = null; }
private void FillForm() { string sqlString; sqlString = "SELECT * FROM ADMIN_CUSTOMER_VIEW"; IDataReader dataReader = DatabaseConnection.CreateReader(sqlString); if (dataReader.Read()) { CompanyName.Text = (string)dataReader["COMPANYNAME"]; PhoneNumber.Text = Convert.ToString(dataReader["PHONE"]); Fax.Text = Convert.ToString(dataReader["FAX"]); Email.Text = Convert.ToString(dataReader["EMAIL"]); WebSite.Text = Convert.ToString(dataReader["WEBSITE"]); AddressInvoice.Text = Convert.ToString(dataReader["ADDRESS"]); CityInvoice.Text = Convert.ToString(dataReader["CITY"]); ProvinceInvoice.Text = Convert.ToString(dataReader["PROVINCE"]); RegionInvoice.Text = Convert.ToString(dataReader["REGION"]); CountryInvoice.Text = Convert.ToString(dataReader["STATE"]); ZipInvoice.Text = Convert.ToString(dataReader["ZIPCODE"]); LeadDays.Text = Convert.ToString(dataReader["ESTIMATEDDATEDAYS"]); Voip.Text = dataReader["LINKFORVOIP"].ToString(); InterPrefix.Text = dataReader["INTERNATIONALPREFIX"].ToString(); long kbc = (int)dataReader["DISKSPACE"]; long kbo = 0; try { kbo = Convert.ToInt64(DatabaseConnection.SqlScalar("SELECT FOLDERSIZE FROM FOLDERSIZE")) / 1024 / 1024; } catch { } string pathTemplate; pathTemplate = ConfigSettings.DataStoragePath; string idxPath = Path.Combine(pathTemplate, "luceneIdx"); int idxSize = 0; int fileCount = 0; if (Directory.Exists(idxPath)) { LuceneParser lucene = new LuceneParser(idxPath); DirectoryInfo di = new DirectoryInfo(idxPath); foreach (FileInfo fi in di.GetFiles()) { idxSize += (int)(fi.Length / 1024); fileCount++; } FileIndexes.Text = lucene.checkIndex() + ", " + idxSize + " Kb"; } else { FileIndexes.Text = "n/a"; } PermittedKb.Text = dataReader["DiskSpace"].ToString() + " Mb"; BusyKb.Text = fileCount + " files, " + kbo.ToString() + " Mb"; if (kbo > kbc) { BusyKb.ForeColor = Color.Red; } if (dataReader["IDAgenda"] != DBNull.Value) { CompanyTextboxID.Text = Convert.ToString(dataReader["IDAGENDA"]); CompanyTextbox.Text = DatabaseConnection.SqlScalar("SELECT COMPANYNAME FROM BASE_COMPANIES WHERE ID=" + uint.Parse(dataReader["IDAgenda"].ToString())); } WebService_pin.Text = dataReader["pin"].ToString(); WebService_guid.Text = dataReader["guid"].ToString(); WebService_OwnerID.Text = dataReader["DefaultWebUser"].ToString(); if (WebService_OwnerID.Text.Length > 0) { WebService_Owner.Text = DatabaseConnection.SqlScalar("SELECT ISNULL(NAME,'')+' '+ISNULL(SURNAME,'') AS CONTACT FROM ACCOUNT WHERE UID=" + int.Parse(WebService_OwnerID.Text)); } else { DataRow dr; dr = DatabaseConnection.CreateDataset("SELECT TOP 1 ISNULL(NAME,'')+' '+ISNULL(SURNAME,'') AS CONTACT,UID FROM ACCOUNT LEFT OUTER JOIN TUSTENA_DATA ON TUSTENA_DATA.ADMINGROUPID=ACCOUNT.GROUPID ORDER BY UID").Tables[0].Rows[0]; WebService_Owner.Text = dr["contact"].ToString(); WebService_OwnerID.Text = dr["uid"].ToString(); } WebGate_OwnerID.Text = dataReader["WEBGATEOWNERID"].ToString(); WebGate_Owner.Text = dataReader["WEBGATEOWNER"].ToString(); WebGate_GroupID.Text = dataReader["WEBGATEGROUP"].ToString(); WebGate_Group.Text = dataReader["WEBGATEGROUPDESCRIPTION"].ToString(); WebGate_NotifyID.Text = dataReader["WEBGATENOTIFYID"].ToString(); WebGate_Notify.Text = dataReader["WEBGATENOTIFY"].ToString(); WebGate_WebSite.Text = dataReader["WEBGATEWEBSITE"].ToString(); string pathTemplateLogo; pathTemplateLogo = ConfigSettings.DataStoragePath + "\\logos"; FileFunctions.CheckDir(pathTemplateLogo, true); DirectoryInfo dirInfo = new DirectoryInfo(pathTemplateLogo); FileInfo[] files = dirInfo.GetFiles(); int select = 0; int counter = 0; checkLogo.Items.Add("No Logo"); if (files.Length > 0) { foreach (FileInfo f in files) { checkLogo.Items.Add(f.Name); counter++; if (dataReader["LOGO"] != System.DBNull.Value && dataReader["LOGO"].ToString() == f.Name) { select = counter; } } } checkLogo.Items[select].Selected = true; } dataReader.Close(); bool ws = false; if (WebService_pin.Text.Length == 0) { Random R = new Random(); WebService_pin.Text = R.Next(30000).ToString(); ws = true; } if (WebService_guid.Text.Length == 0) { WebService_guid.Text = Guid.NewGuid().ToString(); ws = true; } string wsGuid = DatabaseConnection.FilterInjection(WebService_guid.Text); string wsPin = DatabaseConnection.FilterInjection(WebService_pin.Text); if (ws) { DatabaseConnection.DoCommand(String.Format("UPDATE TUSTENA_DATA SET GUID='{0}',PIN='{1}'", wsGuid, wsPin)); } }
public void btn_Click(object sender, EventArgs e) { switch (((LinkButton)sender).ID) { case "LbnSubmit": if (this.inputFile.HasFile) { SaveFile(this.inputFile); } else { if (FileID.Text != "-1") { SaveFile(this.inputFile); } else { Info.Text = "<img src=\"/i/alert.gif\"> " + Root.rm.GetString("Dsttxt23"); } } break; case "LbnNew": InitProgressBar(); NewFile(); break; case "BtnSearchText": if (searchType.Items[0].Selected) { TxtSearch.Text = StaticFunctions.RemoveSpecialChar(TxtSearch.Text); BuildRepeaterQuery(String.Format("(FILEMANAGER.FILENAME LIKE '%{0}%' OR FILEMANAGER.DESCRIPTION LIKE '%{0}%')", TxtSearch.Text)); } else { TxtSearch.Text = StaticFunctions.RemoveSpecialChar(TxtSearch.Text); string pathTemplate; pathTemplate = ConfigSettings.DataStoragePath; LuceneParser lucene = new LuceneParser(Path.Combine(pathTemplate, "luceneIdx")); DataTable dt = new DataTable(); try { dt = lucene.search(TxtSearch.Text); } catch (IndexDamagedException) { lucene.addFolder(pathTemplate); } if (dt.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); foreach (DataRow dr in dt.Rows) { sb.AppendFormat(" OR FILEMANAGER.GUID = '{0}'", dr["title"]); } BuildRepeaterQuery(String.Format("({0})", sb.ToString().Substring(4))); } } break; } }