private void AddMoreInformation(string userCode, PT_PrjMember member) { DataTable oldInfo = this.GetOldInfo(userCode); if ((oldInfo != null) && (oldInfo.Rows.Count > 0)) { member.Post = oldInfo.Rows[0]["Post"].ToString(); member.EducationalBackground = oldInfo.Rows[0]["EducationalBackground"].ToString() + oldInfo.Rows[0]["Specialty"].ToString(); member.Technical = oldInfo.Rows[0]["Technical"].ToString(); member.PastPerformance = oldInfo.Rows[0]["PastPerformance"].ToString(); member.PostAndCompetency = oldInfo.Rows[0]["PostAndCompetency"].ToString(); member.TrainingInformation = oldInfo.Rows[0]["Courses"].ToString(); } }
public static void Update(PrjMember model) { using (pm2Entities entities = new pm2Entities()) { PT_PrjMember member = (from m in entities.PT_PrjMember where m.PrjMemberId == model.PrjMemberId select m).FirstOrDefault <PT_PrjMember>(); if (member != null) { member.Post = model.Post; member.PostAndCompetency = model.PostAndCompetency; member.PastPerformance = model.PastPerformance; member.Technical = model.Technical; member.TrainingInformation = model.TrainingInformation; member.EducationalBackground = model.EducationalBackground; entities.SaveChanges(); } } }
public static void Add(string id, List <string> codes) { using (pm2Entities entities = new pm2Entities()) { Guid guid = new Guid(id); PrjMember member = new PrjMember(); List <string> list = GetCodes(id); using (List <string> .Enumerator enumerator = list.GetEnumerator()) { string code; while (enumerator.MoveNext()) { code = enumerator.Current; if (!codes.Contains(code)) { PT_PrjMember entity = (from m in entities.PT_PrjMember where (m.PrjGuid == guid) && (m.PT_yhmc.v_yhdm == code) select m).FirstOrDefault <PT_PrjMember>(); if (entity != null) { entities.DeleteObject(entity); DelFile(entity.PrjMemberId); } } } } foreach (string str in codes) { if (!list.Contains(str)) { member.AddSign(guid, str, entities); } } entities.SaveChanges(); } }