public static int Compare(GalTableField arg1, GalTableField arg2)
{
if (arg1.Number >= arg2.Number)
{
return(1);
}
if (arg1.Number <= arg2.Number)
{
return(-1);
}
return(0);
}
protected void Page_Load(object sender, EventArgs e)
{
LoginErrorLabel.ForeColor = Color.Red;
LoginErrorLabel.Font.Size = 18;
LoginErrorLabel.Visible = false;
Table1.Width = TableWidth;
Table1.Font.Size = 24;
TableRow tr1 = new TableRow();
TableCell td11 = new TableCell(); Label l11 = new Label();
l11.Text = "Галерея"; td11.Controls.Add(l11); tr1.Cells.Add(td11);
tr1.HorizontalAlign = HorizontalAlign.Center;
tr1.Width = TableWidth;
Table1.Rows.Add(tr1);
List <GalTableField> rows = new List <GalTableField>();
string QueryText = "select ID,Gallery_Number,Gallery_Name from Gallery_List";
string DB = @"Data Source=DESKTOP-5582JAK\SQLEXPRESS; Initial Catalog=Galery; Integrated Security=true";
using (SqlConnection Conn = new SqlConnection(DB))
{
Conn.Open();
SqlCommand Comm = new SqlCommand(QueryText, Conn);
SqlDataReader R = Comm.ExecuteReader();
while (R.Read())
{
rows.Add(new GalTableField(R.GetInt32(0), R.GetInt32(1), R[2].ToString()));
}
rows.Sort((x, y) => GalTableField.Compare(x, y));
for (int i = 0; i < rows.Count; i++)
{
TableRow tr2 = new TableRow();
TableCell td1 = new TableCell();
rows[i].NameButton.Command += new CommandEventHandler(b4_Command);
td1.Controls.Add(rows[i].NameButton);
tr2.Cells.Add(td1);
tr2.Width = TableWidth;
Table1.Rows.Add(tr2);
}
}
}
private void DrawTable()
{
//string DB = @"Data Source=DESKTOP-5582JAK\SQLEXPRESS; Initial Catalog=Galery; Integrated Security=true";
int TableWidth = 400;
Table1.Width = TableWidth + 3 * GalTableField.ButtonsWidth;
Table1.Font.Size = 18;
Table1.Rows.Clear();
TableRow tr1 = new TableRow();
TableCell td11 = new TableCell();
TableCell td12 = new TableCell();
TableCell td13 = new TableCell();
Label l11 = new Label();
Label l12 = new Label();
Label l13 = new Label();
l11.Text = "ID"; td11.Controls.Add(l11); tr1.Cells.Add(td11);
l12.Text = "Номер галереї"; td12.Controls.Add(l12); tr1.Cells.Add(td12);
l13.Text = "Галерея"; td13.Controls.Add(l13); tr1.Cells.Add(td13);
tr1.HorizontalAlign = HorizontalAlign.Center;
tr1.Width = TableWidth + 3 * GalTableField.ButtonsWidth;
Table1.Rows.Add(tr1);
rows = new List <GalTableField>();
string QueryText = "select ID,Gallery_Number,Gallery_Name from Gallery_List";
using (SqlConnection Conn = new SqlConnection(DB))
{
Conn.Open();
SqlCommand Comm = new SqlCommand(QueryText, Conn);
SqlDataReader R = Comm.ExecuteReader();
while (R.Read())
{
rows.Add(new GalTableField(R.GetInt32(0), R.GetInt32(1), R[2].ToString()));
}
rows.Sort((x, y) => GalTableField.Compare(x, y));
for (int i = 0; i < rows.Count; i++)
{
TableRow tr2 = new TableRow();
TableCell td02 = new TableCell();
td02.Controls.Add(rows[i].IDLabel);
tr2.Cells.Add(td02);
TableCell td01 = new TableCell();
td01.Controls.Add(rows[i].NumberLabel);
tr2.Cells.Add(td01);
TableCell td1 = new TableCell();
rows[i].NameButton.Command += new CommandEventHandler(b4_Command);
td1.Controls.Add(rows[i].NameButton);
tr2.Cells.Add(td1);
TableCell td2 = new TableCell();
rows[i].Up.Command += new CommandEventHandler(upRecord);
rows[i].Up.CssClass = "DynamicButtons";
rows[i].Up.OnClientClick = "hide_all()";
td2.Controls.Add(rows[i].Up);
tr2.Cells.Add(td2);
TableCell td3 = new TableCell();
rows[i].Down.Command += new CommandEventHandler(downRecord);
rows[i].Down.CssClass = "DynamicButtons";
rows[i].Down.OnClientClick = "hide_all()";
td3.Controls.Add(rows[i].Down);
tr2.Cells.Add(td3);
TableCell td4 = new TableCell();
rows[i].Delete.Command += new CommandEventHandler(deleteRecord);
rows[i].Delete.CssClass = "DynamicButtons";
rows[i].Delete.OnClientClick = "hide_all()";
td4.Controls.Add(rows[i].Delete);
tr2.Cells.Add(td4);
tr2.Width = TableWidth + 3 * GalTableField.ButtonsWidth;
tr2.HorizontalAlign = HorizontalAlign.Center;
Table1.Rows.Add(tr2);
}
}
}
