public static String GetSolarData(String projectID) { String sqlString = "SELECT Project_id, Job_number, Work_type FROM Project WHERE Project_id = '" + projectID + "'"; String result = SQLServerInterface.ExecuteQuery(sqlString); return(result); }
public static Boolean Login(String username, String password) { SQLServerInterface.this_works(); /**** String sqlString = "SELECT * FROM GreennetUsers WHERE username='******' AND Password='******'"; String result = SQLServerInterface.ExecuteQuery(sqlString); if (result == null) return false; if (result.Length <= 0) return false; *****/ return true; }
static public bool SaveCustomer(string setString) { // setString format: colname=value, colname=value ... String[] tokens = setString.Split(','); String sql = "insert into customer(project_id, phone, email, street, city, state, zip, country) values (1, 555-1212, [email protected], 111 Main Street, San Diego, CA, 92128, USA)"; sql = null; foreach (String s in tokens) { //Do your stuff here if (sql != null) { sql += ","; } else { sql = "INSERT INTO customer ("; } String[] expr = s.Split('='); String var = expr[0]; String val = "\"" + expr[1] + "\""; //if (haveSet) { sql += " " + var; } sql += " ) VALUES ("; Boolean isSet = false; foreach (String s in tokens) { String[] expr = s.Split('='); String var = expr[0]; String val = "\"" + expr[1] + "\""; if (isSet) { sql += ","; } sql += " " + val; isSet = true; } sql += ")"; if (sql != null) { SQLServerInterface.ExecuteQuery(sql); } return(true); }
static public bool UpdateCustomer(string setString, string customer_id) { // setString format: colname=value, colname=value ... String[] tokens = setString.Split(','); String sql = "insert into customer(project_id, phone, email, street, city, state, zip, country) values (1, 555-1212, [email protected], 111 Main Street, San Diego, CA, 92128, USA)"; sql = null; bool haveSet = false; foreach (String s in tokens) { //Do your stuff here if (sql != null) { sql += ","; } else { sql = "UPDATE customer "; } String[] expr = s.Split('='); String var = expr[0]; String val = "\"" + expr[1] + "\""; if (haveSet) { sql += " " + var + " = " + val; } else { sql += "SET " + " " + var + " = " + val; } haveSet = true; } if (sql != null) { sql += " WHERE customer_id = \"" + customer_id + "\""; SQLServerInterface.ExecuteQuery(sql); } return(true); }