public static void LoadPublicher(SqlDataReader reader)
{
while (reader.Read())
{
Publichers publicher = new Publichers();
publicher.PublicherID = (int)reader["PublicherID"];
publicher.Title = reader["Title"].ToString();
publichers.Add(publicher);
}
}
public static void LoadPublicher(SqlDataReader reader)
{
while (reader.Read())
{
Publichers publicher = new Publichers();
publicher.PublicherID = (int)reader["PublicherID"];
publicher.Title = reader["Title"].ToString();
publichers.Add(publicher);
}
}
public static Publichers GetPublicher(int id)
{
Publichers publicher = new Publichers();
SearchConnect();
//if (!DataBase.GetStateConnection())
//{
// if (DataBase.GetSqlConnection().State == ConnectionState.Open)
// {
// string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString());
// SqlCommand command = new SqlCommand(query, DataBase.Sql);
// SqlDataReader reader = command.ExecuteReader();
// reader.Read();
// publicher.PublicherID = (int)reader["PublicherID"];
// publicher.Title = reader["Title"].ToString();
// reader.Close();
// }
//}
//else
//{
// string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString());
// SqlCommand command = new SqlCommand(query, DataBase.Sql);
// SqlDataReader reader = command.ExecuteReader();
// reader.Read();
// publicher.PublicherID = (int)reader["PublicherID"];
// publicher.Title = reader["Title"].ToString();
// reader.Close();
//}
foreach (Publichers pbl in PublichersManager.Publichers)
{
if (pbl.PublicherID == id)
{
publicher = pbl;
}
}
return(publicher);
}
public static Publichers GetPublicher(int id)
{
Publichers publicher = new Publichers();
SearchConnect();
//if (!DataBase.GetStateConnection())
//{
// if (DataBase.GetSqlConnection().State == ConnectionState.Open)
// {
// string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString());
// SqlCommand command = new SqlCommand(query, DataBase.Sql);
// SqlDataReader reader = command.ExecuteReader();
// reader.Read();
// publicher.PublicherID = (int)reader["PublicherID"];
// publicher.Title = reader["Title"].ToString();
// reader.Close();
// }
//}
//else
//{
// string query = string.Format("select * from Publichers where PublicherID = {0}", id.ToString());
// SqlCommand command = new SqlCommand(query, DataBase.Sql);
// SqlDataReader reader = command.ExecuteReader();
// reader.Read();
// publicher.PublicherID = (int)reader["PublicherID"];
// publicher.Title = reader["Title"].ToString();
// reader.Close();
//}
foreach (Publichers pbl in PublichersManager.Publichers)
{
if (pbl.PublicherID == id)
publicher = pbl;
}
return publicher;
}
public Publicher(Publichers pbl, string tl)
{
publicherFromList = pbl;
title = tl;
}
public Form3(Publichers pbl)
{
pblcrs = pbl;
type = 3;
InitializeComponent();
for (int i = 0; i < 2; i++)
{
Label lb = new Label();
lb.Location = new System.Drawing.Point(5, i * 20 + i * 2 + 5);
lb.AutoSize = true;
switch (i)
{
case 0: lb.Text = "PublicherID :"; break;
case 1: lb.Text = "Title :"; break;
default: break;
}
TextBox tB = new TextBox();
tB.Location = new System.Drawing.Point(90, i * 20 + i * 2 + 5);
tB.Size = new System.Drawing.Size(222, 20);
switch (i)
{
case 0: tB.Text = pbl.PublicherID.ToString(); tB.ReadOnly = true; break;
case 1: tB.Text = pbl.Title.ToString(); break;
default: break;
}
this.Controls.Add(lb);
this.Controls.Add(tB);
//Console.WriteLine("{0}: {1}", reader.GetName(i), reader[i]);
}
}
