public void DeleteEmailContext(sp_VendEmail_DM InputEmail) { using (VolTeerEntities context = new VolTeerEntities()) { var VendEmailToRemove = (from n in context.tblVendEmails where n.EmailID == InputEmail.EmailID select n).FirstOrDefault(); context.tblVendEmails.Remove(VendEmailToRemove); context.SaveChanges(); } }
public void DeleteEmailContext(sp_VendEmail_DM _caEmail) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_VendEmail_DM cacheEmail; cacheEmail = (sp_VendEmail_DM)cache[_caEmail.EmailID.ToString()]; if (cacheEmail != null) { cache.Remove(_caEmail.EmailID.ToString()); } BLL.DeleteEmailContext(_caEmail); }
public void UpdateEmailContext(sp_VendEmail_DM InputEmail) { using (VolTeerEntities context = new VolTeerEntities()) { var existingEmail = context.tblVendEmails.Find(InputEmail.EmailID); if (InputEmail != null) { existingEmail.EmailAddr = InputEmail.EmailAddr; existingEmail.ActiveFlg = InputEmail.ActiveFlg; context.SaveChanges(); } } }
public void TestVendEmailDelete() { DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "tblVendEmail.xlsx")); foreach (DataRow row in dt.Rows) // Loop over the rows. { int EmailID = Convert.ToInt32(row["EmailID"].ToString()); sp_VendEmail_DM data = new sp_VendEmail_DM(); sp_VendEmail_BLL vend = new sp_VendEmail_BLL(); data.EmailID = EmailID; vend.DeleteEmailContext(data); data = vend.ListEmails(EmailID); Assert.AreEqual(false, data.ActiveFlg, "ActiveFlag not set as expected"); } }
public int InsertEmailContext(sp_VendEmail_DM InputEmail) { using (VolTeerEntities context = new VolTeerEntities()) { var NewEmail = new tblVendEmail { EmailAddr = InputEmail.EmailAddr, ActiveFlg = InputEmail.ActiveFlg }; context.tblVendEmails.Add(NewEmail); context.SaveChanges(); //Return the id of the newly created record return NewEmail.EmailID; } }
public void UpdateEmailContext(sp_VendEmail_DM _caEmail) { System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_VendEmail_DM cacheEmail; cacheEmail = (sp_VendEmail_DM)cache[_caEmail.EmailID.ToString()]; if (cacheEmail != null) { cache.Remove(_caEmail.EmailID.ToString()); } cache.Insert(_caEmail.EmailID.ToString(), _caEmail, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); BLL.UpdateEmailContext(_caEmail); }
/// <summary> /// ListEmails - There's a good chance the same record may be requested often. Cache the Email object... /// /// </summary> /// <param name="Emails"></param> /// <returns></returns> public sp_VendEmail_DM ListEmails(int VendEmail) { sp_VendEmail_DM caEmail = new sp_VendEmail_DM(); System.Web.Caching.Cache cache = HttpRuntime.Cache; sp_VendEmail_DM cacheEmail; cacheEmail = (sp_VendEmail_DM)cache[VendEmail.ToString()]; if (cacheEmail == null) { caEmail = BLL.ListEmails(VendEmail); cache.Insert(caEmail.EmailID.ToString(), caEmail, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); } else { caEmail = cacheEmail; } return caEmail; }
public void TestVendEmailInsert() { //Test Our Read sp_VendEmail_DM data = new sp_VendEmail_DM(); string EmailAddr = "*****@*****.**"; data.EmailAddr = EmailAddr; data.ActiveFlg = true; sp_VendEmail_BLL vend = new sp_VendEmail_BLL(); vend.InsertEmailContext(data); Assert.AreEqual(EmailAddr, data.EmailAddr, "EmailAddr Not Set As Expected"); }
public void TestVendEmailUpdate() { //Test Our Read DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "tblVendEmail.xlsx")); foreach (DataRow row in dt.Rows) // Loop over the rows. { string EmailAddr = "*****@*****.**"; int EmailID = Convert.ToInt32(row["EmailID"].ToString()); sp_VendEmail_DM data = new sp_VendEmail_DM(); data.EmailID = EmailID; data.EmailAddr = EmailAddr; sp_VendEmail_BLL vend = new sp_VendEmail_BLL(); vend.UpdateEmailContext(data); data = vend.ListEmails(EmailID); Assert.AreEqual(EmailAddr, data.EmailAddr, "EmailAddr Not Set As Expected"); } }
public void InsertEmailContext(sp_VendEmail_DM _caEmail) { BLL.InsertEmailContext(_caEmail); System.Web.Caching.Cache cache = HttpRuntime.Cache; cache.Insert(_caEmail.EmailID.ToString(), _caEmail, null, DateTime.Now.AddSeconds(60), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, null); }
public void UpdateEmailContext(sp_VendEmail_DM InputEmail) { DAL.UpdateEmailContext(InputEmail); }
public int InsertEmailContext(sp_VendEmail_DM InputEmail) { return DAL.InsertEmailContext(InputEmail); }
public void DeleteEmailContext(sp_VendEmail_DM InputEmail) { DAL.DeleteEmailContext(InputEmail); }