// Sadece bir kez kullanıldı
public static void GenerateHash(int id, string isim)
{
string Value = Sync.MD5Operations.GetMd5Hash(isim);
string commandText = "update Table_Basvuru set hash = '" + Value + "' where id = '" + id + "'";
DatabaseOperations.UpdateTable(commandText);
}
public static void AddToTable(string isim, string sayfa, string link)
{
string now = DateTime.Now.ToString("dd/MM/yyyy HH:mm");
string commandText = "insert into Table_Kitap (isim, sayfa, link, bitti, baslangic, degisim, arsiv) values ('" + isim + "', '" + sayfa + "', '" + link + "', '" + now + "', '" + now + "', '0');";
DatabaseOperations.UpdateTable(commandText);
}
public static void AddToTable(string isim, string kayit, string son, string link, string sonuc)
{
string value = Sync.MD5Operations.GetMd5Hash(isim);
string now = DateTime.Now.ToString("dd/MM/yyyy HH:mm");
string commandText = "insert into Table_Basvuru (isim, kayit, son, sonuc, link, bitti, baslangic, degisim, arsiv, sync, hash) values ('" + isim + "', '" + kayit + "', '" + son + "', '" + sonuc + "', '" + link + "', 0, '" + now + "', '" + now + "', 0, 2, '" + value + "');";
DatabaseOperations.UpdateTable(commandText);
}
public static void UpdateRow(string Value, string Column, string id)
{
string commandText = "update Table_Basvuru set " + Column + " = '" + Value + "' where id = '" + id + "'";
DatabaseOperations.UpdateTable(commandText);
string now = DateTime.Now.ToString("dd/MM/yyyy HH:mm");
commandText = "update Table_Basvuru set degisim = '" + now + "' where id = '" + id + "'";
DatabaseOperations.UpdateTable(commandText);
}
public static void DeleteFromTable(string id)
{
string commandText = "delete from Table_Basvuru where id = '" + id + "'";
DatabaseOperations.UpdateTable(commandText);
}