public CategoryBasic(SqlCategory cat)
{
SqlItem = cat;
SqlSingleText st = Procedures.SingleTexts[cat.SqlSingleText];
//SqlColorable c = Procedures.Colorables[cat.SqlColorable];
SqlIconable i = Procedures.Iconables[cat.SqlIconable];
//SqlSingleText
SqlSingleTextObject = st;
Text = st.Text;
//IIconable
SqlIconableObject = i;
ImageSource = i.ImageSource;
Entries = new List <EntryBase>();
foreach (SqlEntryStorage s in Procedures.EntryStorages.Values)
{
if (s.CategoryId != SqlItem.Id)
{
continue;
}
SqlEntry sqle = Procedures.Entries[s.EntryId];
EntryBase entry = GetEntry(sqle);
Entries.Add(entry);
}
}
public EntryBase GetEntry(SqlEntry sqle)
{
EntryBase entry = null;
entry = EntryFactory.GetEntry(sqle);
return(entry);
}
public void createInDB()
{
try
{
var entry = new SqlEntry();
entry.insertInto(queryString + nickname + "', '" + vorname + "', '" + nachname + "', '" + password + "', '" + email + "')");
} catch (SqlException e)
{ throw; }
}
public override IDbDataParameter GetDbParameter(SqlEntry.DataParameter dp)
{
var result = base.GetDbParameter(dp);
if(result.DbType == DbType.Time)
{
result.DbType = DbType.DateTime;
}
return result;
}
public static TEntry Deserialize <TKey, TEntry>(SqlEntry sqlEntry)
where TEntry : ISqlEntry, new()
{
var stream = new MemoryStream(sqlEntry.Data);
var reader = CreateReader(stream);
var entry = DeserializeEntry <TKey, TEntry>(reader);
entry.SetTimestamp(sqlEntry.Timestamp);
return(entry);
}
public void createInDB()
{
try
{
base.createInDB();
var entry = new SqlEntry();
entry.insertInto(queryString + nickname + "', '" + matrikelnumber + "', '" + einschreibeDatum + "')");
} catch (SqlException e)
{ }
}
public override IDbDataParameter GetDbParameter(SqlEntry.DataParameter dp)
{
var result = base.GetDbParameter(dp);
if(result.DbType == DbType.Guid && result.Value != null && result.Value is Guid)
{
result.Value = ((Guid)result.Value).ToString();
result.DbType = DbType.String;
}
return result;
}
public EntryBasic(SqlEntry e)
{
SqlItem = e;
SqlSingleText st = Procedures.SingleTexts[e.SqlSingleText];
//SqlColorable c = Procedures.Colorables[e.SqlColorable];
//SqlSingleText
SqlSingleTextObject = st;
Text = st.Text;
}
public static EntryBase GetEntry(SqlEntry sqle)
{
foreach (KeyValuePair <string, Func <SqlEntry, EntryBase> > kvp in REGISTER)
{
if (kvp.Key == sqle.EntryType)
{
return(kvp.Value(sqle));
}
}
return(null);
}
public EntryMultyText(SqlEntry e)
{
SqlItem = e;
SqlSingleText st = Procedures.SingleTexts[e.SqlSingleText];
SqlMultyText mt = Procedures.MultyTexts[e.SqlMultyText];
//SqlSingleText
SqlSingleTextObject = st;
Text = st.Text;
//IMultiTextStorage
SqlMultyTextObject = mt;
Texts = new Dictionary <string, string>();
Texts = JsonConvert.DeserializeObject <Dictionary <string, string> >(mt.TextsJson);
}
internal static List <Modul> getModulByUser(string nickname)
{
var result = new List <Modul>();
var entry = new SqlEntry();
var reader = entry.getReader(query + nickname + query2);
while (reader.Read())
{
var modul = new Modul
{
description = reader["Bezeichnung"].ToString()
};
result.Add(modul);
}
return(result);
}
public static List <Dokument> getDokumentByUser(string nickname)
{
var result = new List <Dokument>();
var entry = new SqlEntry();
var reader = entry.getReader(query + nickname + "'");
while (reader.Read())
{
var dokument = new Dokument
{
Bereitstellung = (DateTime)reader["Bereitstellungsdatum"],
Titel = reader["Titel"].ToString()
};
result.Add(dokument);
}
return(result);
}
//Ctor
public EntryBasic(string text)
{
//ISingleTextStorage - Data
Text = text;
//ISingleTextStorage - SQL
SqlSingleTextObject = new SqlSingleText()
{
Text = text
};
Procedures.Insert(SqlSingleTextObject);
//Set SQLEntry
SqlItem = new SqlEntry();
//SqlItem.SqlColorable = SqlColorableObject.Id;
SqlItem.SqlSingleText = SqlSingleTextObject.Id;
SqlItem.EntryType = EntryType;
Procedures.Insert(SqlItem);
}
public static List <ForumBeitrag> getBeitragByUser(string nickname)
{
var result = new List <ForumBeitrag>();
var entry = new SqlEntry();
var reader = entry.getReader(query + nickname + query2);
while (reader.Read())
{
var forumBeitrag = new ForumBeitrag
{
description = reader["Bezeichnung"].ToString(),
message = reader["Mitteilung"].ToString(),
changedAt = (DateTime)reader["Änderungsdatum"]
};
result.Add(forumBeitrag);
}
return(result);
}
public static ProfSummary Load(string nickname)
{
var entry = new SqlEntry();
var reader = entry.getReader(queryString + nickname + "'");
reader.Read();
var name = reader["AkademischerTitel"].ToString() + " " + reader["Nachname"].ToString();
var result = new ProfSummary
{
Nickname = nickname,
ProfName = name,
Beiträge = ForumBeitrag.getBeitragByUser(nickname),
Dokumente = Dokument.getDokumentByUser(nickname),
Module = Modul.getModulByUser(nickname)
//...
};
return(result);
}
public EntryMultyText(params string[] texts)
{
//Input check
//We expect input like "key1", "value1", "key2", "value2", ...
//So, even number of strings must be provided as params
if (texts.Length % 2 > 0)
{
throw new System.Exception("Input an even number of strings in key-value fashion");
}
//IMultyTextStorage - Data
Texts = new Dictionary <string, string>();
for (int i = 0; i < texts.Length; i += 2)
{
Texts.Add(texts[i], texts[i + 1]);
}
//IMultyTextStorage - SQL
SqlMultyTextObject = new SqlMultyText();
SqlMultyTextObject.TextsJson = JsonConvert.SerializeObject(Texts);
Procedures.Insert(SqlMultyTextObject);
string txt = (texts.Length > 0) ? texts[1] : "";
//ISingleTextStorage - Data
Text = txt;
//ISingleTextStorage - SQL
SqlSingleTextObject = new SqlSingleText()
{
Text = txt
};
Procedures.Insert(SqlSingleTextObject);
//Set SQLEntry
SqlItem = new SqlEntry();
SqlItem.SqlMultyText = SqlMultyTextObject.Id;
SqlItem.SqlSingleText = SqlSingleTextObject.Id;
SqlItem.EntryType = EntryType;
Procedures.Insert(SqlItem);
}
public List <Benutzer> getBenutzer()
{
try
{
//Connect to DataBase
var entry = new SqlEntry();
var reader = entry.getReader(getAllUsersQueryString);
var benutzerListe = new List <Benutzer>();
//Read results and store it as a list of Moduls
while (reader.Read())
{
var email = reader["Nickname"].ToString();
benutzerListe.Add(new Benutzer(reader["Nickname"].ToString(), reader["Vorname"].ToString(),
reader["Nachname"].ToString(), reader["Passwort"].ToString(), reader["Email"].ToString()));
}
return(benutzerListe);
} catch (SqlException e)
{
throw;
}
}
public List <Modul> getModul()
{
try
{
//Connect to DataBase
var entry = new SqlEntry();
var reader = entry.getReader(queryString);
var moduleListe = new List <Modul>();
//Read results and store it as a list of Moduls
while (reader.Read())
{
var guarantor = reader["Nickname"].ToString();
var profName = reader["AkademischerTitel"].ToString() + " " + reader["Nachname"];
moduleListe.Add(new Modul((int)reader["FachNummer"], reader["Bezeichnung"].ToString(),
guarantor, profName));
}
return(moduleListe);
} catch (SqlException e)
{
throw;
}
}
public Boolean authenticateBenutzer(Benutzer user)
{
try
{
var entry = new SqlEntry();
var dbPassword = (string)entry.getScalar(loginQueryString + "'" + user.nickname + "'");
if (dbPassword == null)
{
//<p>User doesn't exsist!!!</p>
//userName = "";
throw new BenutzerDontExistException();
}
else if (string.Compare(Crypto.Hash(user.password, "md5").ToString(), dbPassword, true) != 0)
{
//<p>Wrong Password!!!</p>
throw new BenutzerPasswordException();
}
} catch (SqlException e)
{
//<p>Anmelden zur Zeit nicht möglich bitte versuchen Sie es später wieder.</p>
}
return(true);
}
public static EntryBasic GetEntryBasic(SqlEntry sqle)
{
return(new EntryBasic(sqle));
}
public static EntryMultyText GetEntryMultyText(SqlEntry sqle)
{
return(new EntryMultyText(sqle));
}
public override string ToSqlText(SqlEntry.DataParameterCollection dpc, Dialect.DbDialect dd, List<string> queryRequiredFields)
{
return null;
}
