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