protected void lbtGenerateTestData_Click(object sender, EventArgs e)
{
SqlScriptRunner.RunScript(Server.MapPath("~/App_Data/SQL/Data/Clean-Data.sql"));
SqlScriptRunner.RunScript(Server.MapPath("~/App_Data/SQL/Data/Create-Data.sql"));
ltlMessage.Text = MessageFormatter.GetFormattedSuccessMessage("Test Data Generated.");
Page.DataBind();
}
protected void buttonInstall_Click(object sender, EventArgs e)
{
try
{
SqlScriptRunner.RunScript(Server.MapPath("~") + @"\App_Data\SQL\Schema\Create-Schema.sql");
SqlScriptRunner.RunScript(Server.MapPath("~") + @"\App_Data\SQL\Data\Create-Data.sql");
labelMessage.Text = MessageFormatter.GetFormattedSuccessMessage("Congratulations! Database installation successful. Click <a href=\"../../../default.aspx\">here </a>to start using Employee Info Starter Kit.");
}
catch (Exception ex)
{
labelMessage.Text = MessageFormatter.GetFormattedErrorMessage("Database installation failed. Please provide a appropriate creadential that has permission to install database. <br>" + ex.ToString());
}
}
public static void CleanTestData()
{
SqlScriptRunner.RunScript(srciptRoot + "Data\\Clean-Data.sql");
}
public static void GenerateTestData()
{
SqlScriptRunner.RunScript(srciptRoot + "Data\\Create-Data.sql");
}
public static void CleanSchema()
{
SqlScriptRunner.RunScript(srciptRoot + "Schema\\Clean-Schema.sql");
}
public static void CreateSchema()
{
SqlScriptRunner.RunScript(srciptRoot + "Schema\\Create-Schema.sql");
}
