/// <summary>
 /// Insert an array of new record to [CompetenceTable] database.Finally
 /// </summary>
 /// <param name="item"></param>
 /// <param name="Id"></param>
 public void Insert_CompetenceTable(UserLevelShow item, int Id)
 {
     s26webDataContext db = new s26webDataContext();
     List<CompetenceTable> ct = new List<CompetenceTable>();
     for (int i = 0; i < item.Competence.Count(); i++)
     {
         ct.Add(new CompetenceTable
         {
             UserLevelId = Id,
             FunctionId = (i + 1),
             Enable = item.Competence[i]
         });
     } db.CompetenceTable.InsertAllOnSubmit(ct);
     db.SubmitChanges();
     db.Connection.Close();
 }
 /// <summary>
 /// Update [Name] of UserLevel and the update function of competence.If success finally, return [1], otherwise, return [-1] 
 /// </summary>
 /// <param name="item"></param>
 /// <returns></returns>
 public int Update_UserLevel(UserLevelShow item)
 {
     s26webDataContext db = new s26webDataContext();
     var data = db.UserLevel.FirstOrDefault(f => f.Id == item.Id);
     if (data != null)
     {
         data.Name = item.Name;
         db.SubmitChanges();
         db.Connection.Close();
         //Another function
         if (Update_FunctionCompetence(item.Competence, item.Id))
         {
             return 1;
         }
     }
     return -1;
 }
 /// <summary>
 /// Insert a new record to [UserLevel] database.Finally, return the record [Id]
 /// </summary>
 /// <param name="item"></param>
 /// <returns></returns>
 public int Insert_UserLevel(UserLevelShow item)
 {
     s26webDataContext db = new s26webDataContext();
     var result = new UserLevel
     {
         Name = item.Name,
         CreateTime = DateTime.UtcNow
     };
     db.UserLevel.InsertOnSubmit(result);
     db.SubmitChanges();
     Insert_CompetenceTable(item, result.Id);
     return result.Id;
 }