protected void ButtonMove_Click(object sender, EventArgs e)
{
foreach (GridViewRow item in GridView1.Rows)
{
if (item.RowType == DataControlRowType.DataRow)
{
var checkBoxDelete = (CheckBox)item.FindControl("CheckBoxDelete");
var hiddenFieldAddressId = (HiddenField)item.FindControl("hiddenFieldAddressId");
if (checkBoxDelete.Checked)
{
int idToMove = int.Parse(hiddenFieldAddressId.Value);
var db = new TerritorySite.BL.Linq.TerritoryDBDataContext();
var address = (from a in db.Addresses
where a.AddressId == idToMove
select a).First();
address.TerritoryId = int.Parse(DropDownListTNumber.SelectedValue);
db.SubmitChanges();
}
}
LabelMessage.Text = "Addresses Moved to territory #" + DropDownListTNumber.SelectedItem.Text;
}
Reload();
}
public static void AddLastNameToMyList(string name, int languageId)
{
var db = new TerritoryDBDataContext();
var newName = new Name();
newName.IsFirstName = false;
newName.FirstOrLastName = name;
newName.LanguageId = languageId;
newName.AccountId = CurrentUser.CurrentAccount.AccountId;
db.Names.InsertOnSubmit(newName);
db.SubmitChanges();
}
public static void Log(string address, double latitude, double longitude, IGeocoder provider, string error)
{
var db = new TerritoryDBDataContext();
GeocodingLog newEntry = new GeocodingLog();
newEntry.AccountId = CurrentUser.CurrentAccount.AccountId;
newEntry.Lat = latitude;
newEntry.Address= address;
newEntry.Long = longitude;
newEntry.Provider = provider.GetType().Name;
newEntry.RequestDateTime = DateTime.Now;
db.GeocodingLogs.InsertOnSubmit(newEntry);
db.SubmitChanges();
}
public static void DeleteNameFromMyList(string name, int languageId)
{
var db = new TerritoryDBDataContext();
var toDelete = (from n in db.Names
where n.FirstOrLastName == name &
n.LanguageId == languageId &
n.IsFirstName == false
& n.AccountId == CurrentUser.CurrentAccount.AccountId
select n).FirstOrDefault();
if (toDelete != null)
{
db.Names.DeleteOnSubmit(toDelete);
db.SubmitChanges();
}
}
public void DoBulkUpload(bool deleteExisting)
{
if (!IsUploadValid())
{
if (!_ignoreErrors)
{
return;
}
}
var currentBatch = CreateNewBatch();
try
{
if (deleteExisting)
{
Territory.CurrentTerritory().DeleteAllAddresses();
}
var uploadedData = GetUploadedData();
List<UploadedAddress> uploadedAddresses = new List<UploadedAddress>();
int rowPosition = 1;
foreach (DataRow thisRow in uploadedData.Rows)
{
try
{
UploadedAddress newAddress = new UploadedAddress();
newAddress.AddressUploadBatchId = currentBatch.AddressUploadBatchId;
newAddress.APT = thisRow["apt"].ToString();
if (uploadedData.Columns.Contains("Area_Code"))
{
newAddress.AREA_CODE = thisRow["Area_Code"].ToString();
}
newAddress.CITY = thisRow["city"].ToString();
newAddress.DIR = thisRow["DIR"].ToString();
newAddress.FIRST_NAME = thisRow["FIRST_NAME"].ToString();
string originalHouseNumber = thisRow["HOUSE_#"].ToString();
string numbersOnlyHouseNumber = Regex.Replace(originalHouseNumber, "[^.0-9]", "");
if (originalHouseNumber != numbersOnlyHouseNumber)
{
newAddress.APT += originalHouseNumber.Replace(numbersOnlyHouseNumber, string.Empty);
}
newAddress.HOUSE__ = numbersOnlyHouseNumber;
newAddress.LAST_NAME = thisRow["LAST_NAME"].ToString();
newAddress.PHONE = thisRow["PHONE"].ToString();
newAddress.STATE = thisRow["STATE"].ToString();
newAddress.STREET = thisRow["STREET"].ToString();
newAddress.TerritoryId = CurrentUser.TerritoryId;
newAddress.ZIP = thisRow["ZIP"].ToString();
uploadedAddresses.Add(newAddress);
rowPosition++;
}
catch (Exception ex)
{
_errorList.Add("There was an error on row " + rowPosition + " Detailed Error: " + ex.Message);
break;
}
}
// upload addresses
if (_errorList.Count == 0)
{
var db = new TerritoryDBDataContext();
db.UploadedAddresses.InsertAllOnSubmit(uploadedAddresses);
db.SubmitChanges();
}
else
{
return;
}
}
catch (Exception Ex)
{
throw Ex;
}
BatchFinished(currentBatch);
}
private AddressUploadBatch CreateNewBatch()
{
var db = new TerritoryDBDataContext();
FileInfo thisFileInfo = new FileInfo(_fileName);
// before uploading a new batch let's delete
// any other batch that might be related to the same session (file name = session)
var listToDelete = (from au in db.AddressUploadBatches
where au.FileName == thisFileInfo.Name
select au);
db.AddressUploadBatches.DeleteAllOnSubmit(listToDelete);
db.SubmitChanges();
// delete all uploads older than 1 day (to clean up the database)
var cutoffDate = DateTime.Now.AddDays(-1);
listToDelete = (from au in db.AddressUploadBatches
where au.DateStarted < cutoffDate
select au);
db.AddressUploadBatches.DeleteAllOnSubmit(listToDelete);
db.SubmitChanges();
var newBatch = new AddressUploadBatch();
newBatch.DateStarted = DateTime.Now;
newBatch.Status = "STARTED";
newBatch.TerritoryId = CurrentUser.TerritoryId;
newBatch.FileName = thisFileInfo.Name;
db.AddressUploadBatches.InsertOnSubmit(newBatch);
db.SubmitChanges();
return newBatch;
}
private void BatchFinished(AddressUploadBatch batch)
{
var db = new TerritoryDBDataContext();
db.AddressUploadBatches.Attach(batch);
batch.Status = "COMPLETED";
batch.DateCompleted = DateTime.Now;
db.SubmitChanges();
}
public static void AssignPinsCurrentTerritory()
{
var db = new TerritoryDBDataContext();
var addressList = (from a in db.Addresses
where a.TerritoryId == CurrentUser.TerritoryId
&&
(
a.LanguageId == CurrentUser.CurrentAccount.LanguageId
||
a.LanguageId == 509
)
select a).ToList();
addressList = (from a in addressList
orderby a.IsGeoCoded descending, a.StreetName, a.HouseNumber
select a).ToList();
int count = 1;
foreach (var address in addressList)
{
address.AssignmentPinNumber = count;
address.HasBeenWorked = false;
address.NotAtHomeCount = 0;
count++;
}
db.SubmitChanges();
}
public void DeleteAllAddresses()
{
if (TerritoryId > 0)
{
var db= new TerritoryDBDataContext();
var addressesToDelete = (from a in db.Addresses where a.TerritoryId == TerritoryId select a).ToList();
db.Addresses.DeleteAllOnSubmit(addressesToDelete);
db.SubmitChanges();
}
}
protected void ButtonNeverHome_Click(object sender, EventArgs e)
{
if (AddressId > 0 & TerritoryId > 0)
{
var db = new TerritorySite.BL.Linq.TerritoryDBDataContext();
var addr = (from a in db.Addresses
where a.AddressId == addressId
&
a.TerritoryId == TerritoryId
select a).FirstOrDefault();
if (addr != null)
{
//addr.FirstName = tFirstName.Text;
//addr.LastName = tLastName.Text;
//addr.LanguageId = int.Parse(ddlLanguage.SelectedValue);
addr.NotAtHomeCount = -1;
addr.HasBeenWorked = true;
db.SubmitChanges();
ReturnTo(addr);
}
}
}
protected void buttonNH_Click(object sender, EventArgs e)
{
if (AddressId > 0 & TerritoryId > 0)
{
var db = new TerritorySite.BL.Linq.TerritoryDBDataContext();
var addr = (from a in db.Addresses
where a.AddressId == addressId
&
a.TerritoryId == TerritoryId
select a).FirstOrDefault();
if (addr != null)
{
if (addr.NotAtHomeCount == -1)
{
addr.NotAtHomeCount = 1;
}
addr.NotAtHomeCount = addr.NotAtHomeCount + 1;
addr.HasBeenWorked = false;
db.SubmitChanges();
ReturnTo(addr);
//Response.Redirect("ContactList.aspx?TerritoryId=" + territoryIdGuid + "&s=" + addr.StreetName);
}
}
}
