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);
}
