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