public static void StartSession()
{
if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/OneCSyncArch/")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/OneCSyncArch/"));
}
var dataFile = HttpContext.Current.Server.MapPath("~/OneCSyncArch/" + FileName);
var writer = new System.Xml.Serialization.XmlSerializer(typeof(XmlToOneC));
var xml = new XmlToOneC();
var fileWriter = File.Create(dataFile);
writer.Serialize(fileWriter, xml);
fileWriter.Close();
}
public static string GenerateCsv(string idListString, string invoiceNumber, string invoiceSeries, string invoiceDate)
{
var result = String.Empty;
var dm = new DataManager();
var idListToMySql = idListString.Split('-').ToList().Aggregate(String.Empty, (current, id) => current + "T.ID = " + id + " OR ");
//читаем старый файл
if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/OneCSyncArch/")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/OneCSyncArch/"));
}
var dataFile = HttpContext.Current.Server.MapPath("~/OneCSyncArch/" + FileName);
var reader = new System.Xml.Serialization.XmlSerializer(typeof(XmlToOneC));
var xml = new XmlToOneC
{
Invoices = new List <Invoice>()
};
if (File.Exists(dataFile))
{
var fileReaded = new StreamReader(dataFile);
xml = (XmlToOneC)reader.Deserialize(fileReaded);
fileReaded.Close();
}
//читаем старый файл
var invoices = new Invoice
{
InvoiceNumber = invoiceNumber,
InvoiceSeries = invoiceSeries,
InvoiceDate = invoiceDate,
CustomOrders = new List <CustomOrderToOneC>()
};
var fullSqlString = "SELECT * FROM `tickets` as T " +
"WHERE ((" + idListToMySql.Remove(idListToMySql.Length - 3) +
") AND T.PrintNakl = '1' AND T.NotPrintInPril2 ='0') ";
var rows = dm.QueryWithReturnDataSet(fullSqlString).Tables[0].Rows;
foreach (DataRow row in rows)
{
var customOrderCost = row["AssessedCost"].ToString();
if (!String.IsNullOrEmpty(row["AgreedCost"].ToString()) && Convert.ToInt32(row["AgreedCost"]) != 0)
{
customOrderCost = row["AgreedCost"].ToString();
}
if (!String.IsNullOrEmpty(row["Pril2Cost"].ToString()) && Convert.ToInt32(row["Pril2Cost"]) != 0)
{
customOrderCost = row["Pril2Cost"].ToString();
}
var customOrder = new CustomOrderToOneC
{
CustomOrderSecureId = row["SecureID"].ToString(),
CustomOrderCost = Convert.ToDecimal(customOrderCost),
CustomOrderDate = OtherMethods.DateConvertWithDot(row["AdmissionDate"].ToString())
};
invoices.CustomOrders.Add(customOrder);
}
xml.Invoices.Add(invoices);
var writer = new System.Xml.Serialization.XmlSerializer(typeof(XmlToOneC));
var fileWriter = File.Create(dataFile);
writer.Serialize(fileWriter, xml);
fileWriter.Close();
return(result);
}