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);
}