public AppJSON Update(string staffCode, App app) { AppJSON result = new AppJSON(); if (app != null) { StringBuilder sbSQL = new StringBuilder(); try { using (NpgDB npgDB = Connection.DBConnect()) { sbSQL.AppendLine("UPDATE mapp"); sbSQL.AppendLine("SET"); sbSQL.AppendLine("name = :p_name,"); sbSQL.AppendLine("description = :p_description,"); if (app.icon != "") { sbSQL.AppendLine("icon = :p_icon,"); } sbSQL.AppendLine("upopr = :p_staff_code,"); sbSQL.AppendLine("upstmp = CURRENT_TIMESTAMP"); sbSQL.AppendLine("WHERE appid = :p_appid"); sbSQL.AppendLine("RETURNING appid"); npgDB.Command = sbSQL.ToString(); npgDB.SetParams(":p_name", app.name); npgDB.SetParams(":p_description", app.description); if (app.icon != "") { npgDB.SetParams(":p_icon", app.icon); } npgDB.SetParams(":p_staff_code", staffCode); npgDB.SetParams(":p_appid", app.appId); using (NpgsqlDataReader rec = npgDB.Query()) { if (rec.Read()) { string updatedAppId = NpgDB.getString(rec, "appid"); result.app = new App { appId = updatedAppId }; result.success = true; } } } } catch (Exception ex) { } } return(result); }
public AppJSON Create(string staffCode, App app) { AppJSON result = new AppJSON(); if (app != null) { StringBuilder sbSQL = new StringBuilder(); try { using (NpgDB npgDB = Connection.DBConnect()) { sbSQL.AppendLine("INSERT INTO mapp"); sbSQL.AppendLine("("); sbSQL.AppendLine("appid, name, description, icon, upopr"); sbSQL.AppendLine(")"); sbSQL.AppendLine("VALUES"); sbSQL.AppendLine("("); sbSQL.AppendLine(":p_appid, :p_name, :p_description, :p_icon, :p_upopr"); sbSQL.AppendLine(")"); sbSQL.AppendLine("RETURNING appid, name, description, icon, upopr"); npgDB.Command = sbSQL.ToString(); npgDB.SetParams(":p_appid", app.appId); npgDB.SetParams(":p_name", app.name); npgDB.SetParams(":p_description", app.description); npgDB.SetParams(":p_icon", app.icon); npgDB.SetParams(":p_upopr", staffCode); using (NpgsqlDataReader rec = npgDB.Query()) { if (rec.Read()) { result.app = new App(rec); result.success = true; } } } } catch (Exception ex) { } } return(result); }
public AppJSON Delete(string staffCode, string appId) { AppJSON result = new AppJSON(); StringBuilder sbSQL = new StringBuilder(); try { using (NpgDB npgDB = Connection.DBConnect()) { sbSQL.AppendLine("UPDATE mapp"); sbSQL.AppendLine("SET endstmp = CURRENT_TIMESTAMP,"); sbSQL.AppendLine("upopr = :p_staff_code,"); sbSQL.AppendLine("upstmp = CURRENT_TIMESTAMP"); sbSQL.AppendLine("WHERE appid = :p_appid"); sbSQL.AppendLine("RETURNING appid"); npgDB.Command = sbSQL.ToString(); npgDB.SetParams(":p_staff_code", staffCode); npgDB.SetParams(":p_appid", appId); using (NpgsqlDataReader rec = npgDB.Query()) { if (rec.Read()) { string deletedAppId = NpgDB.getString(rec, "appid"); result.app = new App { appId = deletedAppId }; result.success = true; } } } } catch (Exception ex) { } return(result); }