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