public IList <OTIssue_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
{
IList <OTIssue_DetailedEntity> oTIssue_DetailedEntityList = new List <OTIssue_DetailedEntity>();
try
{
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = SqlExpressionBuilder.PrepareSortExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueID, SQLSortOrderType.Decending);
}
Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1;
//startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1;
if (pageSize == -1)
{
pageSize = 1000000000;
}
oTIssue_DetailedEntityList = FCCOTIssue_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);
if (oTIssue_DetailedEntityList != null && oTIssue_DetailedEntityList.Count > 0)
{
totalRowCount = oTIssue_DetailedEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(oTIssue_DetailedEntityList ?? new List <OTIssue_DetailedEntity>());
}
private void BuildLabel()
{
String fe = (String)ViewState["SearchString"];
if (fe.IsNotNullOrEmpty())
{
IList <OTIssue_DetailedEntity> lst = FCCOTIssue_Detailed.GetFacadeCreate().GetIL(1000000, 1, String.Empty, fe);
if (lst != null && lst.Count > 0)
{
TimeSpan TotalTimeSpan = new TimeSpan(0, 0, 0);
foreach (OTIssue_DetailedEntity ent in lst)
{
TimeSpan DTLtime;
TimeSpan.TryParse(ent.DTLDuration.ToString(), out DTLtime);
TotalTimeSpan += DTLtime;
}
lblTotalTimeSpan.Text = "Total Duration: " + TotalTimeSpan;
}
else
{
lblTotalTimeSpan.Text = "Total Duration: N/A.";
}
}
}
private void SaveOTIssueEntity()
{
if (IsValid)
{
try
{
OTIssueEntity oTIssueEntity = BuildOTIssueEntity();
Int64 result = -1;
if (oTIssueEntity.IsNew)
{
result = FCCOTIssue.GetFacadeCreate().Add(oTIssueEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(OTIssueEntity.FLD_NAME_IssueID, oTIssueEntity.IssueID.ToString(), SQLMatchType.Equal);
result = FCCOTIssue.GetFacadeCreate().Update(oTIssueEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
if (oTIssueEntity.IsNew)
{
#region Send Notification
String mailSubject = String.Empty;
String mailBody = String.Empty;
String[] mailTo = new String[1];
String fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueID, result.ToString(), SQLMatchType.Equal);
IList <OTIssue_DetailedEntity> lstOTIssueEntity = FCCOTIssue_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe);
if (lstOTIssueEntity != null && lstOTIssueEntity.Count > 0)
{
mailSubject = lstOTIssueEntity[0].Title.ToString() + "-" + lstOTIssueEntity[0].SupervisorFullName;
mailBody = lstOTIssueEntity[0].Description.ToString();
mailBody += "<br/>";
mailBody += "<br/>";
mailBody += "Expected Start Date: " + lstOTIssueEntity[0].ExpectedStartDate.ToString(UIConstants.SHORT_DATE_FORMAT);
mailBody += "<br/>";
mailBody += "Expected End Date: " + lstOTIssueEntity[0].ExpectedEndDate.ToString(UIConstants.SHORT_DATE_FORMAT);
HREmployeeEntity hREmployeeEntitiy = FCCHREmployee.GetFacadeCreate().GetByID(lstOTIssueEntity[0].AssignedToEmployeeID);
if (hREmployeeEntitiy != null && hREmployeeEntitiy.EmployeeID > 0)
{
mailTo[0] = hREmployeeEntitiy.PrimaryEmail;
MiscUtil.SendMail(mailTo, mailSubject, mailBody);
}
}
#endregion
_IssueID = 0;
_OTIssueEntity = new OTIssueEntity();
PrepareInitialView();
MiscUtil.ShowMessage(lblMessage, "Issue Information has been added successfully.", false);
String NavigationUrl = UrlHelper.BuildSecureUrl("~/OT/OTIssueAssignedResource.aspx", string.Empty, UrlConstants.OVERVIEW_ISSUE_ID, result.ToString()).ToString();
Response.Redirect(NavigationUrl);
}
else
{
PrepareInitialView();
PrepareEditView();
MiscUtil.ShowMessage(lblMessage, "Issue Information has been updated successfully.", false);
}
}
else
{
if (oTIssueEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Issue Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Issue Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}