public Staff FindOne(Domain.Tuple <string, string> id)
{
log.InfoFormat("Entering findOne");
IDbConnection con = DBUtils.getConnection();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select username,password,nume from Staff where username=@username";
IDbDataParameter paramId = comm.CreateParameter();
paramId.ParameterName = "@username";
paramId.Value = id.Elem1;
comm.Parameters.Add(paramId);
using (var dataR = comm.ExecuteReader())
{
if (dataR.Read())
{
string username = dataR.GetString(0);
string password = dataR.GetString(1);
string nume = dataR.GetString(2);
Staff s = new Staff(username, password, nume);
log.InfoFormat("Exiting findOne with value {0}", s);
return(s);
}
}
}
log.InfoFormat("Exiting findOne with value {0}", null);
return(null);
}
public Staff Delete(Domain.Tuple <string, string> id)
{
log.InfoFormat("Entering Save");
IDbConnection con = DBUtils.getConnection();
Staff stafff = FindOne(id);
using (var comm = con.CreateCommand())
{
comm.CommandText = "delete from Staff where username=@username";
IDbDataParameter paramUser = comm.CreateParameter();
paramUser.ParameterName = "@username";
paramUser.Value = id.Elem1;
comm.Parameters.Add(paramUser);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
log.InfoFormat("save exited with value {0}", null);
return(null);
}
else
{
log.InfoFormat("save exited with value {0}", result);
return(stafff);
}
}
}
public Staff StaffFindOne(Domain.Tuple <string, string> sid)
{
return(sdr.FindOne(sid));
}
