protected void RegisterUser_CreatedUser(object sender, EventArgs e) { //Log the user in FormsAuthentication.SetAuthCookie(RegisterUser.UserName, createPersistentCookie: false); // Create Volunteer Record RadTextBox userNameTextBox = (RadTextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("UserName"); MembershipUser user = Membership.GetUser(userNameTextBox.Text); sp_Volunteer_BLL BLL = new sp_Volunteer_BLL(); sp_VolEmail_BLL VolEmailBLL = new sp_VolEmail_BLL(); sp_Volunteer_DM vol = new sp_Volunteer_DM(); sp_Email_DM volEmail = new sp_Email_DM(); vol.VolID = (Guid)user.ProviderUserKey; vol.VolFirstName = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("rTXTFirstName") as RadTextBox).Text.Trim(); vol.VolMiddleName = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("rTXTMiddleName") as RadTextBox).Text.Trim(); vol.VolLastName = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("rTXTLastName") as RadTextBox).Text.Trim(); vol.ActiveFlg = true; vol = BLL.InsertVolunteerContext(ref vol); volEmail.VolID = (Guid)user.ProviderUserKey; volEmail.EmailAddr = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("Email") as RadTextBox).Text.Trim(); volEmail.ActiveFlg = true; volEmail.PrimaryFlg = true; VolEmailBLL.InsertEmailContext(ref volEmail); cMail.SendMessage("*****@*****.**", (CreateUserWizardStep1.ContentTemplateContainer.FindControl("Email") as RadTextBox).Text.Trim(), "VolTeer Registration", "Please click link to confirm"); string continueUrl = ConfigurationManager.AppSettings["HomePage"].ToString(); Response.Redirect(continueUrl); }
public static void InsertVolPhoneData(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; System.Guid volID = Guid.NewGuid(); generalTestVol.VolID = volID; volBLL.InsertVolunteerContext(ref generalTestVol); sp_VolPhone_BLL volPhone_bll = new sp_VolPhone_BLL(); primaryTestVolPhone = new sp_Phone_DM(); primaryTestVolPhone.PhoneNbr = "1357924680"; primaryTestVolPhone.VolID = volID; primaryTestVolPhone.ActiveFlg = true; primaryTestVolPhone.PrimaryFlg = true; volPhone_bll.InsertPhoneContext(primaryTestVolPhone); secondaryTestVolPhone = new sp_Phone_DM(); secondaryTestVolPhone.PhoneNbr = "2468013579"; secondaryTestVolPhone.VolID = volID; secondaryTestVolPhone.ActiveFlg = true; secondaryTestVolPhone.PrimaryFlg = false; volPhone_bll.InsertPhoneContext(secondaryTestVolPhone); }
public static void InsertVolEmailData(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; Guid volID = Guid.NewGuid(); generalTestVol.VolID = volID; volBLL.InsertVolunteerContext(ref generalTestVol); sp_VolEmail_BLL volEmail_bll = new sp_VolEmail_BLL(); primaryTestVolEmail = new sp_Email_DM(); primaryTestVolEmail.EmailAddr = "*****@*****.**"; primaryTestVolEmail.VolID = volID; primaryTestVolEmail.ActiveFlg = true; primaryTestVolEmail.PrimaryFlg = true; volEmail_bll.InsertEmailContext(ref primaryTestVolEmail); secondaryTestVolEmail = new sp_Email_DM(); secondaryTestVolEmail.EmailAddr = "*****@*****.**"; secondaryTestVolEmail.VolID = volID; secondaryTestVolEmail.ActiveFlg = true; secondaryTestVolEmail.PrimaryFlg = false; volEmail_bll.InsertEmailContext(ref secondaryTestVolEmail); }
public sp_Volunteer_DM hSelectVolunteer(Guid VolID) { sp_Volunteer_DM VOL = new sp_Volunteer_DM(); sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL(); VOL = VOlBll.ListVolunteers(VolID); return VOL; }
/// <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); } }
public sp_Volunteer_DM InsertVolunteerContext(sp_Volunteer_DM _cVolunteer) { BLL.InsertVolunteerContext(ref _cVolunteer); System.Web.Caching.Cache cache = HttpRuntime.Cache; cache.Insert(_cVolunteer.VolID.ToString(), _cVolunteer, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); return _cVolunteer; }
public void hUpdateVolunteer(sp_Volunteer_DM VOL, string strFirstName, string strMiddleName, string strLastName) { sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL(); VOL.VolFirstName = strFirstName; VOL.VolMiddleName = strMiddleName; VOL.VolLastName = strLastName; VOlBll.UpdateVolunteerContext(VOL); }
/// <summary> /// DeleteVolunteerContext - Will do a soft delete (make inactive) by VolID /// </summary> /// <param name="_cVolunteer"></param> public void DeleteVolunteerContext(sp_Volunteer_DM _cVolunteer) { using (VolTeerEntities context = new VolTeerEntities()) { var VolunteerToRemove = (from n in context.tblVolunteers where n.VolID == _cVolunteer.VolID select n).FirstOrDefault(); context.tblVolunteers.Remove(VolunteerToRemove); context.SaveChanges(); } }
/// <summary> /// Load the User Info based on the current Volunteer /// </summary> protected void LoadUserInfo() { sp_Volunteer_Cache VolCASH = new sp_Volunteer_Cache(); sp_Volunteer_DM VolDM = new sp_Volunteer_DM(); VolDM = VolCASH.ListVolunteers(UserID); rTBFirstName.Text = cCommonFunctions.HandleDBNull(VolDM.VolFirstName); rTBMiddleName.Text = cCommonFunctions.HandleDBNull(VolDM.VolMiddleName); rTBLastName.Text = cCommonFunctions.HandleDBNull(VolDM.VolLastName); }
/// <summary> /// DeleteVolunteerContext - Will do a soft delete (make inactive) by VolID /// </summary> /// <param name="_cVolunteer"></param> public void DeleteVolunteerContext(sp_Volunteer_DM _cVolunteer) { using (VolTeerEntities context = new VolTeerEntities()) { var VolunteerToRemove = (from n in context.tblVolunteers where n.VolID == _cVolunteer.VolID select n).FirstOrDefault(); VolunteerToRemove.ActiveFlg = false; context.sp_Volunteer_Update(VolunteerToRemove.VolID, VolunteerToRemove.ActiveFlg, VolunteerToRemove.VolFirstName, VolunteerToRemove.VolMiddleName, VolunteerToRemove.VolLastName); context.SaveChanges(); } }
public void DeleteVolunteerContext(sp_Volunteer_DM _cVolunteer) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Volunteer_DM cacheVol; cacheVol = (sp_Volunteer_DM)cache[_cVolunteer.VolID.ToString()]; if (cacheVol != null) { cache.Remove(_cVolunteer.VolID.ToString()); } BLL.DeleteVolunteerContext(_cVolunteer); }
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 sp_Volunteer_DM hCreateVolunteer(string strFirstName, string strMiddleName, string strLastName) { sp_Volunteer_DM VOL = new sp_Volunteer_DM(); sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL(); VOL.VolID = Guid.NewGuid(); VOL.ActiveFlg = true; VOL.VolFirstName = strFirstName; VOL.VolMiddleName = strMiddleName; VOL.VolLastName = strLastName; VOL = VOlBll.InsertVolunteerContext(ref VOL); return VOL; }
public void UpdateSampleAddressContext(sp_Volunteer_DM _cVolunteer) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Volunteer_DM cacheVol; cacheVol = (sp_Volunteer_DM)cache[_cVolunteer.VolID.ToString()]; if (cacheVol != null) { cache.Remove(_cVolunteer.VolID.ToString()); } cache.Insert(_cVolunteer.VolID.ToString(), _cVolunteer, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); BLL.UpdateSampleAddressContext(_cVolunteer); }
/// <summary> /// SaveUserInfo - Called from parent screen, build a domain model and save the user info /// </summary> internal void SaveUserInfo() { sp_Volunteer_Cache VolCASH = new sp_Volunteer_Cache(); sp_Volunteer_DM VolDM = new sp_Volunteer_DM(); // Get the VolID from the parent form VolDM.VolID = new Guid(((HiddenField)Parent.FindControl("hdVolID")).Value); // Get the other info from the controls in this container VolDM.VolFirstName = cCommonFunctions.SetNullIfEmpty(rTBFirstName.Text.ToString()); VolDM.VolMiddleName = cCommonFunctions.SetNullIfEmpty(rTBMiddleName.Text.ToString()); VolDM.VolLastName = cCommonFunctions.SetNullIfEmpty(rTBLastName.Text.ToString()); VolCASH.UpdateVolunteerContext(VolDM); }
protected void LoadPage() { MembershipUser currentUser = Membership.GetUser(); Guid? UserID = (Guid)currentUser.ProviderUserKey; sp_Volunteer_Cache VolCASH = new sp_Volunteer_Cache(); sp_Volunteer_DM VolDM = new sp_Volunteer_DM(); VolDM = VolCASH.ListVolunteers(UserID); hdVolID.Value = DataBinder.Eval(VolDM, "VolID").ToString(); hdEditView.Value = "1"; //Handle ucVolBasicInfo parameters ucVolBasicInfo.UserID = UserID; }
public static void InsertVolunteerData(TestContext testContext) { volunteersToRemove = new List<sp_Volunteer_DM>(); System.Diagnostics.Debug.WriteLine(String.Format("{0}", DateTime.Now)); cExcel.RemoveAllData(); cExcel.InsertData(ExcelFilenames); secondaryTestVol = new sp_Volunteer_DM(); secondaryTestVol.ActiveFlg = true; secondaryTestVol.VolFirstName = "first2"; secondaryTestVol.VolMiddleName = "middle2"; secondaryTestVol.VolLastName = "last2"; secondaryTestVol.VolID = Guid.NewGuid(); sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL(); vol_bll.InsertVolunteerContext(ref secondaryTestVol); }
/// <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(); } }
protected void LoadPage() { MembershipUser currentUser; currentUser = Membership.GetUser(); Guid? UserID; UserID = (Guid)currentUser.ProviderUserKey; System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Volunteer_Cache VolCASH = new sp_Volunteer_Cache(); sp_Volunteer_DM VolDM = new sp_Volunteer_DM(); VolDM = VolCASH.ListVolunteers(UserID); ctl02.Text = (string)DataBinder.Eval(VolDM, "VolID"); //Cache.Add(UserID.ToString(), VolDM, null, DateTime.Now.AddSeconds(60), Cache.NoSlidingExpiration, CacheItemPriority.High, null); }
/// <summary> /// ListVolunteers - There's a good chance the same record may be requested often. Cache the vol object... /// /// </summary> /// <param name="Volunteer"></param> /// <returns></returns> public sp_Volunteer_DM ListVolunteers(Guid? Volunteer) { sp_Volunteer_DM cVol = new sp_Volunteer_DM(); //Cache cache = HttpRuntime.Cache; System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_Volunteer_DM cacheVol; cacheVol = (sp_Volunteer_DM)cache[Volunteer.ToString()]; if (cacheVol == null) { cVol = BLL.ListVolunteers(Volunteer); cache.Insert(cVol.VolID.ToString(), cVol, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); } else { cVol = cacheVol; } return cVol; }
public void TestVolunteerCreate() { createTestVol = new sp_Volunteer_DM(); string volFirst = "TestFirst"; string volMiddle = "TestMiddle"; string volLast = "TestLast"; bool ActiveFlg = true; sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL(); sp_Volunteer_DM vol_dm = new sp_Volunteer_DM(); vol_dm.VolFirstName = volFirst; vol_dm.VolMiddleName = volMiddle; vol_dm.VolLastName = volLast; vol_dm.ActiveFlg = ActiveFlg; System.Guid volID = Guid.NewGuid(); vol_dm.VolID = volID; createTestVol = vol_dm; vol_bll.InsertVolunteerContext(ref vol_dm); sp_Volunteer_DM vol_dm_selected = vol_bll.ListVolunteers(volID); Assert.IsTrue(VolEquals(vol_dm, vol_dm_selected)); }
/// <summary> /// UpdateSampleAddressContext - Will update a given Volunteer record by VolID /// </summary> /// <param name="_cVolunteer"></param> public void UpdateVolunteerContext(sp_Volunteer_DM _cVolunteer) { using (VolTeerEntities context = new VolTeerEntities()) { var cVolunteer = context.tblVolunteers.Find(_cVolunteer.VolID); if (cVolunteer != null) { cVolunteer.VolFirstName = _cVolunteer.VolFirstName; cVolunteer.VolMiddleName = _cVolunteer.VolMiddleName; cVolunteer.VolLastName = _cVolunteer.VolLastName; cVolunteer.ActiveFlg = _cVolunteer.ActiveFlg; context.SaveChanges(); } } }
public void TestVolPhoneCreate() { sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL(); sp_Volunteer_DM vol_dm = new sp_Volunteer_DM(); vol_dm.VolFirstName = "createFirst"; vol_dm.VolMiddleName = "createMiddle"; vol_dm.VolLastName = "createLast"; vol_dm.ActiveFlg = true; System.Guid volID = vol_bll.InsertVolunteerContext(ref vol_dm).VolID; vol_dm.VolID = volID; string volPhoneNbr = "0123456789"; bool PrimaryFlg = true; bool ActiveFlg = true; sp_VolPhone_BLL volPhone_bll = new sp_VolPhone_BLL(); sp_Phone_DM volPhone_dm = new sp_Phone_DM(); volPhone_dm.PhoneNbr = volPhoneNbr; volPhone_dm.VolID = volID; volPhone_dm.ActiveFlg = ActiveFlg; volPhone_dm.PrimaryFlg = PrimaryFlg; volPhone_bll.InsertPhoneContext(volPhone_dm); int volPhoneID = volPhone_dm.PhoneID; List<sp_Phone_DM> volPhoneDMs_selected = volPhone_bll.ListPhones(volPhone_dm); Assert.IsTrue(PhoneListContains(volPhoneDMs_selected, volPhone_dm)); }
public void UpdateVolunteerContext(sp_Volunteer_DM _cVolunteer) { DAL.UpdateVolunteerContext(_cVolunteer); }
public void DeleteVolunteerContext(sp_Volunteer_DM _cVolunteer) { DAL.DeleteVolunteerContext(_cVolunteer); }
public void InsertVolunteerContext(sp_Volunteer_DM _cVolunteer) { DAL.InsertVolunteerContext(_cVolunteer); }
private static bool VolEquals(sp_Volunteer_DM vol1, sp_Volunteer_DM vol2) { return ((vol1.VolID == vol2.VolID) && (vol1.VolFirstName == vol2.VolFirstName) && (vol1.VolMiddleName == vol2.VolMiddleName) && (vol1.VolLastName == vol2.VolLastName) && (vol1.ActiveFlg == vol2.ActiveFlg)); }
public sp_Volunteer_DM InsertVolunteerContext(ref sp_Volunteer_DM _cVolunteer) { return DAL.InsertVolunteerContext(ref _cVolunteer); }
private static List<sp_Volunteer_DM> getVolDMs(DataTable dataTable) { List<sp_Volunteer_DM> volDMs = new List<sp_Volunteer_DM>(); for (int i = 0; i < dataTable.Rows.Count; i++) { sp_Volunteer_DM returnVolunteer = new sp_Volunteer_DM(); returnVolunteer.VolID = new Guid((string)dataTable.Rows[i]["VolID"]); returnVolunteer.VolFirstName = (String)dataTable.Rows[i]["VolFirstName"]; returnVolunteer.VolMiddleName = (String)dataTable.Rows[i]["VolMiddleName"]; returnVolunteer.VolLastName = (String)dataTable.Rows[i]["VolLastName"]; returnVolunteer.ActiveFlg = Convert.ToBoolean(dataTable.Rows[i]["ActiveFlg"]); volDMs.Add(returnVolunteer); } return volDMs; }
public void hDeleteVolunteer(sp_Volunteer_DM VOL) { sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL(); VOlBll.DeleteVolunteerContext(VOL); }