/// <summary>
/// Gets the document.
/// </summary>
/// <returns></returns>
protected virtual bool TryGetDocument(out SfDocument document)
{
LibrariesManager librariesManager = LibrariesManager.GetManager(this.ProviderName);
document = librariesManager.GetDocuments()
.Where(i => i.Id == this.Id)
.Where(PredefinedFilters.PublishedItemsFilter <SfDocument>())
.FirstOrDefault();
return(document != null);
}
public ActionResult SearchFiltered()
{
try
{
string _params = TempData["_params"].ToString();
JObject jObj = (JObject)JsonConvert.DeserializeObject(_params);
string filterName = jObj["filterName"].ToString();
string filterKey = jObj["filterKey"].ToString();
object[] args = JsonConvert.DeserializeObject <object[]>(jObj["args"].ToString());
_params = PredefinedFilters.CreateFilter(filterName, filterKey, args);
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
return(PartialView("ProceseView", new ProcesView(Convert.ToInt32(Session["CURENT_USER_ID"]), conStr, _params)));
}
catch
{
return(PartialView());
}
}
protected void btnFilterInfo_Click(object sender, EventArgs e)
{
if (lbxFilterListInfo.Items.Count > 0)
{
lbxFilterListInfo.Items.Clear();
PredefinedFilters predefFilt = new PredefinedFilters();
List <string> filter = predefFilt.getFilters(ddlPredefinedFilterSelection.SelectedIndex);
foreach (string element in filter)
{
lbxFilterListInfo.Items.Add(element);
}
}
else
{
PredefinedFilters predefFilt = new PredefinedFilters();
List <string> filter = predefFilt.getFilters(ddlPredefinedFilterSelection.SelectedIndex);
foreach (string element in filter)
{
lbxFilterListInfo.Items.Add(element);
}
}
}
/// <summary>
/// Gets the image.
/// </summary>
/// <returns></returns>
protected virtual SfImage GetImage()
{
var librariesManager = LibrariesManager.GetManager(this.ImageProviderName);
return(librariesManager.GetImages().Where(i => i.Id == this.ImageId).Where(PredefinedFilters.PublishedItemsFilter <SfImage>()).FirstOrDefault());
}
/// <summary>
/// Gets the image.
/// </summary>
/// <returns></returns>
protected virtual SfImage GetImage()
{
LibrariesManager librariesManager = LibrariesManager.GetManager(this.ProviderName);
return(librariesManager.GetImages().Where(i => i.Id == this.Id).Where(PredefinedFilters.PublishedItemsFilter <Telerik.Sitefinity.Libraries.Model.Image>()).FirstOrDefault());
}
protected void btnSearchButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
bool directionFlag = true;
bool customFlag = false;
string searchTerm = txtSearchBox.Text;
List <String> selected = new List <String>();
foreach (ListItem item in cblFilters.Items)
{
if (item.Selected)
{
selected.Add(item.Value);
if ((item.Value).All(char.IsDigit))
{
customFlag = true;
}
}
}
//Sql Connection info
MySql.Data.MySqlClient.MySqlConnection mysqlConnection = new MySql.Data.MySqlClient.MySqlConnection();
mysqlConnection.ConnectionString = "server=127.0.0.1;uid=root;pwd=Defense;database=Dietation";
try
{
mysqlConnection.Open();
string selectedProduct = "select FoodName, ";
//Gets all the predefined filters
for (int i = 0; i < selected.Count; i++)
{
if (!customFlag)
{
if (i == selected.Count - 1)
{
selectedProduct += selected[i] + " ";
}
else
{
selectedProduct += selected[i] + ", ";
}
}
else
{
//Get predefined and detects custom filters
if ((selected[i]).All(char.IsDigit))
{
selectedProduct.Substring(0, selectedProduct.Length - 2);
break;
}
else if (i == selected.Count - 1)
{
selectedProduct += selected[i] + " ";
}
else
{
selectedProduct += selected[i] + ", ";
}
}
}
//API call to FDA database
List <FDAFoodInfo> info = new SimpleAPIClass(searchTerm).getFoodInfo();
FDAFoodInfo topValue = info.ElementAt(0);
if (info == null)
{
Response.Redirect("UnknownResult.aspx");
}
selectedProduct += "from foodfilter where FoodName = \'" + topValue.foodName + "\'";
MySqlCommand cmd1 = new MySqlCommand(selectedProduct, mysqlConnection);
MySqlDataReader rdr = cmd1.ExecuteReader();
//Executes the database search
//No Custom Filter
if (!customFlag)
{
//Nothing in database
if (!rdr.HasRows)
{
//Load in classes, cls -> is a compare list on list
//Load prefilters holds the predefined filter values
CompareListsSearching cls = new CompareListsSearching();
PredefinedFilters preFilters = new PredefinedFilters();
//sqla commands that fill the database
SQLAccess sqla = new SQLAccess();
sqla.FillIngredients(topValue.foodName, topValue.foodIngredients);
sqla.FillPrefilters(topValue.foodName, topValue.foodBrand, topValue.foodIngredients);
//Sets session cookie to loginId
Session["ProductName"] = topValue.foodName;
//Compare predefined filters against ingredients of the product
foreach (string s in selected)
{
if (!cls.Compare(preFilters.getFilters(s), topValue.foodIngredients))
{
directionFlag = false;
break;
}
}
//If direction is false then its a negative value
if (directionFlag)
{
Response.Redirect("PositiveResult.aspx");
}
else
{
Response.Redirect("NegativeResult.aspx");
}
}
//Item detected in database
else if (rdr.HasRows)
{
//Reads
rdr.Read();
Session["ProductName"] = topValue.foodName;
//Looks through the database to see the if predefined filters values
//Equal 0 in any place, if so then return a false
foreach (string s in selected)
{
int flag = (int)rdr[s];
if (flag == 0)
{
directionFlag = false;
break;
}
}
if (directionFlag)
{
Response.Redirect("PositiveResult.aspx");
}
else
{
Response.Redirect("NegativeResult.aspx");
}
}
}
//Custom Filters
else
{
if (!rdr.HasRows)
{
//Future Feature have a list of items for the customer to choose from when searching
SQLAccess sqla = new SQLAccess();
sqla.FillIngredients(topValue.foodName, topValue.foodIngredients);
sqla.FillPrefilters(topValue.foodName, topValue.foodBrand, topValue.foodIngredients);
CompareListsSearching cls = new CompareListsSearching();
PredefinedFilters preFilters = new PredefinedFilters();
Session["ProductName"] = topValue.foodName;
foreach (string s in selected)
{
if (!cls.Compare(preFilters.getFilters(s), topValue.foodIngredients))
{
directionFlag = false;
break;
}
}
if (directionFlag)
{
List <List <String> > customFilters = new List <List <String> >();
foreach (ListItem item in cblFilters.Items)
{
switch (item.Value)
{
case "0":
CustomFilter cf1 = (CustomFilter)Session["CustomFilter1"];
customFilters.Add(cf1.Ingredients);
break;
case "1":
CustomFilter cf2 = (CustomFilter)Session["CustomFilter2"];
customFilters.Add(cf2.Ingredients);
break;
case "2":
CustomFilter cf3 = (CustomFilter)Session["CustomFilter3"];
customFilters.Add(cf3.Ingredients);
break;
}
}
foreach (List <String> ls in customFilters)
{
if (!cls.Compare(ls, topValue.foodIngredients))
{
directionFlag = false;
break;
}
}
}
if (directionFlag)
{
Response.Redirect("PositiveResult.aspx");
}
else
{
Response.Redirect("NegativeResult.aspx");
}
}
else if (rdr.HasRows)
{
rdr.Read();
Session["ProductName"] = topValue.foodName;
foreach (string s in selected)
{
int flag = (int)rdr[s];
if (flag == 0)
{
directionFlag = false;
break;
}
}
//If predefined filters through back false, why should the program
//search the custom filters?
if (directionFlag)
{
//Searchs the custom filters
List <List <String> > customFilters = new List <List <String> >();
foreach (ListItem item in cblFilters.Items)
{
switch (item.Value)
{
case "0":
CustomFilter cf1 = (CustomFilter)Session["CustomFilter1"];
customFilters.Add(cf1.Ingredients);
break;
case "1":
CustomFilter cf2 = (CustomFilter)Session["CustomFilter2"];
customFilters.Add(cf2.Ingredients);
break;
case "2":
CustomFilter cf3 = (CustomFilter)Session["CustomFilter3"];
customFilters.Add(cf3.Ingredients);
break;
}
}
SQLAccess sqla = new SQLAccess();
List <String> ingredients = new List <String>();
sqla.GetIngredients(rdr[selected[0]].ToString(), ingredients);
CompareListsSearching cls = new CompareListsSearching();
foreach (List <String> ls in customFilters)
{
if (!cls.Compare(ls, ingredients))
{
directionFlag = false;
break;
}
}
}
if (directionFlag)
{
Response.Redirect("PositiveResult.aspx");
}
else
{
Response.Redirect("NegativeResult.aspx");
}
}
}
}
catch (ThreadAbortException except)
{
Console.WriteLine("Exception ThreadAborted: {0}", except.Message);
}
catch
{
Response.Redirect("UnknownResult.aspx");
}
finally
{
mysqlConnection.Close();
}
}
}
public static SfImage GetImage(Guid imageId, string imageProviderName)
{
var librariesManager = LibrariesManager.GetManager(imageProviderName);
return(librariesManager.GetImages().Where(i => i.Id == imageId).Where(PredefinedFilters.PublishedItemsFilter <SfImage>()).FirstOrDefault());
}
public void ExportDosareToExcel(string _sort, string _order, string _filter, string _limit)
{
try
{
JObject jObj = (JObject)JsonConvert.DeserializeObject(_filter);
string filterName = jObj["filterName"].ToString();
string filterKey = jObj["filterKey"].ToString();
object[] args = JsonConvert.DeserializeObject <object[]>(jObj["args"].ToString());
_filter = PredefinedFilters.CreateFilter(filterName, filterKey, args);
}
catch { }
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]);
DosareRepository dr = new DosareRepository(_CURENT_USER_ID, conStr);
//Dosar[] dosare = (Dosar[])dr.GetFiltered(null, null, String.Format(" DOSARE.DATA_SCA = '{0}' AND DOSARE.ID_SOCIETATE_CASCO = '{1}' AND DOSARE.ID_SOCIETATE_RCA = '{2}' ", CommonFunctions.ToMySqlFormatDate(d), Convert.ToInt32(Session["ID_SOCIETATE"]), Convert.ToInt32(id_soc_rca)), null).Result;
Dosar[] dosare = (Dosar[])dr.GetFiltered(_sort, _order, _filter, _limit).Result;
DataTable table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(dosare, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = SOCISA.CommonFunctions.DATE_FORMAT
}), (typeof(DataTable)));
List <string> columns_to_remove = new List <string>();
foreach (DataColumn dc in table.Columns)
{
if (
!dc.ColumnName.ToLower().Equals("id") &&
!dc.ColumnName.ToLower().Contains("nr_dosar_casco") &&
!dc.ColumnName.ToLower().Contains("nr_sca") &&
!dc.ColumnName.ToLower().Contains("data_sca") &&
!dc.ColumnName.ToLower().Contains("nr_polita_casco") &&
!dc.ColumnName.ToLower().Contains("nr_auto_casco") &&
!dc.ColumnName.ToLower().Contains("nr_polita_rca") &&
!dc.ColumnName.ToLower().Contains("nr_auto_rca") &&
!dc.ColumnName.ToLower().Contains("data_eveniment") &&
!dc.ColumnName.ToLower().Contains("valoare_regres") &&
!dc.ColumnName.ToLower().Contains("data_avizare")
)
{
columns_to_remove.Add(dc.ColumnName);
}
}
foreach (string col_name in columns_to_remove)
{
table.Columns.Remove(col_name);
}
DataColumn newdc = new DataColumn("ASIGURAT_CASCO", Type.GetType("System.String"));
table.Columns.Add(newdc);
newdc = new DataColumn("ASIGURATOR_RCA", Type.GetType("System.String"));
table.Columns.Add(newdc);
table.AcceptChanges();
foreach (DataRow drow in table.Rows)
{
try
{
Dosar dosar = new Dosar(_CURENT_USER_ID, conStr, Convert.ToInt32(drow["ID"]));
Asigurat aCasco = (Asigurat)dosar.GetAsiguratCasco().Result;
drow["ASIGURAT_CASCO"] = aCasco.DENUMIRE;
SocietateAsigurare sRca = (SocietateAsigurare)dosar.GetSocietateRca().Result;
drow["ASIGURATOR_RCA"] = sRca.DENUMIRE;
}
catch (Exception exp) { LogWriter.Log(exp); }
}
table.AcceptChanges();
using (ExcelPackage pack = new ExcelPackage())
{
ExcelWorksheet ws = pack.Workbook.Worksheets.Add("Dosare");
ws.Cells["A1"].LoadFromDataTable(table, true);
var ms = new System.IO.MemoryStream();
pack.SaveAs(ms);
Response.BinaryWrite(ms.GetBuffer());
}
}
public void ExportProceseToExcel(string _sort, string _order, string _filter, string _limit)
{
try
{
JObject jObj = (JObject)JsonConvert.DeserializeObject(_filter);
string filterName = jObj["filterName"].ToString();
string filterKey = jObj["filterKey"].ToString();
object[] args = JsonConvert.DeserializeObject <object[]>(jObj["args"].ToString());
_filter = PredefinedFilters.CreateFilter(filterName, filterKey, args);
}
catch { }
string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]);
ProceseRepository pr = new ProceseRepository(_CURENT_USER_ID, conStr);
Proces[] procese = (Proces[])pr.GetFiltered(_sort, _order, _filter, _limit).Result;
DataTable table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(procese, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = SOCISA.CommonFunctions.DATE_FORMAT
}), (typeof(DataTable)));
List <string> columns_to_remove = new List <string>();
foreach (DataColumn dc in table.Columns)
{
if (dc.ColumnName.ToLower().IndexOf("id") > -1)
{
columns_to_remove.Add(dc.ColumnName);
}
}
foreach (string col_name in columns_to_remove)
{
table.Columns.Remove(col_name);
}
// TO DO: add external fields !!!
/*
* DataColumn newdc = new DataColumn("ASIGURAT_CASCO", Type.GetType("System.String"));
* table.Columns.Add(newdc);
* newdc = new DataColumn("ASIGURATOR_RCA", Type.GetType("System.String"));
* table.Columns.Add(newdc);
* table.AcceptChanges();
*
* foreach (DataRow drow in table.Rows)
* {
* try
* {
* Dosar dosar = new Dosar(_CURENT_USER_ID, conStr, Convert.ToInt32(drow["ID"]));
* Asigurat aCasco = (Asigurat)dosar.GetAsiguratCasco().Result;
* drow["ASIGURAT_CASCO"] = aCasco.DENUMIRE;
* SocietateAsigurare sRca = (SocietateAsigurare)dosar.GetSocietateRca().Result;
* drow["ASIGURATOR_RCA"] = sRca.DENUMIRE;
* }
* catch (Exception exp) { LogWriter.Log(exp); }
* }
*/
table.AcceptChanges();
using (ExcelPackage pack = new ExcelPackage())
{
ExcelWorksheet ws = pack.Workbook.Worksheets.Add("Procese");
ws.Cells["A1"].LoadFromDataTable(table, true);
var ms = new System.IO.MemoryStream();
pack.SaveAs(ms);
Response.BinaryWrite(ms.GetBuffer());
}
}
