public ActionResult CPListByOP(string CardCode) { List <SAPContactPerson> SAPCP = new List <SAPContactPerson>(); SAPCP = SAPContactPerson.SAPContactPersonList(CardCode); return(View(SAPCP)); }
public ActionResult ImportSAPCP(string CardCode, int Zakaznik) { List <SAPContactPerson> SAPCP = new List <SAPContactPerson>(); SAPCP = SAPContactPerson.SAPContactPersonList(CardCode); foreach (var item in SAPCP) { bool result = KontakniOsoba.Generate(Zakaznik, item.Name, item.Position, item.Tel1, item.E_MaiL, item.CntctCode); } return(RedirectToAction("Index", "KontaktniOsoby", new { Zakaznik })); }
public static List <SAPContactPerson> SAPContactPersonList(string SAPOP) { string connectionString = ConfigurationManager.ConnectionStrings["SQL"].ConnectionString; string SAP_dtb = ConfigurationManager.ConnectionStrings["SAP_dtb"].ConnectionString; string RS_dtb = ConfigurationManager.ConnectionStrings["RS_dtb"].ConnectionString; List <SAPContactPerson> SAPCP = new List <SAPContactPerson>(); StringBuilder sql = new StringBuilder(); sql.Append(" Select CntctCode, CardCode, Name, Position, Tel1, Cellolar, E_MailL from OCPR"); sql.Append($" Where CardCode = '{SAPOP}' and"); sql.Append($" (select count(*) from [{RS_dtb}].[dbo].[KontakniOsoba] where SapId = CntctCode ) = 0"); //(select COUNT(*) from[Servis].[dbo].[Zakaznik] Z where Z.KodSAP COLLATE DATABASE_DEFAULT = CardCode COLLATE DATABASE_DEFAULT) = 0)"; SqlConnection cnn = new SqlConnection(connectionString); 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()) { SAPContactPerson sapcp = new SAPContactPerson(); if (dr.GetString(dr.GetOrdinal("CardCode")) != null) { sapcp.CntctCode = dr.GetInt32(dr.GetOrdinal("CntctCode")); } try { sapcp.CardCode = dr.GetString(dr.GetOrdinal("CardCode")); } catch (Exception ex) { log.Debug("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sapcp.Name = dr.GetString(dr.GetOrdinal("Name")); } catch (Exception ex) { log.Debug("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sapcp.Position = dr.GetString(dr.GetOrdinal("Position")); } catch (Exception ex) { log.Debug("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sapcp.Tel1 = dr.GetString(dr.GetOrdinal("Tel1")); } catch (Exception ex) { log.Debug("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sapcp.Cellolar = dr.GetString(dr.GetOrdinal("Cellolar")); } catch (Exception ex) { log.Debug("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sapcp.E_MaiL = dr.GetString(dr.GetOrdinal("E_MailL")); } catch (Exception ex) { log.Debug("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } SAPCP.Add(sapcp); } } cnn.Close(); return(SAPCP); }