protected override List <BaseIntegrationObject> ReadPack()
{
var pack = new List <BaseIntegrationObject>();
lock (_lock)
{
using (var provider = new DBConnectionProvider())
{
using (var reader = provider.Execute(_selectQuery, packSize))
{
while (reader != null && reader.Read())
{
pack.Add(new SMS()
{
ContactId = reader.GetValue("ContactId", String.Empty),
ContactPhone = reader.GetValue("ContactPhone", String.Empty),
MessageStatus = reader.GetValue("MessageStatus", String.Empty),
SentDate = reader.GetValue("SentDate", String.Empty),
ERPId = reader.GetValue("ERPId", String.Empty),
Text = reader.GetValue("Text", String.Empty),
Id = Guid.NewGuid(),
});
}
}
}
if (pack.Count > 0)
{
DBConnectionProvider.ExecuteNonQuery(String.Format("Update {1} Set Status = 3 Where ERPId in ({0})", String.Join(",", pack.Select(p => String.Format("'{0}'", p.CorrectERPId))), _tableName));
}
}
return(pack);
}
protected void ProceedPrimaryResults(PrimaryIntegratePackResponse results)
{
try
{
var query = new StringBuilder();
foreach (var result in results.PrimaryIntegratePackResult)
{
if (result.IsSuccess)
{
query.AppendLine(String.Format("Update {1} Set Status = 1 Where ERPId = '{0}';", result.GetCorrectId(), _tableName));
}
else
{
var errorMessage = String.IsNullOrEmpty(result.ErrorMessage) ? String.Empty : result.ErrorMessage.Replace("'", "''").Replace("{", "").Replace("}", "");
if (errorMessage.Length > 250)
{
errorMessage = errorMessage.Substring(0, 250);
}
query.AppendLine(String.Format("Update {2} Set Status = {3}, ErrorMessage = '{1}' Where ERPId = '{0}';", result.GetCorrectId(), errorMessage, _tableName, result.IsTimeout ? "4" : "2"));
}
}
var sql = query.ToString();
if (!string.IsNullOrEmpty(sql))
{
DBConnectionProvider.ExecuteNonQuery(sql);
}
}
catch (Exception e)
{
Logger.LogError(JsonConvert.SerializeObject(results), e);
}
}
protected override List <BaseIntegrationObject> ReadPack()
{
var pack = new List <BaseIntegrationObject>();
lock (_lock)
{
using (var provider = new DBConnectionProvider())
{
using (var reader = provider.Execute(_selectQuery, packSize))
{
while (reader != null && reader.Read())
{
pack.Add(new ProductCategory()
{
Name = reader.GetValue("name", String.Empty),
ERPId = reader.GetValue("ERPId", String.Empty),
Direction = reader.GetValue("Direction", String.Empty),
Id = Guid.NewGuid(),
});
}
}
}
if (pack.Count > 0)
{
DBConnectionProvider.ExecuteNonQuery(String.Format("Update {1} Set Status = 3 Where ERPId in ({0})", String.Join(",", pack.Select(p => String.Format("'{0}'", p.CorrectERPId))), _tableName));
}
}
return(pack);
}
private void SetProcessingErrors(List <BaseIntegrationObject> pack, string responseStr, bool isTimeout)
{
var errorMessage = String.IsNullOrEmpty(responseStr) ? String.Empty : responseStr.Replace("'", "''").Replace("{", "").Replace("}", "");
if (errorMessage.Length > 250)
{
errorMessage = errorMessage.Substring(0, 250);
}
DBConnectionProvider.ExecuteNonQuery(String.Format("Update {1} Set Status = {3}, ErrorMessage = '{2}' Where ERPId in ({0})", String.Join(",", pack.Select(p => String.Format("'{0}'", p.CorrectERPId))), _tableName, errorMessage, isTimeout ? "4" : "2"));
}
protected override List <BaseIntegrationObject> ReadPack()
{
var pack = new List <BaseIntegrationObject>();
lock (_lock)
{
using (var provider = new DBConnectionProvider())
{
using (var reader = provider.Execute(_selectContact, packSize))
{
while (reader != null && reader.Read())
{
pack.Add(new Contact()
{
Address = reader.GetValue("address", String.Empty),
City = reader.GetValue("City", String.Empty),
Country = reader.GetValue("Country", String.Empty),
ContactStatus = reader.GetValue("contactStatus", String.Empty),
Email = reader.GetValue("email", String.Empty),
ErrorMessage = reader.GetValue("errorMessage", String.Empty),
FirstName = reader.GetValue("FirstName", String.Empty),
MiddleName = reader.GetValue("MiddleName", String.Empty),
Phone = reader.GetValue("Phone", String.Empty),
RegistrationDate = reader.GetValue("RegistrationDate", String.Empty),
CreatedOn = reader.GetValue("CreatedOn", String.Empty),
BirthDay = reader.GetValue("birthday", String.Empty),
ERPId = reader.GetValue("ERPId", String.Empty),
Id = Guid.NewGuid(),
Surname = reader.GetValue("Surname", String.Empty),
ShopCode = reader.GetValue("ShopCode", String.Empty),
SmrNearestMetroStation = reader.GetValue("SmrNearestMetroStation", String.Empty),
BonusBalance = reader.GetValue("bonusBalance", 0m),
IsMan = reader.GetValue("gender", false),
PersDataProcAgreement = reader.GetValue("PersDataProcAgreement", false),
RequiresCorrection = reader.GetValue("RequiresCorrection", false),
ThereAreEmptyFields = reader.GetValue("ThereAreEmptyFields", String.Empty),
Type = reader.GetValue("type", -1),
});
}
}
}
if (pack.Count > 0)
{
DBConnectionProvider.ExecuteNonQuery(String.Format("Update ContactGate Set Status = 3 Where ERPId in ({0})", String.Join(",", pack.Select(p => String.Format("'{0}'", p.CorrectERPId)))));
}
}
return(pack);
}
public ActionResult ExportBalance([FromBody] List <ContactBalance> balances)
{
foreach (var balance in balances)
{
DBConnectionProvider.ExecuteNonQuery(
string.Format(
@"IF NOT EXISTS(select top 1 1 from ContactBalanceGate where ERPId = '{0}' and bonusType = '{2}')
BEGIN
Insert into ContactBalanceGate(ERPId, uploadedOn, bonusBalance, bonusType) VALUES('{0}', GETUTCDATE(), {1}, '{2}')
END
ELSE BEGIN
update ContactBalanceGate set bonusBalance = {1}, uploadedOn = GETUTCDATE() where ERPId = '{0}'
END
",
balance.ERPId, balance.Balance.ToString().Replace(",", "."), balance.BonusType));
}
return(Ok());
}
protected override List <BaseIntegrationObject> ReadPack()
{
var pack = new List <BaseIntegrationObject>();
lock (_lock)
{
using (var provider = new DBConnectionProvider())
{
using (var reader = provider.Execute(_selectQuery, packSize))
{
while (reader != null && reader.Read())
{
pack.Add(new Product()
{
Name = reader.GetValue("name", String.Empty),
ERPId = reader.GetValue("ERPId", String.Empty),
Category = reader.GetValue("category", String.Empty),
Brand = reader.GetValue("Brand", String.Empty),
BrandType = reader.GetValue("BrandType", String.Empty),
Code = reader.GetValue("Code", String.Empty),
Direction = reader.GetValue("Direction", String.Empty),
Group = reader.GetValue("Group", String.Empty),
Provider = reader.GetValue("Provider", String.Empty),
Size = reader.GetValue("Size", String.Empty),
SubCategory = reader.GetValue("SubCategory", String.Empty),
IsArchived = reader.GetValue("IsArchived", false),
RecommendedRetailPrice = reader.GetValue("RecommendedRetailPrice", 0m),
Id = Guid.NewGuid(),
});
}
}
}
if (pack.Count > 0)
{
DBConnectionProvider.ExecuteNonQuery(String.Format("Update {1} Set Status = 3 Where ERPId in ({0})", String.Join(",", pack.Select(p => String.Format("'{0}'", p.CorrectERPId))), _tableName));
}
}
return(pack);
}
public virtual void ProceedResult(PackResult result, List <BaseIntegrationObject> pack)
{
lock (_lockRes)
{
try
{
var query = new StringBuilder();
if (result.IsSuccess)
{
foreach (var obj in pack)
{
query.AppendLine(String.Format("Update {1} Set Status = 1 Where ERPId = '{0}';", obj.CorrectERPId, _tableName));
}
}
else
{
var errorMessage = String.IsNullOrEmpty(result.ErrorMessage) ? String.Empty : result.ErrorMessage.Replace("'", "").Replace("{", "").Replace("}", "");
if (errorMessage.Length > 250)
{
errorMessage = errorMessage.Substring(0, 250);
}
foreach (var obj in pack)
{
query.AppendLine(String.Format("Update {2} Set Status = {3}, ErrorMessage = '{1}' Where ERPId = '{0}';", obj.CorrectERPId, errorMessage, _tableName, result.IsTimeout ? "4" : "2"));
}
}
var sql = query.ToString();
if (!string.IsNullOrEmpty(sql))
{
DBConnectionProvider.ExecuteNonQuery(sql);
}
}
catch (Exception e)
{
Logger.LogError(String.Format("Ошибка обновления состояний в ШТ {0} для первичного импорта", _tableName), e);
}
}
}
protected override List <BaseIntegrationObject> ReadPack()
{
var pack = new List <BaseIntegrationObject>();
lock (_lock)
{
using (var provider = new DBConnectionProvider())
{
using (var reader = provider.Execute(_selectQuery, packSize))
{
while (reader != null && reader.Read())
{
pack.Add(new Purchase()
{
Number = reader.GetValue("Number", String.Empty),
ERPId = reader.GetValue("ERPId", String.Empty),
CardNumber = reader.GetValue("CardNumber", String.Empty),
Amount = reader.GetValue("Amount", 0m),
CashDeskCode = reader.GetValue("CashDeskCode", String.Empty),
ContactId = reader.GetValue("ContactId", String.Empty),
CreatedOn = reader.GetValue("CreatedOn", String.Empty),
PaymentForm = reader.GetValue("PaymentForm", String.Empty),
Phone = reader.GetValue("Phone", String.Empty),
PurchaseDate = reader.GetValue("purchaseDateStr", String.Empty),
PDate = reader.GetValue("purchaseDate", DateTime.MinValue),
ShopCode = reader.GetValue("ShopCode", String.Empty),
Id = Guid.NewGuid(),
});
}
}
}
if (pack.Count > 0)
{
DBConnectionProvider.ExecuteNonQuery(String.Format("Update {1} Set Status = 3 Where ERPId in ({0})", String.Join(",", pack.Select(p => String.Format("'{0}'", p.CorrectERPId))), _tableName));
}
}
return(pack);
}
protected override List <BaseIntegrationObject> ReadPack()
{
var pack = new List <BaseIntegrationObject>();
lock (_lock)
{
using (var provider = new DBConnectionProvider())
{
using (var reader = provider.Execute(_selectContact, packSize))
{
while (reader != null && reader.Read())
{
pack.Add(new Card()
{
ActivationDate = reader.GetValue("activationDate", String.Empty),
BlockedOn = reader.GetValue("blockedOn", String.Empty),
BlockingReason = reader.GetValue("blockingReason", String.Empty),
CardStatus = reader.GetValue("cardStatus", String.Empty),
ContactId = reader.GetValue("contactId", String.Empty),
ErrorMessage = reader.GetValue("errorMessage", String.Empty),
IsMain = reader.GetValue("isMain", false),
Number = reader.GetValue("number", String.Empty),
CreatedOn = reader.GetValue("CreatedOn", String.Empty),
ERPId = reader.GetValue("ERPId", String.Empty),
Id = Guid.NewGuid()
});
}
}
}
if (pack.Count > 0)
{
DBConnectionProvider.ExecuteNonQuery(String.Format("Update {1} Set Status = 3 Where ERPId in ({0})", String.Join(",", pack.Select(p => String.Format("'{0}'", p.CorrectERPId))), _tableName));
}
}
return(pack);
}