private void InitialViewGUID()
{
var url = SPContext.Current.Web.Url;
freightManagementDAL = new FreightManagementDAL(url);
var guidViews = freightManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
FreightRequestForSecurityWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
string selectedDepId = this.Page.Request.Params.Get("AdminDeptId");
string selectedVehicleId = this.Page.Request.Params.Get("AdminVehicleId");
string requestNumber = this.Page.Request.Params.Get("reqnum");
string searchType = this.Page.Request.Params.Get("searchtype");
UserHelper userHelper = new UserHelper();
var currentEmployee = userHelper.GetCurrentLoginUser();
XElement filterElement = BuildViewString(currentEmployee, selectedDepId, selectedVehicleId, requestNumber, searchType);
XElement xmlViewDef = XElement.Parse(FreightRequestForSecurityWebPart.XmlDefinition);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
FreightRequestForSecurityWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
GetCurrentUser();
var url = SPContext.Current.Web.Url;
freightManagementDAL = new FreightManagementDAL(url);
var guidViews = freightManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
MyFreightWebPart.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 GetFreightTaskList(FreightManagementDAL freightManagementDAL)
{
var taskListQuery = _filterTaskManager.BuildTaskListQuery(StepModuleList.FreightManagement.ToString(), TaskStatusList.InProgress.ToString(), _currentUserADId);
List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == FreightManagementList.ListUrl).Select(d => d.ListItemID).ToList();
var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserADId, string.Empty, string.Empty, delegatedItemIDs);
var query = $@"<Where>
<And>
<Or>
{taskListQuery}
{delegationQuery}
</Or>
<Geq>
<FieldRef Name='{FreightManagementList.TransportTimeField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Geq>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += freightManagementDAL.CountByQuery(query);
}
else
{
var freightManagementList = freightManagementDAL.GetByQuery(query);
if (freightManagementList != null)
{
foreach (var freightManagement in freightManagementList)
{
var filterTask = new FilterTask(freightManagement);
filterTask.ApprovalStatusId = ApprovalStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void InitialViewGUID()
{
string siteUrl = SPContext.Current.Site.Url;
freightManagementDAL = new FreightManagementDAL(siteUrl);
var guidViews = freightManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
FreightApprovalWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
XElement xmlViewDef = XElement.Parse(FreightApprovalWebPart.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);
FreightApprovalWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
private void GetFreightTaskList(FreightManagementDAL freightManagementDAL)
{
var query = _filterTaskManager.BuildApprovalTaskListQuery(StepModuleList.FreightManagement.ToString(), _currentUserADId, DateTime.Now);
if (this.CountOnly)
{
TotalCount += freightManagementDAL.CountByQuery(query);
}
else
{
var freightManagementList = freightManagementDAL.GetByQuery(query);
if (freightManagementList != null && freightManagementList.Count > 0)
{
foreach (var freightManagement in freightManagementList)
{
var filterTask = new FilterTask(freightManagement);
filterTask.ApprovalStatusId = freightManagement.ApprovalStatus == Status.Approved ? ApprovedStatusId
: freightManagement.ApprovalStatus == Status.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
public void Visit(FreightManagementDAL freightManagementDAL)
{
// Do nothing
}
public void Visit(FreightManagementDAL freightManagementDAL)
{
GetFreightTaskList(freightManagementDAL);
}
