public static List <gjuajtja> listoLlientat(string kerko, string po) { List <gjuajtja> lst = new List <gjuajtja>(); var cnn = DataConnection.GetConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "select * from Gjujtja"; cmd.CommandType = CommandType.Text; cnn.Close(); cnn.Open(); SqlDataReader dr = cmd.ExecuteReader(); cmd.CommandType = CommandType.Text; while (dr.Read()) { gjuajtja d = new gjuajtja(); d.Arma = dr["Arma"].ToString(); d.distanca = dr["distanca"].ToString(); d.PiketEshenuara = Convert.ToInt32(dr["PiketEshenuara"].ToString()); d.klienti = dr["Klienti"].ToString(); d.plumbashfryzuar = dr["plumbashfryzuar"].ToString(); lst.Add(d); } cnn.Close(); return(lst); }
private void btnRegjistroGjuajtjen_Click(object sender, EventArgs e) { #pragma warning disable CS0219 // The variable 'a' is assigned but its value is never used string a = "a"; #pragma warning restore CS0219 // The variable 'a' is assigned but its value is never used string kalbri = txtKalibri.Text; string distanca = Txtdistanca.Text; string maxplumba = txtMaxPlumba.Text; string klienti = dropklientat.Text; string Arma = droparmet.Text; gjuajtja = gjuajtjabll.gjuaje(kalbri, distanca, maxplumba, klienti, Arma); }
private void jFlatButton1_Click(object sender, EventArgs e) { FrmDashboard frm = new FrmDashboard(); this.klienti = dropklientat.Text; this.Arma = droparmet.Text; this.PiketEshenuara = Convert.ToInt32(txtKalibri.Text); this.distanca = Txtdistanca.Text; this.plumbashfryzuar = txtMaxPlumba.Text; gjuajtja ndryshoHjuajte = gjuajtjabll.ndryshogjuajte(klienti, Arma, distanca, plumbashfryzuar, PiketEshenuara); MessageBox.Show("Editimi u krye"); }