protected void Page_Load(object sender, EventArgs e)
{
var url = SPContext.Current.Web.Url;
changeShiftManagementDal = new ChangeShiftManagementDAL(url);
var guidViews = changeShiftManagementDal.GetViewGuildID().Where(x => x.BaseViewID == BASE_VIEW_ID).FirstOrDefault();
ChangeShiftByDepartmentWebPart.ViewGuid = guidViews.ID.ToString();
CheckCurrentUser(url);
bool isAdminDepartment = UserPermission.IsAdminDepartment;
XElement xmlViewDef = XElement.Parse(ChangeShiftByDepartmentWebPart.XmlDefinition);
string selectedDepId = this.Page.Request.Params.Get("AdminDeptId");
XElement filterElement = BuildViewString(isAdminDepartment, selectedDepId);
XElement whereElement = xmlViewDef.Descendants("Where").FirstOrDefault();
if (whereElement != null)
{
if (whereElement.HasElements)
{
whereElement.RemoveNodes();
}
whereElement.Add(filterElement);
ChangeShiftByDepartmentWebPart.XmlDefinition = xmlViewDef.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
siteUrl = SPContext.Current.Site.Url;
_changeShiftManagementDAL = new ChangeShiftManagementDAL(siteUrl);
int currentUserId = SPContext.Current.Web.CurrentUser.ID;
string itemIdParam = this.Page.Request.Params.Get("itemId");
XElement filterElement = null;
Biz.Models.Delegation delegation = null;
if (!string.IsNullOrEmpty(itemIdParam))
{
delegation = _changeShiftManagementDAL.GetDelegatedTaskInfo(itemIdParam);
}
if (delegation != null)
{
filterElement = BuildViewFilterStringForDelegation(delegation);
}
else
{
filterElement = BuildViewFilterString(currentUserId);
}
InitialViewGUID(filterElement);
}
public EmailService()
{
WebUrl = SPContext.Current.Web.Url;
_emailTemplateDAL = new EmailTemplateDAL(WebUrl);
_employeeDAL = new EmployeeInfoDAL(WebUrl);
_changeShiftManagementDAL = new ChangeShiftManagementDAL(WebUrl);
_notOvertimeMangementDAL = new NotOvertimeManagementDAL(WebUrl);
_shiftTimeDAL = new ShiftTimeDAL(WebUrl);
_sendMailActivity = new SendEmailActivity();
}
protected void Page_Load(object sender, EventArgs e)
{
GetCurrentUser();
var url = SPContext.Current.Web.Url;
changeShiftManagementDal = new ChangeShiftManagementDAL(url);
var guidViews = changeShiftManagementDal.GetViewGuildID().Where(x => x.BaseViewID == baseViewID).FirstOrDefault();
ChangeShiftRequestWebPart.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 GetChangeShiftTaskList(ChangeShiftManagementDAL changeShiftManagementDAL)
{
var query = $@"<Where>
<And>
<Or>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>Approved</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>Rejected</Value>
</Eq>
</Or>
<And>
<Eq>
<FieldRef Name='{StringConstant.ChangeShiftList.DHField}' 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>
</Where>";
if (this.CountOnly)
{
TotalCount += changeShiftManagementDAL.CountByQuery(query);
}
else
{
var changeShiftManagementList = changeShiftManagementDAL.GetByQuery(query);
if (changeShiftManagementList != null)
{
foreach (var changeShiftManagement in changeShiftManagementList)
{
var filterTask = new FilterTask(changeShiftManagement);
filterTask.ApprovalStatusId = changeShiftManagement.ApprovalStatus == "Approved" ? ApprovedStatusId : RejectedStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetChangeShiftTaskList(ChangeShiftManagementDAL changeShiftManagementDAL)
{
List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == ChangeShiftList.ListUrl).Select(d => d.ListItemID).ToList();
var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserADId, ChangeShiftList.DHField, "User", delegatedItemIDs);
var query = $@"<Where>
<And>
<And>
{delegationQuery}
<Or>
<Eq>
<FieldRef Name='{StringConstant.ChangeShiftList.FromDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.ChangeShiftList.FromDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(1).ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</Or>
</And>
<IsNull>
<FieldRef Name='{StringConstant.ChangeShiftList.AprovalStatusField}' />
</IsNull>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += changeShiftManagementDAL.CountByQuery(query);
}
else
{
var changeShiftManagementList = changeShiftManagementDAL.GetByQuery(query);
if (changeShiftManagementList != null)
{
foreach (var changeShiftManagement in changeShiftManagementList)
{
var filterTask = new FilterTask(changeShiftManagement);
filterTask.ApprovalStatusId = ApprovalStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
public override void ItemUpdated(SPItemEventProperties properties)
{
base.ItemUpdated(properties);
try
{
int itemID = Convert.ToInt32(properties.ListItemId);
ChangeShiftManagementDAL notovertimeDAL = new ChangeShiftManagementDAL(properties.WebUrl);
var item = notovertimeDAL.GetByID(itemID);
string url = string.Empty;
if (item != null)
{
SPUser currentUser = properties.Web.CurrentUser;
if (item.ApprovalStatus.Equals("1"))
{
var changeShiftRequestMailService = string.Format("{0}/_vti_bin/Services/Email/EmailService.svc/SendChangeShiftRequestMail/{1}/{2}", properties.WebUrl, itemID, "BOD");
var delegationChangeShiftRequestMailService = string.Format("{0}/_vti_bin/Services/Email/EmailService.svc/SendDelegationChangeShiftRequestMail/{1}/{2}", properties.WebUrl, itemID, "BOD");
CallService(changeShiftRequestMailService);
CallService(delegationChangeShiftRequestMailService);
}
else if (item.ApprovalStatus.Equals("Approved"))
{
//update new shift
string updateShiftUrl = string.Format("{0}/_vti_bin/Services/ShiftManagement/ShiftManagementService.svc/UpdateShiftDetailForWorkflow/{1}/{2}/{3}/{4}",
properties.WebUrl, item.Requester.LookupId, item.FromDate.ToString(StringConstant.DateFormatMMddyyyy), item.ToDate.ToString(StringConstant.DateFormatMMddyyyy), item.ToShift.LookupId);
CallService(updateShiftUrl);
}
}
}
catch (Exception ex)
{
ULSLogging.Log(new SPDiagnosticsCategory("STADA - ChangeShiftEventReceiver - ItemUpdated fn",
TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected,
string.Format(CultureInfo.InvariantCulture, "{0}:{1}", ex.Message, ex.StackTrace));
}
}
public ChangeShiftManagementService()
{
var webUrl = SPContext.Current.Web.Url;
_changeShiftManagementDAL = new ChangeShiftManagementDAL(webUrl);
}
public void Visit(ChangeShiftManagementDAL changeShiftManagementDAL)
{
GetChangeShiftTaskList(changeShiftManagementDAL);
}
public void Visit(ChangeShiftManagementDAL changeShiftManagementDAL)
{
// Do nothing
}
