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); }