Example #1
0
        public static List <Nalog> GetNalozi()
        {
            List <Nalog>  nlist            = new List <Nalog>();
            SqlConnection connection       = AppDB.GetConnection();
            SqlCommand    selectAllCommand = new SqlCommand();

            selectAllCommand.Connection  = connection;
            selectAllCommand.CommandText = "DnevnikNaloziSelectAll";
            selectAllCommand.CommandType = System.Data.CommandType.StoredProcedure;

            try
            {
                connection.Open();
                SqlDataReader reader = selectAllCommand.ExecuteReader();
                while (reader.Read())
                {
                    Nalog nalog = new Nalog();
                    nalog.BrojNaNalog    = reader["BrojNaNalog"].ToString();
                    nalog.DatumNaNaNalog = Convert.ToDateTime(reader["DatumNaNalog"]);
                    nalog.SaldoDolzi     = Convert.ToDecimal(reader["SaldoDolzi"]);
                    nalog.SaldoPobaruva  = Convert.ToDecimal(reader["SaldoPobaruva"]);
                    nlist.Add(nalog);
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
            return(nlist);
        }
Example #2
0
        public static Nalog GetNalog()
        {
            Nalog         nalog         = new Nalog();
            SqlConnection connection    = AppDB.GetConnection();
            SqlCommand    selectCommand = new SqlCommand();

            selectCommand.Connection  = connection;
            selectCommand.CommandText = "";
            selectCommand.CommandType = System.Data.CommandType.StoredProcedure;
            selectCommand.Parameters.AddWithValue()
        }