/// <summary>
/// To remove 'Import' element.
/// </summary>
/// <param name="element">Specified 'Import' element to remove.</param>
/// <param name="holdEmptyGroup">Holds empty group if it was inside.</param>
/// <returns>true value if it has been removed.</returns>
public bool RemoveImport(ImportElement element, bool holdEmptyGroup = false)
{
if (element.parentElement == null)
{
return(false);
}
// https://github.com/3F/DllExport/issues/77
// 'The node is not parented by this object' if an `Import` element is already placed inside `ImportGroup`.
//Project.Xml.RemoveChild(element.parentElement);
var imp = element.parentElement;
if (imp.Parent is ProjectImportGroupElement container)
{
if (container.Imports.Count > 1)
{
container.RemoveChild(imp);
return(true);
}
if (holdEmptyGroup)
{
container.RemoveChild(imp); // leave as an ~ <ImportGroup />
}
else
{
Project.Xml.RemoveChild(container);
}
return(true);
}
Project.Xml.RemoveChild(imp);
return(true);
}
string ImportFile(int userId, int tokenID, string fileName)
{
try
{
var package = new ExcelPackage(new FileInfo(Path.Combine(Server.MapPath("~/Images"), fileName)));
ExcelWorksheet workSheet = package.Workbook.Worksheets[1];
for (int i = workSheet.Dimension.Start.Row + 2; i <= workSheet.Dimension.End.Row; i++)
{
int j = workSheet.Dimension.Start.Column + 1;
ImportElement ie = new ImportElement();
ie.Category = workSheet.Cells[i, j].Value.ToString();
ie.Name = workSheet.Cells[i, ++j].Value.ToString();
string s = workSheet.Cells[i, ++j].Value.ToString();
ie.Price = int.Parse(s);
ie.Description = workSheet.Cells[i, ++j].Value.ToString();
ie.Photo = workSheet.Cells[i, ++j].Value.ToString();
ie.Count = int.Parse(workSheet.Cells[i, ++j].Value.ToString());
using (botEntities3 db = new botEntities3())
{
Users user = db.Users.Where(x => x.Id == userId).First();
Token k = db.Token.Where(x => x.UserID == user.Id).FirstOrDefault();
Category c = db.Category.Where(x => x.NameCategory == ie.Category).Where(x => x.TokenId == k.Id).FirstOrDefault();
if (c == null)
{
c = new Category()
{
NameCategory = ie.Category, CategoryId = user.Id, TokenId = tokenID
};
db.Category.Add(c);
db.SaveChanges();
}
db.Product.Add(new Product()
{
Category = c, CategoryId = user.Id, ProductDescription = ie.Description, ProductName = ie.Name, ProductPrice = ie.Price, ProductPhoto = ie.Photo, Counts = ie.Count
});
db.SaveChanges();
}
}
}
catch
{
}
return("ок");
}
private static ImportElement[] CreateImportsElements(NamespaceCollection namespaces)
{
if (namespaces.Count > 0)
{
var elements = new ImportElement[namespaces.Count];
for (int i = 0; i < namespaces.Count; i++)
{
elements[i] = new ImportElement()
{
Namespace = namespaces[i]
}
}
;
return(elements);
}
return(null);
}
public override ErrorList Validate()
{
var result = new ErrorList();
result.AddRange(base.Validate());
if (ImportElement != null)
{
ImportElement.ForEach(elem => result.AddRange(elem.Validate()));
}
if (Include != null)
{
Include.ForEach(elem => result.AddRange(elem.Validate()));
}
if (Exclude != null)
{
Exclude.ForEach(elem => result.AddRange(elem.Validate()));
}
return(result);
}
protected ScriptItem(ImportElement importElement)
{
Element = importElement;
}
public ImportManager()
{
AddElement(scanner_element = new DirectoryScannerPipelineElement());
AddElement(import_element = new ImportElement(this));
}
/// <summary>
/// To add 'import' element.
/// </summary>
/// <param name="element">Specified 'Import' element to add.</param>
/// <returns>true value if it has been added.</returns>
public bool AddImport(ImportElement element)
{
return(AddImport(element.project, element.condition, element.label));
}
protected ScriptItem(ImportElement importElement)
{
Element = importElement;
}
