public void SelectAllObjektet() { SqlConnection con = Generals.GetNewConnection(); try { SqlCommand cmd = new SqlCommand("ObjektiSelectAll", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Objekti o = new Objekti(); o.ObjektiID = (int)rdr["ObjektiID"]; if (rdr["Lokacioni"] != DBNull.Value) { o.Lokacioni = (string)rdr["Lokacioni"]; } mObjektet.Add(o); } } finally { con.Close(); } }
private void DeleteForm(int ID, string page) { if (page == "/Views/Produktet/Index.aspx") { Objekti obj = new Objekti(); obj.ObjektiID = ID; ObjektiMapper objm = new ObjektiMapper(obj); objm.Delete(); } }
public void placeShenimet() { Index form = (Index)Context.Handler; int ID = form.SelectedID; ViewState["SelectedID"] = ID; Objekti ex = new Objekti(); ObjektiMapper em = new ObjektiMapper(ex); em.SelectedID(ID); LokacioniTextBox.Text = ex.Lokacioni; }
public void Dodaj(Objekat obj) { try { if (ProveriKoordinate(obj.X, obj.Y)) { Objekti.Add(obj); } else { throw new ArgumentException(); } } catch { throw new ArgumentException(); } }
protected void SaveButton_Click(object sender, EventArgs e) { if (LokacioniTextBox.Text.Length == 0) { lblError.Visible = true; LokacioniTextBox.Focus(); return; } else { Objekti obj = new Objekti(); obj.Lokacioni = LokacioniTextBox.Text; ObjektiMapper objm = new ObjektiMapper(obj); objm.Insert(); Response.Redirect("Index.aspx"); } }
protected void SaveButton_Click(object sender, EventArgs e) { if (LokacioniTextBox.Text.Length == 0) { lblError.Visible = true; LokacioniTextBox.Focus(); return; } else { int ID = Convert.ToInt32(ViewState["SelectedID"].ToString()); Objekti ex = new Objekti(); ObjektiMapper em = new ObjektiMapper(ex); em.SelectedID(ID); ex.Lokacioni = LokacioniTextBox.Text; em.Update(); Response.Redirect("Index.aspx"); } }
public ObjektiMapper(Objekti o) { mObjekti = o; }