public void DeleteAddressContext(sp_Vol_Address_DM _cAddress, sp_GroupAddr_DM _cGroupAddr)
{
System.Web.Caching.Cache cache = HttpRuntime.Cache;
sp_GroupAddr_DM cacheAddress;
cacheAddress = (sp_GroupAddr_DM)cache[_cGroupAddr.GroupID.ToString() + _cAddress.AddrID.ToString()];
if (cacheAddress != null)
{
cache.Remove(_cGroupAddr.GroupID.ToString() + "|" + _cAddress.AddrID.ToString());
}
BLL.DeleteAddressContext(_cAddress, _cGroupAddr);
}
public void TestGroupAddrCreate()
{
var group_bll = new sp_Group_BLL();
var groupAddr_bll = new sp_GroupAddr_BLL();
var groupAddr_dm = new sp_GroupAddr_DM();
var allGroups = group_bll.ListGroups();
Assert.IsTrue(allGroups.Count > 0, "The allGroups() is broken, or no data in DB");
groupAddr_dm.GroupID = allGroups[0].GroupID;
groupAddr_dm.PrimaryAddrID = true;
groupAddr_dm.ActiveFlg = true;
var volAddress_bll = new sp_Vol_Address_BLL();
var volAddress_dm = volAddress_bll.ListAddress(new sp_Vol_Address_DM());
groupAddr_bll.InsertAddressContext(ref volAddress_dm, ref groupAddr_dm);
groupAddr_dm.AddrID = volAddress_dm.AddrID;
var groupAddr_dm_selected = groupAddr_bll.ListAddress(groupAddr_dm);
Assert.IsTrue(Equals(groupAddr_dm, groupAddr_dm_selected));
}
public void InsertAddressContext(ref sp_Vol_Address_DM _cAddress, ref sp_GroupAddr_DM _cGroupAddr)
{
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 cGroupAddr = new tblGroupAddr
{
GroupID = _cGroupAddr.GroupID,
AddrID = cAddress.AddrID,
PrimaryAddrID = _cGroupAddr.PrimaryAddrID
};
context.tblGroupAddrs.Add(cGroupAddr);
context.SaveChanges();
//If the AddrID isn't null, set it equal to the return value
if (_cAddress.AddrID != null)
{
_cAddress.AddrID = cAddress.AddrID;
}
}
catch (Exception ex)
{
throw (ex);
}
}
}
public List<sp_GroupAddr_DM> ListAddresses(sp_GroupAddr_DM cGroupAddr)
{
List<sp_GroupAddr_DM> cAddress = new List<sp_GroupAddr_DM>();
//Cache cache = HttpRuntime.Cache;
System.Web.Caching.Cache cache = HttpRuntime.Cache;
List<sp_GroupAddr_DM> cacheAddress;
cacheAddress = (List<sp_GroupAddr_DM>)cache[cGroupAddr.GroupID.ToString()];
if (cacheAddress == null)
{
cAddress = BLL.ListAddresses(cGroupAddr);
cache.Insert(cGroupAddr.GroupID.ToString(), cAddress, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, callback);
}
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);
}
}
}
public void InsertAddressContext(ref sp_Vol_Address_DM _cAddress, ref sp_GroupAddr_DM _cGroupAddr)
{
BLL.InsertAddressContext(ref _cAddress, ref _cGroupAddr);
System.Web.Caching.Cache cache = HttpRuntime.Cache;
cache.Insert(_cGroupAddr.GroupID.ToString() + "|" + _cAddress.AddrID.ToString(), _cAddress, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, callback);
}
public void InsertAddressContext(ref sp_Vol_Address_DM _cAddress, ref sp_GroupAddr_DM _cGroupAddr)
{
DAL.InsertAddressContext(ref _cAddress, ref _cGroupAddr);
}
public void UpdateAddressContext(sp_Vol_Address_DM _cAddress, sp_GroupAddr_DM _cGroupAddr)
{
System.Web.Caching.Cache cache = HttpRuntime.Cache;
sp_GroupAddr_DM cacheAddress;
cacheAddress = (sp_GroupAddr_DM)cache[_cAddress.AddrID.ToString()];
if (cacheAddress != null)
{
cache.Remove(_cGroupAddr.GroupID.ToString() + "|" + _cAddress.AddrID.ToString());
}
cache.Insert(_cGroupAddr.GroupID.ToString() + _cAddress.AddrID.ToString(), _cAddress, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, callback);
BLL.UpdateAddressContext(_cAddress, _cGroupAddr);
}
public void UpdateAddressContext(sp_Vol_Address_DM _cAddress, sp_GroupAddr_DM _cGroupAddr)
{
try
{
using (VolTeerEntities context = new VolTeerEntities())
{
var cAddress = context.tblVolAddresses.Find(_cAddress.AddrID);
var cGroupAddr = context.tblGroupAddrs.Find(_cGroupAddr.GroupID, _cGroupAddr.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 (cGroupAddr != null)
{
cGroupAddr.GroupID = _cGroupAddr.GroupID;
cGroupAddr.AddrID = _cGroupAddr.AddrID;
cGroupAddr.PrimaryAddrID = _cGroupAddr.PrimaryAddrID;
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw (ex);
}
}
public void UpdateAddressContext(sp_Vol_Address_DM _cAddress, sp_GroupAddr_DM _cGroupAddr)
{
DAL.UpdateAddressContext(_cAddress, _cGroupAddr);
}
public sp_GroupAddr_DM ListPrimaryAddress(sp_GroupAddr_DM cGroupAddr)
{
sp_GroupAddr_DM cAddress = new sp_GroupAddr_DM();
//Cache cache = HttpRuntime.Cache;
System.Web.Caching.Cache cache = HttpRuntime.Cache;
sp_GroupAddr_DM cacheAddress;
cacheAddress = (sp_GroupAddr_DM)cache[cGroupAddr.GroupID.ToString()];
if (cacheAddress == null)
{
cAddress = BLL.ListPrimaryAddress(cGroupAddr);
cache.Insert(cGroupAddr.GroupID.ToString() + "|" + cAddress.AddrID.ToString(), cAddress, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration, CacheItemPriority.High, callback);
}
else
{
cAddress = cacheAddress;
}
return cAddress;
}
public List<sp_GroupAddr_DM> ListAddresses(sp_GroupAddr_DM cGroupAddr)
{
return DAL.ListAddresses(cGroupAddr);
}
public sp_GroupAddr_DM ListPrimaryAddress(sp_GroupAddr_DM cGroupAddr)
{
return DAL.ListPrimaryAddress(cGroupAddr);
}
public sp_GroupAddr_DM ListPrimaryAddress(sp_GroupAddr_DM cGroupAddr)
{
sp_GroupAddr_DM item = new sp_GroupAddr_DM();
try
{
using (VolTeerEntities context = new VolTeerEntities())
{
item = (from result in context.sp_GroupAddr_Select(cGroupAddr.GroupID, cGroupAddr.AddrID)
select new sp_GroupAddr_DM
{
GroupID = result.GroupID,
AddrID = result.AddrID,
PrimaryAddrID = result.PrimaryAddrID,
ActiveFlg = result.ActiveFlg
}).FirstOrDefault();
} // Guaranteed to close the Connection
}
catch (Exception ex)
{
throw (ex);
}
return item;
}
public sp_GroupAddr_DM ListAddress(sp_GroupAddr_DM cGroupAddr)
{
return ListAddresses(cGroupAddr).Single();
}
bool Equals(sp_GroupAddr_DM dm1, sp_GroupAddr_DM dm2)
{
return (dm1.GroupID == dm2.GroupID &&
dm1.AddrID == dm2.AddrID &&
dm1.PrimaryAddrID == dm2.PrimaryAddrID &&
dm1.ActiveFlg == dm2.ActiveFlg
);
}
private static List<sp_GroupAddr_DM> DMsFrom(DataTable dataTable)
{
var DMs = new List<sp_GroupAddr_DM>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
var returnGroup = new sp_GroupAddr_DM();
returnGroup.GroupID = Convert.ToInt32(dataTable.Rows[i]["GroupID"]);
returnGroup.AddrID = Convert.ToInt32(dataTable.Rows[i]["AddrID"]);
returnGroup.PrimaryAddrID = Convert.ToBoolean(dataTable.Rows[i]["PrimaryAddrID"]);
returnGroup.ActiveFlg = Convert.ToBoolean(dataTable.Rows[i]["ActiveFlg"]);
DMs.Add(returnGroup);
}
return DMs;
}
public List<sp_GroupAddr_DM> ListAddresses(sp_GroupAddr_DM cGroupAddr)
{
List<sp_GroupAddr_DM> list = new List<sp_GroupAddr_DM>();
try
{
using (VolTeerEntities context = new VolTeerEntities())
{
list = (from result in context.sp_GroupAddr_Select(cGroupAddr.GroupID, cGroupAddr.AddrID)
select new sp_GroupAddr_DM
{
GroupID = result.GroupID,
AddrID = result.AddrID,
PrimaryAddrID = result.PrimaryAddrID,
ActiveFlg = result.ActiveFlg
}).ToList();
} // Guaranteed to close the Connection
}
catch (Exception ex)
{
throw (ex);
}
return list;
}