public static Causale GetCausale(string connectionString, string nomeCausale) { if (string.IsNullOrEmpty(nomeCausale)) { return(null); } string query = String.Format("SELECT * from Amm_CausaliAmministrazione WHERE (DESCRIZIONE = '{0}' and TipoCausale = 4)", nomeCausale.Replace("'", "''")); Causale l = null; SqlConnection c = new SqlConnection(connectionString); c.Open(); SqlCommand cmd = new SqlCommand(query, c); SqlDataReader rr = cmd.ExecuteReader(); while (rr.Read()) { l = new Causale(); l.IdCausale = rr.GetInt32(0); l.CausaleDesc = rr.GetString(1); } rr.Close(); c.Close(); return(l); }
protected override bool ValidateItem(movimento item) { Localita l = TransCodeGetter.GetLocalita(_sqlConnectionString, item.Provincia); Causale c = TransCodeGetter.GetCausale(_sqlConnectionString, item.DescrizioneCausale); if (l == null) { return(false); } if (c == null) { return(false); } item.Localita = l; item.CausaleAmministrativa = c; return(true); }