示例#1
0
        /// <summary>
        /// InsertVolunteerContext - Will insert a record into Volunteer table via SProc
        /// </summary>
        /// <param name="_cVolunteer"></param>
        public sp_Volunteer_DM InsertVolunteerContext(ref sp_Volunteer_DM _cVolunteer)
        {
            try
            {
                using (VolTeerEntities context = new VolTeerEntities())
                {
                    var cVolunteer = new tblVolunteer
                    {
                        VolID = _cVolunteer.VolID,
                        VolFirstName = _cVolunteer.VolFirstName,
                        VolMiddleName = _cVolunteer.VolMiddleName,
                        VolLastName = _cVolunteer.VolLastName,
                        ActiveFlg = _cVolunteer.ActiveFlg

                    };
                    context.tblVolunteers.Add(cVolunteer);
                    context.SaveChanges();

                    // pass VolID back to BLL
                    _cVolunteer.VolID = cVolunteer.VolID;

                    return _cVolunteer;
                }
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }
        /// <summary>
        /// InsertVolunteerContext - Will insert a record into Volunteer table via SProc
        /// </summary>
        /// <param name="_cVolunteer"></param>
        public void InsertVolunteerContext(sp_Volunteer_DM _cVolunteer)
        {
            using (VolTeerEntities context = new VolTeerEntities())
            {
                var cVolunteer = new tblVolunteer
                {
                    VolID = _cVolunteer.VolID,
                    VolFirstName = _cVolunteer.VolFirstName,
                    VolMiddleName = _cVolunteer.VolMiddleName,
                    VolLastName = _cVolunteer.VolLastName,
                    ActiveFlg = _cVolunteer.ActiveFlg

                };
                context.tblVolunteers.Add(cVolunteer);
                context.SaveChanges();
            }
        }