public IList <BDProjectAssignedPersonEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
{
IList <BDProjectAssignedPersonEntity> bDProjectAssignedPersonEntityList = new List <BDProjectAssignedPersonEntity>();
try
{
if (pageSize == -1)
{
pageSize = 1000000000;
}
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = BDProjectAssignedPersonEntity.FLD_NAME_ProjectAssignedPersonID + " " + SQLConstants.SORT_ORDER_DESCENDING;
}
startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;
bDProjectAssignedPersonEntityList = FCCBDProjectAssignedPerson.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);
if (bDProjectAssignedPersonEntityList != null && bDProjectAssignedPersonEntityList.Count > 0)
{
totalRowCount = bDProjectAssignedPersonEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(bDProjectAssignedPersonEntityList ?? new List <BDProjectAssignedPersonEntity>());
}
private void SaveBDProjectAssignedPersonEntity()
{
if (IsValid)
{
try
{
BDProjectAssignedPersonEntity bDProjectAssignedPersonEntity = BuildBDProjectAssignedPersonEntity();
Int64 result = -1;
if (bDProjectAssignedPersonEntity.IsNew)
{
result = FCCBDProjectAssignedPerson.GetFacadeCreate().Add(bDProjectAssignedPersonEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(BDProjectAssignedPersonEntity.FLD_NAME_ProjectAssignedPersonID, bDProjectAssignedPersonEntity.ProjectAssignedPersonID.ToString(), SQLMatchType.Equal);
result = FCCBDProjectAssignedPerson.GetFacadeCreate().Update(bDProjectAssignedPersonEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_ProjectAssignedPersonID = 0;
_BDProjectAssignedPersonEntity = new BDProjectAssignedPersonEntity();
PrepareInitialView();
BindBDProjectAssignedPersonList();
if (bDProjectAssignedPersonEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Project Assigned Person Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Project Assigned Person Information has been updated successfully.", false);
}
}
else
{
if (bDProjectAssignedPersonEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Project Assigned Person Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Project Assigned Person Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void lvBDProjectAssignedPerson_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 ProjectAssignedPersonID;
Int64.TryParse(e.CommandArgument.ToString(), out ProjectAssignedPersonID);
if (ProjectAssignedPersonID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_ProjectAssignedPersonID = ProjectAssignedPersonID;
PrepareEditView();
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(BDProjectAssignedPersonEntity.FLD_NAME_ProjectAssignedPersonID, ProjectAssignedPersonID.ToString(), SQLMatchType.Equal);
BDProjectAssignedPersonEntity bDProjectAssignedPersonEntity = new BDProjectAssignedPersonEntity();
result = FCCBDProjectAssignedPerson.GetFacadeCreate().Delete(bDProjectAssignedPersonEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_ProjectAssignedPersonID = 0;
_BDProjectAssignedPersonEntity = new BDProjectAssignedPersonEntity();
PrepareInitialView();
BindBDProjectAssignedPersonList();
MiscUtil.ShowMessage(lblMessage, "Project Assigned Person has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Project Assigned Person.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
public IList <BDProjectAssignedPersonEntity> GetData()
{
IList <BDProjectAssignedPersonEntity> bDProjectAssignedPersonEntityList = new List <BDProjectAssignedPersonEntity>();
try
{
bDProjectAssignedPersonEntityList = FCCBDProjectAssignedPerson.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);
if (bDProjectAssignedPersonEntityList != null && bDProjectAssignedPersonEntityList.Count > 0)
{
totalRowCount = bDProjectAssignedPersonEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(bDProjectAssignedPersonEntityList ?? new List <BDProjectAssignedPersonEntity>());
}
protected void odsREQRequisition_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = String.Empty;
if (this.OverviewProjectID > 0)
{
fe = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_ProjectID, this.OverviewProjectID.ToString(), SQLMatchType.Equal);
}
else
{
fe = "REQRequisition." + REQRequisitionEntity.FLD_NAME_ProjectID + "<> " + "4545454545";
}
if (PageListType == "RCSRequisitionList")
{
String fe1 = "REQRequisition.IsRCS = 1";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1);
}
if (chbxFilter.Checked)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition.RequisitionNo", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("MDRequisitionStatus.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3);
if (txtSearchText.Text.Trim().IsNotNullOrEmpty())
{
// Activity Log
// base.LogActivity("Searching Requisition With " + txtSearchText.Text.Trim().ToString(), true);
}
}
if (chbxShowLogedinApprovedRequisition.Checked)
{
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
String compositeRequisitionID = String.Empty;
if (employeeID > 0)
{
IList <APApprovedRequisitionForWOByPanelMember_CustomEntity> lst = FCCAPApprovedRequisitionForWOByPanelMember_Custom.GetFacadeCreate().GetIL(employeeID);
if (lst != null && lst.Count > 0)
{
foreach (APApprovedRequisitionForWOByPanelMember_CustomEntity ent in lst)
{
compositeRequisitionID += ent.ReferenceID + ",";
}
compositeRequisitionID = compositeRequisitionID.Substring(0, compositeRequisitionID.Length - 1);
}
}
String fe_panelWO = "REQRequisition.RequisitionID in(" + compositeRequisitionID + ")";
String fe_approved = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_RequisitionStatusID, MasterDataConstants.RequisitionStatus.APPROVED.ToString(), SQLMatchType.Equal);
String fe_all = SqlExpressionBuilder.PrepareFilterExpression(fe_approved, SQLJoinType.AND, fe_panelWO);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe_all);
}
if (this.Page.User.Identity.IsAuthenticated == true)
{
if (Roles.IsUserInRole(this.Page.User.Identity.Name, "SiteUser") == true)
{
String fe_assignedPerson1 = SqlExpressionBuilder.PrepareFilterExpression(BDProjectAssignedPersonEntity.FLD_NAME_EmployeeID, MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal);
String fe_assignedPerson2 = SqlExpressionBuilder.PrepareFilterExpression(BDProjectAssignedPersonEntity.FLD_NAME_ProjectAssignedPersonTeamRoleID, MasterDataConstants.ProjectAssignedTeamRole.SITE_INCHARGE.ToString(), SQLMatchType.Equal);
String fe_assignedPerson = SqlExpressionBuilder.PrepareFilterExpression(fe_assignedPerson1, SQLJoinType.AND, fe_assignedPerson2);
IList <BDProjectAssignedPersonEntity> lst = FCCBDProjectAssignedPerson.GetFacadeCreate().GetIL(null, null, String.Empty, fe_assignedPerson, DatabaseOperationType.LoadWithFilterExpression);
if (lst != null && lst.Count > 0)
{
String compositeProjectID = String.Empty;
foreach (BDProjectAssignedPersonEntity ent in lst)
{
compositeProjectID += ent.ProjectID + ",";
}
compositeProjectID = compositeProjectID.Substring(0, compositeProjectID.Length - 1);
String fe1 = "REQRequisition.ProjectID In(" + compositeProjectID + ")";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1);
}
}
else if (Roles.IsUserInRole(this.Page.User.Identity.Name, "Store Keeper") == true)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_PreparedByMemberID, this.CurrentMember.MemberID.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1);
}
}
e.InputParameters["filterExpression"] = fe;
}
