internal SchoolPeriod GetOneSchoolPeriodFromRow(DbDataReader Row)
{
SchoolPeriod p = new SchoolPeriod();
p.IdSchoolPeriodType = SafeDb.SafeString(Row["idSchoolPeriodType"]);
if (p.IdSchoolPeriodType != "N")
{
p.DateFinish = SafeDb.SafeDateTime(Row["dateFinish"]);
p.DateStart = SafeDb.SafeDateTime(Row["dateStart"]);
}
p.Name = SafeDb.SafeString(Row["name"]);
p.Desc = SafeDb.SafeString(Row["desc"]);
p.IdSchoolPeriod = SafeDb.SafeString(Row["idSchoolPeriod"]);
p.IdSchoolYear = SafeDb.SafeString(Row["idSchoolYear"]);
return(p);
}
private Student GetStudentFromRow(DbDataReader Row)
{
Student s = new Student();
s.IdStudent = (int)Row["IdStudent"];
s.LastName = SafeDb.SafeString(Row["LastName"]);
s.FirstName = SafeDb.SafeString(Row["FirstName"]);
s.Residence = SafeDb.SafeString(Row["Residence"]);
s.Origin = SafeDb.SafeString(Row["Origin"]);
s.Email = SafeDb.SafeString(Row["Email"]);
if (!(Row["birthDate"] is DBNull))
{
s.BirthDate = SafeDb.SafeDateTime(Row["birthDate"]);
}
s.BirthPlace = SafeDb.SafeString(Row["birthPlace"]);
s.Eligible = SafeDb.SafeBool(Row["drawable"]);
s.Disabled = SafeDb.SafeBool(Row["disabled"]);
s.RevengeFactorCounter = SafeDb.SafeInt(Row["VFCounter"]);
return(s);
}
private User GetUserFromRow(DbDataReader dRead)
{
User u = null;
if (dRead.HasRows)
{
u = new User(SafeDb.SafeString(dRead["username"]),
SafeDb.SafeString(dRead["password"]));
u.Description = SafeDb.SafeString(dRead["description"]);
u.LastName = SafeDb.SafeString(dRead["lastName"]);
u.FirstName = SafeDb.SafeString(dRead["firstName"]);
u.Email = SafeDb.SafeString(dRead["email"]);
//u.Password = SafeDb.SafeString(dRead["password"]);
u.LastChange = SafeDb.SafeDateTime(dRead["lastChange"]);
u.LastPasswordChange = SafeDb.SafeDateTime(dRead["lastPasswordChange"]);
u.CreationTime = SafeDb.SafeDateTime(dRead["creationTime"]);
u.Salt = SafeDb.SafeString(dRead["salt"]);
u.IdUserCategory = SafeDb.SafeInt(dRead["idUserCategory"]);
u.IsEnabled = SafeDb.SafeBool(dRead["isEnabled"]);
}
return(u);
}
internal void RestoreTableXml(string TableName, bool EraseBefore)
{
DataSet dSet = new DataSet();
DataTable t = null;
dSet.ReadXml(Commons.PathDatabase + "\\" + TableName + ".xml", XmlReadMode.ReadSchema);
t = dSet.Tables[0];
if (t.Rows.Count == 0)
{
return;
}
using (DbConnection conn = dl.Connect())
{
DbCommand cmd;
cmd = conn.CreateCommand();
if (EraseBefore)
{
cmd.CommandText = "DELETE FROM " + TableName + ";";
cmd.ExecuteNonQuery();
}
cmd.CommandText = "INSERT INTO " + TableName + "(";
// column names
DataRow r = t.Rows[0];
foreach (DataColumn c in t.Columns)
{
cmd.CommandText += c.ColumnName + ",";
}
cmd.CommandText = cmd.CommandText.Substring(0, cmd.CommandText.Length - 1);
cmd.CommandText += ")VALUES";
// row values
foreach (DataRow row in t.Rows)
{
cmd.CommandText += "(";
foreach (DataColumn c in t.Columns)
{
switch (Type.GetTypeCode(c.DataType))
{
case TypeCode.String:
case TypeCode.Char:
{
cmd.CommandText += "'" + SqlVal.SqlString(row[c.ColumnName].ToString()) + "',";
break;
};
case TypeCode.DateTime:
{
DateTime?d = SafeDb.SafeDateTime(row[c.ColumnName]);
cmd.CommandText += "'" +
((DateTime)(d)).ToString("yyyy-MM-dd_HH.mm.ss") + "',";
break;
}
default:
{
if (!(row[c.ColumnName] is DBNull))
{
cmd.CommandText += row[c.ColumnName] + ",";
}
else
{
cmd.CommandText += "0,";
}
break;
}
}
}
cmd.CommandText = cmd.CommandText.Substring(0, cmd.CommandText.Length - 1);
cmd.CommandText += "),";
}
cmd.CommandText = cmd.CommandText.Substring(0, cmd.CommandText.Length - 1);
cmd.CommandText += ";";
cmd.ExecuteNonQuery();
dSet.Dispose();
t.Dispose();
cmd.Dispose();
}
}