private void PopulateTree()
{
this.Nodes.Clear();
nodeList = FCCBDMDTaskCategory.GetFacadeCreate().GetIL(null, null, String.Empty, String.Empty, DatabaseOperationType.Load);
taskList = FCCBDMDTask.GetFacadeCreate().GetIL(null, null, String.Empty, String.Empty, DatabaseOperationType.Load);
if (ProjectID > 0)
{
String fe_Project_Document = SqlExpressionBuilder.PrepareFilterExpression(BDProjectCollectedDocumentInfoEntity.FLD_NAME_ProjectID, ProjectID.ToString(), SQLMatchType.Equal);
projectDocumentList = FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().GetIL(null, null, String.Empty, fe_Project_Document, DatabaseOperationType.LoadWithFilterExpression);
}
TreeNode rootNode = new TreeNode();
BayTreeNodeValue rootNodeValue = new BayTreeNodeValue();
rootNodeValue.Value = "0";
rootNodeValue.Attributes["NodeType"] = CustomControlConstants.DocumentNodeType.RootNode;
rootNode.Text = RootNodeText;
rootNode.Value = rootNodeValue.GetValueString();
rootNode.SelectAction = TreeNodeSelectAction.Expand;
rootNode.Expanded = true;
LoadCategories(rootNode, null);
this.Nodes.Add(rootNode);
}
public IList <BDProjectCollectedDocumentInfoEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
{
IList <BDProjectCollectedDocumentInfoEntity> bDProjectCollectedDocumentInfoEntityList = new List <BDProjectCollectedDocumentInfoEntity>();
try
{
if (pageSize == -1)
{
pageSize = 1000000000;
}
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = BDProjectCollectedDocumentInfoEntity.FLD_NAME_ProjectCollectedDocumentInfoID + " " + SQLConstants.SORT_ORDER_DESCENDING;
}
startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;
bDProjectCollectedDocumentInfoEntityList = FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);
if (bDProjectCollectedDocumentInfoEntityList != null && bDProjectCollectedDocumentInfoEntityList.Count > 0)
{
totalRowCount = bDProjectCollectedDocumentInfoEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(bDProjectCollectedDocumentInfoEntityList ?? new List <BDProjectCollectedDocumentInfoEntity>());
}
private void SaveBDProjectCollectedDocumentInfoEntity()
{
if (IsValid)
{
try
{
BDProjectCollectedDocumentInfoEntity bDProjectCollectedDocumentInfoEntity = BuildBDProjectCollectedDocumentInfoEntity();
Int64 result = -1;
if (bDProjectCollectedDocumentInfoEntity.IsNew)
{
result = FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().Add(bDProjectCollectedDocumentInfoEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(BDProjectCollectedDocumentInfoEntity.FLD_NAME_ProjectCollectedDocumentInfoID, bDProjectCollectedDocumentInfoEntity.ProjectCollectedDocumentInfoID.ToString(), SQLMatchType.Equal);
result = FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().Update(bDProjectCollectedDocumentInfoEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_ProjectCollectedDocumentID = 0;
_BDProjectCollectedDocumentInfoEntity = new BDProjectCollectedDocumentInfoEntity();
PrepareInitialViewForm();
PrepareEditView();
if (bDProjectCollectedDocumentInfoEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Project Collected Document Info Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Project Collected Document Info Information has been updated successfully.", false);
}
}
else
{
if (bDProjectCollectedDocumentInfoEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Project Collected Document Info Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Project Collected Document Info Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private void UpdateProjectDocument()
{
try
{
newProjectNodes = treeDocument.CheckedNodes;
foreach (TreeNode tn in treeDocument.CheckedNodes)
{
BayTreeNodeValue bayTreeNodeValue = new BayTreeNodeValue();
bayTreeNodeValue.SetValuesFromString(tn.Value);
BDProjectCollectedDocumentInfoEntity ent = new BDProjectCollectedDocumentInfoEntity();
ent.ProjectDocumentID = Int64.Parse(bayTreeNodeValue.Value);
ent.ProjectID = this.OverviewProjectID;
newProjectDocuments.Add(ent);
}
IList <BDProjectCollectedDocumentInfoEntity> deleteList = currentProjectDocuments.Except(newProjectDocuments, new ProjectDocumentComparer()).ToList();
IList <BDProjectCollectedDocumentInfoEntity> addNewList = newProjectDocuments.Except(currentProjectDocuments, new ProjectDocumentComparer()).ToList();
if (deleteList != null && deleteList.Count > 0)
{
foreach (BDProjectCollectedDocumentInfoEntity ent in deleteList)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(BDProjectCollectedDocumentInfoEntity.FLD_NAME_ProjectID, this.OverviewProjectID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(BDProjectCollectedDocumentInfoEntity.FLD_NAME_ProjectDocumentID, ent.ProjectDocumentID.ToString(), SQLMatchType.Equal);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().Delete(ent, fe, DatabaseOperationType.Delete, TransactionRequired.No);
}
}
if (addNewList != null && addNewList.Count > 0)
{
foreach (BDProjectCollectedDocumentInfoEntity ent in addNewList)
{
FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No);
}
}
MiscUtil.ShowMessage(lblMessage, "Project Document Updated Successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true);
}
}
public IList <BDProjectCollectedDocumentInfoEntity> GetData()
{
IList <BDProjectCollectedDocumentInfoEntity> bDProjectCollectedDocumentInfoEntityList = new List <BDProjectCollectedDocumentInfoEntity>();
try
{
bDProjectCollectedDocumentInfoEntityList = FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);
if (bDProjectCollectedDocumentInfoEntityList != null && bDProjectCollectedDocumentInfoEntityList.Count > 0)
{
totalRowCount = bDProjectCollectedDocumentInfoEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(bDProjectCollectedDocumentInfoEntityList ?? new List <BDProjectCollectedDocumentInfoEntity>());
}
private void PrepareEditView()
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(BDProjectCollectedDocumentInfoEntity.FLD_NAME_ProjectID, this.OverviewProjectID.ToString(), SQLMatchType.Equal);
currentProjectDocuments = FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
// Setting check to the documents
if (currentProjectDocuments != null && currentProjectDocuments.Count > 0)
{
foreach (TreeNode tn in treeDocument.Nodes)
{
IsDocumentNode(tn, 1);
}
}
else
{
currentProjectDocuments = new List <BDProjectCollectedDocumentInfoEntity>();
}
currentProjectNodes = treeDocument.CheckedNodes;
}
private void BuildApprovalNavigation()
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(BDProjectCollectedDocumentInfoEntity.FLD_NAME_ProjectID, OverviewProjectID.ToString(), SQLMatchType.Equal);
IList <BDProjectCollectedDocumentInfoEntity> lstBDProjectCollectedDocumentInfo = FCCBDProjectCollectedDocumentInfo.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
String navUrl = String.Empty;
if (lstBDProjectCollectedDocumentInfo != null && lstBDProjectCollectedDocumentInfo.Count > 0)
{
navUrl = UrlHelper.BuildSecureUrl("~/BD/BDProjectCollectedDocumentInfo.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, OverviewProjectID.ToString()).ToString();
}
else
{
navUrl = UrlHelper.BuildSecureUrl("~/BD/BDProjectCollectedDocumentSetup.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, OverviewProjectID.ToString()).ToString();
}
hypApprovalRequired.NavigateUrl = navUrl;
hypApprovalRequired.Target = "_blank";
}
