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