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