protected void Save_Click(object sender, EventArgs e)
{
if (!IsValid)
{
return;
}
DetailScriptData data = new DetailScriptData();
data.name = tbName.Text;
data.scriptingExspression = tbScriptingExpression.Text;
string id = Request.Params["id"];
// Is server added
if (string.IsNullOrEmpty(id))
{
id = IlcWebDao.InsertDetailScriptData(data, User).ToString();
}
else
{
data.scriptId = id;
IlcWebDao.UpdateDetailScriptData(data, User);
}
Response.Write("<script type=\"text/javascript\"> window.opener.parent.__doPostBack('',''); self.close(); </script>");
}
/// <summary>
/// Gets script data
/// </summary>
/// <param name="id">script id</param>
/// <returns>DetailScriptData object</returns>
public static DetailScriptData GetDetailScriptData(string id)
{
DetailScriptData data = new DetailScriptData();
using (DbConnection connection = new OracleConnection(WebSettings.GetConnectionString()))
{
connection.Open();
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"SELECT ILC_SCENARIO_ID, NAME, SCRIPTING_EXPRESSION FROM " +
schemaName + ".ILC_SCENARIO WHERE ILC_SCENARIO_ID =:PARAM_SCENARIO_ID";
AddInputParameter(cmd, "PARAM_SCENARIO_ID", id);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data.scriptId = Convert.ToString(reader[0]);
data.name = Convert.ToString(reader[1]);
data.scriptingExspression = Convert.ToString(reader[2]);
}
}
}
}
return(data);
}
/// <summary>
/// Inserts script data
/// </summary>
/// <param name="data">DetailScriptData object</param>
/// <param name="user">principal object interface</param>
/// <returns>inserted script id</returns>
public static int InsertDetailScriptData(DetailScriptData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
AddInputParameter(cmd, "NAME", data.name);
AddInputParameter(cmd, "EXPRESSION", data.scriptingExspression);
return(ExecuteAndHandleNewId(cmd,
"INSERT INTO " + schemaName + ".ILC_SCENARIO(NAME, SCRIPTING_EXPRESSION) VALUES(:NAME, :EXPRESSION)"));
}
}
}
/// <summary>
/// Updates script data
/// </summary>
/// <param name="data">DetailScriptData object</param>
/// <param name="user">principal object interface</param>
public static void UpdateDetailScriptData(DetailScriptData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"UPDATE " + schemaName + ".ILC_SCENARIO SET NAME=:NAME, SCRIPTING_EXPRESSION=:EXPRESSION " +
"WHERE ILC_SCENARIO_ID = :SCENARIO_ID";
AddInputParameter(cmd, "NAME", data.name);
AddInputParameter(cmd, "EXPRESSION", data.scriptingExspression);
AddInputParameter(cmd, "SCENARIO_ID", data.scriptId);
cmd.ExecuteNonQuery();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.Params["id"];
// Is script added
if (string.IsNullOrEmpty(id))
{
Header.Title = PAGE_TITLE_ADD;
}
else
{
Header.Title = PAGE_TITLE_EDIT;
DetailScriptData data = IlcWebDao.GetDetailScriptData(Request.Params["Id"]);
tbName.Text = data.name;
tbScriptingExpression.Text = data.scriptingExspression;
}
}
}
