public void TestVendAddressCreate()
{
//Test Our Read
sp_VendAddress_DM data = new sp_VendAddress_DM();
string AddrLine1 = "Add1";
string AddrLine2 = "Add2";
string AddrLine3 = "Add3";
string City = "City";
string St = "St";
int Zip = 11111;
int Zip4 = 1111;
data.AddrLine1 = AddrLine1;
data.AddrLine2 = AddrLine2;
data.AddrLine3 = AddrLine3;
data.City = City;
data.St = St;
data.Zip = Zip;
data.Zip4 = Zip4;
data.ActiveFlg = true;
sp_VendAddress_BLL vend = new sp_VendAddress_BLL();
vend.InsertAddressContext(data);
Assert.AreEqual(AddrLine1, data.AddrLine1, "AddrLine1 Not Set As Expected");
Assert.AreEqual(AddrLine2, data.AddrLine2, "AddrLine2 Not Set As Expected");
Assert.AreEqual(AddrLine3, data.AddrLine3, "AddrLine3 Not Set As Expected");
Assert.AreEqual(City, data.City, "City Not Set As Expected");
Assert.AreEqual(St, data.St, "St Not Set As Expected");
Assert.AreEqual(Zip, data.Zip, "Zip Not Set As Expected");
Assert.AreEqual(Zip4, data.Zip4, "Zip Not Set As Expected");
}
public void DeleteAddressContext(sp_VendAddress_DM InputAddress)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var VendAddressToRemove = (from n in context.tblVendAddresses where n.AddrID == InputAddress.AddrID select n).FirstOrDefault();
context.tblVendAddresses.Remove(VendAddressToRemove);
context.SaveChanges();
}
}
public void TestVendAddressDelete()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "VendAddress.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
int AddrID = Convert.ToInt32(row["AddrID"].ToString());
sp_VendAddress_DM data = new sp_VendAddress_DM();
sp_VendAddress_BLL vend = new sp_VendAddress_BLL();
data.AddrID = AddrID;
vend.DeleteAddressContext(data);
data = vend.ListAddresses(AddrID);
Assert.AreEqual(false, data.ActiveFlg, "ActiveFlag not set as expected");
}
}
public void UpdateAddressContext(sp_VendAddress_DM InputAddress)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var existingAddress = context.tblVendAddresses.Find(InputAddress.AddrID);
if (InputAddress != null)
{
existingAddress.AddrLine1 = InputAddress.AddrLine1;
existingAddress.AddrLine2 = InputAddress.AddrLine2;
existingAddress.AddrLine3 = InputAddress.AddrLine3;
existingAddress.City = InputAddress.City;
existingAddress.St = InputAddress.St;
existingAddress.Zip = InputAddress.Zip;
existingAddress.Zip4 = InputAddress.Zip4;
existingAddress.ActiveFlg = InputAddress.ActiveFlg;
context.SaveChanges();
}
}
}
public int InsertAddressContext(sp_VendAddress_DM InputAddress)
{
using (VolTeerEntities context = new VolTeerEntities())
{
var NewAddress = new tblVendAddress
{
AddrLine1 = InputAddress.AddrLine1,
AddrLine2 = InputAddress.AddrLine2,
AddrLine3 = InputAddress.AddrLine3,
City = InputAddress.City,
St = InputAddress.St,
Zip = InputAddress.Zip,
Zip4 = InputAddress.Zip4,
ActiveFlg = InputAddress.ActiveFlg
};
context.tblVendAddresses.Add(NewAddress);
context.SaveChanges();
//Return the id of the newly created record
return NewAddress.AddrID;
}
}
/// <summary>
/// SetPrimaryValues - Paint the screen with default values (use non-telerik controls)
/// </summary>
protected void SetPrimaryValues()
{
sp_VendAddress_DM VendDM = new sp_VendAddress_DM();
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>
/// 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_VendAddress_DM VendAddressDM = new sp_VendAddress_DM();
sp_VendorAddr_DM VendAddrDM = new sp_VendorAddr_DM();
VendAddrDM.AddrID = (int)currentUser.ProviderUserKey; ;
VendAddressDM.AddrID = (int)currentUser.ProviderUserKey;
if (iAction == (int)RecordAction.Update)
{
VendAddressDM.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
pre_ID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
VendAddrDM.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
}
VendAddressDM.ActiveFlg = (eeditedItem.FindControl("chkActive") as CheckBox).Checked;
VendAddressDM.AddrLine1 = (eeditedItem.FindControl("rTBAddr1") as RadTextBox).Text.ToString();
VendAddressDM.AddrLine2 = (eeditedItem.FindControl("rTBAddr2") as RadTextBox).Text.ToString();
VendAddressDM.AddrLine3 = (eeditedItem.FindControl("rTBAddr3") as RadTextBox).Text.ToString();
VendAddressDM.City = (eeditedItem.FindControl("rTBCity") as RadTextBox).Text.ToString();
VendAddressDM.St = (eeditedItem.FindControl("rDDSt") as RadDropDownList).SelectedValue.ToString();
VendAddressDM.Zip = Convert.ToInt32((eeditedItem.FindControl("rNTBZip") as RadNumericTextBox).Text);
string strZip4 = ((eeditedItem.FindControl("rNTBZip4") as RadNumericTextBox).Text).ToString();
if (strZip4 == string.Empty)
{
VendAddressDM.Zip4 = null;
}
else
{
VendAddressDM.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)
{
}
else if (iAction == (int)RecordAction.Insert)
{
}
}
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();
sp_VendAddress_DM VendDM = new sp_VendAddress_DM();
//VendDM.AddrID = (int)currentUser.ProviderUserKey;
VolDM.VolID = (Guid)currentUser.ProviderUserKey;
//rGridAddress.DataSource = VolAddrBLL.ListAddresses(VolDM);
rGridAddress.DataSource = VolAddrCash.ListAddresses(VolDM);
rGridAddress.DataBind();
}
protected string GetGeoCode(sp_VendAddress_DM VendAddr)
{
GoogleAddress googleAddress = new GoogleAddress();
googleAddress.FormattedAddress = VendAddr.AddrLine1 + ", " +
VendAddr.City + ", " + VendAddr.St + " " + VendAddr.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 void UpdateAddressContext(sp_VendAddress_DM InputAddress)
{
DAL.UpdateAddressContext(InputAddress);
}
public int InsertAddressContext(sp_VendAddress_DM InputAddress)
{
return DAL.InsertAddressContext(InputAddress);
}
public void DeleteAddressContext(sp_VendAddress_DM InputAddress)
{
DAL.DeleteAddressContext(InputAddress);
}
public void TestVendAddressUpdate()
{
//Test Our Read
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "VendAddress.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
string AddrLine1 = "TestAddrLine1";
string AddrLine2 = "TestAddrLine2";
string AddrLine3 = "TestAddrLine3";
string City = "TestCity";
string St = "TestSt";
int Zip = 11111;
int Zip4 = 1111;
int AddrID = Convert.ToInt32(row["AddrID"].ToString());
sp_VendAddress_DM data = new sp_VendAddress_DM();
data.AddrID = AddrID;
data.AddrLine1 = AddrLine1;
data.AddrLine2 = AddrLine2;
data.AddrLine3 = AddrLine3;
data.City = City;
data.St = St;
data.Zip = Zip;
data.Zip4 = Zip4;
sp_VendAddress_BLL vend = new sp_VendAddress_BLL();
vend.UpdateAddressContext(data);
data = vend.ListAddresses(AddrID);
Assert.AreEqual(AddrLine1, data.AddrLine1, "AddrLine1 Not Set As Expected");
Assert.AreEqual(AddrLine2, data.AddrLine2, "AddrLine2 Not Set As Expected");
Assert.AreEqual(AddrLine3, data.AddrLine3, "AddrLine3 Not Set As Expected");
Assert.AreEqual(City, data.City, "City Not Set As Expected");
Assert.AreEqual(St, data.St, "St Not Set As Expected");
Assert.AreEqual(Zip, data.Zip, "Zip Not Set As Expected");
Assert.AreEqual(Zip4, data.Zip4, "Zip4 Not Set As Expected");
}
}