protected void btnDelete_Click(object sender, EventArgs e) { try { IDMjJed = int.Parse(ddlMjJed.SelectedValue); mjJed = mjJedinice.Find(x => x.IDMjernaJedinica == IDMjJed); SqlRepo.Instance.DeleteMjJed(mjJed); tbNaziv.Text = null; mjJedinice = SqlRepo.Instance.FetchMjJed(); FillDdlMjJed(); } catch (Exception) { } }
public void UpdateMjJed(MjJedinica mjJed) { using (SqlConnection con = new SqlConnection(cs)) { con.Open(); using (SqlCommand cmd = con.CreateCommand()) { if (!FetchMjJed().Contains(mjJed)) { cmd.CommandText = "UpdateMjJedinicu"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@naz", SqlDbType.VarChar).Value = mjJed.Naziv; cmd.Parameters.Add("@idmjjed", SqlDbType.VarChar).Value = mjJed.IDMjernaJedinica; object value = cmd.ExecuteNonQuery(); } } } }
private void SetEdit() { IDMjJed = int.Parse(ddlMjJed.SelectedValue); mjJed = mjJedinice.Find(x => x.IDMjernaJedinica == IDMjJed); tbNaziv.Text = mjJed.Naziv.ToString(); }