public static List <ArmaBO> ListoArmet(string kerko, string po) { List <ArmaBO> lst = new List <ArmaBO>(); var cnn = DataConnection.GetConnection(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; if (po == "p") { cmd.CommandText = "select ArmaID,EmriArmes,Kalibri,MaxPlumba from Arma where EmriArmes like @kerko"; cmd.Parameters.AddWithValue("@kerko", kerko); } else { cmd.CommandText = "select ArmaID, EmriArmes,Kalibri,MaxPlumba from Arma"; } cmd.CommandType = CommandType.Text; cnn.Close(); cnn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ArmaBO d = new ArmaBO(); d.ArmaID = Convert.ToInt32(dr["ArmaID"]); d.EmriArmes = (dr["EmriArmes"].ToString()); d.Kalibiri = dr["Kalibri"].ToString(); d.MaxPlumba = Convert.ToInt32(dr["MaxPlumba"]); lst.Add(d); } cnn.Close(); return(lst); }
private void guna2Button1_Click(object sender, EventArgs e) { frmRegjistrimiArmes frmRegjistrimiArmes = new frmRegjistrimiArmes(); if (this.dsatagridArmet[0, dsatagridArmet.CurrentCell.RowIndex].Value.ToString() != null) { var d = new ArmaBO(); int ArmaID = Convert.ToInt32(this.dsatagridArmet[0, dsatagridArmet.CurrentCell.RowIndex].Value); string emriArmes = this.dsatagridArmet[1, dsatagridArmet.CurrentCell.RowIndex].Value.ToString(); string Kalibri = this.dsatagridArmet[2, dsatagridArmet.CurrentCell.RowIndex].Value.ToString(); int maxPlumba = Convert.ToInt32(this.dsatagridArmet[3, dsatagridArmet.CurrentCell.RowIndex].Value); frmRegjistrimiArmes.editoArmen(ArmaID, emriArmes, Kalibri, maxPlumba); } }
private void BtnFshij_Click(object sender, EventArgs e) { if (this.dsatagridArmet[0, dsatagridArmet.CurrentCell.RowIndex].Value.ToString() != null) { var d = new ArmaBO(); d.ArmaID = Convert.ToInt32(this.dsatagridArmet[0, dsatagridArmet.CurrentCell.RowIndex].Value); int qo = d.ArmaID; ArmaDAL.fshij(qo); LoadData(); } }