/// <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 - 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 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);
}
/// <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);
}
}
}
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>
/// 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.
}
}
/// <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);
}
public void InsertAddressContext(ref sp_Vol_Address_DM _cAddress, ref sp_Vol_Addr_DM _cVolAddr)
{
DAL.InsertAddressContext(ref _cAddress, ref _cVolAddr);
}
public void DeleteAddressContext(sp_Vol_Address_DM _cAddress, sp_Vol_Addr_DM _cVolAddr)
{
DAL.DeleteAddressContext(_cAddress, _cVolAddr);
}
/// <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);
}
}
/// <summary>
/// InsertAddressContext - Insert a new address into cache, then call BLL to add to database.
/// </summary>
/// <param name="_cAddress"></param>
/// <param name="_cVolAddr"></param>
public void InsertAddressContext(ref sp_Vol_Address_DM _cAddress, ref sp_Vol_Addr_DM _cVolAddr)
{
BLL.InsertAddressContext(ref _cAddress, ref _cVolAddr);
System.Web.Caching.Cache cache = HttpRuntime.Cache;
cache.Insert(RecordType.VolAddr + "|" + _cVolAddr.VolID.ToString() + "|" + _cAddress.AddrID.ToString(), _cAddress, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, callback);
}
/// <summary>
/// UpdateAddressContext - Record is updated, remove from cache, add back to cache, and then call BLL to update database.
/// </summary>
/// <param name="_cAddress"></param>
/// <param name="_cVolAddr"></param>
public void UpdateAddressContext(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[_cAddress.AddrID.ToString()];
if (cacheAddress != null)
{
cache.Remove(RecordType.VolAddr + "|" + _cVolAddr.VolID.ToString() + "|" + _cAddress.AddrID.ToString());
}
cache.Insert(RecordType.VolAddr + _cVolAddr.VolID.ToString() + _cAddress.AddrID.ToString(), _cAddress, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, callback);
BLL.UpdateAddressContext(_cAddress, _cVolAddr);
}
public void TestVolAddressCreate()
{
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 = Guid.NewGuid();
vol_dm.VolID = volID;
createTestVol = vol_dm;
vol_bll.InsertVolunteerContext(ref vol_dm);
string volAddr1 = "CreateLine1";
string volAddr2 = "CreateLine2";
string volAddr3 = "CreateLine3";
string volCity = "CreateCity";
string volSt = "CS";
int volZip = 13579;
int volZip4 = 2468;
bool PrimaryFlg = true;
bool ActiveFlg = true;
sp_Vol_Address_BLL volAddress_bll = new sp_Vol_Address_BLL();
sp_Vol_Address_DM volAddress_dm = new sp_Vol_Address_DM();
sp_Vol_Addr_DM volAddr_dm = new sp_Vol_Addr_DM();
volAddress_dm.ActiveFlg = ActiveFlg;
volAddress_dm.AddrLine1 = volAddr1;
volAddress_dm.AddrLine2 = volAddr2;
volAddress_dm.AddrLine3 = volAddr3;
volAddress_dm.City = volCity;
volAddress_dm.St = volSt;
volAddress_dm.Zip = volZip;
volAddress_dm.Zip4 = volZip4;
volAddress_dm.VolID = volID;
volAddress_dm.PrimaryAddr = PrimaryFlg;
volAddr_dm.PrimaryAddr = PrimaryFlg;
volAddr_dm.VolID = volID;
volAddress_bll.InsertAddressContext(ref volAddress_dm, ref volAddr_dm);
sp_Vol_Address_DM volAddressDMs_selected = volAddress_bll.ListAddress(volAddress_dm);
Assert.IsTrue(AddressEquals(volAddressDMs_selected, volAddress_dm));
}