public string insertTable(tables newTable, out Guid tableId
, string tag = "")
{
string ret;
newTable.tableId = getNewId("tables", tag);
tableId = newTable.tableId;
ret = tableL.Insert(newTable);
return(ret);
}
public bool isDataTableExisted(string tableName)
{
bool ret = false;
tables tbl = tableL.TableByName(tableName);
if (tbl != null)
{
ret = true;
}
// isDataTableExisted
return(ret);
}
public List <string[]> Get(tables table, string where = "")
{
//var db = new Repository(); //Stare repo
var db = new RepositoryAdapter(_path); //Nowe repo
//var result = db.ExecuteReader(_path, $"SELECT * FROM [{table.ToString()}] {where}"); //Stara metoda.
var result = db.ExecuteReader($"SELECT * FROM [{table.ToString()}] {where}"); //Nowa metoda
switch (table)
{
case tables.Customers:
foreach (var item in result)
{
item[0] = $"ID: {item[0]}";
item[1] = $"Nazwa1: {item[1]}";
item[2] = $"Nazwa2: {item[2]}";
item[3] = $"Numer: {item[3]}";
}
break;
case tables.Services:
foreach (var item in result)
{
item[0] = $"ID: {item[0]}";
item[1] = $"Nazwa: {item[1]}";
item[2] = $"Typ: {item[2]}";
item[3] = $"Cena: {item[3]}";
}
break;
case tables.Transactions:
foreach (var item in result)
{
//string[] customer = db.ExecuteReader(_path, $"SELECT * FROM [{tables.Customers.ToString()}] where ID={item[1]}")[0];
//string[] service = db.ExecuteReader(_path, $"SELECT * FROM [{tables.Services.ToString()}] where ID={item[2]}")[0]; // Stare metody
string[] customer = db.ExecuteReader($"SELECT * FROM [{tables.Customers.ToString()}] where ID={item[1]}")[0];
string[] service = db.ExecuteReader($"SELECT * FROM [{tables.Services.ToString()}] where ID={item[2]}")[0]; // Nowe metody.
item[0] = $"ID: {item[0]}";
item[1] = $"Klient: {String.Join("*", customer)}";
item[2] = $"Usługa: {String.Join("*", service)}";
item[3] = $"Data: " + item[3];
item[4] = $"Kto: " + item[4];
}
break;
default:
break;
}
return(result);
}
public string Add(tables table, string[] one)
{
if (one[0] == "")
{
return("Nie dodano - nieprawidłowe dane!");
}
//var db = new Repository(); //Stare repo
var db = new RepositoryAdapter(_path); //Nowe repo
var sql = new List <string>();
switch (table)
{
case tables.Customers:
if (Get(table, $" where Name='{one[0]}' and LastName='{one[1]}' and Number={one[2]}").Count > 0)
{
return("Klient istnieje w bazie!");
}
sql.Add($"Insert into [{table.ToString()}] (Name, LastName, Number) Values ('{one[0]}','{one[1]}',{one[2]})");
//db.ExecuteNonQuery(_path, sql); //Stara metoda
db.ExecuteNonQuery(sql); //Nowa metoda
return("Dodano");
case tables.Services:
if (Get(table, $" where Name='{one[0]}' and Type='{one[1]}' and Price={one[2]}").Count > 0)
{
return("Usługa istnieje w bazie!");
}
sql.Add($"Insert into [{table.ToString()}] (Name, Type, Price) Values ('{one[0]}','{one[1]}',{one[2]})");
//db.ExecuteNonQuery(_path, sql); //Stara metoda
db.ExecuteNonQuery(sql); //Nowa metoda
return("Dodano");
case tables.Transactions:
if (Get(tables.Customers, $" where ID={one[0]}").Count > 0 && Get(tables.Services, $" where ID={one[1]}").Count > 0)
{
sql.Add($"Insert into [{table.ToString()}] (CustomerID, ServiceID, Date, User) Values ({one[0]},{one[1]},'{one[2]}','{one[3]}')");
//db.ExecuteNonQuery(_path, sql); //Stara metoda
db.ExecuteNonQuery(sql); //Nowa metoda
return("Dodano");
}
else
{
return("Nie dodano, błędne ID klienta lub usługi!");
}
default:
return("Nie dodano - błędny typ tabeli!");
}
}
static void Main(string[] args)
{
int i = 0;
int ii = 0;
int iii = 0;
char c = ' ';
tables table1 = new tables(26, 3, 8, "table1:");
for (i = 0; i < table1.rrows.Length; i++)
{
c = Convert.ToChar(i + 65);
for (ii = 0; ii < table1.rrows[0].cols.Length; ii++)
{
table1.rrows[i].cols[ii] = " " + c + "," + Convert.ToString(ii);
}
}
table1.report();
}
public string Add(tables table, string[] one)
{
if (one[0] == "")
{
return("Nie dodano - nieprawidłowe dane!");
}
var s = new StringBuilder();
var lastIndex = File.ReadAllLines(_path).Count();
switch (table)
{
case tables.Customers:
if (Get(table, $"{one[0]};{one[1]};{one[2]}").Count > 0)
{
return("Klient istnieje w bazie!");
}
break;
case tables.Services:
if (Get(table, $"{one[0]};{one[1]};{one[2]}").Count > 0)
{
return("Usługa istnieje w bazie!");
}
break;
case tables.Transactions:
if (Get(tables.Customers, $"{tables.Customers};{one[0]}").Count == 0 && Get(tables.Services, $"{tables.Services};{one[1]}").Count == 0)
{
return("Nie dodano, błędne ID klienta lub usługi!");
}
break;
default:
return("Nie dodano - błędny typ tabeli!");
}
s.Append($"\r\n{table.ToString()};{lastIndex};");
foreach (var item in one)
{
s.Append(item).Append(";");
}
File.AppendAllText(_path, s.ToString());
return("Dodano");
}
public string deleteTable(string tableName)
{
string ret = "";
tables tbl = tableL.TableByName(tableName);
if (tbl == null)
{
return(ret);
}
List <rows> rows = rowL.RowsByTableId(tbl.tableId);
foreach (rows rec in rows)
{
List <fieldValues> fieldValues = fieldValueL.FieldValueByRowId(rec.rowId);
foreach (fieldValues rec2 in fieldValues)
{
fieldValueL.Delete(rec2);
}
rowL.Delete(rec);
}
tableL.Delete(tbl);
return(ret);
}
static void Main(string[] args)
{
int i = 0;
int ii = 0;
int iii = 0;
double d = 0.00f;
double dd = 0.00f;
char c = ' ';
tables table1 = new tables(12, 5, 8, "table1:");
for (i = 0; i < table1.rrows.Length; i++)
{
table1.rrows[i].cols[0] = Convert.ToString(i);
d = Convert.ToDouble(i) * (360.00f / table1.rrows.Length);
table1.rrows[i].cols[1] = d.ToString("F1");
d = Math.Cos(Convert.ToDouble(i) / ((table1.rrows.Length) / 2.00f) * Math.PI);
table1.rrows[i].cols[2] = d.ToString("F6");
d = Math.Sin(Convert.ToDouble(i) / ((table1.rrows.Length) / 2.00f) * Math.PI);
table1.rrows[i].cols[3] = d.ToString("F6");
d = Math.Tan(Convert.ToDouble(i) / ((table1.rrows.Length) / 2.00f) * Math.PI);
table1.rrows[i].cols[4] = d.ToString("F6");
}
table1.report();
}
//protected string deleteDataTable(DataTable dt)
//{
// string ret = "";
// string tableName = DataTableName(dt);
// return ret;
//}
public string ImportDataTableSaveas(DataTable dt
, string saveAsNewTablename = "", bool append = false)
{
string ret = "";
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 1");
if (saveAsNewTablename == "")
{
saveAsNewTablename = DataTableName(dt);
}
// import datatable save as new table
// if new table existed, append false to overwrite
// delete target table
if (!append)
{
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 2b");
dbBig.deleteTag(saveAsNewTablename);
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 2");
dbBig.deleteTable(saveAsNewTablename);
}
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 3");
// write to tables
tables tbl = new tables();
tbl.tableName = saveAsNewTablename;
Guid tableId;
ret = dbBig.insertTable(tbl, out tableId,
saveAsNewTablename);
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 4");
// write to fields
List <string> colNames = DataTableColumnNames(dt);
List <string> colTypes = DataTableColumnTypes(dt);
Dictionary <string, Guid> name2id = new Dictionary <string, Guid>();
for (int i = 0; i < colNames.Count && i < colTypes.Count; i++)
{
fields fld = new fields();
fld.fieldName = colNames[i];
fld.fieldDesc = colTypes[i];
fld.tableId = tableId;
fld.defaultOrder = i + 1;
Guid fieldId = Guid.Empty;
ret = dbBig.insertField(fld, out fieldId,
saveAsNewTablename);
name2id.Add(fld.fieldName, fieldId);
//Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 5 i="+i);
}
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 6");
List <Dictionary <string, string> > dtCells =
DataTableCellValue(dt);
int j = 0;
foreach (Dictionary <string, string> rowCols in dtCells)
{
// write to rows
Guid rowId = Guid.Empty;
rows rw = new rows();
rw.tableId = tableId;
ret = dbBig.insertRow(rw, out rowId,
saveAsNewTablename);
if (++j % 10000 == 0)
{
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") +
$" ImportDataTableSaveas 7 [{j}/{dtCells.Count}]");
}
// write to field values
foreach (KeyValuePair <string, string> pair in rowCols)
{
fieldValues fv = new fieldValues();
fv.rowId = rowId;
fv.fieldId = name2id[pair.Key];
fv.fieldValue = pair.Value;
ret = dbBig.insertFieldValue(fv);
}
}
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 8 end");
return(ret);
}
private void writetables()
{
tables table = new tables();
//set 1
table.IP_1 = ip_1.Text;
table.DOMAIN_1 = domain_1.Text;
table.USE_1 = use_1.Checked;
table.IP_2 = ip_2.Text;
table.DOMAIN_2 = domain_2.Text;
table.USE_2 = use_2.Checked;
table.IP_3 = ip_3.Text;
table.DOMAIN_3 = domain_3.Text;
table.USE_3 = use_3.Checked;
table.IP_4 = ip_4.Text;
table.DOMAIN_4 = domain_4.Text;
table.USE_4 = use_4.Checked;
table.IP_5 = ip_5.Text;
table.DOMAIN_5 = domain_5.Text;
table.USE_5 = use_5.Checked;
table.IP_6 = ip_6.Text;
table.DOMAIN_6 = domain_6.Text;
table.USE_6 = use_6.Checked;
table.IP_7 = ip_7.Text;
table.DOMAIN_7 = domain_7.Text;
table.USE_7 = use_7.Checked;
table.IP_8 = ip_8.Text;
table.DOMAIN_8 = domain_8.Text;
table.USE_8 = use_8.Checked;
table.IP_9 = ip_9.Text;
table.DOMAIN_9 = domain_9.Text;
table.USE_9 = use_9.Checked;
table.IP_10 = ip_10.Text;
table.DOMAIN_10 = domain_10.Text;
table.USE_10 = use_10.Checked;
table.IP_11 = ip_11.Text;
table.DOMAIN_11 = domain_11.Text;
table.USE_11 = use_11.Checked;
table.IP_12 = ip_12.Text;
table.DOMAIN_12 = domain_12.Text;
table.USE_12 = use_12.Checked;
table.IP_13 = ip_13.Text;
table.DOMAIN_13 = domain_13.Text;
table.USE_13 = use_13.Checked;
table.IP_14 = ip_14.Text;
table.DOMAIN_14 = domain_14.Text;
table.USE_14 = use_14.Checked;
table.IP_15 = ip_15.Text;
table.DOMAIN_15 = domain_15.Text;
table.USE_15 = use_15.Checked;
table.IP_16 = ip_16.Text;
table.DOMAIN_16 = domain_16.Text;
table.USE_16 = use_16.Checked;
table.IP_17 = ip_17.Text;
table.DOMAIN_17 = domain_17.Text;
table.USE_17 = use_17.Checked;
table.IP_18 = ip_18.Text;
table.DOMAIN_18 = domain_18.Text;
table.USE_18 = use_18.Checked;
table.IP_19 = ip_19.Text;
table.DOMAIN_19 = domain_19.Text;
table.USE_19 = use_19.Checked;
table.IP_20 = ip_20.Text;
table.DOMAIN_20 = domain_20.Text;
table.USE_20 = use_20.Checked;
table.IP_21 = ip_21.Text;
table.DOMAIN_21 = domain_21.Text;
table.USE_21 = use_21.Checked;
table.IP_22 = ip_22.Text;
table.DOMAIN_22 = domain_22.Text;
table.USE_22 = use_22.Checked;
table.IP_23 = ip_23.Text;
table.DOMAIN_23 = domain_23.Text;
table.USE_23 = use_23.Checked;
table.IP_24 = ip_24.Text;
table.DOMAIN_24 = domain_24.Text;
table.USE_24 = use_24.Checked;
table.IP_25 = ip_25.Text;
table.DOMAIN_25 = domain_25.Text;
table.USE_25 = use_25.Checked;
//set 2
table.IP_101 = ip_101.Text;
table.DOMAIN_101 = domain_101.Text;
table.USE_101 = use_101.Checked;
table.IP_102 = ip_102.Text;
table.DOMAIN_102 = domain_102.Text;
table.USE_102 = use_102.Checked;
table.IP_103 = ip_103.Text;
table.DOMAIN_103 = domain_103.Text;
table.USE_103 = use_103.Checked;
table.IP_104 = ip_104.Text;
table.DOMAIN_104 = domain_104.Text;
table.USE_104 = use_104.Checked;
table.IP_105 = ip_105.Text;
table.DOMAIN_105 = domain_105.Text;
table.USE_105 = use_105.Checked;
table.IP_106 = ip_106.Text;
table.DOMAIN_106 = domain_106.Text;
table.USE_106 = use_106.Checked;
table.IP_107 = ip_107.Text;
table.DOMAIN_107 = domain_107.Text;
table.USE_107 = use_107.Checked;
table.IP_108 = ip_108.Text;
table.DOMAIN_108 = domain_108.Text;
table.USE_108 = use_108.Checked;
table.IP_109 = ip_109.Text;
table.DOMAIN_109 = domain_109.Text;
table.USE_109 = use_109.Checked;
table.IP_110 = ip_110.Text;
table.DOMAIN_110 = domain_110.Text;
table.USE_110 = use_110.Checked;
table.IP_111 = ip_111.Text;
table.DOMAIN_111 = domain_111.Text;
table.USE_111 = use_111.Checked;
table.IP_112 = ip_112.Text;
table.DOMAIN_112 = domain_112.Text;
table.USE_112 = use_112.Checked;
table.IP_113 = ip_113.Text;
table.DOMAIN_113 = domain_113.Text;
table.USE_113 = use_113.Checked;
table.IP_114 = ip_114.Text;
table.DOMAIN_114 = domain_114.Text;
table.USE_114 = use_114.Checked;
table.IP_115 = ip_115.Text;
table.DOMAIN_115 = domain_115.Text;
table.USE_115 = use_115.Checked;
table.IP_116 = ip_116.Text;
table.DOMAIN_116 = domain_116.Text;
table.USE_116 = use_116.Checked;
table.IP_117 = ip_117.Text;
table.DOMAIN_117 = domain_117.Text;
table.USE_117 = use_117.Checked;
table.IP_118 = ip_118.Text;
table.DOMAIN_118 = domain_118.Text;
table.USE_118 = use_118.Checked;
table.IP_119 = ip_119.Text;
table.DOMAIN_119 = domain_119.Text;
table.USE_119 = use_119.Checked;
table.IP_120 = ip_120.Text;
table.DOMAIN_120 = domain_120.Text;
table.USE_120 = use_120.Checked;
table.IP_121 = ip_121.Text;
table.DOMAIN_121 = domain_121.Text;
table.USE_121 = use_121.Checked;
table.IP_122 = ip_122.Text;
table.DOMAIN_122 = domain_122.Text;
table.USE_122 = use_122.Checked;
table.IP_123 = ip_123.Text;
table.DOMAIN_123 = domain_123.Text;
table.USE_123 = use_123.Checked;
table.IP_124 = ip_124.Text;
table.DOMAIN_124 = domain_124.Text;
table.USE_124 = use_124.Checked;
table.IP_125 = ip_125.Text;
table.DOMAIN_125 = domain_125.Text;
table.USE_125 = use_125.Checked;
XmlSerializer xs = new XmlSerializer(typeof(tables));
using (FileStream fs = new FileStream(filename.Text + ".xml", FileMode.Create))
{
xs.Serialize(fs, table);
}
MessageBox.Show("Tables have been saved to local directory", "System.IO", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public tableEditViewModel()
{
editModel = new tables();
}
public List <string[]> Get(tables table, string where = "")
{
var temp = File.ReadAllLines(_path).ToList();
var result = new List <string[]>();
if (where != "")
{
var one = temp.Where(a => a.Contains(table.ToString()) && a.Contains(where)).FirstOrDefault();
if (one != null)
{
result.Add(one.Split(';'));
}
return(result);
}
switch (table)
{
case tables.Customers:
var customers = temp.Where(a => a.StartsWith(table.ToString())).ToList();
foreach (var item in customers)
{
string[] tempArr = item.Split(';');
if (tempArr.Length > 4)
{
result.Add(new string[]
{
$"ID: {tempArr[1]}",
$"Nazwa1: {tempArr[2]}",
$"Nazwa2: {tempArr[3]}",
$"Numer: {tempArr[4]}"
});
}
}
break;
case tables.Services:
var services = temp.Where(a => a.StartsWith(table.ToString())).ToList();
foreach (var item in services)
{
string[] tempArr = item.Split(';');
if (tempArr.Length > 4)
{
result.Add(new string[]
{
$"ID: {tempArr[1]}",
$"Nazwa: {tempArr[2]}",
$"Typ: {tempArr[3]}",
$"Cena: {tempArr[4]}"
});
}
}
break;
case tables.Transactions:
var transactions = temp.Where(a => a.StartsWith(table.ToString())).ToList();
foreach (var item in transactions)
{
string[] tempArr = item.Split(';');
var customer = temp.Where(a => a.StartsWith($"{tables.Customers.ToString()};{tempArr[2]}")).FirstOrDefault().Split(';');
var service = temp.Where(a => a.StartsWith($"{tables.Services.ToString()};{tempArr[3]}")).FirstOrDefault().Split(';');
customer[0] = ""; //Czyszczenie niepotrzebnych wiadomości
service[0] = "";
if (tempArr.Length > 5)
{
result.Add(new string[]
{
$"ID: {tempArr[1]}",
$"Klient: {String.Join("*", customer)}",
$"Usługa: {String.Join("*", service)}",
$"Data: {tempArr[4]}",
$"Kto: {tempArr[5]}"
});
}
}
break;
default:
break;
}
return(result);
}
//public ServiceOutput getAgricastServiceData(string strToken, string xmlFeatureRequest, string strServiceID, string strModuleIDs, DateTime dStartDate, DateTime dEndDate, string strCultureCode)
public ServiceOutput getAgricastServiceData(string strToken, string xmlFeatureRequest, string strServiceID, string strModuleIDs, string dStartDate, string dEndDate, string strCultureCode, string strUnit)
{
//HttpContext.Current.Session["MySessionState"] = "Try";
WebServicePresenter objWebSvcPre = new WebServicePresenter(this);
xmlFeatureRequest = HttpUtility.UrlDecode(xmlFeatureRequest);
xmlFeatureRequest = HttpUtility.HtmlDecode(xmlFeatureRequest);
DTOIcon objParam = new DTOIcon();
DataSet ds = new DataSet();
InitialiseOutput();
/*** Used for Testing Webservice*/
#region TestData
//strToken = "agricast";
//xmlFeatureRequest = "<FeatureRequest><Latitude>47.5</Latitude><Longitude>7.5</Longitude><Altitude>500</Altitude><MaxAltitudeDiff>200</MaxAltitudeDiff><MaxDistanceDiff>450</MaxDistanceDiff></FeatureRequest>";
//strServiceID = "glbsip02o";
//strModuleIDs = "vew_daily";
//dStartDate = System.DateTime.Today.AddDays(-15).ToShortDateString();
//dEndDate = System.DateTime.Today.AddDays(-11).ToShortDateString();
//strCultureCode = "en-GB";
//strUnit = "metric";
#endregion
/****End of Test Data****/
/* IM01770145:New Agricast - AgricastService.svc - remove default token - Modify by Infosys-20140402-start*/
//if (HttpUtility.HtmlDecode(strToken).ToLower() != "agricast")
// return so;
strToken = HttpUtility.HtmlDecode(strToken);
// check if the token is valid
var validToken = Roles.FindUsersInRole(strServiceID, strToken);
if (validToken.Length == 0)
return so;
/* IM01770145:New Agricast - AgricastService.svc - remove default token - Modify by Infosys-20140402-end*/
//Deserialization of the XML file
try
{
XmlDocument xdoc = new XmlDocument();
xdoc.LoadXml(xmlFeatureRequest);
XmlSerializer xSerializer = new XmlSerializer(typeof(FeatureRequest));
System.IO.StringReader rdr = new StringReader(xmlFeatureRequest);
objFR = (FeatureRequest)xSerializer.Deserialize(rdr);
int iResultCount = 10;
string timezone = objWebSvcPre.getTimeZoneOffset(objFR.Latitude, objFR.Longitude, (int)objFR.MaxDistanceDiff, (int)objFR.Altitude, iResultCount).ToString();
string sunrise = objWebSvcPre.getSunrise(DateTime.Now.Date, objFR.Latitude, objFR.Longitude).ToString();
string sunset = objWebSvcPre.getSunset(DateTime.Now.Date, objFR.Latitude, objFR.Longitude).ToString();
Response res = new Response();
res.FeatureRequest = objFR;
res.Sunrise = sunrise;
res.Sunset = sunset;
res.TimeZoneOffset = timezone;
so.FeatureResponse = res;
DataTable dt = objWebSvcPre.getNeabyStations(objFR.Latitude, objFR.Longitude, (int)objFR.MaxDistanceDiff, (int)objFR.Altitude, iResultCount, HttpUtility.HtmlDecode(strCultureCode));
stnDet.Name = dt.Rows[0]["Name"].ToString();
stnDet.Altitude = Int32.Parse(dt.Rows[0]["Altitude"].ToString());
stnDet.BearingDegrees = double.Parse(dt.Rows[0]["BearingDegrees"].ToString());
stnDet.Distance = double.Parse(dt.Rows[0]["DistanceKm"].ToString());
stnDet.Latitude = double.Parse(dt.Rows[0]["Latitude"].ToString());
stnDet.Longitude = double.Parse(dt.Rows[0]["Longitude"].ToString());
res.StationDetails = stnDet;
objWebSvcPre.setServiceHandlerWebServiceValues(HttpUtility.HtmlDecode(strServiceID), "");
DataTable dtNodes = objWebSvcPre.getNodeList(HttpUtility.HtmlDecode(strModuleIDs));
/*Unit Implementation in Web Services - Begin*/
if (string.IsNullOrEmpty(strUnit) || !strUnit.ToLower().Contains("imperial"))
/*Unit Implementation in Web Services - End*/
strUnit = "metric";
for (int i = 0; i < dtNodes.Rows.Count; i++)
{
switch (dtNodes.Rows[i]["Node"].ToString())
{
case "chart":
chart = new Chart();
DataTable dtChartData = new DataTable();
/*Unit Implementation in Web Services - Begin*/
dtChartData = objWebSvcPre.getChartData(stnDet.Latitude, stnDet.Longitude, (int)stnDet.Altitude, (int)objFR.MaxAltitudeDiff, (int)objFR.MaxDistanceDiff, dtNodes.Rows[i]["ModuleName"].ToString(), strServiceID, strCultureCode, strUnit);
/*Unit Implementation in Web Services - End*/
chart.ChartUrl = dtChartData.Rows[0][1].ToString();
chart.ModuleID = dtChartData.Rows[0][0].ToString();
so.Charts.Add(chart);
break;
case "icon":
icon = new Icons();
objWebSvcPre.setIconWebServiceValues(stnDet.Latitude, stnDet.Longitude, (int)stnDet.Altitude, (int)objFR.MaxAltitudeDiff, (int)objFR.MaxDistanceDiff, Convert.ToDateTime(sunrise), Convert.ToDateTime(sunset), strServiceID, dtNodes.Rows[i]["ModuleName"].ToString(), strCultureCode);
icon.ModuleID = dtNodes.Rows[i][1].ToString();
icon.IconList = objWebSvcPre.getWeatherIcons(objParam, dtNodes.Rows[i]["NodeName"].ToString());
so.Icons.Add(icon);
break;
case "tblDaysRows":
tbls = new tables();
tbls.tableList = new List<table>();
tbls.ModuleID = dtNodes.Rows[i][1].ToString();
tbls.tableList = objWebSvcPre.getTableData(stnDet.Latitude, stnDet.Longitude, (int)stnDet.Altitude, (int)objFR.MaxDistanceDiff, (int)objFR.MaxAltitudeDiff, this, dtNodes.Rows[i]["Node"].ToString(), dtNodes.Rows[i]["NodeName"].ToString(), strCultureCode, strServiceID, dtNodes.Rows[i]["ModuleName"].ToString(), HttpUtility.HtmlDecode(strCultureCode), strUnit);
so.tables.Add(tbls);
break;
case "tblSeriesRows":
tbls = new tables();
tbls.tableList = new List<table>();
tbls.ModuleID = dtNodes.Rows[i][1].ToString();
tbls.tableList = objWebSvcPre.getTableData(stnDet.Latitude, stnDet.Longitude, (int)stnDet.Altitude, (int)objFR.MaxDistanceDiff, (int)objFR.MaxAltitudeDiff, this, dtNodes.Rows[i]["Node"].ToString(), dtNodes.Rows[i]["NodeName"].ToString(), strCultureCode, strServiceID, dtNodes.Rows[i]["ModuleName"].ToString(), HttpUtility.HtmlDecode(strCultureCode), strUnit);
so.tables.Add(tbls);
break;
//case "nearbyDataPoint":
// ds.Tables.Add(objWebSvcPre.getNeabyStations(objFR.Latitude, objFR.Longitude, (int)objFR.MaxDistanceDiff, (int)objFR.Altitude, iResultCount, HttpUtility.HtmlDecode(strCultureCode)));
// ds.AcceptChanges();
// break;
case "legend":
legs = new Legend();
legs = objWebSvcPre.getLegendData(dtNodes.Rows[i]["NodeName"].ToString());
so.Legends.Add(legs);
break;
}
}
}
catch (Exception ex)
{
AgriCastException currEx = new AgriCastException(objWebSvcPre.GetServiceDetails(), ex);
AgriCastLogger.Publish(currEx, AgriCastLogger.LogType.Error);
// HttpContext.Current.Session["ErrorMessage"] = objComUtil.getTransText(Constants.WS_GETSVCDATA_FAILURE) + " : " + ex.Message.ToString();
}
finally
{
IDictionary dictAudit = new Hashtable();
dictAudit["userIP"] = "";// HttpContext.Current.Request.UserHostAddress;
dictAudit["userID"] = "";
dictAudit["token"] = strToken;
dictAudit["referrer"] = "none";
/* IM01770145:New Agricast - AgricastService.svc - remove default token - Modify by Infosys-20140402-start*/
//dictAudit["entrancePath"] = "WebService";
dictAudit["entrancePath"] = "AgricastService - getAgricastServiceData";
/* IM01770145:New Agricast - AgricastService.svc - remove default token - Modify by Infosys-20140402-end*/
dictAudit["culture"] = HttpUtility.HtmlDecode(strCultureCode);
dictAudit["sessionID"] = "";// HttpContext.Current.Session.SessionID;
dictAudit["service"] = strServiceID;
dictAudit["module"] = strModuleIDs;
dictAudit["locSearchType"] = "";
dictAudit["locSearchStringType"] = "";
dictAudit["locSearchString"] = xmlFeatureRequest;
dictAudit["locSearchDatasource"] = "";
dictAudit["numOfLocs"] = 0;
if (objFR.Latitude == 0)
dictAudit["searchLat"] = DBNull.Value;
else
dictAudit["searchLat"] = objFR.Latitude;
if (objFR.Longitude == 0)
dictAudit["searchLong"] = DBNull.Value;
else
dictAudit["searchLong"] = objFR.Longitude;
dictAudit["countryName"] = "";
dictAudit["locName"] = "";
dictAudit["weatherDatasource"] = "";
dictAudit["weatherLat"] = DBNull.Value;
dictAudit["weatherLong"] = DBNull.Value;
dictAudit["weatherDateFrom"] = "";
dictAudit["weatherDateTo"] = "";
dictAudit["weatherSeries"] = "";
dictAudit["weatherParams"] = DBNull.Value;
objWebSvcPre.SaveServiceAuditData(dictAudit);
}
return so;
}
void Awake()
{
// dice = new Dice();
// gall = gameObject.AddComponent("gallery") as gallery;
tbl = new tables();
// fl = new newfaceloader();
// Debug.Log("Script started");
loadState();
}
