public int ShareCube(ContentUserMappingModel model, OrmLiteConnectionFactory dbFactory) { int lastInsertedId = 0; using (var dbConn = dbFactory.OpenDbConnection()) { dbConn.Save(model); lastInsertedId = model.Id; } return(lastInsertedId); }
public int CreateContent(ContentModel model, int userid, OrmLiteConnectionFactory dbFactory) { int lastInsertedId = 0; using (var dbConn = dbFactory.OpenDbConnection()) { dbConn.Save(model); lastInsertedId = model.Id; ContentUserMappingModel mapping = new ContentUserMappingModel() { ContentId = lastInsertedId, UserId = userid, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, IsActive = true }; dbConn.Insert <ContentUserMappingModel>(mapping); } return(lastInsertedId); }
public int AddContentToCube(CubeContentMappingModel model, int userid, OrmLiteConnectionFactory dbFactory) { int lastInsertedId = 0; using (var dbConn = dbFactory.OpenDbConnection()) { CubeContentMappingModel mapping = new CubeContentMappingModel() { CubeId = model.CubeId, ContentId = model.ContentId, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, IsActive = true }; dbConn.Save(mapping); lastInsertedId = model.Id; var cubes = dbConn.Select <CubeUserMappingModel>("select * from cubeusermapping where cubeid = " + model.CubeId + " and isactive = 1"); var userids = cubes.Select(x => x.UserId).ToList(); userids.Remove(userid); if (userids != null && userids.Count > 0) { userids.ForEach(x => { ContentUserMappingModel mapping1 = new ContentUserMappingModel() { ContentId = model.ContentId, UserId = x, ModifiedDate = DateTime.Now, CreatedDate = DateTime.Now, IsActive = true }; dbConn.Save(mapping1); }); } } return(lastInsertedId); }