protected void btnCancel_Click(object sender, EventArgs e) { CurrentACBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity(); txtItemName.Text = String.Empty; hdEmpID.Value = "0"; txtMemoDetail.Text = String.Empty; txtAmount.Text = String.Empty; pnlUpdate.Visible = false; pnlAdd.Visible = true; }
protected void lvACBankAccountDepositItem_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; ACBankAccountDepositItem_DetailedEntity ent = (ACBankAccountDepositItem_DetailedEntity)dataItem.DataItem; HyperLink hypRequisitionLV = (HyperLink)e.Item.FindControl("hypRequisitionLV"); HyperLink hypWorkOrderLV = (HyperLink)e.Item.FindControl("hypWorkOrderLV"); hypRequisitionLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString(); hypRequisitionLV.Target = "_blank"; hypWorkOrderLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString(); hypWorkOrderLV.Target = "_blank"; } }
protected void lvACBankAccountDepositItem_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 BankAccountDepositItemID; Int64.TryParse(e.CommandArgument.ToString(), out BankAccountDepositItemID); if (BankAccountDepositItemID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _BankAccountDepositItemID = BankAccountDepositItemID; PrepareEditViewDepositeItem(); pnlAdd.Visible = false; pnlUpdate.Visible = true; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; ACBankAccountDepositItem_DetailedEntity depositeItemEntity = (from s in CurrentACBankAccountDepositItemList where s.BankAccountDepositItemID == BankAccountDepositItemID select s).FirstOrDefault(); CurrentACBankAccountDepositItemList.Remove(depositeItemEntity); BindACBankAccountDepositItemList(); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
protected void btnUpdate_Click(object sender, EventArgs e) { if (ValidateInputAccounts()) { // Implement Update Code Here. ACBankAccountDepositItem_DetailedEntity cust = (from c in CurrentACBankAccountDepositItemList where c.BankAccountDepositItemID == CurrentACBankAccountDepositItemEntity.BankAccountDepositItemID select c).SingleOrDefault(); CurrentACBankAccountDepositItemList.Remove(cust); ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = cust; if (hdEmpID.Value != "0") { aCBankAccountDepositItemEntity.AccountID = Int64.Parse(hdEmpID.Value); aCBankAccountDepositItemEntity.AccountName = txtItemName.Text.ToString().Trim(); } if (ddlItemID.Items.Count > 0) { if (ddlItemID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ItemID = null; aCBankAccountDepositItemEntity.ItemName = String.Empty; } else { aCBankAccountDepositItemEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue); aCBankAccountDepositItemEntity.ItemName = ddlItemID.SelectedItem.ToString(); } } if (ddlRequisitionID.Items.Count > 0) { if (ddlRequisitionID.SelectedValue == "0") { aCBankAccountDepositItemEntity.RequisitionID = null; aCBankAccountDepositItemEntity.RequisitionNo = String.Empty; } else { aCBankAccountDepositItemEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue); aCBankAccountDepositItemEntity.RequisitionNo = ddlRequisitionID.SelectedItem.ToString(); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { aCBankAccountDepositItemEntity.WorkOrderID = null; aCBankAccountDepositItemEntity.WorkOrderNo = String.Empty; } else { aCBankAccountDepositItemEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); aCBankAccountDepositItemEntity.WorkOrderNo = ddlWorkOrderID.SelectedItem.ToString(); } } if (ddlBillID.Items.Count > 0) { if (ddlBillID.SelectedValue == "0") { aCBankAccountDepositItemEntity.BillID = null; aCBankAccountDepositItemEntity.BillNo = String.Empty; } else { aCBankAccountDepositItemEntity.BillID = Int64.Parse(ddlBillID.SelectedValue); aCBankAccountDepositItemEntity.BillNo = ddlBillID.SelectedItem.ToString(); } } if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ProjectID = null; aCBankAccountDepositItemEntity.ProjectName = String.Empty; } else { aCBankAccountDepositItemEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); aCBankAccountDepositItemEntity.ProjectName = ddlProjectID.SelectedItem.ToString(); } } if (ddlProjectFloorID.Items.Count > 0) { if (ddlProjectFloorID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ProjectFloorID = null; aCBankAccountDepositItemEntity.ProjectFloorName = String.Empty; } else { aCBankAccountDepositItemEntity.ProjectFloorID = Int64.Parse(ddlProjectFloorID.SelectedValue); aCBankAccountDepositItemEntity.ProjectFloorName = ddlProjectFloorID.SelectedItem.ToString(); } } if (ddlProjectFloorUnitID.Items.Count > 0) { if (ddlProjectFloorUnitID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ProjectFloorUnitID = null; aCBankAccountDepositItemEntity.ProjectFloorUnitName = String.Empty; } else { aCBankAccountDepositItemEntity.ProjectFloorUnitID = Int64.Parse(ddlProjectFloorUnitID.SelectedValue); aCBankAccountDepositItemEntity.ProjectFloorUnitName = ddlProjectFloorUnitID.SelectedItem.ToString(); } } if (!txtAmount.Text.Trim().IsNullOrEmpty()) { aCBankAccountDepositItemEntity.Amount = Decimal.Parse(txtAmount.Text.Trim()); } aCBankAccountDepositItemEntity.Memo = txtMemoDetail.Text.Trim(); CurrentACBankAccountDepositItemList.Add(aCBankAccountDepositItemEntity); BindACBankAccountDepositItemList(); pnlAdd.Visible = true; pnlUpdate.Visible = false; ClearAll(); BuildTotalValueLabel(); } }
private void SaveACBankAccountDepositEntity() { if (IsValid) { try { ACBankAccountDepositEntity aCBankAccountDepositEntity = BuildACBankAccountDepositEntity(); Int64 result = -1; if (aCBankAccountDepositEntity.IsNew) { result = FCCACBankAccountDeposit.GetFacadeCreate().Add(aCBankAccountDepositEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountDepositEntity.FLD_NAME_BankAccountDepositID, aCBankAccountDepositEntity.BankAccountDepositID.ToString(), SQLMatchType.Equal); result = FCCACBankAccountDeposit.GetFacadeCreate().Update(aCBankAccountDepositEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { Int64 resut_two = -1; if (!aCBankAccountDepositEntity.IsNew) { CurrentACBankAccountDepositItemList = new List <ACBankAccountDepositItem_DetailedEntity>(); ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity(); IList <ListViewDataItem> listBankDeposit = lvACBankAccountDepositItem.Items; if (listBankDeposit != null && listBankDeposit.Count > 0) { String fe_del = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountDepositItemEntity.FLD_NAME_BankAccountDepositID, result.ToString(), SQLMatchType.Equal); ACBankAccountDepositItemEntity acDopsitItem = new ACBankAccountDepositItemEntity(); FCCACBankAccountDepositItem.GetFacadeCreate().Delete(acDopsitItem, fe_del, DatabaseOperationType.Delete, TransactionRequired.No); foreach (ListViewDataItem lvdi in listBankDeposit) { aCBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity(); Label lblAccountIDLV = (Label)lvdi.FindControl("lblAccountIDLV"); Label lblAccountNameLV = (Label)lvdi.FindControl("lblAccountNameLV"); Label lblAmountLV = (Label)lvdi.FindControl("lblAmountLV"); Label lblMemoLV = (Label)lvdi.FindControl("lblMemoLV"); aCBankAccountDepositItemEntity.BankAccountDepositItemID = CurrentACBankAccountDepositItemList.Count + 1; if (lblAccountIDLV.Text.Trim().IsNotNullOrEmpty()) { aCBankAccountDepositItemEntity.AccountID = Int64.Parse(lblAccountIDLV.Text.Trim()); aCBankAccountDepositItemEntity.AccountName = lblAccountNameLV.Text.ToString().Trim(); } if (!lblAmountLV.Text.Trim().IsNullOrEmpty()) { aCBankAccountDepositItemEntity.Amount = Decimal.Parse(lblAmountLV.Text.Trim()); } aCBankAccountDepositItemEntity.Memo = lblMemoLV.Text.Trim(); #region Update Value ACBankAccountDepositItemEntity acBankAccountDepositItemEntity = new ACBankAccountDepositItemEntity(); acBankAccountDepositItemEntity.AccountID = aCBankAccountDepositItemEntity.AccountID; acBankAccountDepositItemEntity.DimensionID = aCBankAccountDepositItemEntity.DimensionID; acBankAccountDepositItemEntity.Amount = aCBankAccountDepositItemEntity.Amount; acBankAccountDepositItemEntity.Memo = aCBankAccountDepositItemEntity.Memo; acBankAccountDepositItemEntity.ItemID = aCBankAccountDepositItemEntity.ItemID; acBankAccountDepositItemEntity.RequisitionID = aCBankAccountDepositItemEntity.RequisitionID; acBankAccountDepositItemEntity.WorkOrderID = aCBankAccountDepositItemEntity.WorkOrderID; acBankAccountDepositItemEntity.BillID = aCBankAccountDepositItemEntity.BillID; acBankAccountDepositItemEntity.ProjectID = aCBankAccountDepositItemEntity.ProjectID; acBankAccountDepositItemEntity.ProjectFloorID = aCBankAccountDepositItemEntity.ProjectFloorID; acBankAccountDepositItemEntity.ProjectFloorUnitID = aCBankAccountDepositItemEntity.ProjectFloorUnitID; acBankAccountDepositItemEntity.BankAccountDepositID = result; resut_two = FCCACBankAccountDepositItem.GetFacadeCreate().Add(acBankAccountDepositItemEntity, DatabaseOperationType.Add, TransactionRequired.No); #endregion CurrentACBankAccountDepositItemList.Add(aCBankAccountDepositItemEntity); } BindACBankAccountDepositItemList(); BuildTotalValueLabel(); } } if (aCBankAccountDepositEntity.IsNew) { if (CurrentACBankAccountDepositItemList != null && CurrentACBankAccountDepositItemList.Count > 0) { foreach (ACBankAccountDepositItem_DetailedEntity ent in CurrentACBankAccountDepositItemList) { ACBankAccountDepositItemEntity acBankAccountDepositItemEntity = new ACBankAccountDepositItemEntity(); acBankAccountDepositItemEntity.AccountID = ent.AccountID; acBankAccountDepositItemEntity.DimensionID = ent.DimensionID; acBankAccountDepositItemEntity.Amount = ent.Amount; acBankAccountDepositItemEntity.Memo = ent.Memo; acBankAccountDepositItemEntity.ItemID = ent.ItemID; acBankAccountDepositItemEntity.RequisitionID = ent.RequisitionID; acBankAccountDepositItemEntity.WorkOrderID = ent.WorkOrderID; acBankAccountDepositItemEntity.BillID = ent.BillID; acBankAccountDepositItemEntity.ProjectID = ent.ProjectID; acBankAccountDepositItemEntity.ProjectFloorID = ent.ProjectFloorID; acBankAccountDepositItemEntity.ProjectFloorUnitID = ent.ProjectFloorUnitID; acBankAccountDepositItemEntity.BankAccountDepositID = result; resut_two = FCCACBankAccountDepositItem.GetFacadeCreate().Add(acBankAccountDepositItemEntity, DatabaseOperationType.Add, TransactionRequired.No); } } } hypReportLink.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.BANK_ACCOUNT_DEPOSIT_REPORT, UrlConstants.OVERVIEW_BANK_ACCOUNT_DEPOSIT_ID, result.ToString()).ToString(); hypReportLink.Target = "_blank"; hypReportLink.Visible = true; String str = (String)ViewState["Action"].ToString(); if (str == "GenerateReport") { _BankAccountDepositID = result; _bankAccountDepositID = result; PrepareEditView(); } else if (str == "Approval") { _BankAccountDepositID = 0; _bankAccountDepositID = result; _ACBankAccountDepositEntity = new ACBankAccountDepositEntity(); PrepareInitialView(); PrepareInitialViewDepositeItem(); CurrentACBankAccountDepositItemList = new List <ACBankAccountDepositItem_DetailedEntity>(); BindACBankAccountDepositItemList(); BuildTotalValueLabel(); } if (aCBankAccountDepositEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Bank Account Deposit Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Bank Account Deposit Information has been updated successfully.", false); } } else { if (aCBankAccountDepositEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Bank Account Deposit Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Bank Account Deposit Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private void PrepareEditViewDepositeItem() { ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = CurrentACBankAccountDepositItemEntity; if (!aCBankAccountDepositItemEntity.IsNew) { if (aCBankAccountDepositItemEntity.AccountID > 0) { txtItemName.Text = aCBankAccountDepositItemEntity.AccountName.ToString(); hdEmpID.Value = aCBankAccountDepositItemEntity.AccountID.ToString(); } if (ddlItemID.Items.Count > 0 && aCBankAccountDepositItemEntity.ItemID != null) { ddlItemID.SelectedValue = aCBankAccountDepositItemEntity.ItemID.ToString(); } else if (aCBankAccountDepositItemEntity.ItemID == null) { ddlItemID.SelectedValue = "0"; } if (ddlProjectID.Items.Count > 0 && aCBankAccountDepositItemEntity.ProjectID != null) { ddlProjectID.SelectedValue = aCBankAccountDepositItemEntity.ProjectID.ToString(); } else if (aCBankAccountDepositItemEntity.ProjectID == null) { ddlProjectID.SelectedValue = "0"; } BuildProjectWiseDropdownInfo(); if (ddlRequisitionID.Items.Count > 0 && aCBankAccountDepositItemEntity.RequisitionID != null) { ddlRequisitionID.SelectedValue = aCBankAccountDepositItemEntity.RequisitionID.ToString(); } else if (aCBankAccountDepositItemEntity.RequisitionID == null) { ddlRequisitionID.SelectedValue = "0"; } BuildRequisitionWiseInfo(); if (ddlWorkOrderID.Items.Count > 0 && aCBankAccountDepositItemEntity.WorkOrderID != null) { ddlWorkOrderID.SelectedValue = aCBankAccountDepositItemEntity.WorkOrderID.ToString(); } else if (aCBankAccountDepositItemEntity.WorkOrderID == null) { ddlWorkOrderID.SelectedValue = "0"; } BuildWorkorderWiseInfo(); if (ddlBillID.Items.Count > 0 && aCBankAccountDepositItemEntity.BillID != null) { ddlBillID.SelectedValue = aCBankAccountDepositItemEntity.BillID.ToString(); } else if (aCBankAccountDepositItemEntity.BillID == null) { ddlBillID.SelectedValue = "0"; } if (ddlProjectFloorID.Items.Count > 0 && aCBankAccountDepositItemEntity.ProjectFloorID != null) { ddlProjectFloorID.SelectedValue = aCBankAccountDepositItemEntity.ProjectFloorID.ToString(); } else if (aCBankAccountDepositItemEntity.ProjectFloorID == null) { ddlProjectFloorID.SelectedValue = "0"; } BuildFloorWiseInfo(); if (ddlProjectFloorUnitID.Items.Count > 0 && aCBankAccountDepositItemEntity.ProjectFloorUnitID != null) { ddlProjectFloorUnitID.SelectedValue = aCBankAccountDepositItemEntity.ProjectFloorUnitID.ToString(); } else if (aCBankAccountDepositItemEntity.ProjectFloorUnitID == null) { ddlProjectFloorUnitID.SelectedValue = "0"; } txtAmount.Text = aCBankAccountDepositItemEntity.Amount.ToString(); txtMemoDetail.Text = aCBankAccountDepositItemEntity.Memo.ToString(); } }
protected void btnAddItem_Click(object sender, EventArgs e) { if (ValidateInputAccounts()) { ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity(); aCBankAccountDepositItemEntity.BankAccountDepositItemID = CurrentACBankAccountDepositItemList.Count + 1; if (hdEmpID.Value != "0") { aCBankAccountDepositItemEntity.AccountID = Int64.Parse(hdEmpID.Value); aCBankAccountDepositItemEntity.AccountName = txtItemName.Text.ToString().Trim(); } if (ddlItemID.Items.Count > 0) { if (ddlItemID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ItemID = null; } else { aCBankAccountDepositItemEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue); aCBankAccountDepositItemEntity.ItemName = ddlItemID.SelectedItem.ToString(); } } if (ddlRequisitionID.Items.Count > 0) { if (ddlRequisitionID.SelectedValue == "0") { aCBankAccountDepositItemEntity.RequisitionID = null; } else { aCBankAccountDepositItemEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue); aCBankAccountDepositItemEntity.RequisitionNo = ddlRequisitionID.SelectedItem.ToString(); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { aCBankAccountDepositItemEntity.WorkOrderID = null; } else { aCBankAccountDepositItemEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); aCBankAccountDepositItemEntity.WorkOrderNo = ddlWorkOrderID.SelectedItem.ToString(); } } if (ddlBillID.Items.Count > 0) { if (ddlBillID.SelectedValue == "0") { aCBankAccountDepositItemEntity.BillID = null; } else { aCBankAccountDepositItemEntity.BillID = Int64.Parse(ddlBillID.SelectedValue); aCBankAccountDepositItemEntity.BillNo = ddlBillID.SelectedItem.ToString(); } } if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ProjectID = null; } else { aCBankAccountDepositItemEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); aCBankAccountDepositItemEntity.ProjectName = ddlProjectID.SelectedItem.ToString(); } } if (ddlProjectFloorID.Items.Count > 0) { if (ddlProjectFloorID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ProjectFloorID = null; } else { aCBankAccountDepositItemEntity.ProjectFloorID = Int64.Parse(ddlProjectFloorID.SelectedValue); aCBankAccountDepositItemEntity.ProjectFloorName = ddlProjectFloorID.SelectedItem.ToString(); } } if (ddlProjectFloorUnitID.Items.Count > 0) { if (ddlProjectFloorUnitID.SelectedValue == "0") { aCBankAccountDepositItemEntity.ProjectFloorUnitID = null; } else { aCBankAccountDepositItemEntity.ProjectFloorUnitID = Int64.Parse(ddlProjectFloorUnitID.SelectedValue); aCBankAccountDepositItemEntity.ProjectFloorUnitName = ddlProjectFloorUnitID.SelectedItem.ToString(); } } if (!txtAmount.Text.Trim().IsNullOrEmpty()) { aCBankAccountDepositItemEntity.Amount = Decimal.Parse(txtAmount.Text.Trim()); } aCBankAccountDepositItemEntity.Memo = txtMemoDetail.Text.Trim(); CurrentACBankAccountDepositItemList.Add(aCBankAccountDepositItemEntity); BindACBankAccountDepositItemList(); ClearAll(); BuildTotalValueLabel(); } }