C# (CSharp) Igman.DB.DAL Tag Examples

Example #1

File: ArticlesController.cs Project: fitba/km-2013-projects-team-igman

 private List<Igman.DB.DAL.Tag> SinhronyzeWithDB(List<Models.Json.Tag> list, List<Models.Json.Tag> insideList)
 {
     var lTag = new List<Igman.DB.DAL.Tag>();
     using (DBBL Baza = new DBBL())
     {
         foreach (var tag in list)
         {
             Igman.DB.DAL.Tag t = new Igman.DB.DAL.Tag();
             t.Name = tag.Naziv;
             t.GUID = Guid.NewGuid();
             lTag.Add(Baza.AddTag(t));
         }
     }
     foreach (var tag in insideList)
     {
         Igman.DB.DAL.Tag t = new Igman.DB.DAL.Tag();
         t.Name = tag.Naziv;
         t.GUID = Guid.NewGuid();
         t.TagID = tag.TagID.ToInt();
         lTag.Add(t);
     }
     return lTag;
 }

Example #2

File: DBBL.cs Project: fitba/km-2013-projects-team-igman

 public Tag AddTag(Tag t)
 {
     string cmd = string.Format("EXEC dbo.usp_TagInsert '{0}','{1}'", t.GUID, t.Name);
     return context.Database.SqlQuery<Tag>(cmd).SingleOrDefault();
 }