/// <summary> /// DeleteAddressContext - Will do a soft delete (make inactive) by AddrID /// </summary> /// <param name="_cAddress"></param> public void DeleteAddressContext(sp_Vol_Address_DM _cAddress, sp_Vol_Addr_DM _cVolAddr) { using (VolTeerEntities context = new VolTeerEntities()) { try { var AddrToRemove = (from n in context.tblVolAddrs where n.AddrID == _cVolAddr.AddrID select n).FirstOrDefault(); if (AddrToRemove != null) context.tblVolAddrs.Remove(AddrToRemove); context.SaveChanges(); var AddressToRemove = (from n in context.tblVolAddresses where n.AddrID == _cAddress.AddrID select n).FirstOrDefault(); //context.tblVolAddresses.Remove(AddressToRemove); AddressToRemove.ActiveFlg = false; if (AddressToRemove != null) context.sp_Vol_Address_Update(AddressToRemove.AddrID, AddressToRemove.ActiveFlg, AddressToRemove.AddrLine1, AddressToRemove.AddrLine2, AddressToRemove.AddrLine3, AddressToRemove.City, AddressToRemove.St, AddressToRemove.Zip, AddressToRemove.Zip4, AddressToRemove.GeoCodeGetSet); context.SaveChanges(); } catch (Exception ex) { throw (ex); } } }
/// <summary> /// DeleteAddressContext - Will do a soft delete (make inactive) by AddrID /// </summary> /// <param name="_cAddress"></param> public void DeleteAddressContext(sp_Vol_Address_DM _cAddress) { using (VolTeerEntities context = new VolTeerEntities()) { var AddressToRemove = (from n in context.tblVolAddresses where n.AddrID == _cAddress.AddrID select n).FirstOrDefault(); context.tblVolAddresses.Remove(AddressToRemove); context.SaveChanges(); } }
/// <summary> /// DeleteAddressContext - Remove from cache and call delete method in BLL. /// </summary> /// <param name="_cAddress"></param> /// <param name="_cVolAddr"></param> public void DeleteAddressContext(sp_Vol_Address_DM _cAddress, sp_Vol_Addr_DM _cVolAddr) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Vol_Address_DM cacheAddress; cacheAddress = (sp_Vol_Address_DM)cache[RecordType.VolAddr + _cVolAddr.VolID.ToString() + _cAddress.AddrID.ToString()]; if (cacheAddress != null) { cache.Remove(RecordType.VolAddr + "|" + _cVolAddr.VolID.ToString() + "|" + _cAddress.AddrID.ToString()); } BLL.DeleteAddressContext(_cAddress, _cVolAddr); }
public void DeleteAddressContext(sp_Vol_Address_DM _cAddress) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Vol_Address_DM cacheAddress; cacheAddress = (sp_Vol_Address_DM)cache[_cAddress.AddrID.ToString()]; if (cacheAddress != null) { cache.Remove(_cAddress.AddrID.ToString()); } BLL.DeleteAddressContext(_cAddress); }
public static void InsertVolAddressData(TestContext testContext) { System.Diagnostics.Debug.WriteLine(String.Format("{0}", DateTime.Now)); cExcel.RemoveAllData(); cExcel.InsertData(ExcelFilenames); sp_Volunteer_BLL volBLL = new sp_Volunteer_BLL(); generalTestVol = new sp_Volunteer_DM(); generalTestVol.VolFirstName = "TestFirst"; generalTestVol.VolMiddleName = "TestMiddle"; generalTestVol.VolLastName = "TestLast"; generalTestVol.ActiveFlg = true; generalTestVol.VolID = Guid.NewGuid(); volBLL.InsertVolunteerContext(ref generalTestVol); sp_Vol_Address_BLL volAddress_bll = new sp_Vol_Address_BLL(); primaryTestVolAddress = new sp_Vol_Address_DM(); primaryTestVolAddress.AddrLine1 = "PrimaryLine1"; primaryTestVolAddress.AddrLine2 = "PrimaryLine2"; primaryTestVolAddress.AddrLine3 = "PrimaryLine3"; primaryTestVolAddress.City = "PrimaryCity"; primaryTestVolAddress.St = "PS"; primaryTestVolAddress.Zip = 12345; primaryTestVolAddress.Zip4 = 6789; primaryTestVolAddress.VolID = generalTestVol.VolID; primaryTestVolAddress.ActiveFlg = true; primaryTestVolAddress.PrimaryAddr = true; primaryTestVolAddr = new sp_Vol_Addr_DM(); primaryTestVolAddr.VolID = generalTestVol.VolID; primaryTestVolAddr.PrimaryAddr = true; volAddress_bll.InsertAddressContext(ref primaryTestVolAddress, ref primaryTestVolAddr); secondaryTestVolAddress = new sp_Vol_Address_DM(); secondaryTestVolAddress.AddrLine1 = "SecondaryLine1"; secondaryTestVolAddress.AddrLine2 = "SecondaryLine2"; secondaryTestVolAddress.AddrLine3 = "SecondaryLine3"; secondaryTestVolAddress.City = "SecondaryCity"; secondaryTestVolAddress.St = "SS"; secondaryTestVolAddress.Zip = 98765; secondaryTestVolAddress.Zip4 = 4321; secondaryTestVolAddress.VolID = generalTestVol.VolID; secondaryTestVolAddress.ActiveFlg = true; secondaryTestVolAddress.PrimaryAddr = false; secondaryTestVolAddr = new sp_Vol_Addr_DM(); secondaryTestVolAddr.VolID = generalTestVol.VolID; secondaryTestVolAddr.PrimaryAddr = false; volAddress_bll.InsertAddressContext(ref secondaryTestVolAddress, ref secondaryTestVolAddr); }
public void UpdateAddressContext(sp_Vol_Address_DM _cAddress) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Vol_Address_DM cacheAddress; cacheAddress = (sp_Vol_Address_DM)cache[_cAddress.AddrID.ToString()]; if (cacheAddress != null) { cache.Remove(_cAddress.AddrID.ToString()); } cache.Insert(_cAddress.AddrID.ToString(), _cAddress, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); BLL.UpdateAddressContext(_cAddress); }
/// <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(); } }
public sp_Vol_Address_DM hCreateVolAddress(string AddrLine1,string AddrLine2,string AddrLine3,string City,string State,Nullable<int> Zip,Nullable<int> Zip4,bool PrimaryAddr,Guid VolID) { sp_Vol_Address_DM VolAddress = new sp_Vol_Address_DM(); sp_Vol_Addr_DM VolAddr = new sp_Vol_Addr_DM(); sp_Vol_Address_BLL VolAddressBll = new sp_Vol_Address_BLL(); VolAddress.AddrLine1 = AddrLine1; VolAddress.AddrLine2 = AddrLine2; VolAddress.AddrLine3 = AddrLine3; VolAddress.City = City; VolAddress.St = State; VolAddress.Zip = Zip; VolAddress.Zip4 = Zip4; VolAddr.VolID = VolID; VolAddr.PrimaryAddr = PrimaryAddr; VolAddressBll.InsertAddressContext(ref VolAddress,ref VolAddr); return VolAddress; }
/// <summary> /// ListAddress - There's a good chance the same record may be requested often. Cache the address object... /// /// </summary> /// <param name="Address"></param> /// <returns></returns> public sp_Vol_Address_DM ListAddresses(int? Address) { sp_Vol_Address_DM cAddress = new sp_Vol_Address_DM(); //Cache cache = HttpRuntime.Cache; System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Vol_Address_DM cacheAddress; cacheAddress = (sp_Vol_Address_DM)cache[Address.ToString()]; if (cacheAddress == null) { cAddress = BLL.ListAddresses(Address); cache.Insert(cAddress.AddrID.ToString(), cAddress, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); } else { cAddress = cacheAddress; } return cAddress; }
public void DeleteAddressContext(sp_Vol_Address_DM _cAddress, sp_GroupAddr_DM _cGroupAddr) { using (VolTeerEntities context = new VolTeerEntities()) { try { var AddrToRemove = (from n in context.tblGroupAddrs where n.AddrID == _cGroupAddr.AddrID select n).FirstOrDefault(); context.tblGroupAddrs.Remove(AddrToRemove); context.SaveChanges(); var AddressToRemove = (from n in context.tblVolAddresses where n.AddrID == _cAddress.AddrID select n).FirstOrDefault(); context.tblVolAddresses.Remove(AddressToRemove); context.SaveChanges(); } catch (Exception ex) { throw (ex); } } }
/// <summary> /// rGridAddress_NeedDataSource - Called when the grid needs a data source /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rGridAddress_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { try { sp_Vol_Address_DM VolDM = new sp_Vol_Address_DM(); VolDM.VolID = (Guid)currentUser.ProviderUserKey; //rGridAddress.DataSource = VolAddrBLL.ListAddresses(VolDM); rGridAddress.DataSource = VolAddrCash.ListAddresses(VolDM); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } }
/// <summary> /// rGridAdress_UpdIns - Handle update/insert in a common procedure /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <param name="iAction"></param> protected void rGridAdress_UpdIns(object sender, GridCommandEventArgs e, int iAction) { try { GridEditableItem eeditedItem = e.Item as GridEditableItem; sp_Vol_Address_DM VolAddressDM = new sp_Vol_Address_DM(); sp_Vol_Addr_DM VolAddrDM = new sp_Vol_Addr_DM(); VolAddrDM.VolID = (Guid)currentUser.ProviderUserKey; ; VolAddressDM.VolID = (Guid)currentUser.ProviderUserKey; if (iAction == (int)RecordAction.Update) { VolAddressDM.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]); pre_ID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]); VolAddrDM.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]); } VolAddressDM.ActiveFlg = (eeditedItem.FindControl("chkActive") as CheckBox).Checked; VolAddrDM.PrimaryAddr = (eeditedItem.FindControl("chkPrimaryAddr") as CheckBox).Checked; VolAddressDM.AddrLine1 = (eeditedItem.FindControl("rTBAddr1") as RadTextBox).Text.ToString(); VolAddressDM.AddrLine2 = (eeditedItem.FindControl("rTBAddr2") as RadTextBox).Text.ToString(); VolAddressDM.AddrLine3 = (eeditedItem.FindControl("rTBAddr3") as RadTextBox).Text.ToString(); VolAddressDM.City = (eeditedItem.FindControl("rTBCity") as RadTextBox).Text.ToString(); VolAddressDM.St = (eeditedItem.FindControl("rDDSt") as RadDropDownList).SelectedValue.ToString(); VolAddressDM.Zip = Convert.ToInt32((eeditedItem.FindControl("rNTBZip") as RadNumericTextBox).Text); string strZip4 = ((eeditedItem.FindControl("rNTBZip4") as RadNumericTextBox).Text).ToString(); if (strZip4 == string.Empty) { VolAddressDM.Zip4 = null; } else { VolAddressDM.Zip4 = Convert.ToInt32(strZip4.ToString()); } //TODO - Test to see if GeoCode works without USA at end // VolAddressDM.GeoCodeGetSet = GetGeoCode(VolAddressDM); if (iAction == (int)RecordAction.Update) { VolAddrBLL.UpdateAddressContext(VolAddressDM, VolAddrDM); } else if (iAction == (int)RecordAction.Insert) { VolAddrBLL.InsertAddressContext(ref VolAddressDM, ref VolAddrDM); } } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } try { HandleScreenLoad(); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } }
protected void HandleScreenLoad() { currentUser = Membership.GetUser(); pnlSingleAddress.Visible = false; pnlAddressGrid.Visible = true; sp_Vol_Address_DM VolDM = new sp_Vol_Address_DM(); VolDM.VolID = (Guid)currentUser.ProviderUserKey; //rGridAddress.DataSource = VolAddrBLL.ListAddresses(VolDM); rGridAddress.DataSource = VolAddrCash.ListAddresses(VolDM); rGridAddress.DataBind(); }
/// <summary> /// rGridAddress_DeleteCommand - Handle the delete command /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rGridAddress_DeleteCommand(object sender, GridCommandEventArgs e) { sp_Vol_Address_DM VolAddressDM = new sp_Vol_Address_DM(); sp_Vol_Addr_DM VolAddrDM = new sp_Vol_Addr_DM(); try { VolAddressDM.VolID = (Guid)currentUser.ProviderUserKey; VolAddressDM.AddrID = (int)e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["AddrID"]; VolAddrDM.VolID = (Guid)currentUser.ProviderUserKey; VolAddrDM.AddrID = (int)e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["AddrID"]; VolAddrBLL.DeleteAddressContext(VolAddressDM, VolAddrDM); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } }
public void UpdateAddressContext(sp_Vol_Address_DM _cAddress, sp_Vol_Addr_DM _cVolAddr) { DAL.UpdateAddressContext(_cAddress, _cVolAddr); }
protected string GetGeoCode(sp_Vol_Address_DM VolAddr) { GoogleAddress googleAddress = new GoogleAddress(); googleAddress.FormattedAddress = VolAddr.AddrLine1 + ", " + VolAddr.City + ", " + VolAddr.St + " " + VolAddr.Zip; //Assume we want to send the request to Google using SSL IGeocoder geoCoder = new GoogleGeocoder(true); String geoCoderXML = geoCoder.GetLatLongFromAddress(googleAddress); String latitude; String longitude; using (XmlReader reader = XmlReader.Create(new StringReader(geoCoderXML))) { reader.ReadToFollowing("lat"); reader.MoveToFirstAttribute(); latitude = reader.Value; reader.ReadToFollowing("lon"); longitude = reader.Value; } String gcReturn; if (latitude.Contains("unknown") || longitude.Contains("unknown")) { gcReturn = null; } else { gcReturn = "'POINT(" + longitude + " " + latitude + ")'"; } return gcReturn; }
public List<sp_Vol_Address_DM> ListAddresses(sp_Vol_Address_DM cVolAddr) { return DAL.ListAddresses(cVolAddr); }
/// <summary> /// ListPrimaryAddress - List the Primary address /// </summary> /// <param name="cVolAddr"></param> /// <returns></returns> public sp_Vol_Address_DM ListPrimaryAddress(sp_Vol_Address_DM cVolAddr) { return DAL.ListPrimaryAddress(cVolAddr); }
public void InsertAddressContext(ref sp_Vol_Address_DM _cAddress, ref sp_Vol_Addr_DM _cVolAddr) { DAL.InsertAddressContext(ref _cAddress, ref _cVolAddr); }
public sp_Vol_Address_DM ListAddress(sp_Vol_Address_DM cVolAddr) { return ListAddresses(cVolAddr).SingleOrDefault(); }
/// <summary> /// Returns a list of all addresses /// </summary> /// <returns></returns> public List<sp_Vol_Address_DM> ListAddresses(sp_Vol_Address_DM cVolAddr) { List<sp_Vol_Address_DM> list = new List<sp_Vol_Address_DM>(); try { using (VolTeerEntities context = new VolTeerEntities()) { list = (from result in context.sp_Vol_Address_Select(cVolAddr.VolID, cVolAddr.AddrID, null) select new sp_Vol_Address_DM { AddrID = result.AddrID, ActiveFlg = result.ActiveFlg, AddrLine1 = result.AddrLine1, AddrLine2 = result.AddrLine2, AddrLine3 = result.AddrLine3, City = result.City, St = result.St, Zip = result.Zip, Zip4 = result.Zip4, GeoCodeGetSet = result.GeoCodeGetSet, PrimaryAddr = result.PrimaryAddr, VolID = cVolAddr.VolID }).ToList(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return list; }
public void InsertAddressContext(sp_Vol_Address_DM _cAddress) { DAL.InsertAddressContext(_cAddress); }
/// <summary> /// SetPrimaryValues - Paint the screen with default values (use non-telerik controls) /// </summary> protected void SetPrimaryValues() { sp_Vol_Address_DM VolDM = new sp_Vol_Address_DM(); StringBuilder sb = new StringBuilder(); try { VolDM.VolID = (Guid)currentUser.ProviderUserKey; VolDM = VolAddrCash.ListPrimaryAddress(VolDM); lblAddr1.Text = VolDM.AddrLine1; lblAddr2.Text = VolDM.AddrLine2; if (string.IsNullOrEmpty(lblAddr2.Text)) { rowAddr2.Visible = false; } else { rowAddr2.Visible = true; } lblAddr3.Text = VolDM.AddrLine3; if (string.IsNullOrEmpty(lblAddr3.Text)) { rowAddr3.Visible = false; } else { rowAddr3.Visible = true; } sb.Clear(); sb.Append(VolDM.City.ToString()); sb.Append(", "); sb.Append(VolDM.St.ToString()); sb.Append(" "); sb.Append(VolDM.Zip.ToString()); if (!string.IsNullOrEmpty(VolDM.Zip4.ToString())) { sb.Append('-'); sb.Append(VolDM.Zip4.ToString()); } lblCityStZip.Text = sb.ToString(); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } }
/// <summary> /// UpdateAddressContext - Will update a given Address record by AddrID /// </summary> /// <param name="_cAddress"></param> public void UpdateAddressContext(sp_Vol_Address_DM _cAddress, sp_Vol_Addr_DM _cVolAddr) { try { using (VolTeerEntities context = new VolTeerEntities()) { var cAddress = context.tblVolAddresses.Find(_cAddress.AddrID); var cVolAddr = context.tblVolAddrs.Find(_cVolAddr.VolID,_cVolAddr.AddrID); if (cAddress != null) { cAddress.AddrLine1 = _cAddress.AddrLine1; cAddress.AddrLine2 = _cAddress.AddrLine2; cAddress.AddrLine3 = _cAddress.AddrLine3; cAddress.City = _cAddress.City; cAddress.St = _cAddress.St; cAddress.Zip = _cAddress.Zip; cAddress.Zip4 = _cAddress.Zip4; cAddress.ActiveFlg = _cAddress.ActiveFlg; cAddress.GeoCodeGetSet = _cAddress.GeoCodeGetSet; } if (cVolAddr != null) { cVolAddr.VolID = _cVolAddr.VolID; cVolAddr.AddrID = _cVolAddr.AddrID; cVolAddr.PrimaryAddr = _cVolAddr.PrimaryAddr; } context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
public sp_Vol_Address_DM ListPrimaryAddress(sp_Vol_Address_DM cVolAddr) { sp_Vol_Address_DM item = new sp_Vol_Address_DM(); try { using (VolTeerEntities context = new VolTeerEntities()) { item = (from result in context.sp_Vol_Address_Select(cVolAddr.VolID, null, true) select new sp_Vol_Address_DM { AddrID = result.AddrID, ActiveFlg = result.ActiveFlg, AddrLine1 = result.AddrLine1, AddrLine2 = result.AddrLine2, AddrLine3 = result.AddrLine3, City = result.City, St = result.St, Zip = result.Zip, Zip4 = result.Zip4, GeoCodeGetSet = result.GeoCodeGetSet, PrimaryAddr = result.PrimaryAddr, VolID = cVolAddr.VolID }).FirstOrDefault(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return item; }
public void DeleteAddressContext(sp_Vol_Address_DM _cAddress) { DAL.DeleteAddressContext(_cAddress); }
/// <summary> /// SetPrimaryValues - Paint the screen with default values (use non-telerik controls) /// </summary> protected void SetPrimaryValues() { //setup and bind all 3 primary values currentUser = Membership.GetUser(); sp_Vol_Address_DM address_DM = new sp_Vol_Address_DM(); sp_Email_DM email_DM = new sp_Email_DM(); sp_Phone_DM phone_DM = new sp_Phone_DM(); StringBuilder sb = new StringBuilder(); try { //email code email_DM.VolID = (Guid)currentUser.ProviderUserKey; email_DM = VolEmailCache.ListPrimaryEmail(email_DM); if (email_DM != null) { PrimaryEmail.Text = email_DM.EmailAddr; } else { PrimaryEmail.Text = "-- NONE --"; } //phone code phone_DM.VolID = (Guid)currentUser.ProviderUserKey; phone_DM = VolPhoneCache.ListPrimaryPhone(phone_DM); if (phone_DM != null) { PrimaryPhone.Text = phone_DM.PhoneNbr; } else { PrimaryPhone.Text = "-- NONE --"; } //address code address_DM.VolID = (Guid)currentUser.ProviderUserKey; address_DM = VolAddrCash.ListPrimaryAddress(address_DM); sb.Clear(); if (address_DM != null) { sb.Append(address_DM.AddrLine1.ToString()); sb.Append(" "); if (!string.IsNullOrEmpty(address_DM.AddrLine2)) { sb.Append(address_DM.AddrLine2.ToString()); sb.Append(" "); } if (!string.IsNullOrEmpty(address_DM.AddrLine3)) { sb.Append(address_DM.AddrLine3.ToString()); sb.Append(" "); } sb.Append(", "); sb.Append(address_DM.City.ToString()); sb.Append(" "); sb.Append(address_DM.St.ToString()); sb.Append(", "); sb.Append(address_DM.Zip.ToString()); if (!string.IsNullOrEmpty(address_DM.Zip4.ToString())) { sb.Append('-'); sb.Append(address_DM.Zip4.ToString()); } } PrimaryAddress.Text = sb.ToString(); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL Response.Redirect(url); // Go to the error page. } }
public void UpdateAddressContext(sp_Vol_Address_DM _cAddress) { DAL.UpdateAddressContext(_cAddress); }
public void DeleteAddressContext(sp_Vol_Address_DM _cAddress, sp_Vol_Addr_DM _cVolAddr) { DAL.DeleteAddressContext(_cAddress, _cVolAddr); }