public void LoadPointer(int IDLantai)
{
AllPointer.Clear();
con.Open();
string SelectQuery = "SELECT LocX, LocY, Pointer FROM Ruang WHERE PetaID = " + IDLantai;
SqlCommand command = new SqlCommand(SelectQuery, con);
SqlDataReader read = command.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
var locx = read.GetInt32(0);
var locy = read.GetInt32(1);
var name = read.GetString(2);
var Pini = new PExist(locx, locy, name);
AllPointer.Add(Pini);
Pointer P = ReadPointer(locx, locy, name);
pbPetaLantai.Controls.Add(P);
P.MouseDown += new System.Windows.Forms.MouseEventHandler(this.PointerDown);
P.MouseMove += new System.Windows.Forms.MouseEventHandler(this.PointerDrag);
P.Move += new System.EventHandler(this.PointerMove);
P.Click += new System.EventHandler(this.PointerClick);
// var locx = AllPointer[PointerID].LocX;
}
maxCounter = AllPointer.Count;
LastPointer = Convert.ToInt32(AllPointer[maxCounter - 1].Name);
con.Close();
PopulateButton();
ListPoint(IDLantai);
NotSave = false;
}
else
{
con.Close();
MessageBox.Show("Tambahkan Pointer");
buttonPrev.Enabled = false;
buttonNext.Enabled = false;
}
}
public void LoadPointer(int IDLantai)
{
con.Open();
string SelectQuery = "SELECT LocX, LocY, Pointer FROM Ruang WHERE PetaID = " + IDLantai;
SqlCommand command = new SqlCommand(SelectQuery, con);
SqlDataReader read = command.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
var locx = read.GetInt32(0);
var locy = read.GetInt32(1);
var name = read.GetString(2);
var Pini = new PExist(locx, locy, name);
AllPointer.Add(Pini);
Pointer P = ReadPointer(locx, locy, name);
pbPetaLantai.Controls.Add(P);
}
con.Close();
maxCounter = AllPointer.Count;
PreviewDetail(AllPointer[0].Name);
}
else
{
maxCounter = 1;
labelJudul.Text = "Pointer belum diatur";
textBoxIsi.Text = "";
Bitmap bmp = new Bitmap(Properties.Resources.defaultPic);
pictureBoxRuang.Image = bmp;
}
PopulateButton();
}
