public UslugiCategory(JournalUslugiItem item) { this.Checked = item.Is_Paid; this.ShortName = item.UslugaShortName; this.Name = item.UslugaName; this.Description = item.Description; this.ID = item.Id_Uslugi; this.Price = item.Price; }
public static List<JournalUslugiItem> GetJournalUslugiItems(int id) { List<JournalUslugiItem> journalList = new List<JournalUslugiItem>(); try { SqlConnection connection = OpenConnection(); if ((connection == null) || (connection.State == ConnectionState.Closed)) return null; SqlCommand ngCommand = connection.CreateCommand(); ngCommand.CommandType = CommandType.StoredProcedure; ngCommand.CommandText = GET_JOURNALUSLUGIITEMS_REGISRTY; ngCommand.Parameters.AddWithValue("@journalId", id); // ngCommand.CommandTimeout = CommandTimeOut > 2 * connection.ConnectionTimeout ? CommandTimeOut : 2 * connection.ConnectionTimeout; ngCommand.ExecuteNonQuery(); SqlDataReader reader = null; if (connection != null) { reader = ngCommand.ExecuteReader(); while (reader.Read()) { JournalUslugiItem newItem = new JournalUslugiItem(); // newItem.Date = (DateTime)reader["Date"]; newItem.Id_Uslugi = (int)reader["ID_Uslugi"]; newItem.Id_Journal = (int)reader["ID_Journal"]; newItem.ID_Client = (int)reader["ID_Client"]; newItem.ID = (int)reader["ID"]; newItem.Price = (double)reader["Price"]; newItem.Is_Paid = (bool)reader["IsPaid"]; newItem.UslugaName = (string)reader["UslugaName"]; newItem.Date = (DateTime)reader["Date"]; newItem.UslugaShortName = (string)reader["UslugaShortName"]; journalList.Add(newItem); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); CloseConnection(); return null; } CloseConnection(); return journalList; }
public static List<JournalUslugiItem> GetClientUslugiItemsExt(int IdJournal) { List<JournalUslugiItem> itemList = new List<JournalUslugiItem>(); try { SqlConnection connection = OpenConnection(); if ((connection == null) || (connection.State == ConnectionState.Closed)) return null; SqlCommand ngCommand = connection.CreateCommand(); ngCommand.CommandType = CommandType.StoredProcedure; ngCommand.CommandText = GET_CLIENTSUSLUGIITEMS_REGISRTY; ngCommand.Parameters.AddWithValue("@journalID", IdJournal); // ngCommand.CommandTimeout = CommandTimeOut > 2 * connection.ConnectionTimeout ? CommandTimeOut : 2 * connection.ConnectionTimeout; ngCommand.ExecuteNonQuery(); SqlDataReader reader = null; if (connection != null) { reader = ngCommand.ExecuteReader(); while (reader.Read()) { JournalUslugiItem newItem= new JournalUslugiItem(); newItem.UslugaShortName = (string)reader["UslugaShortName"]; newItem.Price = (double)reader["Price"]; if (!DBNull.Value.Equals(reader["IsAnalize"])) newItem.IsAnalize = (bool)reader["IsAnalize"]; else newItem.IsAnalize = false; itemList.Add(newItem); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); CloseConnection(); return null; } CloseConnection(); return itemList; }