public override DataTable Clone()
{
NodeDataTable cln = ((NodeDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
internal void InitVars()
{
this.tableNode = ((NodeDataTable)(this.Tables["Node"]));
if ((this.tableNode != null))
{
this.tableNode.InitVars();
}
}
private void InitClass()
{
this.DataSetName = "Nodes";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Nodes.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableNode = new NodeDataTable();
base.Tables.Add(this.tableNode);
}
private void InitClass()
{
this.DataSetName = "Nodes";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Nodes.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableNode = new NodeDataTable();
this.Tables.Add(this.tableNode);
}
internal void InitVars(bool initTable)
{
this.tableNode = ((NodeDataTable)(base.Tables["Node"]));
if ((initTable == true))
{
if ((this.tableNode != null))
{
this.tableNode.InitVars();
}
}
}
internal NodeRow(DataRowBuilder rb) :
base(rb)
{
this.tableNode = ((NodeDataTable)(this.Table));
}
public EntityNodeData PrepareList()
{
EntityNodeData nodeDatas = new EntityNodeData();
List <NodeData> nodes = new List <NodeData>();
List <NodeLink> linkNodes = new List <NodeLink>();
if (Request.Files.Count > 0)
{
HttpFileCollectionBase files = Request.Files;
string filename = Path.GetFileName(Request.Files[0].FileName);
HttpPostedFileBase file = files[0];
string fname;
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
string sheetName = Session["sheetName"].ToString();
ExcelWorksheet workSheet;
if (sheetName == string.Empty)
{
workSheet = currentSheet.First();
}
else
{
workSheet = currentSheet.Where(p => p.Name == sheetName).FirstOrDefault();
}
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
string tableName;
string columnName;
string lookupTable;
string LinkColumn;
string LinkType;
string pk;
string toColumn;
string datatype;
string tableExp;
string columnExp;
string uzunluk;
bool boolPK = false;
List <string> tables = new List <string>();
NodeData newNoteData = null;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
tableExp = ((workSheet.Cells[rowIterator, 1].Value == null) ? "" : workSheet.Cells[rowIterator, 1].Value.ToString()).Trim();
tableName = ((workSheet.Cells[rowIterator, 2].Value == null) ? "" : workSheet.Cells[rowIterator, 2].Value.ToString()).Trim().ToUpperInvariant();
columnName = (workSheet.Cells[rowIterator, 3].Value == null) ? "" : workSheet.Cells[rowIterator, 3].Value.ToString().Trim();
columnExp = (workSheet.Cells[rowIterator, 4].Value == null) ? "" : workSheet.Cells[rowIterator, 4].Value.ToString().Trim();
datatype = (workSheet.Cells[rowIterator, 5].Value == null) ? "" : workSheet.Cells[rowIterator, 5].Value.ToString().Trim();
uzunluk = (workSheet.Cells[rowIterator, 6].Value == null) ? "" : workSheet.Cells[rowIterator, 6].Value.ToString().Trim();
lookupTable = ((workSheet.Cells[rowIterator, 7].Value == null) ? "" : workSheet.Cells[rowIterator, 7].Value.ToString()).Trim().ToUpperInvariant();
LinkColumn = (workSheet.Cells[rowIterator, 8].Value == null) ? "" : workSheet.Cells[rowIterator, 8].Value.ToString().Trim();
toColumn = (workSheet.Cells[rowIterator, 9].Value == null) ? "" : workSheet.Cells[rowIterator, 9].Value.ToString().Trim();
LinkType = (workSheet.Cells[rowIterator, 10].Value == null) ? "" : workSheet.Cells[rowIterator, 10].Value.ToString().Trim();
pk = (workSheet.Cells[rowIterator, 11].Value == null) ? "" : workSheet.Cells[rowIterator, 11].Value.ToString().Trim();
if (toColumn == string.Empty)
{
toColumn = columnName;
}
//if (pk != string.Empty)
// boolPK = bool.Parse(pk);
//else
// boolPK = false;
try
{
boolPK = bool.Parse(pk);
}
catch (Exception)
{
boolPK = false;
}
//veriler excel'den alındı. İlgili tablolara atılması gerekiyor.
if (tableName != string.Empty && !tables.Contains(tableName))
{
newNoteData = new NodeData();
newNoteData.key = tableName;
newNoteData.description = tableExp;
newNoteData.tables = new List <NodeDataTable>();
tables.Add(tableName);
nodes.Add(newNoteData);
}
if (columnName != string.Empty)
{
NodeDataTable newNodeDataSubItem;
newNodeDataSubItem = new NodeDataTable(columnName, boolPK, datatype, uzunluk, columnExp);
newNoteData.tables.Add(newNodeDataSubItem);
}
if (lookupTable != string.Empty && LinkColumn != string.Empty)
{
NodeLink linkNode = new NodeLink(tableName, lookupTable, LinkColumn, toColumn);
linkNodes.Add(linkNode);
}
} // for end
} //using end
nodeDatas.NodeDatas = nodes;
nodeDatas.NodeLinks = linkNodes;
}//if end
}
return(nodeDatas);
}
internal NodeRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableNode = ((NodeDataTable)(this.Table));
}
internal void InitVars()
{
this.tableNode = ((NodeDataTable)(this.Tables["Node"]));
if ((this.tableNode != null)) {
this.tableNode.InitVars();
}
}
internal NodeRow(DataRowBuilder rb)
: base(rb)
{
this.tableNode = ((NodeDataTable)(this.Table));
}
private void InitClass()
{
this.DataSetName = "Nodes";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Nodes.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableNode = new NodeDataTable();
this.Tables.Add(this.tableNode);
}
