private String MergeAllString() { String fe = String.Empty; String fe_account = String.Empty; if (ddlReferenceID != null && ddlReferenceID.Items.Count > 0) { String feResourceCategory = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_AccountResourceCategoryID, ddlAccountResourceCategoryID.SelectedValue, SQLMatchType.Equal); String feResource = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_ReferenceID, ddlReferenceID.SelectedValue, SQLMatchType.Equal); fe_account = SqlExpressionBuilder.PrepareFilterExpression(feResourceCategory, SQLJoinType.AND, feResource); IList <ACAccountResourceAccountMapEntity> lst = FCCACAccountResourceAccountMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_account, DatabaseOperationType.LoadWithFilterExpression); if (lst != null && lst.Count > 0) { fe = SqlExpressionBuilder.PrepareFilterExpression(ACBankStatement_CustomEntity.FLD_NAME_AccountID, lst[0].AccountID.ToString(), SQLMatchType.Equal); } } if (!String.IsNullOrWhiteSpace(txtTransactionFromDate.Text.Trim())) { if (!String.IsNullOrWhiteSpace(txtTransactionToDate.Text.Trim())) { String fe1 = "TransactionDateTime between '" + MiscUtil.ParseToDateTime(txtTransactionFromDate.Text) + "' and '" + MiscUtil.ParseToDateTime(txtTransactionToDate.Text) + "'"; fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1); } } return(fe); }
public IList <ACAccountResourceAccountMapEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <ACAccountResourceAccountMapEntity> aCAccountResourceAccountMapEntityList = new List <ACAccountResourceAccountMapEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = ACAccountResourceAccountMapEntity.FLD_NAME_ResourceAccountMapID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; aCAccountResourceAccountMapEntityList = FCCACAccountResourceAccountMap.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (aCAccountResourceAccountMapEntityList != null && aCAccountResourceAccountMapEntityList.Count > 0) { totalRowCount = aCAccountResourceAccountMapEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(aCAccountResourceAccountMapEntityList ?? new List <ACAccountResourceAccountMapEntity>()); }
private void SaveACAccountResourceAccountMapEntity() { if (IsValid) { try { ACAccountResourceAccountMapEntity aCAccountResourceAccountMapEntity = BuildACAccountResourceAccountMapEntity(); Int64 result = -1; if (aCAccountResourceAccountMapEntity.IsNew) { result = FCCACAccountResourceAccountMap.GetFacadeCreate().Add(aCAccountResourceAccountMapEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_ResourceAccountMapID, aCAccountResourceAccountMapEntity.ResourceAccountMapID.ToString(), SQLMatchType.Equal); result = FCCACAccountResourceAccountMap.GetFacadeCreate().Update(aCAccountResourceAccountMapEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _ResourceAccountMapID = 0; _ACAccountResourceAccountMapEntity = new ACAccountResourceAccountMapEntity(); PrepareInitialView(); BindACAccountResourceAccountMapList(); if (aCAccountResourceAccountMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Account Resource Account Map Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Account Resource Account Map Information has been updated successfully.", false); } } else { if (aCAccountResourceAccountMapEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Account Resource Account Map Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Account Resource Account Map Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvACAccountResourceAccountMap_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 ResourceAccountMapID; Int64.TryParse(e.CommandArgument.ToString(), out ResourceAccountMapID); if (ResourceAccountMapID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _ResourceAccountMapID = ResourceAccountMapID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_ResourceAccountMapID, ResourceAccountMapID.ToString(), SQLMatchType.Equal); ACAccountResourceAccountMapEntity aCAccountResourceAccountMapEntity = new ACAccountResourceAccountMapEntity(); result = FCCACAccountResourceAccountMap.GetFacadeCreate().Delete(aCAccountResourceAccountMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _ResourceAccountMapID = 0; _ACAccountResourceAccountMapEntity = new ACAccountResourceAccountMapEntity(); PrepareInitialView(); BindACAccountResourceAccountMapList(); MiscUtil.ShowMessage(lblMessage, "A CAccount Resource Account Map has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete A CAccount Resource Account Map.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <ACAccountResourceAccountMapEntity> GetData() { IList <ACAccountResourceAccountMapEntity> aCAccountResourceAccountMapEntityList = new List <ACAccountResourceAccountMapEntity>(); try { aCAccountResourceAccountMapEntityList = FCCACAccountResourceAccountMap.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (aCAccountResourceAccountMapEntityList != null && aCAccountResourceAccountMapEntityList.Count > 0) { totalRowCount = aCAccountResourceAccountMapEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(aCAccountResourceAccountMapEntityList ?? new List <ACAccountResourceAccountMapEntity>()); }
protected void btnMakePayment_Click(object sender, EventArgs e) { try { IList <ListViewDataItem> list = lvACCPrePayableStatementDetail.Items; if (list != null && list.Count > 0) { Int32 tempDataItemIndex = 0; foreach (ListViewDataItem lvdi in list) { DataKey currentDataKey = lvACCPrePayableStatementDetail.DataKeys[tempDataItemIndex++]; Int64 _postPayableStatementDetailID = (Int64)currentDataKey["PostPayableStatementDetailID"]; _PostPayableStatementDetailID = _postPayableStatementDetailID; } } } catch (Exception ex) { } if (_PostPayableStatementDetailID > 0) { ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity = CurrentACCPostPayableStatementDetailEntity; if (aCCPostPayableStatementDetailEntity != null && aCCPostPayableStatementDetailEntity.PostPayableStatementDetailID > 0) { txtAmount.Text = aCCPostPayableStatementDetailEntity.NetPayableConsideringBillAndSecurity.ToString(); PRMSupplierEntity pRMSupplierEntity = FCCPRMSupplier.GetFacadeCreate().GetByID(aCCPostPayableStatementDetailEntity.FromVendorID); String compositeID = String.Empty; Int64 accountID = 0; if (pRMSupplierEntity != null && pRMSupplierEntity.SupplierID > 0) { Int64 referenceID, resourceCategoryID = 0; referenceID = pRMSupplierEntity.SupplierID; switch (pRMSupplierEntity.SupplierTypeID) { case MasterDataConstants.MDSupplierType.LOCAL: case MasterDataConstants.MDSupplierType.IMPORTER: case MasterDataConstants.MDSupplierType.LOCAL_AND_IMPORTER: resourceCategoryID = MasterDataConstants.ACMDAccountResourceCategory.VENDOR; break; case MasterDataConstants.MDSupplierType.CONTRACTOR: resourceCategoryID = MasterDataConstants.ACMDAccountResourceCategory.CONTRACTOR; break; case MasterDataConstants.MDSupplierType.CONSULTANT: resourceCategoryID = MasterDataConstants.ACMDAccountResourceCategory.CONSULTANT; break; } if (referenceID > 0 && resourceCategoryID > 0) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_AccountResourceCategoryID, resourceCategoryID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_ReferenceID, referenceID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); IList <ACAccountResourceAccountMapEntity> lst = FCCACAccountResourceAccountMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (lst != null && lst.Count > 0) { foreach (ACAccountResourceAccountMapEntity ent in lst) { compositeID += ent.ReferenceID + ","; accountID = ent.AccountID; } compositeID = compositeID.Substring(0, compositeID.Length - 1); } } } MiscUtil.PopulateACAccountByAccountGroupByReference(ddlACCAccountID, false, compositeID); if (ddlACCAccountID != null && ddlACCAccountID.Items.Count > 0) { //ddlACCAccountID.SelectedValue = accountID.ToString(); } } } this.Panel1_ModalPopupExtender.Show(); }