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