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;
}
}
