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