示例#1
0
        public Upit getUpitID(int _id)
        {
            connection();
            Upit upit = new UPit();

            con.ConnectionString = str;
            using (MySqlCommand cmd = new MySqlCommand())
            {
                cmd.Connection  = con;
                cmd.CommandText = "SELECT id_upit,id_stanar,datum,naslov,opis,dogovoreno FROM upit WHERE id=+@id";
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.AddWithValue("@id", _id);
                con.Open();
                using (MySqlDataReader sdr = cmd.ExecuteReader())
                {
                    if (sdr.HasRows)
                    {
                        while (sdr.Read())
                        {
                            upit = new Upit()
                            {
                                id_upit    = Convert.ToInt32(sdr["id_upit"]),
                                id_stanar  = Convert.ToInt32(sdr["id_stanar"]),
                                datum      = sdr["datum"].datetime(),
                                naslov     = sdr["naslov"].ToString(),
                                opis       = sdr["opis"].ToString(),
                                dogovoreno = sdr["dogovoreno"].ToString()
                            };
                        }
                    }
                }
                con.Close();
            }
            return(upit);
        }
示例#2
0
 public string updateUpit(Upit data)
 {
     try
     {
         connection();
         using (MySqlCommand cmd = new MySqlCommand())
         {
             cmd.Connection  = con;
             cmd.CommandText = "UPDATE upit SET id_upit = @id_upit, id_stanar = @id_stanar,datum = @datum,naslov = @naslov,opis = @opis,dogovreno = @dogovoreno WHERE id = @id";
             cmd.CommandType = CommandType.Text;
             cmd.Parameters.AddWithValue("@id_upit", data.id_upit);
             cmd.Parameters.AddWithValue("@id_stanar", data.id_stanar);
             cmd.Parameters.AddWithValue("@datum", data.datum);
             cmd.Parameters.AddWithValue("@naslov", data.naslov);
             cmd.Parameters.AddWithValue("@opis", data.opis);
             cmd.Parameters.AddWithValue("@dogovoreno", data.dogovoreno);
             con.Open();
             cmd.ExecuteNonQuery();
             con.Close();
             return("OK");
         }
     }
     catch (Exception err)
     {
         con.Close();
         return("Error");
     }
 }
示例#3
0
 public string addUpit(Upit data)
 {
     try
     {
         connection();
         using (MySqlCommand cmd = new MySqlCommand())
         {
             cmd.Connection  = con;
             cmd.CommandText = "INSERT INTO upit(id_upit,id_stanar,datum,naslov,opis,dogovoreno) " + " VALUES(@id_upit,@id_stanar,@datum,@naslov,@opis,@dogovoreno)";
             cmd.CommandType = CommandType.Text;
             cmd.Parameters.AddWithValue("@id_upit", data.id_upit);
             cmd.Parameters.AddWithValue("@id_stanar", data.id_stanar);
             cmd.Parameters.AddWithValue("@datum", data.datum);
             cmd.Parameters.AddWithValue("@naslov", data.naslov);
             cmd.Parameters.AddWithValue("@opis", data.opis);
             cmd.Parameters.AddWithValue("@dogovoreno", data.dogovoreno);
             con.Open();
             cmd.ExecuteNonQuery();
             con.Close();
             return("OK");
         }
     }
     catch (Exception err)
     {
         con.Close();
         return("Error");
     }
 }
示例#4
0
        public List <upit> GetUpit_2(string searchData)
        {
            connection();
            List <Upit> upit = new List <Upit>();

            con.ConnectionString = str;
            using (MySqlCommand cmd = new MySqlCommand())
            {
                cmd.Connection  = con;
                cmd.CommandText = "SELECT id_upit,id_stanar,datum,naslov,opis,dogovoreno FROM upit WHERE " +
                                  " naslov like '%" + searchData + "%' " +
                                  " ORDER BY id_upit ASC";
                con.Open();
                using (MySqlDataReader sdr = cmd.ExecuteReader())
                {
                    if (sdr.HasRows)
                    {
                        while (sdr.Read())
                        {
                            Upit emp = new Upit()
                            {
                                id_upit    = Convert.ToInt32(sdr["id_upit"]),
                                id_stanar  = Convert.ToInt32(sdr["id_stanar"]),
                                datum      = sdr["datum"].datetime(),
                                naslov     = sdr["naslov"].ToString(),
                                opis       = sdr["opis"].ToString(),
                                dogovoreno = sdr["dogovoreno"].ToString()
                            };
                            if (emp.naslov.Length > 0)
                            {
                                upit.Add(emp);
                            }
                        }
                    }
                }
                con.Close();
            }
            return(upit);
        }