private Boolean DoesBuzzwordNotExistInRepository(String name, String category)
{
using (BuzzyCardsDataContext ctx = new BuzzyCardsDataContext(BuzzyGo.Utilities.ConnectionStringHelper.GetCQRSConnectionString()))
{
return ctx.Buzzwords
.Count(b => String.Compare(b.Name, name, true) == 0 &&
String.Compare(b.Category, category, true) == 0) == 0;
}
}
public ActionResult List()
{
ListBuzzwordsViewModel theModel = new ListBuzzwordsViewModel();
using (BuzzyCardsDataContext ctx = new BuzzyCardsDataContext(BuzzyGo.Utilities.ConnectionStringHelper.GetCQRSConnectionString()))
{
ctx.ObjectTrackingEnabled = false;
theModel.Buzzwords = ctx.Buzzwords
.OrderBy(b => b.Category)
.ThenBy(b => b.Name)
.ToList();
}
return View(theModel.Buzzwords);
}
public ActionResult Create()
{
BuzzyGo.Model.Buzz.CreateBuzzViewModel theModel = new Model.Buzz.CreateBuzzViewModel();
using (BuzzyCardsDataContext ctx = new BuzzyCardsDataContext(BuzzyGo.Utilities.ConnectionStringHelper.GetCQRSConnectionString()))
{
ctx.ObjectTrackingEnabled = false;
theModel.BuzzwordCategories = ctx.BuzzCategories.OrderBy(c => c.Name).ToList();
}
CloudHelper.LogMessage(0, "User about to create a new buzzword", "BUZZ");
return View(theModel);
}
public static Guid GetGuidForSequenceID(Int64 seqVal)
{
Int64? theSeq = seqVal;
Guid? theGuid = Guid.Empty;
using (Repository.BuzzyCardsDataContext ctx = new BuzzyCardsDataContext(BuzzyGo.Utilities.ConnectionStringHelper.GetCQRSConnectionString()))
{
ctx.GetGuidForSequence(theSeq, ref theGuid);
}
if (theGuid.HasValue)
{
return theGuid.Value;
}
return Guid.Empty;
}
public static UniqueID GenerateNewUniqueID()
{
Int64? newSeq = null;
Guid? newGuid = Guid.NewGuid();
UniqueID newID;
using (Repository.BuzzyCardsDataContext ctx = new BuzzyCardsDataContext(BuzzyGo.Utilities.ConnectionStringHelper.GetCQRSConnectionString()))
{
ctx.GetNewSequence(newGuid, ref newSeq);
}
if (newSeq.HasValue && newGuid.HasValue)
{
newID = new UniqueID() { SequenceID = newSeq.Value, UniqueIdentifier = newGuid.Value };
}
else
{
newID = new UniqueID();
}
return newID;
}
public ActionResult View(Int64 id)
{
ViewCardViewModel theModel = new ViewCardViewModel();
using (BuzzyCardsDataContext ctx = new BuzzyCardsDataContext(BuzzyGo.Utilities.ConnectionStringHelper.GetCQRSConnectionString()))
{
ctx.ObjectTrackingEnabled = false;
theModel.CardSquareInfo = ctx.CardSquares
.Where(c => c.CardID == id)
.OrderBy(c => c.RowNum)
.ThenBy(c => c.ColNum)
.ToList();
}
theModel.Name = theModel.CardSquareInfo[0].Name;
theModel.CardID = theModel.CardSquareInfo[0].CardID;
CloudHelper.LogMessage(0, String.Format("User VIEWED card {0} ({1})", theModel.Name, id.ToString()), "CARD");
return View(theModel);
}
