private void InitialViewGUID()
{
var siteUrl = SPContext.Current.Web.Url;
businessTripManagementDAL = new BusinessTripManagementDAL(siteUrl);
var guidViews = businessTripManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
MyBusinessTripRequestWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
UserHelper userHelper = new UserHelper();
EmployeeInfo employeeInfo = userHelper.GetCurrentLoginUser();
XElement xmlViewDef = XElement.Parse(MyBusinessTripRequestWebPart.XmlDefinition);
XElement filterElement = BuildViewString(employeeInfo, siteUrl);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
MyBusinessTripRequestWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
private void InitialViewGUID()
{
var url = SPContext.Current.Web.Url;
businessTripManagementDAL = new BusinessTripManagementDAL(url);
var guidViews = businessTripManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
BusinessTripByDepartmentWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
UserHelper userHelper = new UserHelper();
EmployeeInfo currentEmployeeInfo = userHelper.GetCurrentLoginUser();
string selectedDepId = this.Page.Request.Params.Get("AdminDeptId");
XElement filterElement = BuildViewString(currentEmployeeInfo, selectedDepId);
XElement xmlViewDef = XElement.Parse(BusinessTripByDepartmentWebPart.XmlDefinition);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
BusinessTripByDepartmentWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
private void InitialViewGUID(string webUrl)
{
businessTripManagementDAL = new BusinessTripManagementDAL(webUrl);
var guidViews = businessTripManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
BusinessTripByExtAdminWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
}
public BusinessTripManagementService()
{
var webUrl = SPContext.Current.Web.Url;
_businessTripEmployeeDetailDAL = new BusinessTripEmployeeDetailDAL(webUrl);
_businessTripManagementDAL = new BusinessTripManagementDAL(webUrl);
_businessTripScheduleDAL = new BusinessTripScheduleDAL(webUrl);
}
private void InitialViewGUID()
{
var url = SPContext.Current.Web.Url;
businessTripManagementDAL = new BusinessTripManagementDAL(url);
var guidViews = businessTripManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
BusinessTripDriverWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
GetCurrentUser();
var url = SPContext.Current.Web.Url;
businessTripManagementDAL = new BusinessTripManagementDAL(url);
var guidViews = businessTripManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
BusinessTripRequestWebPart.ViewGuid = guidViews.ID.ToString();
}
/// <summary>
/// InitDALObject
/// </summary>
/// <param name="listUrl"></param>
/// <param name="currentWeb"></param>
/// <returns></returns>
private static IDelegationManager InitDALObject(string listUrl, SPWeb currentWeb)
{
IDelegationManager moduleDAL = null;
if (string.Compare(listUrl, ShiftManagementList.ListUrl, true) == 0)
{
moduleDAL = new ShiftManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, ChangeShiftList.ListUrl, true) == 0)
{
moduleDAL = new ChangeShiftManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, OverTimeManagementList.ListUrl, true) == 0)
{
moduleDAL = new OverTimeManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, NotOvertimeList.ListUrl, true) == 0)
{
moduleDAL = new NotOvertimeManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, VehicleManagementList.ListUrl, true) == 0)
{
moduleDAL = new VehicleManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, LeaveManagementList.ListUrl, true) == 0)
{
moduleDAL = new LeaveManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, FreightManagementList.ListUrl, true) == 0)
{
moduleDAL = new FreightManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, BusinessTripManagementList.Url, true) == 0)
{
moduleDAL = new BusinessTripManagementDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, RequestsList.Url, true) == 0)
{
moduleDAL = new RequestsDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, EmployeeRequirementSheetsList.Url, true) == 0)
{
moduleDAL = new EmployeeRequirementSheetDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, RequestForDiplomaSuppliesList.Url, true) == 0)
{
moduleDAL = new RequestForDiplomaSupplyDAL(currentWeb.Url);
}
else if (string.Compare(listUrl, RequisitionOfMeetingRoomList.Url, true) == 0)
{
moduleDAL = new RequisitionOfMeetingRoomDAL(currentWeb.Url);
}
return(moduleDAL);
}
private void GetBusinessTripTaskList(BusinessTripManagementDAL businessTripManagementDAL)
{
var taskListQuery = _filterTaskManager.BuildTaskListQuery(StepModuleList.BusinessTripManagement.ToString(), TaskStatusList.InProgress.ToString(), _currentUserADId);
List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == BusinessTripManagementList.Url).Select(d => d.ListItemID).ToList();
var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserADId, string.Empty, string.Empty, delegatedItemIDs);
var query = $@"<Where>
<And>
<Or>
{taskListQuery}
{delegationQuery}
</Or>
<Or>
<Eq>
<FieldRef Name='{CommonSPListField.CommonReqDueDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
<Eq>
<FieldRef Name='{CommonSPListField.CommonReqDueDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(1).ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</Or>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += businessTripManagementDAL.CountByQuery(query);
}
else
{
var businessTripManagementList = businessTripManagementDAL.GetByQuery(query);
if (businessTripManagementList != null)
{
foreach (var businessTripManagement in businessTripManagementList)
{
var filterTask = new FilterTask(businessTripManagement);
filterTask.ApprovalStatusId = ApprovalStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetBusinessTripTaskList(BusinessTripManagementDAL businessTripManagementDAL)
{
var query = _filterTaskManager.BuildApprovalTaskListQuery(StepModuleList.BusinessTripManagement.ToString(), _currentUserADId, DateTime.Now);
if (this.CountOnly)
{
TotalCount += businessTripManagementDAL.CountByQuery(query);
}
else
{
var businessTripManagementList = businessTripManagementDAL.GetByQuery(query);
if (businessTripManagementList != null && businessTripManagementList.Count > 0)
{
foreach (var businessTripManagement in businessTripManagementList)
{
var filterTask = new FilterTask(businessTripManagement);
filterTask.ApprovalStatusId = businessTripManagement.ApprovalStatus == Status.Approved ? ApprovedStatusId
: businessTripManagement.ApprovalStatus == Status.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void InitialViewGUID()
{
var siteUrl = SPContext.Current.Web.Url;
businessTripManagementDAL = new BusinessTripManagementDAL(siteUrl);
var guidViews = businessTripManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
BusinessTripApprovalWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
XElement xmlViewDef = XElement.Parse(BusinessTripApprovalWebPart.XmlDefinition);
XElement filterElement = BuildViewString(SPContext.Current.Web.CurrentUser.ID, siteUrl);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
BusinessTripApprovalWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
public void Visit(BusinessTripManagementDAL businessTripManagementDAL)
{
GetBusinessTripTaskList(businessTripManagementDAL);
}
public void Visit(BusinessTripManagementDAL businessTripManagementDAL)
{
// Do nothing
}
