public static async Task <Employee> GetEmployee(int id)
{
string sql = "SELECT * FROM Employee WHERE Id = @id";
SqlCeCommand command = new SqlCeCommand(sql, con);
command.Parameters.Add("@id", id);
await con.OpenAsync();
SqlCeDataReader result = (SqlCeDataReader)await command.ExecuteReaderAsync();
Employee employee = new Employee();
while (await result.ReadAsync())
{
employee.Id = result.GetInt32(0);
employee.Name = result.GetString(1);
employee.Email = result.GetString(2);
employee.Salary = result.GetDecimal(3);
employee.Gender = result.GetString(4);
employee.ContractType = result.GetString(5);
//employee.RegisterDate = result.GetDateTime(6);
}
con.Close();
return(employee);
}
public async Task <IDataReader> ExecuteReaderAsync(string querry)
{
SqlCeCommand command = new SqlCeCommand(querry, dbConnection);
DbDataReader reader = await command.ExecuteReaderAsync();
return(reader);
}
/// <summary>
/// Gets the member id of the associated name
/// </summary>
private async Task <int> GetMemberID(string memberName)
{
int memberID = 0;
using (SqlCeConnection connection = new SqlCeConnection(connectionFilePath))
{
await connection.OpenAsync();
// TODO: Establish unique item
string query = "SELECT ID FROM Members WHERE NAME='" + memberName + "'";
SqlCeCommand command = new SqlCeCommand();
command.Connection = connection;
command.CommandText = query;
DbDataReader reader = await command.ExecuteReaderAsync();
try
{
while (reader.Read())
{
memberID = reader.GetInt32(0);
}
}
finally
{
reader.Close();
}
connection.Close();
}
return(memberID);
}
public async Task <IList <LogEntity> > GetAllAsync()
{
var Logs = new List <LogEntity>();
var _connection = new SqlCeConnection(Globals.DbConnectionString);
_connection.Open();
var sql = "SELECT * FROM LogEntities";
SqlCeCommand selectCommand;
using (selectCommand = new SqlCeCommand(sql, _connection))
{
using (var reader = await selectCommand.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
var log = new LogEntity();
DateTime?CreatedDate = null;
DateTime CreatedDate2;
DateTime?ModifiedDate = null;
DateTime ModifiedDate2;
var s = DateTime.TryParse(reader["CreatedDateTime"].ToString(), out CreatedDate2);
if (s)
{
CreatedDate = CreatedDate2;
log.CreatedDateTime = CreatedDate;
}
var s2 = DateTime.TryParse(reader["ModifiedDateTime"].ToString(), out ModifiedDate2);
if (s2)
{
ModifiedDate = ModifiedDate2;
log.ModifiedDateTime = ModifiedDate;
}
log.Id = Convert.ToInt64(reader["Id"].ToString());
log.Date = Convert.ToDateTime(reader["Date"].ToString());
log.Level = reader["Level"].ToString();
log.Thread = reader["Thread"].ToString();
log.Message = reader["Message"].ToString();
log.Exception = reader["Exception"].ToString();
Logs.Add(log);
}
}
return(Logs);
}
}
/// <summary>
/// Gets the ticket id of the associated seat parameters
/// </summary>
private async Task <int> GetTicketID(int section, int row, int seat)
{
int ticketID = 0;
using (SqlCeConnection connection = new SqlCeConnection(connectionFilePath))
{
await connection.OpenAsync();
// TODO: Establish unique item
string query = "SELECT ID FROM Tickets WHERE T_SECTION=" + section
+ " AND T_ROW=" + row
+ " AND T_SEAT=" + seat;
SqlCeCommand command = new SqlCeCommand();
command.Connection = connection;
command.CommandText = query;
DbDataReader reader = await command.ExecuteReaderAsync();
try
{
while (reader.Read())
{
ticketID = reader.GetInt32(0);
}
}
finally
{
reader.Close();
}
connection.Close();
}
return(ticketID);
}
