public Guid Create(Model.Member memberEntity) { var context = new CMS_DataContext(); var member = new DataAccess.Member() { Id = memberEntity.Id, FirstName = memberEntity.FirstName, MiddleName = memberEntity.MiddleName, LastName = memberEntity.LastName, Age = memberEntity.Age, Gender = memberEntity.Gender, Birthday = string.IsNullOrEmpty(memberEntity.Birthday)? (DateTime?)null: DateTime.Parse(memberEntity.Birthday), MobilePhone = memberEntity.MobilePhone, LandLine = memberEntity.LandLine, Address = memberEntity.Address, MaritalStatus = memberEntity.MaritalStatus, NameOfSpouse = memberEntity.NameOfSpouse, SpouseContact = memberEntity.SpouseContact, ChildrenCount = memberEntity.ChildrenCount, MemberStatus = memberEntity.MemberStatus, BaptizedDate = string.IsNullOrEmpty(memberEntity.BaptizedDate)?(DateTime?)null:DateTime.Parse(memberEntity.BaptizedDate), BaptizedPlace = memberEntity.BaptizedPlace, BaptizedMinister = memberEntity.BaptizedMinister, BelongsToGroups = memberEntity.BelongsToGroups, Positions = memberEntity.Positions }; context.Members.InsertOnSubmit(member); context.SubmitChanges(); return(memberEntity.Id); }
public Member MemberIDataReader(IDataReader dr) { DataAccess.Member obj = new DataAccess.Member(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString(); obj.Username = (dr["Username"] is DBNull) ? string.Empty : dr["Username"].ToString(); obj.Password = (dr["Password"] is DBNull) ? string.Empty : dr["Password"].ToString(); obj.GroupMemberId = (dr["GroupMemberId"] is DBNull) ? string.Empty : dr["GroupMemberId"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); return(obj); }
public List <Member> Member_GetByAll() { List <DataAccess.Member> list = new List <DataAccess.Member>(); DataAccess.Member obj = new DataAccess.Member(); DbCommand cmd = db.GetStoredProcCommand("sp_Member_GetByAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.MemberIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }