public static OrganizationMember AddOrgMember(CMSDataContext db, int organizationId, int peopleId, int memberTypeId, DateTime enrollmentDate, string name)
{
var om = new OrganizationMember
{
OrganizationId = organizationId,
PeopleId = peopleId,
MemberTypeId = memberTypeId,
EnrollmentDate = enrollmentDate,
CreatedDate = Util.Now,
SkipInsertTriggerProcessing = true
};
var et = new EnrollmentTransaction
{
OrganizationId = om.OrganizationId,
PeopleId = om.PeopleId,
MemberTypeId = om.MemberTypeId,
OrganizationName = name,
TransactionDate = enrollmentDate,
EnrollmentDate = enrollmentDate,
TransactionTypeId = 1,
// join
CreatedBy = Util.UserId1,
CreatedDate = Util.Now,
AttendancePercentage = om.AttendPct,
SkipInsertTriggerProcessing = true
};
db.OrganizationMembers.InsertOnSubmit(om);
db.EnrollmentTransactions.InsertOnSubmit(et);
db.SubmitChanges();
return om;
}