private void BindList()
{
CustomerModel customerModel;
EmployeeModel employeeModel;
LocationModel locationModel;
DivisionModel divisionModel;
JobModel jobModel;
CallLogModel callLogModel;
EquipmentModel equipmentModel;
IList<CS_Customer> customerDataSource;
IList<CS_Contact> contactDataSource;
IList<CS_Employee> employeeDataSource;
IList<CS_JobStatus> jobStatusDataSource;
IList<CS_City> cityDataSource;
IList<CS_Division> divisionDataSource;
IList<CS_PriceType> priceTypeDataSource;
IList<CS_JobAction> jobActionDataSource;
IList<CS_Job> jobNumberDataSource;
IList<CS_ZipCode> zipCodeDataSource;
IList<CS_State> stateDataSource;
IList<CS_CallType> callTypeDataSource;
IList<CS_EquipmentType> equipmentTypeDataSource;
IList<CS_Equipment> equipmentDataSource;
IList<CS_LocalEquipmentType> localEquipmentTypeDataSource;
switch (Request.QueryString["AutoCompleteSource"])
{
case "Customer":
customerModel = new CustomerModel();
customerDataSource = customerModel.ListAllCustomers().OrderBy(e => e.Name).ToList();
ViewStateList = customerDataSource;
break;
case "Contact":
customerModel = new CustomerModel();
contactDataSource = customerModel.ListAllFilteredContactsByName(long.Parse(Request.QueryString["FilterId"]), "").OrderBy(e => e.LastName).ThenBy(e => e.Name).ToList();
ViewStateList = contactDataSource;
break;
case "DynamicsContact":
customerModel = new CustomerModel();
contactDataSource = customerModel.ListFilteredContactsByName(long.Parse(Request.QueryString["FilterId"]), true, "").OrderBy(e => e.Attn).ToList();
ViewStateList = contactDataSource;
break;
case "CustomerServiceContact":
customerModel = new CustomerModel();
contactDataSource = customerModel.ListFilteredContactsByName(long.Parse(Request.QueryString["FilterId"]), false, "").OrderBy(e => e.LastName).ThenBy(e => e.Name).ToList();
ViewStateList = contactDataSource;
break;
case "Employee":
employeeModel = new EmployeeModel();
if (Request.QueryString["FilterId"] != "0")
employeeDataSource = employeeModel.ListAllFilteredEmployee(long.Parse(Request.QueryString["FilterId"])).OrderBy(e => e.CS_Division.Name).ThenBy(e => e.FullName).ToList();
else
employeeDataSource = employeeModel.ListAllEmployee().OrderBy(e => e.CS_Division.Name).ThenBy(e => e.FullName).ToList();
ViewStateList = employeeDataSource;
break;
case "EmployeeWithDivision":
employeeModel = new EmployeeModel();
if (Request.QueryString["FilterId"] != "0")
employeeDataSource = employeeModel.ListAllFilteredEmployee(long.Parse(Request.QueryString["FilterId"])).OrderBy(e => e.CS_Division.Name).ThenBy(e => e.FullName).ToList();
else
employeeDataSource = employeeModel.ListAllEmployee().OrderBy(e => e.CS_Division, new Globals.JobRecord.EmployeeComparer()).ThenBy(e => e.FullName).ToList();
ViewStateList = employeeDataSource;
break;
case "JobStatus":
jobModel = new JobModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
jobStatusDataSource = new List<CS_JobStatus>();
jobStatusDataSource.Add(jobModel.GetJobStatus(int.Parse(Request.QueryString["FilterId"])));
}
else
jobStatusDataSource = jobModel.ListAllJobStatus();
ViewStateList = jobStatusDataSource;
break;
case "JobStatusJobRecord":
jobModel = new JobModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0" && Request.QueryString["FilterId"] != Globals.JobRecord.JobStatus.ClosedHold.ToString())
{
jobStatusDataSource = new List<CS_JobStatus>();
jobStatusDataSource.Add(jobModel.GetJobStatus(int.Parse(Request.QueryString["FilterId"])));
}
else
{
jobStatusDataSource = jobModel.ListAllJobStatus();
if (jobStatusDataSource.Count > 0)
{
CS_JobStatus jobStatus = jobStatusDataSource.Where(w => w.ID == (int)Globals.JobRecord.JobStatus.ClosedHold).FirstOrDefault();
if (null != jobStatus)
jobStatusDataSource.Remove(jobStatus);
}
}
ViewStateList = jobStatusDataSource;
break;
case "State":
locationModel = new LocationModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString.Get("FilterId") != "0")
stateDataSource = locationModel.GetStateByCountryId(int.Parse(Request.QueryString.Get("FilterId")));
else
stateDataSource = locationModel.ListAllStates();
ViewStateList = stateDataSource;
break;
case "StateByDivision":
locationModel = new LocationModel();
stateDataSource = locationModel.ListAllStatesByAllocatedDivision();
ViewStateList = stateDataSource;
break;
case "City":
locationModel = new LocationModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString.Get("FilterId") != "0")
cityDataSource = locationModel.GetCityByState(int.Parse(Request.QueryString.Get("FilterId"))).OrderBy(e => e.Name).ToList();
else
cityDataSource = locationModel.ListAllCities().OrderBy(e => e.Name).ToList();
ViewStateList = cityDataSource;
break;
case "Division":
divisionModel = new DivisionModel();
divisionDataSource = divisionModel.ListAllDivision();
ViewStateList = divisionDataSource;
break;
case "PriceType":
jobModel = new JobModel();
priceTypeDataSource = jobModel.ListAllPriceTypes();
ViewStateList = priceTypeDataSource;
break;
case "JobAction":
jobModel = new JobModel();
jobActionDataSource = jobModel.ListAllJobActions().OrderBy(w => w.Description).ToList();
ViewStateList = jobActionDataSource;
break;
case "ZipCode":
locationModel = new LocationModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString.Get("FilterId") != "0")
zipCodeDataSource = locationModel.GetZipCodeByCityId(int.Parse(Request.QueryString.Get("FilterId"))).OrderBy(e => e.ZipCodeNameEdited).ToList();
else
zipCodeDataSource = locationModel.ListAllZipCodes();
ViewStateList = zipCodeDataSource;
break;
case "JobNumber":
jobModel = new JobModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
jobNumberDataSource = new List<CS_Job>();
jobNumberDataSource.Add(jobModel.GetJobById(int.Parse(Request.QueryString["FilterId"])));
}
else
jobNumberDataSource = jobModel.ListAllJobs();
ViewStateList = jobNumberDataSource;
break;
case "JobNumberByStatus":
jobModel = new JobModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
jobNumberDataSource = new List<CS_Job>();
jobNumberDataSource = jobModel.ListAllJobsByNumber("", Request.QueryString["FilterId"]);
}
else
jobNumberDataSource = jobModel.ListAllJobs();
ViewStateList = jobNumberDataSource;
break;
case "JobNumberWithGeneral":
jobModel = new JobModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
jobNumberDataSource = new List<CS_Job>();
jobNumberDataSource.Add(jobModel.GetJobById(int.Parse(Request.QueryString["FilterId"])));
}
else
{
List<CS_Job> source = new List<CS_Job>();
source.Add(jobModel.GetGeneralJob());
source.AddRange(jobModel.ListAllJobs());
jobNumberDataSource = source;
}
ViewStateList = jobNumberDataSource;
break;
case "BillableJobNumber":
jobModel = new JobModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
jobNumberDataSource = new List<CS_Job>();
jobNumberDataSource.Add(jobModel.GetJobById(int.Parse(Request.QueryString["FilterId"])));
}
else
jobNumberDataSource = jobModel.ListAllBillableJobs();
ViewStateList = jobNumberDataSource;
break;
case "CallType":
callLogModel = new CallLogModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
callTypeDataSource = new List<CS_CallType>();
callTypeDataSource.Add(callLogModel.GetCallType(int.Parse(Request.QueryString["FilterId"])));
}
else
callTypeDataSource = callLogModel.ListAllCallType();
ViewStateList = callTypeDataSource;
break;
case "EquipmentType":
equipmentModel = new EquipmentModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
equipmentTypeDataSource = new List<CS_EquipmentType>();
equipmentTypeDataSource.Add(equipmentModel.GetEquipmentType(int.Parse(Request.QueryString["FilterId"])));
}
else
equipmentTypeDataSource = equipmentModel.ListAllEquipmentType();
ViewStateList = equipmentTypeDataSource;
break;
case "Equipment":
equipmentModel = new EquipmentModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
equipmentDataSource = new List<CS_Equipment>();
equipmentDataSource = equipmentModel.GetEquipmentByEqType(int.Parse(Request.QueryString["FilterId"])).OrderBy(w => w.Name).ToList();
}
else
equipmentDataSource = equipmentModel.ListAllEquipment().OrderBy(w => w.Name).ToList(); ;
ViewStateList = equipmentDataSource;
break;
case "LocalEquipmentType":
equipmentModel = new EquipmentModel();
if (!string.IsNullOrEmpty(Request.QueryString.Get("FilterId")) && Request.QueryString["FilterId"] != "0")
{
localEquipmentTypeDataSource = new List<CS_LocalEquipmentType>();
localEquipmentTypeDataSource.Add(equipmentModel.GetLocalEquipmentTypeByID(int.Parse(Request.QueryString["FilterId"])));
}
else
localEquipmentTypeDataSource = equipmentModel.ListAllLocalEquipmentType();
ViewStateList = localEquipmentTypeDataSource;
break;
case "ProjectManager":
employeeModel = new EmployeeModel();
employeeDataSource = employeeModel.ListAllEmployeeProjectManager();
ViewStateList = employeeDataSource;
break;
default:
break;
}
}
/// <summary>
/// Sends the email notification for the permit team
/// </summary>
/// <param name="equipmentPermitId">job id</param>
public IList<CS_EquipmentPermitEmail> SendNotificationForPermitTeam(IList<CS_EquipmentPermit> expiredPermits)
{
_settingsModel = new SettingsModel();
try
{
IList<CS_EquipmentPermit> expiredLicenses = expiredPermits.Distinct(new Globals.EmailService.CS_EquipmentPermit_Comparer()).ToList();
IList<CS_State> states = new List<CS_State>();
using (_locationModel = new LocationModel())
{
states = _locationModel.ListAllStates();
}
IList<CS_EquipmentPermitEmail> returnList = new List<CS_EquipmentPermitEmail>();
for (int i = 0; i < expiredLicenses.Count; i++)
{
CS_EquipmentPermit license = expiredLicenses[i];
IList<CS_EquipmentPermit> expiredEquipments = expiredPermits.Where(e => e.LicenseNumber == license.LicenseNumber && e.Code == license.Code).ToList();
IList<CS_Email> emails = new List<CS_Email>();
//Body
string body = GenerateEmailBodyForPermitTeam(license, expiredEquipments, states);
//List receipts
string receipts = _settingsModel.GetPermitTeamEmails();
//Subject
string subject = GenerateEmailSubjectEstimationTeam(license, states);
if (!string.IsNullOrEmpty(receipts))
{
using (_emailModel = new EmailModel())
{
emails = _emailModel.SaveEmailList(receipts, subject, body, "System", Globals.Security.SystemEmployeeID);
}
}
for (int j = 0; j < expiredEquipments.Count; j++)
{
CS_EquipmentPermit equipmentPermit = expiredEquipments[j];
for (int h = 0; h < emails.Count; h++)
{
CS_Email email = emails[h];
returnList.Add
(
new CS_EquipmentPermitEmail()
{
EmailID = email.ID,
EquipmentPermitID = equipmentPermit.Id,
CreatedBy = "System",
CreationDate = email.CreationDate,
CreationID = Globals.Security.SystemEmployeeID,
ModifiedBy = "System",
ModificationDate = email.CreationDate,
ModificationID = Globals.Security.SystemEmployeeID,
Active = true
}
);
}
}
}
return returnList;
}
catch (Exception ex)
{
throw new Exception("There was an error sending the email notification for the Permit Team.", ex);
}
}
