/// <summary>
/// Добавление выписок в БД
/// </summary>
/// <param name="cashBankAllUlFace">Выписки</param>
/// <param name="innUl">ИНН ЮЛ</param>
public void AddCashBankAllUlFace(ArrayBodyDoc cashBankAllUlFace, string innUl)
{
//ИНН Есть ли лицо
int idUl;
using (var context = new Base.Automation())
{
context.Database.CommandTimeout = 120000;
idUl = (from users in context.UlFaces where users.Inn == innUl select users.IdUl).SingleOrDefault();
cashBankAllUlFace.CashBankAllUlFace.ToList().ForEach(cashBank => cashBank.IdUl = idUl);
}
if (cashBankAllUlFace.CashBankAllUlFace[0].IdUl != 0)
{
//Удаляем старые записи по выписке заполняем новыми
using (var contextDelete = new Base.Automation())
{
contextDelete.Database.CommandTimeout = 120000;
contextDelete.CashBankAllUlFaces.RemoveRange(contextDelete.CashBankAllUlFaces.Where(x => x.IdUl == idUl));
contextDelete.SaveChanges();
}
XmlReadOrWrite xml = new XmlReadOrWrite();
var xsdFile = $"{ConfigurationManager.AppSettings["PathXsdScheme"]}XsdAllBodyData.xsd";
var xmlFile = $"{ConfigurationManager.AppSettings["PathDownloadTempXml"]}CashDataBank.xml";
xml.CreateXmlFile(xmlFile, cashBankAllUlFace, typeof(ArrayBodyDoc));
BulkInsertIntoDb(xsdFile, xmlFile);
}
//Отсутствует лицо сохранение не возможно
}
/// <summary>
/// Загрузка деклараций всех в БД
/// </summary>
/// <param name="declarationAll">Декларации</param>
/// <param name="declarationData">Массив строк декларации</param>
public void AddDeclarationAllModel(DeclarationAll declarationAll, ArrayBodyDoc declarationData)
{
if (!(from declarationAlls in Automation.DeclarationAlls
where declarationAlls.RegNumDecl == declarationAll.RegNumDecl
select new { DeclarationAlls = declarationAlls }).Any())
{
XmlReadOrWrite xml = new XmlReadOrWrite();
var xsdFile = $"{ConfigurationManager.AppSettings["PathXsdScheme"]}XsdAllBodyData.xsd";
var xmlFile = $"{ConfigurationManager.AppSettings["PathDownloadTempXml"]}DeclarationDataAll.xml";
xml.CreateXmlFile(xmlFile, declarationData, typeof(XsdShemeSqlLoad.XsdAllBodyData.ArrayBodyDoc));
Automation.DeclarationAlls.Add(declarationAll);
try
{
Automation.SaveChanges();
BulkInsertIntoDb(xsdFile, xmlFile);
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
Trace.WriteLine(validationError.Entry.Entity.ToString());
Trace.WriteLine("");
foreach (DbValidationError err in validationError.ValidationErrors)
{
Trace.WriteLine(err.ErrorMessage);
}
}
}
}
//Обновление данных и внутренних полей не требуется
}
public void Send()
{
var pathXlsx = @"D:\WWW.xlsx";
var sheetName = @"1";
DataTable dataTable = GetDateTableXslx(pathXlsx, sheetName);
dataTable.Columns.Remove(dataTable.Columns[0]);
DataNamesMapper <BookPurchase> mapper = new DataNamesMapper <BookPurchase>();
var bookSales = new ArrayBodyDoc()
{
BookPurchase = mapper.Map(dataTable).ToArray()
};
}
/// <summary>
/// Загрузка сведений по фактическому действию патента
/// </summary>
/// <param name="docPatent">Модель для загрузки сведений по фактическому действию патента</param>
public void AddSvedFactPatent(ArrayBodyDoc docPatent)
{
var index = docPatent.SvedFactPatent[0].IdPatent;
if (index != 0)
{
Automation.SvedFactPatents.RemoveRange(Automation.SvedFactPatents.Where(x => x.IdPatent == index));
Automation.SaveChanges();
XmlReadOrWrite xml = new XmlReadOrWrite();
var xsdFile = $"{ConfigurationManager.AppSettings["PathXsdScheme"]}XsdAllBodyData.xsd";
var xmlFile = $"{ConfigurationManager.AppSettings["PathDownloadTempXml"]}SvedFactPatent.xml";
xml.CreateXmlFile(xmlFile, docPatent, typeof(ArrayBodyDoc));
BulkInsertIntoDb(xsdFile, xmlFile);
}
}
/// <summary>
/// Добавление в БД Книги Продаж
/// </summary>
/// <param name="books">Книга</param>
/// <param name="bookPurchase">Книга продаж</param>
public void AddBookPurchase(ref Book books, ArrayBodyDoc bookPurchase)
{
var book = books;
bookPurchase.BookPurchase.ToList().ForEach(sales => sales.IdBook = book.IdBook);
using (var contextDelete = new Base.Automation())
{
contextDelete.Database.CommandTimeout = 120000;
contextDelete.BookPurchases.RemoveRange(contextDelete.BookPurchases.Where(x => x.IdBook == book.IdBook));
contextDelete.SaveChanges();
}
XmlReadOrWrite xml = new XmlReadOrWrite();
var xsdFile = $"{ConfigurationManager.AppSettings["PathXsdScheme"]}XsdAllBodyData.xsd";
var xmlFile = $"{ConfigurationManager.AppSettings["PathDownloadTempXml"]}bookPurchase.xml";
xml.CreateXmlFile(xmlFile, bookPurchase, typeof(ArrayBodyDoc));
BulkInsertIntoDb(xsdFile, xmlFile);
UpdeteBookPurchase(ref books);
}
/// <summary>
/// Добавление деклараций на все
/// </summary>
/// <param name="declarationUl">Основа декларации</param>
/// <param name="declarationData">Массив строк декларации</param>
/// <param name="innUl">ИНН</param>
public void AddDeclarationModel(DeclarationUl declarationUl, ArrayBodyDoc declarationData, string innUl)
{
using (var context = new Base.Automation())
{
context.Database.CommandTimeout = 120000;
var idUl = (from users in context.UlFaces where users.Inn == innUl select users.IdUl).SingleOrDefault();
declarationUl.IdUl = idUl;
}
if (declarationUl.IdUl != 0)
{
if (!(from declarationUls in Automation.DeclarationUls
where declarationUls.RegNumDecl == declarationUl.RegNumDecl
select new { DeclarationUls = declarationUls }).Any())
{
XmlReadOrWrite xml = new XmlReadOrWrite();
var xsdFile = $"{ConfigurationManager.AppSettings["PathXsdScheme"]}XsdAllBodyData.xsd";
var xmlFile = $"{ConfigurationManager.AppSettings["PathDownloadTempXml"]}DeclarationData.xml";
xml.CreateXmlFile(xmlFile, declarationData, typeof(XsdShemeSqlLoad.XsdAllBodyData.ArrayBodyDoc));
Automation.DeclarationUls.Add(declarationUl);
try
{
Automation.SaveChanges();
BulkInsertIntoDb(xsdFile, xmlFile);
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
Trace.WriteLine(validationError.Entry.Entity.ToString());
Trace.WriteLine("");
foreach (DbValidationError err in validationError.ValidationErrors)
{
Trace.WriteLine(err.ErrorMessage);
}
}
}
}
//Обновление данных и внутренних полей не требуется
}
//Отсутствует лицо сохранение не возможно
}
