private System.Data.DataTable CreateDataTable()
{
var table = new CustomDataTable();
bool isFirst = true;
// without Linq
for (int i = 0; i < students.Count; i++)
{
var student = students[i];
if (isFirst)
{
table.Columns.Add(FIRST_NAME);
table.Columns.Add(LAST_NAME);
table.Columns.Add(NUMBER);
isFirst = false;
}
var dataRow = (CustomDataRow)table.NewRow();
dataRow.ItemArray = new string[] { student.FirstName, student.LastName, student.Number.ToString() };
dataRow.Tag = student;
table.Rows.Add(dataRow);
}
return(table);
}
protected DataTable CreateTable()
{
CustomDataTable table = new CustomDataTable();
table.Columns.Add("timeCol", typeof(DateTime));
return(table);
}
void Initialize()
{
if (!hasBeenInitizlied)
{
// check save data for previous language setting
if (SaveGame.GetHasSetLanguage())
{
currentLanguage = SaveGame.GetLanguage();
}
else
{
// check system language
switch (Application.systemLanguage)
{
case SystemLanguage.Arabic:
{
currentLanguage = Language.Arabic;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Arabic");
break;
}
case SystemLanguage.English:
{
currentLanguage = Language.English;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "English");
break;
}
//case SystemLanguage.Spanish:
// {
// currentLanguage = Language.Spanish;
// MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Spanish");
// break;
// }
case SystemLanguage.Romanian:
{
currentLanguage = Language.Romanian;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Romanian");
break;
}
default:
{
currentLanguage = Language.English;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Unknown");
break;
}
}
}
FileIO localizedTextFile = new FileIO("localizedText", "csv");
localizedDataTableObject = ReadCSV(localizedTextFile.GetFileText());
hasBeenInitizlied = true;
}
}
public CustomDataTable ReadCSV(string csvText)
{
CustomDataTable table = new CustomDataTable();
// collect column headers to use as languages
string[] lineArray = csvText.Split('\n');
List <string> columnHeaders = null;
for (int i = 0; i < lineArray.Length; i++)
{
string oneLine = lineArray[i];
oneLine = oneLine.TrimEnd();
string[] columnItemArray = oneLine.Split(',');
if (i == 0) // get the language column headers
{
columnHeaders = new List <string>(columnItemArray);
}
else
{
string rowHeader = columnItemArray[0];
for (int j = 1; j < columnItemArray.Length; j++) // start at 1 to skip row header
{
string contents = columnItemArray[j];
// replace escaped escape characters with literal escape characters
contents = contents.Replace("\\n", "\n");
contents = contents.Replace("*c*", ",");
// reverse order if language requires
if (columnHeaders[j] == "Arabic")
{
contents = ArabicSupport.ArabicFixer.Fix(contents);
}
table.AddEntry(columnHeaders[j], rowHeader, contents);
}
}
}
return(table);
}
public CustomDataTable ReadCSV(string csvText)
{
CustomDataTable table = new CustomDataTable();
// collect column headers to use as languages
string[] lineArray = csvText.Split('\n');
List<string> columnHeaders = null;
for (int i = 0; i < lineArray.Length; i++)
{
string oneLine = lineArray[i];
oneLine = oneLine.TrimEnd();
string[] columnItemArray = oneLine.Split(',');
if (i == 0) // get the language column headers
{
columnHeaders = new List<string>(columnItemArray);
}
else
{
string rowHeader = columnItemArray[0];
for (int j = 1; j < columnItemArray.Length; j++) // start at 1 to skip row header
{
string contents = columnItemArray[j];
// replace escaped escape characters with literal escape characters
contents = contents.Replace("\\n", "\n");
contents = contents.Replace("*c*", ",");
// reverse order if language requires
if (columnHeaders[j] == "Arabic")
{
contents = ArabicSupport.ArabicFixer.Fix(contents);
}
table.AddEntry(columnHeaders[j], rowHeader, contents);
}
}
}
return table;
}
private System.Data.DataTable CreateDataTable()
{
var table = new CustomDataTable();
bool isFirst = true;
// without Linq
for (int i = 0; i < students.Count; i++)
{
var student = students[i];
if (isFirst)
{
//table.Columns.Add(IN_CLASS, System.Type.GetType("System.Boolean"));
table.Columns.Add(IN_CLASS);
table.Columns.Add(FIRST_NAME);
table.Columns.Add(LAST_NAME);
table.Columns.Add(NUMBER);
isFirst = false;
}
//var dataRow = (CustomDataRow)table.NewRow();
//dataRow.ItemArray = new string[] { student.FirstName, student.LastName, student.Number.ToString() };
//dataRow.Tag = student;
//table.Rows.Add(dataRow);
var dataRow = (CustomDataRow)table.NewRow();
//dataRow["InClass"] = "true"; bu otomatik olarak checkbox u dataya bakmadan işaretli getiriyor.
dataRow["InClass"] = student.InClass; // bu haliyle jsondakini doğru okuyor.
dataRow["FirstName"] = student.FirstName;
dataRow["LastName"] = student.LastName;
dataRow["Number"] = student.Number;
dataRow.Tag = student;
table.Rows.Add(dataRow);
table.AcceptChanges();
}
return(table);
}
void Initialize()
{
if (!hasBeenInitizlied)
{
// check save data for previous language setting
if (SaveGame.GetHasSetLanguage())
{
currentLanguage = SaveGame.GetLanguage();
}
else
{
// check system language
switch (Application.systemLanguage)
{
case SystemLanguage.Arabic:
{
currentLanguage = Language.Arabic;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Arabic");
break;
}
case SystemLanguage.English:
{
currentLanguage = Language.English;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "English");
break;
}
//case SystemLanguage.Spanish:
// {
// currentLanguage = Language.Spanish;
// MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Spanish");
// break;
// }
case SystemLanguage.Romanian:
{
currentLanguage = Language.Romanian;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Romanian");
break;
}
default:
{
currentLanguage = Language.English;
MetricsLogger.Instance.LogCustomEvent("Settings", "SystemLanguageSet", "Unknown");
break;
}
}
}
FileIO localizedTextFile = new FileIO("localizedText", "csv");
localizedDataTableObject = ReadCSV(localizedTextFile.GetFileText());
hasBeenInitizlied = true;
}
}
public ActionResult Script(Int64 NetLayerId, Int64 SiteId, Int64[] EventTypeId, string[] EventValue, string[] BandReselection, string[] ScannerSelection, string[] ManufacturerSelection, string[] ScannerModelSelection, string[] OptionSelection, string[] OptionIdSelection, bool[] IsValue, bool[] IsL3Enabled, string[] Color, int[] SequenceId, int?SiteClusterId = 0, int?ScopeId = 0, string[] TestKPI = null, string[] SrId = null, string[] IsDeleted = null)
{
Response res = new Response();
try
{
dbDataTable dbtd = new dbDataTable();
CustomDataTable ctd = new CustomDataTable();
DataTable dt = dbtd.Script();
DataTable cs = dbtd.Script();
int counter = 1;
long LayerId = 0;
for (int i = 0; i < EventValue.Length; i++)
{
// bool contains = Sequences.Any(z => z == i || i==0);
//if(contains == true)
//{
// if (i == 0) counter = 1;
// else counter = i;
// myDataTable.AddRow(dt, "Value1", SiteId, "Value2", NetLayerId, "Value3", 0, "Value4", EventTypeId[i], "Value5", EventValue[i], "Value6", IsValue[i], "Value7", IsL3Enabled[i], "Value8", Color[i], "Value8", counter);
//}
//else
//{
if (IsL3Enabled[i])
{
myDataTable.AddRow(dt, "Value1", SiteId, "Value2", NetLayerId, "Value3", 0, "Value4", EventTypeId[i], "Value5", EventValue[i], "Value6", IsValue[i], "Value7", IsL3Enabled[i], "Value8", Color[i], "Value9", SequenceId[i], "Value10", BandReselection[i], "value11", TestKPI[i], "value12", i + 1, "value13", SrId[i], "value14", IsDeleted[i], "value15", (i + 1).ToString(), "value16", "", "value17", "", "value18", "", "value19", "", "value20", "", "value21", "", "value22", "", "value23", "", "value24", "", "value25", "");
}
else
{
myDataTable.AddRow(dt, "Value1", SiteId, "Value2", NetLayerId, "Value3", 0, "Value4", EventTypeId[i], "Value5", EventValue[i], "Value6", IsValue[i], "Value7", IsL3Enabled[i], "Value8", Color[i], "Value9", SequenceId[i], "Value10", BandReselection[i], "value11", "", "value12", i + 1, "value13", SrId[i], "value14", IsDeleted[i], "value15", ScannerSelection[i], "value16", ManufacturerSelection[i], "value17", ScannerModelSelection[i], "value18", OptionSelection[i], "value19", OptionIdSelection[i], "value20", "", "value21", "", "value22", "", "value23", "", "value24", "", "value25", "");
}
//}
}
AV_SiteScriptDL ssd = new AV_SiteScriptDL();
var scripts = ssd.Manage("Insert", dt);
if (SiteClusterId != 0)
{
myDataTable.AddRow(cs, "Value1", SiteId, "Value2", NetLayerId, "Value3", 0, "Value4", SiteClusterId, "Value5", NetLayerId, "Value6", ScopeId, "Value7", true);
for (int i = 0; i < SequenceId.Length; i++)
{
if (SequenceId[i] == counter && SiteClusterId != 0)
{
myDataTable.AddRow(cs, "Value1", SiteId, "Value2", NetLayerId, "Value3", SequenceId[i], "Value4", SiteClusterId, "Value5", NetLayerId, "Value6", ScopeId, "Value7", false);
counter++;
}
}
ssd.CLSScript("CLSScripts", cs);
}
res.Status = "success";
res.Message = "save successfully";
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
protected DataTable CreateTable()
{
CustomDataTable table = new CustomDataTable();
table.Columns.Add("timeCol", typeof(DateTime));
return table;
}
