public void CreateSchema(string connectionName = null)
{
string script = GetEmbeddedResourceFile("Tiraggo.AspNet.Identity.Schema.sql");
// split script on GO command
IEnumerable <string> commandStrings = Regex.Split(script, @"^\s*GO\s*$", RegexOptions.Multiline | RegexOptions.IgnoreCase);
using (tgTransactionScope scope = new tgTransactionScope())
{
tgUtility util = new tgUtility();
if (connectionName != null)
{
util.ConnectionServiceOverride(connectionName);
}
foreach (string commandString in commandStrings)
{
if (!String.IsNullOrWhiteSpace(commandString))
{
switch (commandString)
{
case "SET ANSI_NULLS ON":
case "SET QUOTED_IDENTIFIER ON":
continue;
default:
util.ExecuteNonQuery(tgQueryType.Text, commandString);
break;
}
}
}
scope.Complete();
}
}
public void Delete(TVShows show)
{
if (this.MessageBoxService.ShowMessage("Are you sure you wish to delete the selected show?", "Confirm", MessageButton.YesNo, MessageIcon.Question) == MessageResult.Yes)
{
try
{
this.SplashScreenService.ShowSplashScreen();
using (tgTransactionScope scope = new tgTransactionScope())
{
show.MarkAsDeleted();
this.TVShowsCollection.Save();
this.Shows.Remove(show);
scope.Complete();
}
this.SplashScreenService.HideSplashScreen();
}
catch (Exception ex)
{
this.SplashScreenService.HideSplashScreen();
this.MessageBoxService.ShowMessage(ex.Message, "Error");
}
}
}
