Int64 IACBankAccountDepositDataAccess.Add(ACBankAccountDepositEntity aCBankAccountDepositEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(aCBankAccountDepositEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(aCBankAccountDepositEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private ACBankAccountDepositEntity BuildACBankAccountDepositEntity() { ACBankAccountDepositEntity aCBankAccountDepositEntity = CurrentACBankAccountDepositEntity; if (txtDepositDate.Text.Trim().IsNotNullOrEmpty()) { aCBankAccountDepositEntity.DepositDate = MiscUtil.ParseToDateTime(txtDepositDate.Text); } if (ddlPaidFromID.Items.Count > 0) { if (ddlPaidFromID.SelectedValue == "0") { } else { aCBankAccountDepositEntity.PaidFromID = Int64.Parse(ddlPaidFromID.SelectedValue); } } if (ddlReferenceID.Items.Count > 0 && ddlReferenceID.SelectedValue != "0") { aCBankAccountDepositEntity.ReferenceID = Int64.Parse(ddlReferenceID.SelectedValue); } else { aCBankAccountDepositEntity.ReferenceID = null; } if (ddlBankAccountID.Items.Count > 0) { if (ddlBankAccountID.SelectedValue == "0") { } else { aCBankAccountDepositEntity.BankAccountID = Int64.Parse(ddlBankAccountID.SelectedValue); } } //if (ddlProjectID.Items.Count > 0) //{ // if (ddlProjectID.SelectedValue == "0") // { // } // else // { // aCBankAccountDepositEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); // } //} aCBankAccountDepositEntity.BankAccountDepositApprovalStatusID = MasterDataConstants.ACMDBankAccountDepositApprovalStatus.INITIATED; aCBankAccountDepositEntity.Reference = txtReference.Text.Trim(); aCBankAccountDepositEntity.Name = txtName.Text.Trim(); aCBankAccountDepositEntity.Memo = txtMemo.Text.Trim(); aCBankAccountDepositEntity.PreparedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(aCBankAccountDepositEntity); }
private Int64 UpdateTran(ACBankAccountDepositEntity aCBankAccountDepositEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACBankAccountDeposit_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@BankAccountDepositID", DbType.Int64, aCBankAccountDepositEntity.BankAccountDepositID); db.AddInParameter(cmd, "@DepositDate", DbType.DateTime, aCBankAccountDepositEntity.DepositDate); db.AddInParameter(cmd, "@PaidFromID", DbType.Int64, aCBankAccountDepositEntity.PaidFromID); db.AddInParameter(cmd, "@ReferenceID", DbType.Int64, aCBankAccountDepositEntity.ReferenceID); db.AddInParameter(cmd, "@BankAccountID", DbType.Int64, aCBankAccountDepositEntity.BankAccountID); db.AddInParameter(cmd, "@Reference", DbType.String, aCBankAccountDepositEntity.Reference); db.AddInParameter(cmd, "@Name", DbType.String, aCBankAccountDepositEntity.Name); db.AddInParameter(cmd, "@Memo", DbType.String, aCBankAccountDepositEntity.Memo); db.AddInParameter(cmd, "@BankAccountDepositApprovalStatusID", DbType.Int64, aCBankAccountDepositEntity.BankAccountDepositApprovalStatusID); db.AddInParameter(cmd, "@PreparedByEmployeeID", DbType.Int64, aCBankAccountDepositEntity.PreparedByEmployeeID); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode > 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
protected void btnInitiateApprovalProcess_Click(object sender, EventArgs e) { if (ValidationInput()) { ViewState["Action"] = "Approval"; #region Save Initailly if (_bankAccountDepositID <= 0) { SaveACBankAccountDepositEntity(); } #endregion #region Approval Process Boolean apResult = APRobot.CreateApprovalProcessForNewBankDeposit(_bankAccountDepositID, Int64.Parse(ddlAPPanelID.SelectedValue)); if (apResult == true) { MiscUtil.ShowMessage(lblMessage, "Approval Process Submited successfully.", UIConstants.MessageType.GREEN); //String NavigationUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisitionList.aspx", string.Empty).ToString(); //Response.Redirect(NavigationUrl); _bankAccountDepositID = 0; String str = (String)ViewState["Action"].ToString(); if (str == "Approval") { _BankAccountDepositID = 0; _ACBankAccountDepositEntity = new ACBankAccountDepositEntity(); PrepareInitialView(); PrepareInitialViewDepositeItem(); CurrentACBankAccountDepositItemList = new List <ACBankAccountDepositItem_DetailedEntity>(); BindACBankAccountDepositItemList(); BuildTotalValueLabel(); hypReportLink.Visible = false; } } else { MiscUtil.ShowMessage(lblMessage, "Failed to Submit Approval Process.", UIConstants.MessageType.RED); } EnableDisableApprovalProcessCheck(); #endregion } }
private Int64 DeleteTran(ACBankAccountDepositEntity aCBankAccountDepositEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACBankAccountDeposit_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode >= 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
private Int64 Update(ACBankAccountDepositEntity aCBankAccountDepositEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACBankAccountDeposit_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@BankAccountDepositID", DbType.Int64, aCBankAccountDepositEntity.BankAccountDepositID); Database.AddInParameter(cmd, "@DepositDate", DbType.DateTime, aCBankAccountDepositEntity.DepositDate); Database.AddInParameter(cmd, "@PaidFromID", DbType.Int64, aCBankAccountDepositEntity.PaidFromID); Database.AddInParameter(cmd, "@ReferenceID", DbType.Int64, aCBankAccountDepositEntity.ReferenceID); Database.AddInParameter(cmd, "@BankAccountID", DbType.Int64, aCBankAccountDepositEntity.BankAccountID); Database.AddInParameter(cmd, "@Reference", DbType.String, aCBankAccountDepositEntity.Reference); Database.AddInParameter(cmd, "@Name", DbType.String, aCBankAccountDepositEntity.Name); Database.AddInParameter(cmd, "@Memo", DbType.String, aCBankAccountDepositEntity.Memo); Database.AddInParameter(cmd, "@BankAccountDepositApprovalStatusID", DbType.Int64, aCBankAccountDepositEntity.BankAccountDepositApprovalStatusID); Database.AddInParameter(cmd, "@PreparedByEmployeeID", DbType.Int64, aCBankAccountDepositEntity.PreparedByEmployeeID); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("ACBankAccountDepositEntity already exists. Please specify another ACBankAccountDepositEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("ACBankAccountDepositEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("ACBankAccountDepositEntity already exists. Please specify another ACBankAccountDepositEntity."); } } } } return(returnCode); }
private Int64 Delete(ACBankAccountDepositEntity aCBankAccountDepositEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACBankAccountDeposit_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("ACBankAccountDepositEntity already exists. Please specify another ACBankAccountDepositEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("ACBankAccountDepositEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("ACBankAccountDepositEntity already exists. Please specify another ACBankAccountDepositEntity."); } } } } return(returnCode); }
private void PrepareEditView() { ACBankAccountDepositEntity aCBankAccountDepositEntity = CurrentACBankAccountDepositEntity; if (!aCBankAccountDepositEntity.IsNew) { txtDepositDate.Text = aCBankAccountDepositEntity.DepositDate.ToStringDefault(); if (ddlPaidFromID.Items.Count > 0 && aCBankAccountDepositEntity.PaidFromID != null) { ddlPaidFromID.SelectedValue = aCBankAccountDepositEntity.PaidFromID.ToString(); } if (ddlBankAccountID.Items.Count > 0 && aCBankAccountDepositEntity.BankAccountID != null) { ddlBankAccountID.SelectedValue = aCBankAccountDepositEntity.BankAccountID.ToString(); } txtReference.Text = aCBankAccountDepositEntity.Reference.ToString(); txtName.Text = aCBankAccountDepositEntity.Name.ToString(); txtMemo.Text = aCBankAccountDepositEntity.Memo.ToString(); } }
Int64 IACBankAccountDepositFacade.Delete(ACBankAccountDepositEntity aCBankAccountDepositEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateACBankAccountDepositDataAccess().Delete(aCBankAccountDepositEntity, filterExpression, option, reqTran)); }
Int64 IACBankAccountDepositFacade.Add(ACBankAccountDepositEntity aCBankAccountDepositEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateACBankAccountDepositDataAccess().Add(aCBankAccountDepositEntity, option, reqTran)); }
protected void btnAddNew_Click(object sender, EventArgs e) { _BankAccountDepositID = 0; _ACBankAccountDepositEntity = new ACBankAccountDepositEntity(); PrepareInitialView(); }
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); } } }