protected void btnAddItem_Click(object sender, EventArgs e) { if (ValidateInput()) { ACBankAccountPaymentItemEntity acBankAccountPaymentItemEntity = new ACBankAccountPaymentItemEntity(); if (hdEmpID.Value != "0") { acBankAccountPaymentItemEntity.AccountID = Int64.Parse(hdEmpID.Value); } if (!txtAmount.Text.Trim().IsNullOrEmpty()) { acBankAccountPaymentItemEntity.Amount = Decimal.Parse(txtAmount.Text.Trim()); } acBankAccountPaymentItemEntity.Memo = txtMemoDetail.Text.Trim(); acBankAccountPaymentItemEntity.BankAccountPaymentID = OverviewBankAccountPaymentID; FCCACBankAccountPaymentItem.GetFacadeCreate().Add(acBankAccountPaymentItemEntity, DatabaseOperationType.Add, TransactionRequired.No); BindACBankAccountPaymentItemList(); ClearAll(); BuildTotalValueLabel(); } }
public IList <ACBankAccountPaymentItemEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <ACBankAccountPaymentItemEntity> aCBankAccountPaymentItemEntityList = new List <ACBankAccountPaymentItemEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = ACBankAccountPaymentItemEntity.FLD_NAME_BankAccountPaymentItemID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; aCBankAccountPaymentItemEntityList = FCCACBankAccountPaymentItem.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (aCBankAccountPaymentItemEntityList != null && aCBankAccountPaymentItemEntityList.Count > 0) { totalRowCount = aCBankAccountPaymentItemEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(aCBankAccountPaymentItemEntityList ?? new List <ACBankAccountPaymentItemEntity>()); }
protected void lvACBankAccountPaymentItem_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 BankAccountPaymentitemID; Int64.TryParse(e.CommandArgument.ToString(), out BankAccountPaymentitemID); if (BankAccountPaymentitemID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _BankAccountPaymentItemID = BankAccountPaymentitemID; PrepareEditViewPaymentItem(); pnlAdd.Visible = false; pnlUpdate.Visible = true; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; ACBankAccountPaymentItemEntity aCBankAccountPaymentItemEntity = new ACBankAccountPaymentItemEntity(); String fe = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountPaymentItemEntity.FLD_NAME_BankAccountPaymentItemID, BankAccountPaymentitemID.ToString(), SQLMatchType.Equal); result = FCCACBankAccountPaymentItem.GetFacadeCreate().Delete(aCBankAccountPaymentItemEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { BindACBankAccountPaymentItemList(); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <ACBankAccountPaymentItemEntity> GetData() { IList <ACBankAccountPaymentItemEntity> aCBankAccountPaymentItemEntityList = new List <ACBankAccountPaymentItemEntity>(); try { aCBankAccountPaymentItemEntityList = FCCACBankAccountPaymentItem.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (aCBankAccountPaymentItemEntityList != null && aCBankAccountPaymentItemEntityList.Count > 0) { totalRowCount = aCBankAccountPaymentItemEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(aCBankAccountPaymentItemEntityList ?? new List <ACBankAccountPaymentItemEntity>()); }
protected void btnUpdate_Click(object sender, EventArgs e) { if (ValidateInput()) { // Implement Update Code Here. ACBankAccountPaymentItemEntity aCBankAccountPaymentItemEntity = FCCACBankAccountPaymentItem.GetFacadeCreate().GetByID(_BankAccountPaymentItemID); if (hdEmpID.Value != "0") { aCBankAccountPaymentItemEntity.AccountID = Int64.Parse(hdEmpID.Value); } if (ddlItemID.Items.Count > 0) { if (ddlItemID.SelectedValue == "0") { aCBankAccountPaymentItemEntity.ItemID = null; } else { aCBankAccountPaymentItemEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue); } } if (ddlRequisitionID.Items.Count > 0) { if (ddlRequisitionID.SelectedValue == "0") { aCBankAccountPaymentItemEntity.RequisitionID = null; } else { aCBankAccountPaymentItemEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { aCBankAccountPaymentItemEntity.WorkOrderID = null; } else { aCBankAccountPaymentItemEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); } } if (ddlBillID.Items.Count > 0) { if (ddlBillID.SelectedValue == "0") { aCBankAccountPaymentItemEntity.BillID = null; } else { aCBankAccountPaymentItemEntity.BillID = Int64.Parse(ddlBillID.SelectedValue); } } if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { aCBankAccountPaymentItemEntity.ProjectID = null; } else { aCBankAccountPaymentItemEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } if (ddlProjectFloorID.Items.Count > 0) { if (ddlProjectFloorID.SelectedValue == "0") { aCBankAccountPaymentItemEntity.ProjectFloorID = null; } else { aCBankAccountPaymentItemEntity.ProjectFloorID = Int64.Parse(ddlProjectFloorID.SelectedValue); } } if (ddlProjectFloorUnitID.Items.Count > 0) { if (ddlProjectFloorUnitID.SelectedValue == "0") { aCBankAccountPaymentItemEntity.ProjectFloorUnitID = null; } else { aCBankAccountPaymentItemEntity.ProjectFloorUnitID = Int64.Parse(ddlProjectFloorUnitID.SelectedValue); } } if (!txtAmount.Text.Trim().IsNullOrEmpty()) { aCBankAccountPaymentItemEntity.Amount = Decimal.Parse(txtAmount.Text.Trim()); } aCBankAccountPaymentItemEntity.Memo = txtMemoDetail.Text.Trim(); aCBankAccountPaymentItemEntity.BankAccountPaymentID = OverviewBankAccountPaymentID; #region Update Bank Account Payment Item String fe = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountPaymentItemEntity.FLD_NAME_BankAccountPaymentItemID, _BankAccountPaymentItemID.ToString(), SQLMatchType.Equal); FCCACBankAccountPaymentItem.GetFacadeCreate().Update(aCBankAccountPaymentItemEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); #endregion BindACBankAccountPaymentItemList(); ClearAll(); pnlAdd.Visible = true; pnlUpdate.Visible = false; BuildTotalValueLabel(); } }