static bool InsertPop3Credential(MySqlCommand cmd, ulong countryId, Pop3Credential item) { lock (cmd) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("HOST", countryId); cmd.Parameters.AddWithValue("PORT", item.Port); cmd.Parameters.AddWithValue("TYPE", item.Type.ToString()); cmd.Parameters.AddWithValue("AUTH_TYPE", NotNull(item.AuthType)); cmd.Parameters.AddWithValue("DATE", item.Date.Substring(0, 10)); cmd.Parameters.AddWithValue("HOUR", item.Date.Substring(11, 5)); cmd.Parameters.AddWithValue("USER", NotNull(item.User)); cmd.Parameters.AddWithValue("PASS", NotNull(item.Password)); cmd.Parameters.AddWithValue("VALID", item.IsValid ? 1 : 0); cmd.CommandText = "INSERT IGNORE INTO credentials_pop3(HOST,PORT,TYPE,AUTH_TYPE,DATE,HOUR,USER,PASS,VALID)VALUES(@HOST,@PORT,@TYPE,@AUTH_TYPE,@DATE,@HOUR,@USER,@PASS,@VALID);"; cmd.ExecuteNonQuery(); return(true); } }
static void InsertPop3Credential(MySqlCommand cmd, ulong id, Pop3Credential item) { }