public Entry FindOne(Contest.model.Tuple <long, long> id)
{
log.InfoFormat("Entering FindOne with value {0}", id);
IDbConnection con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select kid , cid , date from Entries where kid = @kid and cid = @cid";
IDbDataParameter paramKId = comm.CreateParameter();
paramKId.ParameterName = "@kid";
paramKId.Value = id.Left;
comm.Parameters.Add(paramKId);
IDbDataParameter paramCId = comm.CreateParameter();
paramCId.ParameterName = "@cid";
paramCId.Value = id.Right;
comm.Parameters.Add(paramCId);
using (var dataR = comm.ExecuteReader())
{
if (dataR.Read())
{
long kidE = dataR.GetInt64(0);
long cidE = dataR.GetInt64(1);
DateTime date = dataR.GetDateTime(2);
Contest.model.Tuple <long, long> idE = new Contest.model.Tuple <long, long>(kidE, cidE);
Child child = childRepo.FindOne(kidE);
Challenge challenge = challengeRepo.FindOne(cidE);
Entry entry = new Entry(date, child, challenge);
entry.Id = idE;
log.InfoFormat("Exiting FindOne with value {0}", entry);
return(entry);
}
}
}
log.InfoFormat("Exiting FindOne with value {0}", null);
return(null);
}
public Entry Update(Entry entry)
{
log.InfoFormat("Entering Update with Entry {0}", entry);
var con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "update Entries set date = @date where kid = @kid and cid = @cid)";
var paramDate = comm.CreateParameter();
paramDate.ParameterName = "@date";
paramDate.Value = entry.Date;
comm.Parameters.Add(paramDate);
IDbDataParameter paramKId = comm.CreateParameter();
paramKId.ParameterName = "@kid";
paramKId.Value = entry.Id.Left;
comm.Parameters.Add(paramKId);
IDbDataParameter paramCId = comm.CreateParameter();
paramCId.ParameterName = "@cid";
paramCId.Value = entry.Id.Right;
comm.Parameters.Add(paramCId);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
log.InfoFormat("Exiting Update with value {0}", entry);
return(entry);
}
else
{
log.InfoFormat("Exiting Update with value {0}", null);
return(null);
}
}
}
public Child Update(Child child)
{
log.InfoFormat("Entering Update with Child {0}", child);
var con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "update Child set name = @name , age = @age where id = @id)";
var paramName = comm.CreateParameter();
paramName.ParameterName = "@name";
paramName.Value = child.Name;
comm.Parameters.Add(paramName);
var paramAge = comm.CreateParameter();
paramAge.ParameterName = "@age";
paramAge.Value = child.Age;
comm.Parameters.Add(paramAge);
IDbDataParameter paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = child.Id;
comm.Parameters.Add(paramId);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
log.InfoFormat("Exiting Update with value {0}", child);
return(child);
}
else
{
log.InfoFormat("Exiting Update with value {0}", null);
return(null);
}
}
}
public Employee Update(Employee employee)
{
log.InfoFormat("Entering Update with Employee {0}", employee);
var con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "update Employees set username = @username , password = @password where id = @id)";
var paramUsername = comm.CreateParameter();
paramUsername.ParameterName = "@username";
paramUsername.Value = employee.Username;
comm.Parameters.Add(paramUsername);
var paramPassowrd = comm.CreateParameter();
paramPassowrd.ParameterName = "@password";
paramPassowrd.Value = employee.Password;
comm.Parameters.Add(paramPassowrd);
IDbDataParameter paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = employee.Id;
comm.Parameters.Add(paramId);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
log.InfoFormat("Exiting Update with value {0}", employee);
return(employee);
}
else
{
log.InfoFormat("Exiting Update with value {0}", null);
return(null);
}
}
}
public Challenge Save(Challenge challenge)
{
log.InfoFormat("Entering Save with Challenge {0}", challenge);
var con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "insert into Challenge(minimum_age,maximum_age,name) values (@minimum_age , @maximum_age , @name)";
var paramMinimumAge = comm.CreateParameter();
paramMinimumAge.ParameterName = "@minimum_age";
paramMinimumAge.Value = challenge.MinimumAge;
comm.Parameters.Add(paramMinimumAge);
var paramMaximumAge = comm.CreateParameter();
paramMaximumAge.ParameterName = "@maximum_age";
paramMaximumAge.Value = challenge.MaximumAge;
comm.Parameters.Add(paramMaximumAge);
var paramName = comm.CreateParameter();
paramName.ParameterName = "@name";
paramName.Value = challenge.Name;
comm.Parameters.Add(paramName);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
log.InfoFormat("Exiting Save with value {0}", challenge);
return(challenge);
}
else
{
log.InfoFormat("Exiting Save with value {0}", null);
return(null);
}
}
}
public Entry Save(Entry entry)
{
log.InfoFormat("Entering Save with Entry {0}", entry);
var con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "insert into Entries values (@kid, @cid, @date)";
var paramKId = comm.CreateParameter();
paramKId.ParameterName = "@kid";
paramKId.Value = entry.Id.Left;
comm.Parameters.Add(paramKId);
var paramCId = comm.CreateParameter();
paramCId.ParameterName = "@cid";
paramCId.Value = entry.Id.Right;
comm.Parameters.Add(paramCId);
var paramDate = comm.CreateParameter();
paramDate.ParameterName = "@date";
paramDate.Value = entry.Date;
comm.Parameters.Add(paramDate);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
log.InfoFormat("Exiting Save with value {0}", entry);
return(entry);
}
else
{
log.InfoFormat("Exiting Save with value {0}", null);
return(null);
}
}
}
public Child FindByProperties(string name, int age)
{
log.InfoFormat("Entering FindByProperties with name {0} , age {1}", name, age);
IDbConnection con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select id , name, age from Child where name = @name and age = @age";
IDbDataParameter paramName = comm.CreateParameter();
paramName.ParameterName = "@name";
paramName.Value = name;
comm.Parameters.Add(paramName);
IDbDataParameter paramAge = comm.CreateParameter();
paramAge.ParameterName = "@age";
paramAge.Value = age;
comm.Parameters.Add(paramAge);
using (var dataR = comm.ExecuteReader())
{
if (dataR.Read())
{
long id = dataR.GetInt64(0);
String the_name = dataR.GetString(1);
int the_age = dataR.GetInt32(2);
Child child = new Child(the_name, the_age);
child.Id = id;
log.InfoFormat("Exiting FindByProperties with value {0}", child);
return(child);
}
}
}
log.InfoFormat("Exiting FindByProperties with value {0}", null);
return(null);
}