public static void LoadWriter(SqlDataReader reader) { while (reader.Read()) { Writers writer = new Writers(); writer.WriterID = (int)reader["WriterID"]; writer.FirstName = reader["FirstName"].ToString(); writer.LastName = reader["LastName"].ToString(); writers.Add(writer); } }
public static Writers GetWriter(int id) { Writers writer = new Writers(); SearchConnect(); //string query = string.Format("select * from Writers where WriterID = {0}", id.ToString()); //if (!DataBase.GetStateConnection()) //{ // if (DataBase.GetSqlConnection().State == ConnectionState.Open) // { // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // writer.WriterID = (int)reader["WriterID"]; // writer.FirstName = reader["FirstName"].ToString(); // writer.LastName = reader["LastName"].ToString(); // reader.Close(); // } //} //else //{ // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // writer.WriterID = (int)reader["WriterID"]; // writer.FirstName = reader["FirstName"].ToString(); // writer.LastName = reader["LastName"].ToString(); // reader.Close(); //} foreach (Writers wrt in WritersManager.Writers) { if (wrt.WriterID == id) { writer = wrt; } } return(writer); }
public static Writers GetWriter(int id) { Writers writer = new Writers(); SearchConnect(); //string query = string.Format("select * from Writers where WriterID = {0}", id.ToString()); //if (!DataBase.GetStateConnection()) //{ // if (DataBase.GetSqlConnection().State == ConnectionState.Open) // { // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // writer.WriterID = (int)reader["WriterID"]; // writer.FirstName = reader["FirstName"].ToString(); // writer.LastName = reader["LastName"].ToString(); // reader.Close(); // } //} //else //{ // SqlCommand command = new SqlCommand(query, DataBase.Sql); // SqlDataReader reader = command.ExecuteReader(); // reader.Read(); // writer.WriterID = (int)reader["WriterID"]; // writer.FirstName = reader["FirstName"].ToString(); // writer.LastName = reader["LastName"].ToString(); // reader.Close(); //} foreach (Writers wrt in WritersManager.Writers) { if (wrt.WriterID == id) writer = wrt; } return writer; }
public Form3(Writers wrt) { wrtrs = wrt; type = 2; InitializeComponent(); for (int i = 0; i < 3; 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 = "WriterID :"; break; case 1: lb.Text = "First Name :"; break; case 2: lb.Text = "Last Name :"; 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); //tB.ReadOnly = true; switch (i) { case 0: tB.Text = wrt.WriterID.ToString(); tB.ReadOnly = true; break; case 1: tB.Text = wrt.FirstName.ToString(); break; case 2: tB.Text = wrt.LastName.ToString(); break; default: break; } this.Controls.Add(lb); this.Controls.Add(tB); //Console.WriteLine("{0}: {1}", reader.GetName(i), reader[i]); } }
public Writer(Writers wrt, string fn, string ln) { writerFromList = wrt; firstLastName = fn + " " + ln; }