public static void LoggingRequest(string methodName, string apiName, string apiType, string incomingParameters, int responseBodyLenght, int userId, string apiKey) { if (BackendHelper.TagToValue("allow_unauth_api_request") == "true") { return; } var apiLog = new ApiLog { MethodName = methodName, ApiName = apiName, ApiType = apiType, IncomingParameters = incomingParameters, ResponseBodyLenght = responseBodyLenght, UserID = userId, ApiKey = apiKey, UserIP = OtherMethods.GetIPAddress() }; apiLog.Create(); }
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); }
public static string OldNewValueToRuss(string tableName, string propertyName, string value) { #region таблица заявок if (tableName == "tickets") { if (propertyName == "CourseRUR" || propertyName == "CourseUSD" || propertyName == "CourseEUR" || propertyName == "DeliveryCost" || propertyName == "AssessedCost" || propertyName == "AgreedCost" || propertyName == "ReceivedUSD" || propertyName == "ReceivedEUR" || propertyName == "ReceivedEUR" || propertyName == "ReceivedBLR" || propertyName == "GruzobozCost") { return(MoneyMethods.MoneySeparator(value)); } if (propertyName == "DriverID") { return(DriversHelper.DriverIDToFioToPrint(value)); } if (propertyName == "StatusIDOld" || propertyName == "StatusID") { return(OtherMethods.TicketStatusToText(value)); } if (propertyName == "CityID") { return(CityHelper.CityIDToCityNameWithotCustom(value)); } if (propertyName == "TrackIDUser") { return(OtherMethods.TrackToText(Convert.ToInt32(value))); } if (propertyName == "DeliveryDate") { return(value.Remove(value.Length - 8)); } if (propertyName == "Comment") { return(WebUtility.HtmlDecode(value)); } if (propertyName == "PrintNakl" || propertyName == "PrintNaklInMap" || propertyName == "IsExchange" || propertyName == "WithoutMoney" || propertyName == "CheckedOut" || propertyName == "Phoned") { return(value == "0" ? "нет" : "да"); } if (propertyName == "OvDateFrom" || propertyName == "OvDateTo") { return(String.IsNullOrEmpty(value) ? String.Empty : Convert.ToDateTime(value).ToString("HH:mm")); } } #endregion #region таблица пользователей if (tableName == "users") { if (propertyName == "SpecialClient" || propertyName == "IsCourse" || propertyName == "AllowApi") { return(value == "0" ? "нет" : "да"); } if (propertyName == "Status") { return(UsersHelper.UserStatusToText(Convert.ToInt32(value))); } if (propertyName == "Role") { return(UsersHelper.RoleToRuss(value)); } if (propertyName == "Discount") { return(String.Format("{0}%", value)); } if (propertyName == "Password") { return(String.Empty); } if (propertyName == "Validity" && value.Length >= 8) { return(value.Remove(value.Length - 8)); } if (propertyName == "BirthDay" && value.Length >= 8) { return(value.Remove(value.Length - 8)); } if (propertyName == "DateOfIssue" && value.Length >= 8) { return(value.Remove(value.Length - 8)); } } #endregion #region таблица грузов if (tableName == "goods") { if (propertyName == "Cost") { return(MoneyMethods.MoneySeparator(value)); } if (propertyName == "WithoutAkciza") { return(value == "0" ? "нет" : "да"); } } #endregion #region таблица профилей if (tableName == "usersprofiles") { if (propertyName == "StatusID") { return(UsersProfilesHelper.UserProfileStatusToText(Convert.ToInt32(value))); } } #endregion #region таблица водителй if (tableName == "drivers") { if (propertyName == "StatusID" && !String.IsNullOrEmpty(value)) { return(DriversHelper.DriverStatusToText(Convert.ToInt32(value))); } if (value.Length >= 8 && (propertyName == "DateOfIssue" || propertyName == "Validity" || propertyName == "BirthDay" || propertyName == "DriverPassportDateOfIssue" || propertyName == "DriverPassportValidity" || propertyName == "MedPolisDateOfIssue" || propertyName == "MedPolisValidity")) { return(value.Remove(value.Length - 8)); } } #endregion #region таблица авто if (tableName == "cars") { if (propertyName == "TypeID" && !String.IsNullOrEmpty(value)) { return(CarsHelper.CarTypeToFullString(Convert.ToInt32(value))); } } #endregion #region таблица категорий if (tableName == "category") { if (propertyName == "Name") { return(value); } } #endregion return(value); }