public int AddNew(ExistingMember existingMember) { using (var entities = new atmEntities()) { var exist = (from a in entities.tblExistingAtmMembers where a.ICNOBaru == existingMember.IdNumber select a).SingleOrDefault(); if (null != exist) { exist.COID = exist.COID; return Update(existingMember); } var atm = new tblExistingAtmMember() { COID = existingMember.CoId, CONm = existingMember.Name, ICNOBaru = existingMember.IdNumber, NoTentera = existingMember.ArmyNo, ExistingMemberStatusCd = existingMember.Status }; entities.tblExistingAtmMembers.Add(atm); if (entities.SaveChanges() > 0) return atm.COID; } return 0; }
public IEnumerable<ExistingMember> Search(string status, string searchcriteria, string armyno) { var list = new List<ExistingMember>(); using (var entities = new atmEntities()) { var l = from a in entities.tblExistingAtmMembers select a; if (!string.IsNullOrWhiteSpace(status)) l = l.Where(a => a.ExistingMemberStatusCd == status); if (!string.IsNullOrWhiteSpace(searchcriteria)) l = l.Where(a => a.CONm.Contains(searchcriteria) || a.ICNOBaru.Contains(searchcriteria)); if (!string.IsNullOrWhiteSpace(armyno)) l = l.Where(a => a.NoTentera == armyno); foreach (var atm in l) { var ea = new ExistingMember() { CoId = atm.COID, ArmyNo = atm.NoTentera, IdNumber = atm.ICNOBaru, Name = atm.CONm }; if (!string.IsNullOrWhiteSpace(atm.ExistingMemberStatusCd)) { ea.ExistingMemberStatus = new ExistingMemberStatus() { Code = atm.tblREFExistingMemberStatu.ExistingMemberStatusCD, Status = atm.tblREFExistingMemberStatu.ExistingMemberStatus }; } list.Add(ea); } } return list; }
public ExistingMember ExistingAtmMemberByArmyNo(string armyno) { if (!string.IsNullOrWhiteSpace(armyno)) { using (var entities = new atmEntities()) { var exist = (from a in entities.tblExistingAtmMembers where a.NoTentera == armyno select a).SingleOrDefault(); if (null != exist) { var atm = new ExistingMember { CoId = exist.COID, Name = exist.CONm, ArmyNo = exist.NoTentera, IdNumber = exist.ICNOBaru, }; if (!string.IsNullOrWhiteSpace(exist.ExistingMemberStatusCd)) { atm.ExistingMemberStatus = new ExistingMemberStatus { Code = exist.tblREFExistingMemberStatu.ExistingMemberStatusCD, Status = exist.tblREFExistingMemberStatu.ExistingMemberStatus }; } return atm; } } } return null; }
public int Update(ExistingMember existingMember) { using (var entities = new atmEntities()) { var exist = (from a in entities.tblExistingAtmMembers where a.COID == existingMember.CoId select a).SingleOrDefault(); if (null != exist) { exist.CONm = existingMember.Name; exist.ICNOBaru = existingMember.IdNumber; exist.NoTentera = existingMember.ArmyNo; exist.ExistingMemberStatusCd = existingMember.Status; if (entities.SaveChanges() > 0) return exist.COID; } } return 0; }