public IEnumerable <Employee> GetEmployees()
{
string selectCommand = @" SELECT id_gamma, ename, case when barcode is not null then barcode else '' END barcode FROM Employee order by ename";
using (SqlCeConnection connect = new SqlCeConnection(Datasource))
{
connect.Open();
using (SqlCeCommand command = new SqlCeCommand(selectCommand, connect))
{
using (SqlCeDataReader reader = command.ExecuteReader())
{
if (reader != null)
{
try
{
while (reader.Read())
{
yield return(new Employee()
{
GammaID = (int)reader.GetInt32(reader.GetOrdinal("id_gamma")),
Barcode = (reader.IsDBNull(reader.GetOrdinal("barcode")))?"" : reader.GetString(reader.GetOrdinal("barcode")),
Name = reader.GetString(reader.GetOrdinal("ename"))
});
}
}
finally
{
reader.Close();
}
}
}
}
}
}
public ForgotPassword(string userID)
{
InitializeComponent();
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
txtUsername.Text = userID;
if (!string.IsNullOrWhiteSpace(txtUsername.Text))
{
txtUsername.IsReadOnly = true;
SqlCeConnection conn = DBUtils.GetDBConnection();
conn.Open();
using (SqlCeCommand cmd = new SqlCeCommand("Select * from Accounts where userID = @userID", conn))
{
cmd.Parameters.AddWithValue("@userID", userID);
SqlCeDataReader reader = cmd.ExecuteResultSet(ResultSetOptions.Scrollable);
int ordinal = 0;
if (reader.Read())
{
ordinal = reader.GetOrdinal("securityQuestion");
question = reader.GetString(ordinal);
ordinal = reader.GetOrdinal("securityAnswer");
answer = reader.GetString(ordinal);
lblQuestion.Content = question;
lblQuestion.Visibility = Visibility.Visible;
txtAnswer.Visibility = Visibility.Visible;
txtAnswer.Focus();
}
reader.Close();
}
}
}
private void txtUsername_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
SqlCeConnection conn = DBUtils.GetDBConnection();
conn.Open();
userID = txtUsername.Text;
using (SqlCeCommand cmd = new SqlCeCommand("Select * from Accounts where userID = @userID", conn))
{
cmd.Parameters.AddWithValue("@userID", userID);
SqlCeDataReader reader = cmd.ExecuteResultSet(ResultSetOptions.Scrollable);
int ordinal = 0;
if (reader.Read())
{
ordinal = reader.GetOrdinal("securityQuestion");
question = reader.GetString(ordinal);
ordinal = reader.GetOrdinal("securityAnswer");
answer = reader.GetString(ordinal);
lblQuestion.Content = question;
unlockFields();
txtAnswer.Focus();
}
else
{
MessageBox.Show("Account does not exist.");
return;
}
reader.Close();
}
}
}
private static Semana DataReaderAObjeto(SqlCeDataReader rdrLector)
{
Semana Semana = new Semana();
Semana.ID = rdrLector.GetInt64(rdrLector.GetOrdinal("ID"));
Semana.Periodo = rdrLector.GetDateTime(rdrLector.GetOrdinal("Periodo"));
Semana.FechaDesde = rdrLector.GetDateTime(rdrLector.GetOrdinal("FechaDesde"));
Semana.FechaHasta = rdrLector.GetDateTime(rdrLector.GetOrdinal("FechaHasta"));
Semana.Agencia = new Agencia {
ID = rdrLector.GetInt64(rdrLector.GetOrdinal("IdAgencia"))
};
/*if (!rdrLector.IsDBNull(rdrLector.GetOrdinal("IdAgencia")))
* {
* Agencias Agencias = new Agencias(conn);
* Semana.Agencia = Agencias.GetByID(rdrLector.GetInt64(rdrLector.GetOrdinal("IdAgencia")));
* }*/
/*BSP_Tickets BSP_Tickets = new BSP_Tickets();
* Semana.TicketsBSP = BSP_Tickets.ObtenerPorSemana(Semana.ID);
*
* BO_Tickets BO_Tickets = new BO_Tickets();
* Semana.TicketsBO = BO_Tickets.ObtenerPorSemana(Semana.ID);*/
return(Semana);
}
protected virtual int? ReadIntOrNull(SqlCeDataReader reader, string columnName)
{
if (reader.IsDBNull(reader.GetOrdinal(columnName)))
return null;
return reader.GetInt32(reader.GetOrdinal(columnName));
}
protected virtual DateTime? ReadDateTimeOrNull(SqlCeDataReader reader, string columnName)
{
if (reader.IsDBNull(reader.GetOrdinal(columnName)))
return null;
return reader.GetDateTime(reader.GetOrdinal(columnName));
}
Transaction ReaderToTransaction(SqlCeDataReader reader, Resource par)
{
return(new Transaction(reader.GetInt32(reader.GetOrdinal(COLUMN_ID)), reader.GetInt32(reader.GetOrdinal(COLUMN_PAR_ID)),
reader.GetBoolean(reader.GetOrdinal(COLUMN_IS_REMOVAL)), reader.GetInt32(reader.GetOrdinal(COLUMN_TRANS_NUM)), par,
reader.GetString(reader.GetOrdinal(COLUMN_COMMENT)), reader.GetString(reader.GetOrdinal(COLUMN_DATE_CREATED)),
reader.GetString(reader.GetOrdinal(COLUMN_SHORT_DATE))));
}
public ReportSpecific(int studNo)
{
InitializeComponent();
this.studNo = studNo;
conn.Open();
using (SqlCeCommand cmd = new SqlCeCommand("SELECT LastName + ', ' + FirstName + ' ' + COALESCE(MiddleName, '') AS [Full Name], ResidenceStatus, CounterProbi FROM StudentInfo WHERE StudentNo = @studentNo", conn))
{
cmd.Parameters.AddWithValue("@studentNo", studNo);
using (SqlCeDataReader reader = cmd.ExecuteResultSet(ResultSetOptions.Scrollable))
{
if (reader.Read())
{
int fullNameIndex = reader.GetOrdinal("Full Name");
fullName = Convert.ToString(reader.GetValue(fullNameIndex));
int residenceIndex = reader.GetOrdinal("ResidenceStatus");
residence = Convert.ToString(reader.GetValue(residenceIndex));
int probiCountIndex = reader.GetOrdinal("CounterProbi");
probiCount = Convert.ToInt32(reader.GetValue(probiCountIndex));
}
}
}
txtStudNo.Text = studNo.ToString();
txtResidence.Text = residence;
txtFullName.Text = fullName;
txtProb.Text = AddOrdinal(probiCount);
updateListView();
}
/// <summary>
/// Returns editionID of give EditionGUID; will create a new entry into the editions table if unknown
/// </summary>
/// <param name="editionGuid">GUID of edition</param>
/// <returns>Returns editionID of given EditionGUID</returns>
private int GetEditionID(string editionGuid)
{
int editionID = -1;
lock (this.databaseSyncRoot)
{
this.selectEditionCommand.Parameters["@editionGuid"].Value = editionGuid;
SqlCeDataReader reader = this.selectEditionCommand.ExecuteReader();
if (!reader.Read())
{
// edition unknown, create new entry:
this.insertEditionCommand.Parameters["@editionGuid"].Value = editionGuid;
this.insertEditionCommand.ExecuteNonQuery();
// re-read to get newly created editionID
reader = this.selectEditionCommand.ExecuteReader();
if (reader.Read())
{
editionID = reader.GetInt32(reader.GetOrdinal("EditionID"));
}
}
else
{
editionID = reader.GetInt32(reader.GetOrdinal("EditionID"));
}
}
return(editionID);
}
private void txtName_TextChanged(object sender, TextChangedEventArgs e)
{
SqlCeConnection conn = DBUtils.GetDBConnection();
conn.Open();
using (SqlCeCommand cmd = new SqlCeCommand("SELECT LastName, firstName from StudentInfo WHERE (LastName LIKE @lastName ) or (firstName LIKE @firstName)", conn))
{
cmd.Parameters.AddWithValue("@lastName", txtLastName.Text + "%");
cmd.Parameters.AddWithValue("@firstName", txtFirstName.Text + "%");
using (SqlCeDataReader reader = cmd.ExecuteResultSet(ResultSetOptions.Scrollable))
{
lvListStudent.Items.Clear();
i = 1;
if (reader.HasRows)
{
while (reader.Read())
{
int lastNameIndex = reader.GetOrdinal("LastName");
string lastName = Convert.ToString(reader.GetValue(lastNameIndex));
int firstNameIndex = reader.GetOrdinal("firstName");
string firstName = Convert.ToString(reader.GetValue(firstNameIndex));
lvListStudent.Items.Add(new ListViewSearchStudent
{
i = this.i,
LastName = lastName,
FirstName = firstName
});
i++;
}
}
}
}
conn.Close();
}
public IEnumerable <ScanLog> GetAllScansLog()
{
Scan scan = null;
string selectCommand = @" SELECT * FROM ScanLog ";
using (SqlCeConnection connect = new SqlCeConnection(Datasource))
{
connect.Open();
using (SqlCeCommand command = new SqlCeCommand(selectCommand, connect))
{
using (SqlCeDataReader reader = command.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
yield return(new ScanLog((int)reader.GetInt32(reader.GetOrdinal("artcode")),
(int)reader.GetInt32(reader.GetOrdinal("id_gamma")),
(int)reader.GetInt32(reader.GetOrdinal("Qty")),
(string)reader.GetString(reader.GetOrdinal("Dt")),
(string)reader.GetString(reader.GetOrdinal("Barcode")),
(AType)(int)reader.GetSqlInt32(reader.GetOrdinal("ActionType"))));
}
}
}
}
}
}
private static Agencia DataReaderAObjeto(SqlCeDataReader rdrLector)
{
Agencia oAgencia = new Agencia();
oAgencia.ID = rdrLector.GetInt64(rdrLector.GetOrdinal("ID"));
oAgencia.Nombre = rdrLector.GetString(rdrLector.GetOrdinal("Nombre"));
return(oAgencia);
}
private static Concepto DataReaderAObjeto(SqlCeDataReader rdrLector)
{
Concepto oConcepto = new Concepto();
oConcepto.ID = rdrLector.GetInt64(rdrLector.GetOrdinal("ID"));
oConcepto.Nombre = rdrLector.GetString(rdrLector.GetOrdinal("Nombre"));
oConcepto.Tipo = rdrLector.GetString(rdrLector.GetOrdinal("Tipo"))[0];
return(oConcepto);
}
private void updateRecords()
{
SqlCeConnection conn = DBUtils.GetDBConnection();
conn.Open();
borrowers.Clear();
using (SqlCeCommand cmd = new SqlCeCommand("SELECT DISTINCT bl.prodCode, ai.name, ai.manuf, bl.qty, bl.breakage, ai.size from BorrowerList bl INNER JOIN ApparatusInventory ai on bl.prodCode = ai.prodCode where bl.studentNo = @studentNo and bl.groupID = @grpID and bl.lockNo = @lockNo and bl.subject = @subj and bl.expName = @experiment and bl.dateReq = @dateReq and bl.dateExp = @dateExp", conn))
{
cmd.Parameters.AddWithValue("@studentNo", studentNo);
cmd.Parameters.AddWithValue("@subj", txtSubj.Text);
cmd.Parameters.AddWithValue("@grpID", txtGrpID.Text);
cmd.Parameters.AddWithValue("@experiment", txtExpName.Text);
cmd.Parameters.AddWithValue("@lockNo", txtLockNo.Text);
cmd.Parameters.AddWithValue("@dateReq", txtDateReq.Text);
cmd.Parameters.AddWithValue("@dateExp", txtDateExp.Text);
using (SqlCeDataReader reader = cmd.ExecuteResultSet(ResultSetOptions.Scrollable))
{
if (reader.HasRows)
{
while (reader.Read())
{
int nameIndex = reader.GetOrdinal("name");
string name = Convert.ToString(reader.GetValue(nameIndex));
int manufIndex = reader.GetOrdinal("manuf");
string manuf = Convert.ToString(reader.GetValue(manufIndex));
int qtyIndex = reader.GetOrdinal("qty");
int qty = Convert.ToInt32(reader.GetValue(qtyIndex));
int sizeIndex = reader.GetOrdinal("size");
string size = Convert.ToString(reader.GetValue(sizeIndex));
int breakageIndex = reader.GetOrdinal("breakage");
bool breakage = Convert.ToBoolean(reader.GetValue(breakageIndex));
borrowers.Add(new LVBorrower
{
breakage = breakage,
prodName = name,
manuf = manuf,
qty = qty,
size = size
});
}
}
else
{
this.NavigationService.Navigate(new BorrowersList());
}
}
}
}
private static Compania DataReaderAObjeto(SqlCeDataReader rdrLector)
{
Compania oCompania = new Compania();
oCompania.ID = rdrLector.GetInt64(rdrLector.GetOrdinal("ID"));
oCompania.Nombre = rdrLector.GetString(rdrLector.GetOrdinal("Nombre"));
if (!rdrLector.IsDBNull(rdrLector.GetOrdinal("Codigo")))
{
oCompania.Codigo = rdrLector.GetString(rdrLector.GetOrdinal("Codigo"));
}
return(oCompania);
}
public override UserVO ReadRecord(SqlCeDataReader reader)
{
UserVO result = new UserVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
result.Username = reader[userName].ToString();
result.Password = reader[userPassword].ToString();
result.IsActive = reader.GetBoolean(reader.GetOrdinal(userIsActive));
result.IsLoggedIn = reader.GetBoolean(reader.GetOrdinal(userIsLoggedIn));
return(result);
}
private bool loadBillData(SqlCeConnection connection)
{
try
{
using (SqlCeCommand command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM BILLMASTER WHERE ID = " + billToEdit.Value;
using (SqlCeDataReader reader = command.ExecuteReader())
{
reader.Read();
billDateField.Value = reader.GetDateTime(reader.GetOrdinal("BillDate"));
object val = reader.GetValue(reader.GetOrdinal("CustomerID"));
if (val == DBNull.Value)
{
cashBillButton.Checked = true;
}
else
{
creditBillButton.Checked = true;
customerNameField.SelectedValue = (int)val;
}
decimal amount = reader.GetDecimal(reader.GetOrdinal("DiscountAmount"));
discountField.Text = amount.ToString("N2");
amount = reader.GetDecimal(reader.GetOrdinal("ExpenseAmount"));
expenseAmountField.Text = amount.ToString("N2");
val = reader.GetValue(reader.GetOrdinal("ExpenseText"));
if (val != DBNull.Value)
{
expenseTextField.Text = (string)val;
}
}
}
loadBillDetails(connection);
}
catch (Exception ex)
{
string message = "An error occurred in loading the bill data. \nThe error text is as follows:\n"
+ Global.getExceptionText(ex);
SystemSounds.Hand.Play();
Cursor.Current = Cursors.Default;
MessageBox.Show(message, "Error in Loading Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogger.LogError(ex);
return(false);
}
return(true);
}
private void searchUser_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
if (string.IsNullOrEmpty(txtUser.Text))
{
MessageBox.Show("Username field is empty!");
txtUser.Focus();
}
else
{
SqlCeConnection conn = DBUtils.GetDBConnection();
conn.Open();
using (SqlCeCommand cmd = new SqlCeCommand("Select COUNT(1) from Accounts where username = @username", conn))
{
cmd.Parameters.AddWithValue("@username", txtUser.Text);
int userCount;
userCount = (int)cmd.ExecuteScalar();
if (userCount > 0)
{
using (SqlCeCommand cmd1 = new SqlCeCommand("SELECT * from Accounts where username = @username", conn))
{
cmd1.Parameters.AddWithValue("@username", txtUser.Text);
using (SqlCeDataReader reader = cmd1.ExecuteResultSet(ResultSetOptions.Scrollable))
{
if (reader.HasRows)
{
reader.Read();
int firstNameIndex = reader.GetOrdinal("firstName");
string firstName = Convert.ToString(reader.GetValue(firstNameIndex));
int lastNameIndex = reader.GetOrdinal("lastName");
string lastName = Convert.ToString(reader.GetValue(lastNameIndex));
int securityQuestionIndex = reader.GetOrdinal("securityQuestion");
string securityQuestion = Convert.ToString(reader.GetValue(securityQuestionIndex));
txtFirstName.Text = firstName;
txtLastName.Text = lastName;
cmbQuestion.Text = securityQuestion;
}
}
}
}
else
{
MessageBox.Show("User does not exist!");
}
}
}
}
public static Customer GetCustomerFromReader(SqlCeDataReader reader)
{
if (reader != null)
{
Customer customer = new Customer();
customer.CustomerID = (long)reader["CustomerID"];
if (!reader.IsDBNull(reader.GetOrdinal("ResponsiblePartyID")))
{
customer.ResponsiblePartyID = (long)reader["ResponsiblePartyID"];
}
Customer.Types type;
Enum.TryParse<Customer.Types>(reader["Type"].ToString(), out type);
customer.Type = type;
customer.PersonID = (long)reader["PersonID"];
customer.FirstName = reader["FirstName"].ToString();
customer.LastName = reader["LastName"].ToString();
customer.DateOfBirth = DateTime.Parse(reader["DateOfBirth"].ToString());
Person.PersonTypes personType;
Enum.TryParse<Person.PersonTypes>(reader["PersonType"].ToString(), out personType);
customer.PersonType = personType;
customer.Email = reader["Email"].ToString();
customer.Password = reader["Password"].ToString();
customer.SetAddress(AddressDB.GetAddressFromReader(reader));
return customer;
}
return null;
}
public override MessageVO ReadRecord(SqlCeDataReader reader)
{
MessageVO result = new MessageVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
result.FromUser = udao.GetItem(reader.GetInt32(reader.GetOrdinal(messageFrom)));
result.ToUser = udao.GetItem(reader.GetInt32(reader.GetOrdinal(messageTo)));
udao.CloseConnection();
result.Date = reader.GetDateTime(reader.GetOrdinal(messageDate));
result.IsSeen = reader.GetBoolean(reader.GetOrdinal(messageIsSeen));
result.Body = reader[messageBody].ToString();
return(result);
}
protected virtual Guid? ReadGuidOrNull(SqlCeDataReader reader, string columnName)
{
if(reader.IsDBNull(reader.GetOrdinal(columnName)))
return null;
return ReadGuid(reader, columnName);
}
public override CategoryVO ReadRecord(SqlCeDataReader reader)
{
CategoryVO result = new CategoryVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
result.Name = reader[categoryName].ToString();
return(result);
}
public override OperationVO ReadRecord(SqlCeDataReader reader)
{
OperationVO result = new OperationVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
result.Name = reader[operationName].ToString();
return(result);
}
/// <summary>
/// Повертає список усіх товарів
/// </summary>
/// <returns>Список товарів</returns>
public IEnumerable <IProductsModel> GetAll()
{
List <ProductsModel> products = new List <ProductsModel>();
using (var db = new SqlCeConnection(connectionString))
{
try
{
db.Open();
}
catch (SqlCeException)
{
throw new Exception("Немає підключення до бази даних.");
}
string query = "select Id, SupplierId, CategoryId, GroupId, UnitId, NameWebStore, NameSupplier, CodeWebStore, " +
"CodeSupplier, PriceWebStore, PriceSupplier, Available, LinkWebStore, LinkSupplier, Notes from Products";
using (SqlCeCommand command = new SqlCeCommand(query, db))
{
try
{
using (SqlCeDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductsModel product = new ProductsModel
{
Id = Convert.ToInt32(reader["Id"]),
SupplierId = Convert.ToInt32(reader["SupplierId"]),
CategoryId = Convert.ToInt32(reader["CategoryId"]),
GroupId = reader.IsDBNull(reader.GetOrdinal("GroupId")) ? 0 : Convert.ToInt32(reader["GroupId"]),
UnitId = Convert.ToInt32(reader["UnitId"]),
NameWebStore = reader["NameWebStore"].ToString(),
NameSupplier = reader["NameSupplier"].ToString(),
CodeWebStore = reader["CodeWebStore"].ToString(),
CodeSupplier = reader["CodeSupplier"].ToString(),
PriceWebStore = Convert.ToDecimal(reader["PriceWebStore"]),
PriceSupplier = Convert.ToDecimal(reader["PriceSupplier"]),
Available = reader["Available"].ToString(),
LinkWebStore = reader["LinkWebStore"].ToString(),
LinkSupplier = reader["LinkSupplier"].ToString(),
Notes = reader["Notes"].ToString()
};
products.Add(product);
}
}
}
catch (SqlCeException)
{
throw new Exception("Помилка отримання списку товарів з бази даних.");
}
}
}
return(products);
}
protected string getString(SqlCeDataReader reader, string columnName)
{
int index = reader.GetOrdinal(columnName);
if (!reader.IsDBNull(index))
{
return(reader.GetString(index));
}
return(null);
}
protected float?getFloat(SqlCeDataReader reader, string columnName)
{
int index = reader.GetOrdinal(columnName);
if (!reader.IsDBNull(index))
{
return((float)reader.GetFloat(index));
}
return(null);
}
private void updateListView()
{
SqlCeConnection conn = DBUtils.GetDBConnection();
conn.Open();
using (SqlCeCommand cmd = new SqlCeCommand("SELECT * from ApparatusInventory", conn))
{
summary.Clear();
using (SqlCeDataReader reader = cmd.ExecuteResultSet(ResultSetOptions.Scrollable))
{
while (reader.Read())
{
int prodCodeIndex = reader.GetOrdinal("prodCode");
string prodCode = Convert.ToString(reader.GetValue(prodCodeIndex));
int inventNameIndex = reader.GetOrdinal("name");
string inventName = Convert.ToString(reader.GetValue(inventNameIndex));
int manufIndex = reader.GetOrdinal("manuf");
string manuf = Convert.ToString(reader.GetValue(manufIndex));
int qtyIndex = reader.GetOrdinal("qty");
int qty = Convert.ToInt32(reader.GetValue(qtyIndex));
int sizeIndex = reader.GetOrdinal("size");
string size = Convert.ToString(reader.GetValue(sizeIndex));
summary.Add(new LVOutstanding
{
i = i,
prodCode = prodCode,
inventName = inventName,
manuf = manuf,
qty = qty.ToString(),
size = size,
});
i++;
}
}
}
}
/// <summary>
/// Повертає товар по ідентифікатору
/// </summary>
/// <param name="id">Ідентифікатор товару</param>
/// <returns>Екземпляр товару</returns>
public IProductsModel GetById(int id)
{
ProductsModel product = new ProductsModel();
using (var db = new SqlCeConnection(connectionString))
{
try
{
db.Open();
}
catch (SqlCeException)
{
throw new Exception("Немає підключення до бази даних.");
}
string query = "select Id, SupplierId, CategoryId, GroupId, UnitId, NameWebStore, NameSupplier, CodeWebStore, " +
"CodeSupplier, PriceWebStore, PriceSupplier, Available, LinkWebStore, LinkSupplier, Notes from Products where Id=@Id";
using (SqlCeCommand cmd = new SqlCeCommand(query, db))
{
cmd.Prepare();
cmd.Parameters.AddWithValue("@Id", id);
try
{
using (SqlCeDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
product.Id = Convert.ToInt32(reader["Id"]);
product.SupplierId = Convert.ToInt32(reader["SupplierId"]);
product.CategoryId = Convert.ToInt32(reader["CategoryId"]);
product.GroupId = reader.IsDBNull(reader.GetOrdinal("GroupId")) ? 0 : Convert.ToInt32(reader["GroupId"]);
product.UnitId = Convert.ToInt32(reader["UnitId"]);
product.NameWebStore = reader["NameWebStore"].ToString();
product.NameSupplier = reader["NameSupplier"].ToString();
product.CodeWebStore = reader["CodeWebStore"].ToString();
product.CodeSupplier = reader["CodeSupplier"].ToString();
product.PriceWebStore = Convert.ToDecimal(reader["PriceWebStore"]);
product.PriceSupplier = Convert.ToDecimal(reader["PriceSupplier"]);
product.Available = reader["Available"].ToString();
product.LinkWebStore = reader["LinkWebStore"].ToString();
product.LinkSupplier = reader["LinkSupplier"].ToString();
product.Notes = reader["Notes"].ToString();
}
}
}
catch (SqlCeException)
{
throw new Exception("Помилка отримання товару з бази даних.");
}
}
}
return(product);
}
private void populateControlsWithData(SqlCeDataReader reader)
{
int customerID = reader.GetInt32(reader.GetOrdinal("CustomerID"));
customerNameCombo.SelectedValue = customerID;
paymentDatePicker.Value = reader.GetDateTime(reader.GetOrdinal("PaymentDate"));
decimal amount = reader.GetDecimal(reader.GetOrdinal("Amount"));
amountField.Text = amount.ToString("N2");
string paymentMode = reader.GetString(reader.GetOrdinal("PaymentMode"));
switch (paymentMode)
{
case "C":
cashButton.Checked = true;
break;
case "Q":
chequeButton.Checked = true;
break;
case "D":
demandDraftButton.Checked = true;
break;
}
object value = reader.GetValue(reader.GetOrdinal("InstrumentNumber"));
if (value != DBNull.Value)
{
instrumentNumberField.Text = (string)value;
}
value = reader.GetValue(reader.GetOrdinal("Notes"));
if (value != DBNull.Value)
{
notesField.Text = (string)value;
}
string errorText;
decimal?balanceAmount = GlobalMethods.GetCustomerBalance(customerID,
out errorText);
if (!balanceAmount.HasValue)
{
string message = "An error occurred in fetching the customer's balance from the database."
+ "\nThe error text is as follows:\n" + errorText;
Cursor.Current = Cursors.Default;
SystemSounds.Exclamation.Play();
MessageBox.Show(message, "Error in Fetching Account Balance", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
return;
}
balanceAmount = balanceAmount.Value - amount;
balanceField.Text = GlobalMethods.GetBalanceAsString(balanceAmount.Value);
}
public IEnumerable <Scan> GetAllScans()
{
Scan scan = null;
string selectCommand = @" SELECT * FROM scan ";
using (SqlCeConnection connect = new SqlCeConnection(Datasource))
{
connect.Open();
using (SqlCeCommand command = new SqlCeCommand(selectCommand, connect))
{
using (SqlCeDataReader reader = command.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
yield return(new Scan((int)reader.GetInt32(reader.GetOrdinal("artcode")),
(int)reader.GetInt32(reader.GetOrdinal("id_gamma")),
(int)reader.GetInt32(reader.GetOrdinal("qty")))
{
Dt = reader.GetDateTime(reader.GetOrdinal("dt")),
StartDt = reader.GetString(reader.GetOrdinal("StartDt")),
EndDt = reader.GetString(reader.GetOrdinal("EndDt")),
});
}
}
}
}
}
}
public void RetornaCabo()
{
SqlCeConnection con = new SqlCeConnection();
con.ConnectionString = "Data Source=|DataDirectory|\\Database\\DBCalcBus.sdf";
try
{
con.Open();
SqlCeCommand com = new SqlCeCommand();
string tipoCondutor = cboTipoCondutor.SelectionBoxItem.ToString();
com.CommandText = "SELECT Id, Condutor, Bitola, STTotal, DiamNominalTotal, PesoNominalTotal, PesoNominal1350, PesoNominal6201, ResistenciaEletricaCA_25, ResistenciaEletricaCA_75, Tipo FROM tblCabos ORDER BY Condutor";
com.CommandType = CommandType.Text;
com.Connection = con;
SqlCeDataReader DR = com.ExecuteReader();
Cabos = new ObservableCollection <Cabo>();
while (DR.Read())
{
Cabo _cabo = new Cabo();
_cabo.ID = DR.GetInt32(0);
_cabo.CONDUTOR = DR.GetString(1);
_cabo.BITOLA = DR.GetString(2);
_cabo.STTOTAL = DR.GetString(3);
_cabo.DIAMNOMINAL = DR.GetString(4);
_cabo.PESONOMINAL = DR.GetString(5);
_cabo.PPT1350 = (!DR.IsDBNull(DR.GetOrdinal("PesoNominal1350")) ? DR.GetString(6) : "");
_cabo.PPT6201 = (!DR.IsDBNull(DR.GetOrdinal("PesoNominal6201")) ? DR.GetString(7) : "");
_cabo.RESISTCA25 = DR.GetString(8);
_cabo.RESISTCA75 = DR.GetString(9);
_cabo.TIPO = DR.GetString(10);
Cabos.Add(_cabo);
}
con.Close();
}
catch (Exception)
{
throw;
}
}
private object DataReaderToObject(SqlCeDataReader reader, EntityType entity)
{
object entityObject = null;
switch (entity)
{
case EntityType.Processor:
entityObject = new EntProcessor();
break;
case EntityType.OS:
entityObject = new EntOS();
break;
case EntityType.Bios:
entityObject = new EntBios();
break;
case EntityType.MotherBoard:
entityObject = new EntMotherBoard();
break;
case EntityType.Disk:
entityObject = new EntDisk();
break;
case EntityType.Memory:
entityObject = new EntMemory();
break;
case EntityType.LogicalDrive:
entityObject = new EntLogicalDrive();
break;
case EntityType.CDRom:
entityObject = new EntCDRom();
break;
case EntityType.Video:
entityObject = new EntVideo();
break;
case EntityType.Multimedia:
entityObject = new EntMultimedia();
break;
case EntityType.Monitor:
entityObject = new EntMonitor();
break;
case EntityType.Share:
entityObject = new EntShare();
break;
case EntityType.StartUp:
entityObject = new EntStartUp();
break;
case EntityType.Hotfix:
entityObject = new EntHotfixes();
break;
case EntityType.Processes:
entityObject = new EntProcesses();
break;
case EntityType.Softwares:
entityObject = new EntSoftwares();
break;
case EntityType.Services:
entityObject = new EntServices();
break;
case EntityType.IPRoutes:
entityObject = new EntIPRoutes();
break;
case EntityType.EnvironmentVar:
entityObject = new EntEnvironmentVars();
break;
case EntityType.Computer:
entityObject = new EntComputer();
break;
case EntityType.Printer:
entityObject = new EntPrinter();
break;
case EntityType.UserGroup:
entityObject = new EntUserGroups();
break;
case EntityType.NetworkAdapter:
entityObject = new EntNetworkAdapter();
break;
}
Type t = entityObject.GetType();
PropertyInfo[] pi = t.GetProperties();
foreach (PropertyInfo prop in pi)
{
if (prop.Name == "ClassName" || prop.Name == "Icon" || prop.Name == "NodeName")
continue;
switch (prop.PropertyType.Name)
{
case "String":
string strValue = reader.GetString(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, strValue, null);
break;
case "Int32":
int intValue = reader.GetInt32(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, intValue, null);
break;
case "Double":
double dValue = reader.GetDouble(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, dValue, null);
break;
case "DateTime":
DateTime dtValue = DateTime.MinValue;
if ( reader.GetValue(reader.GetOrdinal(prop.Name))== DBNull.Value)
{
dtValue = DateTime.MinValue;
}
else
{
dtValue = reader.GetDateTime(reader.GetOrdinal(prop.Name));
}
prop.SetValue(entityObject, dtValue, null);
break;
case "Boolean":
bool bValue = reader.GetBoolean(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, bValue, null);
break;
}
}
return entityObject;
}
void ActivateNewDeal(int newline, int level, bool loadFromDB, SqlCeDataReader sqlReader)
{
// ----------- 1. Создание сдачи в БД / загрузка сдачи из БД + REFLECT --------------
if (!loadFromDB)
{
// !!! Выполнить инициализацию данных, помеченных в REFLECT_Depends со значением {-1}
// !!! Обычно это зона и порядковые номера
// !!! При sub-deal для 1 стола -1, для 2 стола -2 и т.д.
REFLECT_DEPENDENCES(newline, (this.isSplit ? -(level + 1) : -1));
}
else
{
ArrayOfInt poss = new ArrayOfInt(); //колонки, в которые будут загружены данные; список всегда начинается с -1 (-2)
poss.Add((this.isSplit ? -(level + 1) : -1));
for (int i = 0; i < DB_Deals_ColumnsNames.Keys.Count; i++)
{
int colPos = DB_Deals_ColumnsNames.Keys.ElementAt(i); //VALUES[newline, colPos]
if (this.isSplit)
{
if (SUBDEALS_WhatLevel(colPos) == level || SUBDEALS_WhatLevel(colPos) == -1 && level == 0)
{
//ok
}
else
continue;
}
// *** Загрузить из БД ***
poss.Add(colPos);
object val = sqlReader.GetValue(sqlReader.GetOrdinal(DB_Deals_ColumnsNames[colPos]));
(VALUES[newline, colPos] as ISQLSerialize)._FromDataBase(val);
}
// Одним махом REFLECT для poss[] - т.е. для начала (-1, -2 для subdeal) и для загруженных данных
REFLECT_DEPENDENCES(newline, poss);
}
// -------------- 2. Активация изменений данных: Changed -> SAVE, REFLECT ----------------
for (int i = 0; i < columnsDataClasses.Count; i++)
{
if (this.isSplit)
{
if (SUBDEALS_WhatLevel(i) == level || SUBDEALS_WhatLevel(i) == -1 && level == 0)
{
//ok
}
else
continue;
}
// >>>>>>>>> Сначала SAVE, потом REFLECT <<<<<<<<<<<<<<
// delme!!!
if (DB_Deals_ColumnsNames.Keys.Contains(i))
(VALUES[newline, i] as BaseChangedData).Changed += OnInputChanged_SaveToDataBase;
(VALUES[newline, i] as BaseChangedData).Changed += OnInputChanged;
}
// ----------------- 3. Присоединение данных к контролам -----------------
int startControlIndex;
int endControlIndex;
if (!this.isSplit || this.isSplit && level == 0)
{
startControlIndex = 0;
endControlIndex = columnsControlsClasses.Count - 1;
}
else
{
startControlIndex = columnsControlsClasses.Count + (level - 1) * SUBDEALS_CONTROLS_GetSpliColumnsCount();
endControlIndex = startControlIndex + SUBDEALS_CONTROLS_GetSpliColumnsCount() - 1;
}
for (int i = startControlIndex; i <= endControlIndex; i++)
{
int columnIndex = (!this.isSplit ? i : SUBDEALS_CONTROLS_Get_Split_Coordinates(i).column);
MethodInfo method;
Type[] types;
object[] parameters;
int params_count = 0; //для sub-deal
if (!this.isSplit)
{
types = new Type[CoVa_Dependences[columnIndex].Count];
for (int j = 0; j < CoVa_Dependences[columnIndex].Count; j++)
types[j] = VALUES[newline, CoVa_Dependences[columnIndex, j]].GetType();
}
else
{
params_count = CoVa_Dependences[columnIndex].Count + (CoVa_Dependences_SPLIT[columnIndex].Count / SUBDEALS.Count);
types = new Type[params_count];
int ind = 0;
for (int j = 0; j < CoVa_Dependences[columnIndex].Count; j++)
{
types[ind++] = VALUES[newline, CoVa_Dependences[columnIndex, j]].GetType();
}
for (int j = 0; j < CoVa_Dependences_SPLIT[columnIndex].Count; j++)
{
int l = SUBDEALS_WhatLevel(CoVa_Dependences_SPLIT[columnIndex, j]);
if (l == level)
types[ind++] = VALUES[newline, CoVa_Dependences_SPLIT[columnIndex, j]].GetType();
}
}
method = CONTROLS[newline, i].GetType().GetMethod("AttachData", types);
if (method != null)
{
if (!this.isSplit)
{
parameters = new object[CoVa_Dependences[columnIndex].Count];
for (int j = 0; j < CoVa_Dependences[columnIndex].Count; j++)
parameters[j] = VALUES[newline, CoVa_Dependences[columnIndex, j]];
}
else
{
parameters = new object[params_count];
int ind = 0;
for (int j = 0; j < CoVa_Dependences[columnIndex].Count; j++)
{
parameters[ind++] = VALUES[newline, CoVa_Dependences[columnIndex, j]];
}
for (int j = 0; j < CoVa_Dependences_SPLIT[columnIndex].Count; j++)
{
int l = SUBDEALS_WhatLevel(CoVa_Dependences_SPLIT[columnIndex, j]);
if (l == level)
parameters[ind++] = VALUES[newline, CoVa_Dependences_SPLIT[columnIndex, j]];
}
}
method.Invoke(CONTROLS[newline, i], parameters);
}
}
}
private EntCredential DataReaderToObject(SqlCeDataReader reader)
{
EntCredential credential = new EntCredential();
credential.CredentialID = reader.GetInt32(reader.GetOrdinal("CredentialID"));
credential.Username = reader.GetString(reader.GetOrdinal("Username"));
credential.Password = reader.GetString(reader.GetOrdinal("Password"));
credential.CredentialName = reader.GetString(reader.GetOrdinal("CredentialName"));
return credential;
}
public static IBaseObject Reader(SqlCeDataReader reader, string entity)
{
Assembly entityImpl = Assembly.GetAssembly(typeof (BaseObject));
string entityName = entityImpl.FullName.Substring(0, entityImpl.FullName.IndexOf(",")).Trim() + "." + entity;
Type type = entityImpl.GetType(entityName);
object obj = entityImpl.CreateInstance(entityName);
foreach (PropertyInfo p in type.GetProperties())
{
try
{
int index;
object value;
if (p.PropertyType == typeof(ITeacher))
{
index = reader.GetOrdinal("Teacher_Id");
using (Command cmd = new Command("init_Teacher"))
{
try
{
string id = Convert.ToString(reader.GetValue(index));
value = UserGateway.Get(cmd, id, Role.Teacher) as ITeacher;
}
catch
{
value = null;
}
}
}
else if (p.PropertyType == typeof(ICourse))
{
index = reader.GetOrdinal("Course_Id");
using (Command cmd = new Command("init_Course"))
{
try
{
string id = Convert.ToString(reader.GetValue(index));
value = CourseGateway.Get(cmd, id);
}
catch
{
value = null;
}
}
}
else if (p.PropertyType == typeof(IStudent))
{
index = reader.GetOrdinal("Student_Id");
using (Command cmd = new Command("init_Student"))
{
try
{
string id = Convert.ToString(reader.GetValue(index));
value = UserGateway.Get(cmd, id, Role.Student) as IStudent;
}
catch
{
value = null;
}
}
}
else
{
index = reader.GetOrdinal(p.Name);
value = reader.GetValue(index);
value = value is DBNull ? null : value;
}
p.SetValue(obj, value, null);
}
catch
{
continue;
}
}
return obj as IBaseObject;
}
private String GetTranslationText(SqlCeDataReader reader)
{
return reader.GetString(reader.GetOrdinal("Translation"));
}
static FS2JournalItem ReadOneJournalItem(SqlCeDataReader reader)
{
var journalItem = new FS2JournalItem();
if (!reader.IsDBNull(reader.GetOrdinal("Id")))
journalItem.No = reader.GetInt32(reader.GetOrdinal("Id"));
if (!reader.IsDBNull(reader.GetOrdinal("SystemTime")))
journalItem.SystemTime = reader.GetDateTime(reader.GetOrdinal("SystemTime"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceTime")))
journalItem.DeviceTime = reader.GetDateTime(reader.GetOrdinal("DeviceTime"));
if (!reader.IsDBNull(reader.GetOrdinal("Description")))
journalItem.Description = reader.GetString(reader.GetOrdinal("Description"));
if (!reader.IsDBNull(reader.GetOrdinal("Detalization")))
journalItem.Detalization = reader.GetString(reader.GetOrdinal("Detalization"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceName")))
journalItem.DeviceName = reader.GetString(reader.GetOrdinal("DeviceName"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelName")))
journalItem.PanelName = reader.GetString(reader.GetOrdinal("PanelName"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceUID")))
journalItem.DeviceUID = reader.GetGuid(reader.GetOrdinal("DeviceUID"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelUID")))
journalItem.PanelUID = reader.GetGuid(reader.GetOrdinal("PanelUID"));
if (!reader.IsDBNull(reader.GetOrdinal("ZoneName")))
journalItem.ZoneName = reader.GetString(reader.GetOrdinal("ZoneName"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceCategory")))
journalItem.DeviceCategory = reader.GetInt32(reader.GetOrdinal("DeviceCategory"));
if (!reader.IsDBNull(reader.GetOrdinal("StateType")))
journalItem.StateType = (StateType)reader.GetInt32(reader.GetOrdinal("StateType"));
if (!reader.IsDBNull(reader.GetOrdinal("SubsystemType")))
journalItem.SubsystemType = (SubsystemType)reader.GetInt32(reader.GetOrdinal("SubsystemType"));
if (!reader.IsDBNull(reader.GetOrdinal("UserName")))
journalItem.UserName = reader.GetString(reader.GetOrdinal("UserName"));
return journalItem;
}
private String GetDefinitionText(SqlCeDataReader reader)
{
return reader.GetString(reader.GetOrdinal("Definition"));
}
private EntDiscover DataReaderToObject(SqlCeDataReader reader)
{
EntDiscover machine = new EntDiscover();
machine.MachineID = reader.GetInt32(reader.GetOrdinal("MachineID"));
machine.IPAddr = reader.GetString(reader.GetOrdinal("IPAddress"));
machine.LastChecked = reader.GetDateTime(reader.GetOrdinal("LastChecked"));
machine.Discovered = reader.GetBoolean(reader.GetOrdinal("Discovered"));
machine.StatusMessage = reader.GetString(reader.GetOrdinal("StatusMessage"));
machine.DomainName = reader.GetString(reader.GetOrdinal("DomainName"));
machine.MachineName = reader.GetString(reader.GetOrdinal("MachineName"));
machine.CredentialID = reader.GetInt32(reader.GetOrdinal("CredentialID"));
return machine;
}
private static Transaction GetTransactionFromReader(SqlCeDataReader reader)
{
if(reader != null)
{
Transaction transaction = new Transaction();
transaction.TransactionID = (long)reader["TransactionID"];
transaction.CustomerID = (long)reader["CustomerID"];
if (!reader.IsDBNull(reader.GetOrdinal("ResponsiblePartyID")))
{
transaction.ResponsiblePartyID = (long)reader["ResponsiblePartyID"];
}
transaction.TransactionDate = DateTime.Parse(reader["TransactionDate"].ToString());
transaction.PaymentRecieved = DateTime.Parse(reader["PaymentRecieved"].ToString());
transaction.TotalPrice = (int)reader["TotalPrice"];
return transaction;
}
return null;
}
private void PopulateEntity(Entity entity, SqlCeDataReader reader)
{
entity.Id = reader.GetValue(reader.GetOrdinal("Id")).ToString();
entity.Code = (string)reader.GetValue(reader.GetOrdinal("Code"));
entity.Label = (string)reader.GetValue(reader.GetOrdinal("Label"));
entity.Data1 = (string)reader.GetValue(reader.GetOrdinal("Data1"));
entity.Data2 = (string)reader.GetValue(reader.GetOrdinal("Data2"));
entity.Data3 = (string)reader.GetValue(reader.GetOrdinal("Data3"));
}
static JournalItem ReadOneJournalItem(SqlCeDataReader reader)
{
var journalItem = new JournalItem();
if (!reader.IsDBNull(reader.GetOrdinal("JournalItemType")))
journalItem.JournalItemType = (JournalItemType)reader.GetByte(reader.GetOrdinal("JournalItemType"));
if (!reader.IsDBNull(reader.GetOrdinal("SystemDateTime")))
journalItem.SystemDateTime = reader.GetDateTime(reader.GetOrdinal("SystemDateTime"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceDateTime")))
journalItem.DeviceDateTime = reader.GetDateTime(reader.GetOrdinal("DeviceDateTime"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectUID")))
journalItem.ObjectUID = reader.GetGuid(reader.GetOrdinal("ObjectUID"));
if (!reader.IsDBNull(reader.GetOrdinal("Name")))
journalItem.Name = reader.GetString(reader.GetOrdinal("Name"));
if (!reader.IsDBNull(reader.GetOrdinal("Description")))
journalItem.Description = reader.GetString(reader.GetOrdinal("Description"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectState")))
journalItem.ObjectState = reader.GetInt32(reader.GetOrdinal("ObjectState"));
if (!reader.IsDBNull(reader.GetOrdinal("GKObjectNo")))
journalItem.GKObjectNo = (ushort)reader.GetInt16(reader.GetOrdinal("GKObjectNo"));
if (!reader.IsDBNull(reader.GetOrdinal("GKIpAddress")))
journalItem.GKIpAddress = reader.GetString(reader.GetOrdinal("GKIpAddress"));
if (!reader.IsDBNull(reader.GetOrdinal("GKJournalRecordNo")))
journalItem.GKJournalRecordNo = reader.GetInt32(reader.GetOrdinal("GKJournalRecordNo"));
if (!reader.IsDBNull(reader.GetOrdinal("KAUNo")))
journalItem.ControllerAddress = (ushort)reader.GetInt32(reader.GetOrdinal("KAUNo"));
if (!reader.IsDBNull(reader.GetOrdinal("StateClass")))
journalItem.StateClass = (XStateClass)reader.GetByte(reader.GetOrdinal("StateClass"));
if (!reader.IsDBNull(reader.GetOrdinal("UserName")))
journalItem.UserName = reader.GetString(reader.GetOrdinal("UserName"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectStateClass")))
journalItem.ObjectStateClass = (XStateClass)reader.GetByte(reader.GetOrdinal("ObjectStateClass"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectName")))
journalItem.ObjectName = reader.GetString(reader.GetOrdinal("ObjectName"));
if (!reader.IsDBNull(reader.GetOrdinal("AdditionalDescription")))
journalItem.AdditionalDescription = reader.GetString(reader.GetOrdinal("AdditionalDescription"));
if (!reader.IsDBNull(reader.GetOrdinal("Subsystem")))
journalItem.SubsystemType = (XSubsystemType)reader.GetByte(reader.GetOrdinal("Subsystem"));
return journalItem;
}
private void AddString(StringBuilder builder, SqlCeDataReader reader, String column)
{
String text = reader.GetString(reader.GetOrdinal(column));
if (!StringUtils.IsEmpty(text))
{
if (builder.Length > 0)
{
builder.Append(" ");
}
builder.Append(text);
}
}
private EntScan DataReaderToObject(SqlCeDataReader reader)
{
EntScan scan = new EntScan();
scan.MachineID = reader.GetInt32(reader.GetOrdinal("MachineID"));
scan.ScanID = reader.GetInt32(reader.GetOrdinal("ScanID"));
scan.Date = reader.GetDateTime(reader.GetOrdinal("ScanDate"));
return scan;
}
static JournalRecord ReadOneJournalRecord(SqlCeDataReader reader)
{
var journalRecord = new JournalRecord();
if (!reader.IsDBNull(reader.GetOrdinal("Description")))
journalRecord.Description = reader.GetString(reader.GetOrdinal("Description"));
if (!reader.IsDBNull(reader.GetOrdinal("Detalization")))
journalRecord.Detalization = reader.GetString(reader.GetOrdinal("Detalization"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceCategory")))
journalRecord.DeviceCategory = reader.GetInt32(reader.GetOrdinal("DeviceCategory"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceDatabaseId")))
journalRecord.DeviceDatabaseId = reader.GetString(reader.GetOrdinal("DeviceDatabaseId"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceName")))
journalRecord.DeviceName = reader.GetString(reader.GetOrdinal("DeviceName"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceTime")))
journalRecord.DeviceTime = reader.GetDateTime(reader.GetOrdinal("DeviceTime"));
if (!reader.IsDBNull(reader.GetOrdinal("OldId")))
journalRecord.OldId = reader.GetInt32(reader.GetOrdinal("OldId"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelDatabaseId")))
journalRecord.PanelDatabaseId = reader.GetString(reader.GetOrdinal("PanelDatabaseId"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelName")))
journalRecord.PanelName = reader.GetString(reader.GetOrdinal("PanelName"));
if (!reader.IsDBNull(reader.GetOrdinal("StateType")))
journalRecord.StateType = (StateType)reader.GetInt32(reader.GetOrdinal("StateType"));
if (!reader.IsDBNull(reader.GetOrdinal("SubsystemType")))
journalRecord.SubsystemType = (SubsystemType)reader.GetInt32(reader.GetOrdinal("SubsystemType"));
if (!reader.IsDBNull(reader.GetOrdinal("SystemTime")))
journalRecord.SystemTime = reader.GetDateTime(reader.GetOrdinal("SystemTime"));
if (!reader.IsDBNull(reader.GetOrdinal("UserName")))
journalRecord.User = reader.GetString(reader.GetOrdinal("UserName"));
if (!reader.IsDBNull(reader.GetOrdinal("ZoneName")))
journalRecord.ZoneName = reader.GetString(reader.GetOrdinal("ZoneName"));
if (!reader.IsDBNull(reader.GetOrdinal("Id")))
journalRecord.No = reader.GetInt32(reader.GetOrdinal("Id"));
return journalRecord;
}
private String GetExampleText(SqlCeDataReader reader)
{
return reader.GetString(reader.GetOrdinal("Example"));
}
