public ActionResult ImportSAPAddress(string CardCode, int Zakaznik)
{
List <SAPDeliveryAddress> SAPDAList = new List <SAPDeliveryAddress>();
SAPDAList = SAPDeliveryAddress.LoadSAPDeliveryAddresses(CardCode, Zakaznik);
foreach (var item in SAPDAList)
{
bool result = Provoz.Generate(item.Address, item.CardCode, item.Street, item.City, item.Country, item.Country, Zakaznik);
}
return(RedirectToAction("Details", "Zakaznici", new { id = Zakaznik }));
}
public static List <SAPDeliveryAddress> LoadSAPDeliveryAddresses(string CardCode, int Zakaznik)
{
List <SAPDeliveryAddress> SAPDAList = new List <SAPDeliveryAddress>();
string connectionString = ConfigurationManager.ConnectionStrings["SQL"].ConnectionString;
string SAP_dtb = ConfigurationManager.ConnectionStrings["SAP_dtb"].ConnectionString;
string RS_dtb = ConfigurationManager.ConnectionStrings["RS_dtb"].ConnectionString;
StringBuilder sql = new StringBuilder();
sql.Append(" Select Address, CardCode, Street, ZipCode, City, Country from CRD1");
sql.Append($" where CardCode = '{CardCode}' and AdresType = 'S' and ");
sql.Append($" (select count(*) from [{RS_dtb}].[dbo].[Provoz] X where X.ZakaznikId = '{Zakaznik}' and X.SAPAddress COLLATE DATABASE_DEFAULT = Address COLLATE DATABASE_DEFAULT) = 0 ");
SqlConnection cnn = new SqlConnection(connectionString);
//SqlConnection con = new SqlConnection(cnn);
SqlCommand cmd = new SqlCommand
{
Connection = cnn,
CommandText = sql.ToString()
};
cnn.Open();
cmd.ExecuteNonQuery();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
//MAKES IT HERE
while (dr.Read())
{
SAPDeliveryAddress sapda = new SAPDeliveryAddress();
if (dr.GetString(dr.GetOrdinal("CardCode")) != null)
{
sapda.Address = dr.GetString(dr.GetOrdinal("Address"));
}
try
{
sapda.CardCode = dr.GetString(dr.GetOrdinal("CardCode"));
}
catch (Exception ex)
{
log.Debug("LoadSAPDeliveryAddresses - Načtení CardCode - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException);
}
try
{
sapda.Street = dr.GetString(dr.GetOrdinal("Street"));
}
catch (Exception ex)
{
log.Debug("LoadSAPDeliveryAddresses - Načtení Street - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException);
}
try
{
sapda.ZipCode = dr.GetString(dr.GetOrdinal("ZipCode"));
}
catch (Exception ex)
{
log.Debug("LoadSAPDeliveryAddresses - Načtení ZipCode - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException);
}
try
{
sapda.City = dr.GetString(dr.GetOrdinal("City"));
}
catch (Exception ex)
{
log.Error("LoadSAPDeliveryAddresses - Načtení City - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException);
}
try
{
sapda.Country = dr.GetString(dr.GetOrdinal("Country"));
}
catch (Exception ex)
{
log.Debug("LoadSAPDeliveryAddresses - Načtení Country - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException);
}
SAPDAList.Add(sapda);
}
}
cnn.Close();
return(SAPDAList);
}
