public static void insertPhotoId(string UseName, string LikePhotoId) { try { string insertQuery = "insert into " + tableLikeInfo + "(UseName,Status,LikePhotoId) values('" + UseName + "','" + "1" + "','" + LikePhotoId + "')"; DBHandler.InsertQuery(insertQuery, tableLikeInfo); } catch { } }
public static void insertAccount(string username, string password, string addr, string port, string user, string pass, string path) { try { string insertQuery = "Insert into " + tableAccountInfo + " (Username, Password,proxyAddress,proxyPort,proxyUsername,proxyPassword,Path) values('" + username + "','" + password + "','" + addr + "','" + port + "','" + user + "','" + pass + "','" + path + "')"; DBHandler.InsertQuery(insertQuery, tableAccountInfo); } catch { } }
public static void insertLikeStatus(string id, string username, int status) { try { string insertQuery = "Insert into " + tableLikeInfo + " (UseName,Status,LikePhotoId) values('" + username + "'," + status + ",'" + id + "')"; DBHandler.InsertQuery(insertQuery, tableLikeInfo); } catch { } }
public static void insertFollowInfo(string account, string user, string status) { string dt = String.Format("{0:MM/dd/yyyy}", DateTime.Now); try { string insertQuery = "insert into " + tableFollowInfo + "(AccountHolder,FollowingUser,FollowTime,FollowStatus) values('" + account + "','" + user + "','" + dt + "','" + status + "')"; DBHandler.InsertQuery(insertQuery, tableFollowInfo); } catch { } }