private void InitialViewGUID()
{
var url = SPContext.Current.Web.Url;
leaveManagementDAL = new LeaveManagementDAL(url);
var guidViews = leaveManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
LeaveByDepartmentWebPart.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(LeaveByDepartmentWebPart.XmlDefinition);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
LeaveByDepartmentWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
private void InitialViewGUID()
{
var webUrl = SPContext.Current.Web.Url;
leaveManagementDAL = new LeaveManagementDAL(webUrl);
var guidViews = leaveManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
LeaveRequestForSecurityWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
string employeeID = this.Page.Request.Params.Get("employeeId");
XElement filterElement = BuildViewString(webUrl, employeeID);
XElement xmlViewDef = XElement.Parse(LeaveRequestForSecurityWebPart.XmlDefinition);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
LeaveRequestForSecurityWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
public EmployeeInfo GetNextApproval(int departmentID, int locationID, StepModuleList StepModule, int stepNumber)
{
IModuleBuilder moduleBuilder = null;
EmployeeInfo nextAssignee = null;
switch (StepModule)
{
case StepModuleList.VehicleManagement:
moduleBuilder = new VehicleManagementDAL(SiteUrl);
break;
case StepModuleList.LeaveManagement:
moduleBuilder = new LeaveManagementDAL(SiteUrl);
break;
default:
return(null);
}
var approvalList = moduleBuilder.CreateApprovalList(departmentID, locationID);
if (approvalList.Count > 0 && approvalList.Count() >= stepNumber)
{
nextAssignee = approvalList.ElementAt(stepNumber - 1);
}
return(nextAssignee);
}
protected void Page_Load(object sender, EventArgs e)
{
GetCurrentUser();
var url = SPContext.Current.Web.Url;
LeaveManagementDal = new LeaveManagementDAL(url);
var guidViews = LeaveManagementDal.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
LeaveRequestWebPart.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 InitialViewGUID()
{
var siteUrl = SPContext.Current.Web.Url;
leaveManagementDAL = new LeaveManagementDAL(siteUrl);
var guidViews = leaveManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
LeaveApprovalWebPart.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
XElement xmlViewDef = XElement.Parse(LeaveApprovalWebPart.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);
LeaveApprovalWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
private void GetLeaveTaskList(LeaveManagementDAL leaveManagementDAL)
{
var query = _filterTaskManager.BuildApprovalTaskListQuery(StepModuleList.LeaveManagement.ToString(), _currentUserADId, DateTime.Now);
if (this.CountOnly)
{
TotalCount += leaveManagementDAL.CountByQuery(query);
}
else
{
var leaveManagementList = leaveManagementDAL.GetByQuery(query);
if (leaveManagementList != null && leaveManagementList.Count > 0)
{
foreach (var leaveManagement in leaveManagementList)
{
var filterTask = new FilterTask(leaveManagement);
filterTask.ApprovalStatusId = leaveManagement.ApprovalStatus == Status.Approved ? ApprovedStatusId
: leaveManagement.ApprovalStatus == Status.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
public void Visit(LeaveManagementDAL leaveManagementDAL)
{
GetLeaveTaskList(leaveManagementDAL);
}
private void GetLeaveTaskList(LeaveManagementDAL leaveManagementDAL)
{
var taskListQuery = _filterTaskManager.BuildTaskListQuery(StepModuleList.LeaveManagement.ToString(), TaskStatusList.InProgress.ToString(), _currentUserADId);
List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == LeaveManagementList.ListUrl).Select(d => d.ListItemID).ToList();
var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserADId, string.Empty, string.Empty, delegatedItemIDs);
var query = $@"<Where>
<And>
<Or>
{taskListQuery}
{delegationQuery}
</Or>
<Or>
<Or>
<And>
<And>
<Gt>
<FieldRef Name='{LeaveManagementList.TotalDaysField}' />
<Value Type='Number'>0</Value>
</Gt>
<Lt>
<FieldRef Name='{LeaveManagementList.TotalDaysField}' />
<Value Type='Number'>3</Value>
</Lt>
</And>
<Gt>
<FieldRef Name='{CommonSPListField.CommonReqDueDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(1).ToString(StringConstant.DateFormatForCAML)}</Value>
</Gt>
</And>
<And>
<And>
<Geq>
<FieldRef Name='{LeaveManagementList.TotalDaysField}' />
<Value Type='Number'>3</Value>
</Geq>
<Lt>
<FieldRef Name='{LeaveManagementList.TotalDaysField}' />
<Value Type='Number'>5</Value>
</Lt>
</And>
<Geq>
<FieldRef Name='{CommonSPListField.CommonReqDueDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(3).ToString(StringConstant.DateFormatForCAML)}</Value>
</Geq>
</And>
</Or>
<And>
<Geq>
<FieldRef Name='{LeaveManagementList.TotalDaysField}' />
<Value Type='Number'>5</Value>
</Geq>
<Gt>
<FieldRef Name='{CommonSPListField.CommonReqDueDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(15).ToString(StringConstant.DateFormatForCAML)}</Value>
</Gt>
</And>
</Or>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += leaveManagementDAL.CountByQuery(query);
}
else
{
var leaveManagementList = leaveManagementDAL.GetByQuery(query);
if (leaveManagementList != null)
{
foreach (var leaveManagement in leaveManagementList)
{
var filterTask = new FilterTask(leaveManagement);
filterTask.ApprovalStatusId = ApprovalStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
public void Visit(LeaveManagementDAL leaveManagementDAL)
{
// Do nothing
}
