// Add your own data access methods.
// This file should not get overridden
public IList<CS_SP_GetCallCriteriaValues_Result> ListCallCriteriaValueByID(int CallCriteriaID)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_SP_GetCallCriteriaValues(CallCriteriaID).ToList();
}
}
// Add your own data access methods.
// This file should not get overridden
public string GetInitialAdviseNote(bool isEmployee, int personID)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_SP_GetInitialAdviseNote(isEmployee, personID).FirstOrDefault();
}
}
// Add your own data access methods.
// This file should not get overridden
/// <summary>
/// Executes the StoredProcedure to update Equipment information from Integration
/// </summary>
public List<int?> ListJobsBySearchCriteria(SearchCriteriaVO searchVO)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_SP_ListJobsBySearchCriteria(searchVO.customerInfoType, searchVO.jobInfoType, searchVO.locationInfoType, searchVO.jobDescriptionType, searchVO.equipmentType, searchVO.resourceType, searchVO.customerInfoValue, searchVO.jobInfoValue, searchVO.locationInfoValue, searchVO.jobDescriptionValue, searchVO.equipmentValue, searchVO.resourceValue, searchVO.startDate, searchVO.endDate).ToList();
}
}
public void UpdateFromIntegration()
{
using (var db = new CustomerServiceModelContainer())
{
db.CS_SP_UpdateContact();
}
}
/// <summary>
/// Executes the StoredProcedure to update Equipment information from Integration
/// </summary>
public void UpdateFromIntegration()
{
using (var db = new CustomerServiceModelContainer())
{
db.CS_SP_UpdateEquipmentAndType();
}
}
public IList<CS_SP_CheckCallCriteria_Result> CheckCallCriteria(int CallLogID, int callLogTypeId, int jobId)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_SP_CheckCallCriteria(CallLogID, callLogTypeId, jobId).ToList();
}
}
// Add your own data access methods.
// This file should not get overridden
public IList<CS_SP_GetJobSummary_Result> GetJobSummary(int? JobStatusID, int? JobID, int? DivisionID, int? CustomerID,
int? DateFilterTypeID, DateTime BeginDate, DateTime EndDate, string PersonName)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_SP_GetJobSummary(JobStatusID, JobID, DivisionID, CustomerID, DateFilterTypeID, BeginDate, EndDate, PersonName).ToList();
}
}
// Add your own data access methods.
// This file should not get overridden
public IList<CS_View_JobCallLog> GetJobCallLog(int? JobStatusID, int? CallTypeID, int? DivisionID, string ModifiedBy,
bool? ShiftTransferLog, bool? GeneralLog, DateTime StartModificationDate,
DateTime EndModificationDate, string PersonName)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_SP_GetJobCallLog(JobStatusID, CallTypeID, DivisionID, ModifiedBy, ShiftTransferLog, GeneralLog, StartModificationDate, EndModificationDate, PersonName).ToList();
}
}
public void Initialize()
{
CustomerServiceModelContainer ctx = new CustomerServiceModelContainer();
// EmployeeDao.Singleton.ExecuteSql(ctx, "DELETE FROM CS_STATE");
// EmployeeDao.Singleton.ExecuteSql(ctx, "DELETE FROM CS_COUNTRY");
// EmployeeDao.Singleton.ExecuteSql(ctx, "DELETE FROM CS_CUSTOMER");
// EmployeeDao.Singleton.ExecuteSql(ctx, "DELETE FROM CS_CUSTOMERCONTRACT");
}
public void Initialize()
{
CustomerServiceModelContainer ctx = new CustomerServiceModelContainer();
EmployeeDao.Singleton.ExecuteSql(ctx, "DELETE FROM CS_EMPLOYEE");
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EmployeeInfo> ListFilteredByJobNumber(string[] jobNumbers)
{
using (var db = new CustomerServiceModelContainer())
{
IList<CS_View_EmployeeInfo> returnList = db.CS_View_EmployeeInfo.Where(e => jobNumbers.Contains(e.JobNumber)).OrderBy(e => e.DivisionName).ToList();
return returnList;
}
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EquipmentInfo> ListFilteredByUnitNumber(string[] unitNumbers)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_View_EquipmentInfo.Where(e => unitNumbers.Any(unitNumber => e.UnitNumber.Contains(unitNumber))).OrderBy(e => e.ComboName).ToList();
}
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EquipmentInfo> ListFilteredByStatus(string[] statusList)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_View_EquipmentInfo.Where(e => statusList.Any(status => e.Status.Contains(status))).OrderBy(e => e.ComboName).ToList();
}
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EquipmentInfo> ListFilteredByJobLocation(string[] jobLocations)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_View_EquipmentInfo.Where(e => jobLocations.Any(location => e.JobLocation.Contains(location))).OrderBy(e => e.ComboName).ToList();
}
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EquipmentInfo> ListFilteredByDivisionState(string[] divisionStates)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_View_EquipmentInfo.Where(e => divisionStates.Any(state => e.DivisionState.Contains(state))).OrderBy(e => e.ComboName).ToList();
}
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EquipmentInfo> ListFilteredByCallType(string[] callTypes)
{
using (var db = new CustomerServiceModelContainer())
{
return db.CS_View_EquipmentInfo.Where(e => callTypes.Any(callType => e.Type.Contains(callType))).OrderBy(e => e.ComboName).ToList();
}
}
/// <summary>
/// List all items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EquipmentInfo> ListAll()
{
using (var db = new CustomerServiceModelContainer())
{
IList<CS_View_EquipmentInfo> returnList = ListAllQuery.Invoke(db).ToList<CS_View_EquipmentInfo>();
return returnList;
}
}
/// <summary>
/// Get a specific Entity in the Database
/// </summary>
/// <param name="id">Entity's Identifier (Primary Key)</param>
/// <returns>Entity loaded with all its information</returns>
public CS_View_EquipmentInfo Get(int id)
{
using (var db = new CustomerServiceModelContainer())
{
CS_View_EquipmentInfo returnItem = GetQuery.Invoke(db, id).FirstOrDefault<CS_View_EquipmentInfo>();
return returnItem;
}
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EmployeeInfo> ListFilteredByPosition(string[] positionNames)
{
using (var db = new CustomerServiceModelContainer())
{
IList<CS_View_EmployeeInfo> returnList = db.CS_View_EmployeeInfo.Where(e => positionNames.Contains(e.Position)).OrderBy(e => e.Position).ToList();
return returnList;
}
}
/// <summary>
/// List Filtered items of an Entity
/// </summary>
/// <returns>List of Entities</returns>
public IList<CS_View_EmployeeInfo> ListFilteredByStatus(string[] status)
{
using (var db = new CustomerServiceModelContainer())
{
IList<CS_View_EmployeeInfo> returnList = db.CS_View_EmployeeInfo.Where(e => status.Contains(e.Assigned)).OrderBy(e => e.DivisionName).ToList();
return returnList;
}
}
/// <summary>
/// List filterd items for the Reserve Equipment View
/// </summary>
/// <param name="equipmentTypeId">Equipment Type filter</param>
/// <param name="stateId">State filter</param>
/// <param name="divisionId">Division filter</param>
/// <returns>List of Equipments</returns>
public IList<CS_View_ReserveEquipment> ListAllFiltered(int? equipmentTypeId, int? stateId, int? divisionId)
{
using (var db = new CustomerServiceModelContainer())
{
return ListFilteredQuery.Invoke(db, equipmentTypeId, stateId, divisionId).ToList<CS_View_ReserveEquipment>();
}
}
/// <summary>
/// Returns a list of all equipment types available for reserve
/// </summary>
/// <returns>List of Equipments</returns>
public IList<CS_View_ReserveEquipment> ListAll()
{
using (var db = new CustomerServiceModelContainer())
{
return ListAllQuery.Invoke(db).ToList<CS_View_ReserveEquipment>();
}
}
public void Initialize()
{
CustomerServiceModelContainer ctx = new CustomerServiceModelContainer();
_jobPhotoReportDao = new JobPhotoReportDao();
JobPhotoReportDao.Singleton.ExecuteSql(ctx, "DELETE FROM CS_JobPhotoReport");
}
