private void initialViewGUID()
{
var url = SPContext.Current.Web.Url;
overTimeManagementDAL = new OverTimeManagementDAL(url);
var guidViews = overTimeManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == BASE_VIEW_ID).FirstOrDefault();
OvertimeDepartment.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
CheckCurrentUser(url);
bool isAdminDepartment = UserPermission.IsAdminDepartment;
XElement xmlViewDef = XElement.Parse(OvertimeDepartment.XmlDefinition);
string selectedDepId = this.Page.Request.Params.Get("AdminDeptId");
XElement filterElement = BuildViewString(isBOD, isAdminDepartment, selectedDepId);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
OvertimeDepartment.XmlDefinition = xmlViewDef.ToString();
}
}
private void GetOvertimeTaskList(OverTimeManagementDAL overTimeManagementDAL)
{
var query = $@"<Where>
<Or>
<And>
<Eq>
<FieldRef Name='{StringConstant.OverTimeManagementList.FirstApprovedByField}' LookupId='TRUE' />
<Value Type='User'>{_currentUserADId}</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.OverTimeManagementList.FirstApprovedDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</And>
<And>
<Or>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>true</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>false</Value>
</Eq>
</Or>
<And>
<Eq>
<FieldRef Name='{StringConstant.OverTimeManagementList.ApprovedByField}' LookupId='TRUE' />
<Value Type='User'>{_currentUserADId}</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.DefaultSPListField.ModifiedField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</And>
</And>
</Or>
</Where>";
if (this.CountOnly)
{
TotalCount += overTimeManagementDAL.CountByQuery(query);
}
else
{
var overtimeManagementList = overTimeManagementDAL.GetByQuery(query);
if (overtimeManagementList != null && overtimeManagementList.Count > 0)
{
foreach (var overtimeManagement in overtimeManagementList)
{
var filterTask = new FilterTask(overtimeManagement);
filterTask.ApprovalStatusId = overtimeManagement.ApprovalStatus == "true" ? ApprovedStatusId
: overtimeManagement.ApprovalStatus == "false" ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
public OvertimeService()
{
var webUrl = SPContext.Current.Web.Url;
_overTimeManagementDAL = new OverTimeManagementDAL(webUrl);
_overTimeManagementDetailDAL = new OverTimeManagementDetailDAL(webUrl);
_notOvertimeManagementDal = new NotOvertimeManagementDAL(webUrl);
_employeeInfoDAL = new EmployeeInfoDAL(webUrl);
}
public EmployeeService()
{
var url = SPContext.Current.Web.Url;
_employeeInfoDAL = new EmployeeInfoDAL(url);
_departmentDAL = new DepartmentDAL(url);
_overtimeManagementDAL = new OverTimeManagementDAL(url);
_overtimeManagementDetailDAL = new OverTimeManagementDetailDAL(url);
_employeePositionDAL = new EmployeePositionDAL(url);
}
protected void Page_Load(object sender, EventArgs e)
{
// Set Guid
var url = SPContext.Current.Web.Url;
overTimeManagementDAL = new OverTimeManagementDAL(url);
var guidViews = overTimeManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == BASE_VIEW_ID).FirstOrDefault();
OvertimeApprovalControl.ViewGuid = guidViews == null ? "" : 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);
}
public MessageResult GetModifiedDate(string moduleId, string itemId)
{
string ret = string.Empty;
try
{
SPWeb currentWeb = SPContext.Current.Web;
int moduleIdendify = 0;
int itemIdentify = 0;
if (int.TryParse(moduleId, out moduleIdendify) && int.TryParse(itemId, out itemIdentify))
{
SPListItemCollection itemCollection = null;
SPQuery spQuery = new SPQuery()
{
Query = $"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>{itemIdentify}</Value></Eq></Where>",
RowLimit = 1
};
switch (moduleIdendify)
{
case (int)StepModuleList.ShiftManagement:
ShiftManagementDAL _shiftManagementDAL = new ShiftManagementDAL(currentWeb.Url);
itemCollection = _shiftManagementDAL.GetByQueryToSPListItemCollection(currentWeb, spQuery, new string[] { StringConstant.DefaultSPListField.ModifiedField });
break;
case (int)StepModuleList.OvertimeManagement:
OverTimeManagementDAL _overTimeManagementDAL = new OverTimeManagementDAL(currentWeb.Url);
itemCollection = _overTimeManagementDAL.GetByQueryToSPListItemCollection(currentWeb, spQuery, new string[] { StringConstant.DefaultSPListField.ModifiedField });
break;
default:
break;
}
if (itemCollection != null && itemCollection.Count > 0)
{
DateTime modifiedField = (DateTime)itemCollection[0][StringConstant.DefaultSPListField.ModifiedField];
ret = modifiedField.ToString(StringConstant.DateFormatddMMyyyyHHmmss);
}
}
}
catch (Exception ex)
{
return(new MessageResult {
Code = -1, Message = ex.Message
});
}
return(new MessageResult {
Code = 0, Message = ret
});
}
private void GetOvertimeTaskList(OverTimeManagementDAL overTimeManagementDAL)
{
List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == OverTimeManagementList.ListUrl).Select(d => d.ListItemID).ToList();
var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserADId, OverTimeManagementList.ApprovedByField, "User", delegatedItemIDs);
var query = $@"<Where>
<And>
<And>
{delegationQuery}
<Geq>
<FieldRef Name='{StringConstant.OverTimeManagementList.CommonDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Geq>
</And>
<IsNull>
<FieldRef Name='{StringConstant.OverTimeManagementList.ApprovalStatusField}' />
</IsNull>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += overTimeManagementDAL.CountByQuery(query);
}
else
{
var overtimeManagementList = overTimeManagementDAL.GetByQuery(query);
if (overtimeManagementList != null && overtimeManagementList.Count > 0)
{
foreach (var overtimeManagement in overtimeManagementList)
{
var filterTask = new FilterTask(overtimeManagement);
filterTask.ApprovalStatusId = ApprovalStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserHelper userHelper = new UserHelper();
var currentEmployee = userHelper.GetCurrentLoginUser();
if (currentEmployee == null || currentEmployee.ID <= 0)
{
ParamRequesterLookupIDHidden.Value = "";
ParamDepartmentIDHidden.Value = "";
}
else
{
ParamRequesterLookupIDHidden.Value = currentEmployee.ID.ToString();
ParamDepartmentIDHidden.Value = Convert.ToString(currentEmployee.Department.LookupId);
}
var url = SPContext.Current.Web.Url;
overTimeManagementDAL = new OverTimeManagementDAL(url);
var guidViews = overTimeManagementDAL.GetViewGuildID().Where(x => x.BaseViewID == BASE_VIEW_ID).FirstOrDefault();
OvertimeRequestList.ViewGuid = guidViews == null ? "" : guidViews.ID.ToString();
}
public void Visit(OverTimeManagementDAL overTimeManagementDAL)
{
// DO NOTHING
}
public void Visit(OverTimeManagementDAL overTimeManagementDAL)
{
GetOvertimeTaskList(overTimeManagementDAL);
}
public OvertimeRepository(string siteURL)
{
_overtimeDAL = new OverTimeManagementDAL(siteURL);
_overtimeDetailDAL = new OverTimeManagementDetailDAL(siteURL);
}
public void Visit(OverTimeManagementDAL overTimeManagementDAL)
{
// Do nothing
}
