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