/// <summary> /// InsertAddressContext - Will insert a record into Address table via SProc /// </summary> /// <param name="_cAddress"></param> public void InsertAddressContext(ref sp_Vol_Address_DM _cAddress, ref sp_Vol_Addr_DM _cVolAddr) { using (VolTeerEntities context = new VolTeerEntities()) { try { var cAddress = new tblVolAddress { AddrLine1 = _cAddress.AddrLine1, AddrLine2 = _cAddress.AddrLine2, AddrLine3 = _cAddress.AddrLine3, City = _cAddress.City, St = _cAddress.St, Zip = _cAddress.Zip, Zip4 = _cAddress.Zip4, GeoCodeGetSet = _cAddress.GeoCodeGetSet, ActiveFlg = _cAddress.ActiveFlg }; context.tblVolAddresses.Add(cAddress); context.SaveChanges(); var cVolAddr = new tblVolAddr { VolID = _cVolAddr.VolID, AddrID = cAddress.AddrID, PrimaryAddr = _cVolAddr.PrimaryAddr }; context.tblVolAddrs.Add(cVolAddr); context.SaveChanges(); //If the AddrID isn't null, set it equal to the return value if (cAddress.AddrID != null) _cAddress.AddrID = cAddress.AddrID; if (cVolAddr.AddrID != null) _cVolAddr.AddrID = cVolAddr.AddrID; } catch (Exception ex) { throw (ex); } } }
/// <summary> /// InsertAddressContext - Will insert a record into Address table via SProc /// </summary> /// <param name="_cAddress"></param> public void InsertAddressContext(sp_Vol_Address_DM _cAddress) { using (VolTeerEntities context = new VolTeerEntities()) { var cAddress = new tblVolAddress { AddrID = _cAddress.AddrID, AddrLine1 = _cAddress.AddrLine1, AddrLine2 = _cAddress.AddrLine2, AddrLine3 = _cAddress.AddrLine3, City = _cAddress.City, St = _cAddress.St, Zip = _cAddress.Zip, Zip4 = _cAddress.Zip4, ActiveFlg = _cAddress.ActiveFlg }; context.tblVolAddresses.Add(cAddress); context.SaveChanges(); } }