Int64 IACCPostPayableStatementDetailDataAccess.Delete(ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Delete(aCCPostPayableStatementDetailEntity, filterExpression, option); break; } case TransactionRequired.Yes: { retValues = DeleteTran(aCCPostPayableStatementDetailEntity, filterExpression, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void SaveACCPostPayableStatementDetailEntity() { if (IsValid) { try { ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity = BuildACCPostPayableStatementDetailEntity();//new ACCPostPayableStatementDetailEntity();//BuildACCPostPayableStatementDetailEntity(); Int64 result = -1; if (aCCPostPayableStatementDetailEntity.IsNew) { result = FCCACCPostPayableStatementDetail.GetFacadeCreate().Add(aCCPostPayableStatementDetailEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementDetailEntity.FLD_NAME_PostPayableStatementDetailID, aCCPostPayableStatementDetailEntity.PostPayableStatementDetailID.ToString(), SQLMatchType.Equal); result = FCCACCPostPayableStatementDetail.GetFacadeCreate().Update(aCCPostPayableStatementDetailEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _PostPayableStatementDetailID = 0; _ACCPostPayableStatementDetailEntity = new ACCPostPayableStatementDetailEntity(); PrepareInitialView(); BindACCPostPayableStatementDetailList(); if (aCCPostPayableStatementDetailEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Payable Statement Detail Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Payable Statement Detail Information has been updated successfully.", false); } } else { if (aCCPostPayableStatementDetailEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Payable Statement Detail Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Payable Statement Detail Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private Int64 DeleteTran(ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACCPostPayableStatementDetail_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); }
protected void lvACCPostPayableStatementDetail_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 PostPayableStatementDetailID; Int64.TryParse(e.CommandArgument.ToString(), out PostPayableStatementDetailID); if (PostPayableStatementDetailID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _PostPayableStatementDetailID = PostPayableStatementDetailID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementDetailEntity.FLD_NAME_PostPayableStatementDetailID, PostPayableStatementDetailID.ToString(), SQLMatchType.Equal); ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity = new ACCPostPayableStatementDetailEntity(); result = FCCACCPostPayableStatementDetail.GetFacadeCreate().Delete(aCCPostPayableStatementDetailEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _PostPayableStatementDetailID = 0; _ACCPostPayableStatementDetailEntity = new ACCPostPayableStatementDetailEntity(); PrepareInitialView(); BindACCPostPayableStatementDetailList(); MiscUtil.ShowMessage(lblMessage, "A CCPost Payable Statement Detail has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete A CCPost Payable Statement Detail.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 Delete(ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACCPostPayableStatementDetail_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("ACCPostPayableStatementDetailEntity already exists. Please specify another ACCPostPayableStatementDetailEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("ACCPostPayableStatementDetailEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("ACCPostPayableStatementDetailEntity already exists. Please specify another ACCPostPayableStatementDetailEntity."); } } } } return(returnCode); }
Int64 IACCPostPayableStatementDetailFacade.Delete(ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateACCPostPayableStatementDetailDataAccess().Delete(aCCPostPayableStatementDetailEntity, filterExpression, option, reqTran)); }
Int64 IACCPostPayableStatementDetailFacade.Add(ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateACCPostPayableStatementDetailDataAccess().Add(aCCPostPayableStatementDetailEntity, option, reqTran)); }
protected void lvACCPrePayableStatementDetail_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; ACCPostPayableStatementDetailEntity ent = (ACCPostPayableStatementDetailEntity)dataItem.DataItem; Label lblProjectNameLV = (Label)e.Item.FindControl("lblProjectNameLV"); Label lblVendorCategoryNameLV = (Label)e.Item.FindControl("lblVendorCategoryNameLV"); Label lblVendorCategoryIDLV = (Label)e.Item.FindControl("lblVendorCategoryIDLV"); Label lblVendorIDLV = (Label)e.Item.FindControl("lblVendorIDLV"); Label lblVendorNameLV = (Label)e.Item.FindControl("lblVendorNameLV"); Label lblProjectIDLV = (Label)e.Item.FindControl("lblProjectIDLV"); DropDownList ddlACCPayableApprovalStatusIDLV = (DropDownList)e.Item.FindControl("ddlACCPayableApprovalStatusIDLV"); DropDownList ddlACCPayablePaymentStatusIDLV = (DropDownList)e.Item.FindControl("ddlACCPayablePaymentStatusIDLV"); DropDownList ddlPayableClassificationIDLV = (DropDownList)e.Item.FindControl("ddlPayableClassificationIDLV"); DropDownList ddlAccountPaybleStatementDetailCategoryIDLV = (DropDownList)e.Item.FindControl("ddlAccountPaybleStatementDetailCategoryIDLV"); CheckBox chkPartyReconcileLV = (CheckBox)e.Item.FindControl("chkPartyReconcileLV"); if (lblProjectIDLV != null) { BDProjectEntity _bDProjectEntity = FCCBDProject.GetFacadeCreate().GetByID(Int64.Parse(lblProjectIDLV.Text)); if (_bDProjectEntity != null) { lblProjectNameLV.Text = _bDProjectEntity.ProjectName + " (" + _bDProjectEntity.ProjectCode + ")"; } } MiscUtil.PopulateMDACCPayablePaymentStatus(ddlACCPayablePaymentStatusIDLV, false); MiscUtil.PopulateMDACCPayableApprovalStatus(ddlACCPayableApprovalStatusIDLV, false); MiscUtil.PopulateMDPayableClassification(ddlPayableClassificationIDLV, false); MiscUtil.PopulateMDAccountPaybleStatementDetailCategory(ddlAccountPaybleStatementDetailCategoryIDLV, false); _PostPayableStatementDetailID = ent.PostPayableStatementDetailID; if (ent.PartyReconcile == true) { chkPartyReconcileLV.Checked = true; } else { chkPartyReconcileLV.Checked = false; } Int64 vendorID; Int64.TryParse(lblVendorIDLV.Text.ToString(), out vendorID); switch (lblVendorCategoryIDLV.Text) { case MasterDataConstants.CM_Bill_VendorCategory.CONSULTANT: CMConsultantEntity _cmConsultantEntity = FCCCMConsultant.GetFacadeCreate().GetByID(vendorID); lblVendorCategoryNameLV.Text = "CONSULTANT"; lblVendorNameLV.Text = _cmConsultantEntity.Name; break; case MasterDataConstants.CM_Bill_VendorCategory.CONTRACTOR: CMContractorEntity _cMContractorEntity = FCCCMContractor.GetFacadeCreate().GetByID(vendorID); lblVendorCategoryNameLV.Text = "CONTRACTOR"; lblVendorNameLV.Text = _cMContractorEntity.Name; break; case MasterDataConstants.CM_Bill_VendorCategory.VENDOR: PRMSupplierEntity _pRMSupplierEntity = FCCPRMSupplier.GetFacadeCreate().GetByID(vendorID); lblVendorCategoryNameLV.Text = "VENDOR"; lblVendorNameLV.Text = _pRMSupplierEntity.SupplierName; break; } if (ddlACCPayableApprovalStatusIDLV != null && ddlACCPayableApprovalStatusIDLV.Items.Count > 0) { ddlACCPayableApprovalStatusIDLV.SelectedValue = ent.ACCPayableApprovalStatusID.ToString(); } if (ddlACCPayablePaymentStatusIDLV != null && ddlACCPayablePaymentStatusIDLV.Items.Count > 0) { ddlACCPayablePaymentStatusIDLV.SelectedValue = ent.ACCPayablePaymentStatusID.ToString(); } if (ddlPayableClassificationIDLV != null && ddlPayableClassificationIDLV.Items.Count > 0) { ddlPayableClassificationIDLV.SelectedValue = ent.PayableClassificationID.ToString(); } if (ddlAccountPaybleStatementDetailCategoryIDLV != null && ddlAccountPaybleStatementDetailCategoryIDLV.Items.Count > 0) { ddlAccountPaybleStatementDetailCategoryIDLV.SelectedValue = ent.AccountPaybleStatementDetailCategoryID.ToString(); } ddlACCPayableApprovalStatusIDLV.Enabled = false; } }
private void UpdatePayableStatementDetail() { 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"]; // Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0; ACCPostPayableStatementDetailEntity aCCPrePayableStatementDetailEntity = FCCACCPostPayableStatementDetail.GetFacadeCreate().GetByID(_postPayableStatementDetailID); DropDownList ddlACCPayableApprovalStatusIDLV = (DropDownList)lvdi.FindControl("ddlACCPayableApprovalStatusIDLV"); DropDownList ddlACCPayablePaymentStatusIDLV = (DropDownList)lvdi.FindControl("ddlACCPayablePaymentStatusIDLV"); DropDownList ddlAccountPaybleStatementDetailCategoryIDLV = (DropDownList)lvdi.FindControl("ddlAccountPaybleStatementDetailCategoryIDLV"); DropDownList ddlPayableClassificationIDLV = (DropDownList)lvdi.FindControl("ddlPayableClassificationIDLV"); CheckBox chkPartyReconcileLV = (CheckBox)lvdi.FindControl("chkPartyReconcileLV"); //L lblWorkOrderNoLV = (TextBox)lvdi.FindControl("lblWorkOrderNoLV"); //TextBox txtWorkOrderAmountLV = (TextBox)lvdi.FindControl("txtWorkOrderAmountLV"); //TextBox txtWorkOrderDateLV = (TextBox)lvdi.FindControl("txtWorkOrderDateLV"); //TextBox txtPaidAmountLV = (TextBox)lvdi.FindControl("txtPaidAmountLV"); //TextBox txtSecurityMoneyLV = (TextBox)lvdi.FindControl("txtSecurityMoneyLV"); TextBox txtPayableAgainstWorkOrderLV = (TextBox)lvdi.FindControl("txtPayableAgainstWorkOrderLV"); //TextBox txtTDSAmountLV = (TextBox)lvdi.FindControl("txtTDSAmountLV"); //TextBox txtApprovedBillAmountLV = (TextBox)lvdi.FindControl("txtApprovedBillAmountLV"); TextBox txtNetPayableConsideringBillAndSecurityLV = (TextBox)lvdi.FindControl("txtNetPayableConsideringBillAndSecurityLV"); //TextBox txtRequisitionNoLV = (TextBox)lvdi.FindControl("txtRequisitionNoLV"); //TextBox txtRequisitionDateLV = (TextBox)lvdi.FindControl("txtRequisitionDateLV"); // TextBox txtBillNoLV = (TextBox)lvdi.FindControl("txtBillNoLV"); //TextBox txtBillDateLV = (TextBox)lvdi.FindControl("txtBillDateLV"); //TextBox txtRefLV = (TextBox)lvdi.FindControl("txtRefLV"); //TextBox txtCreateDateLV = (TextBox)lvdi.FindControl("txtCreateDateLV"); TextBox txtDueDateLV = (TextBox)lvdi.FindControl("txtDueDateLV"); TextBox txtPlannedDateLV = (TextBox)lvdi.FindControl("txtPlannedDateLV"); TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV"); //TextBox txtAdditionalRemarksLV = (TextBox)lvdi.FindControl("txtAdditionalRemarksLV"); //if (!lblWorkOrderNoLV.Text.Trim().IsNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.WorkOrderNo = lblWorkOrderNoLV.Text.Trim(); //} //else //{ // aCCPrePayableStatementDetailEntity.WorkOrderNo = null; //} //Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount); //Decimal netPayableConsideringBillSecurity = (payableAgainstWO - paidAmount - securityMoney - tDSAmount); //if (!txtWorkOrderAmountLV.Text.Trim().IsNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.WorkOrderAmount = Decimal.Parse(txtWorkOrderAmountLV.Text.Trim()); //} //else //{ // aCCPrePayableStatementDetailEntity.WorkOrderAmount = null; //} //if (txtWorkOrderDateLV.Text.Trim().IsNotNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.WorkOrderDate = MiscUtil.ParseToDateTime(txtWorkOrderDateLV.Text); //} //else //{ // aCCPrePayableStatementDetailEntity.WorkOrderDate = null; //} //if (!txtPaidAmountLV.Text.Trim().IsNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.PaidAmount = Decimal.Parse(txtPaidAmountLV.Text.Trim()); //} //else //{ // aCCPrePayableStatementDetailEntity.PaidAmount = null; //} //if (!txtSecurityMoneyLV.Text.Trim().IsNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.SecurityMoney = Decimal.Parse(txtSecurityMoneyLV.Text.Trim()); //} //else //{ // aCCPrePayableStatementDetailEntity.SecurityMoney = null; //} //if (!txtTDSAmountLV.Text.Trim().IsNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.TDSAmount = Decimal.Parse(txtTDSAmountLV.Text.Trim()); //} //else //{ // aCCPrePayableStatementDetailEntity.TDSAmount = null; //} if (!txtPayableAgainstWorkOrderLV.Text.Trim().IsNullOrEmpty()) { aCCPrePayableStatementDetailEntity.PayableAgainstWorkOrder = Decimal.Parse(txtPayableAgainstWorkOrderLV.Text.Trim()); } else { aCCPrePayableStatementDetailEntity.PayableAgainstWorkOrder = null; } //if (!txtApprovedBillAmountLV.Text.Trim().IsNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.ApprovedBillAmount = Decimal.Parse(txtApprovedBillAmountLV.Text.Trim()); //} //else //{ // aCCPrePayableStatementDetailEntity.ApprovedBillAmount = null; //} if (!txtNetPayableConsideringBillAndSecurityLV.Text.Trim().IsNullOrEmpty()) { aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = Decimal.Parse(txtNetPayableConsideringBillAndSecurityLV.Text.Trim()); } else { aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = null; } aCCPrePayableStatementDetailEntity.PartyReconcile = chkPartyReconcileLV.Checked; //aCCPrePayableStatementDetailEntity.RequisitionNo = txtRequisitionNoLV.Text.Trim(); //if (txtRequisitionDateLV.Text.Trim().IsNotNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.RequisitionDate = MiscUtil.ParseToDateTime(txtRequisitionDateLV.Text); //} //else //{ // aCCPrePayableStatementDetailEntity.RequisitionDate = null; //} //aCCPrePayableStatementDetailEntity.BillNo = txtBillNoLV.Text.Trim(); //if (txtBillDateLV.Text.Trim().IsNotNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.BillDate = MiscUtil.ParseToDateTime(txtBillDateLV.Text); //} //else //{ // aCCPrePayableStatementDetailEntity.BillDate = null; //} aCCPrePayableStatementDetailEntity.Remarks = txtRemarksLV.Text.Trim(); // aCCPrePayableStatementDetailEntity.Ref = txtRemarksLV.Text.Trim(); //if (txtCreateDateLV.Text.Trim().IsNotNullOrEmpty()) //{ // aCCPrePayableStatementDetailEntity.CreateDate = MiscUtil.ParseToDateTime(txtCreateDateLV.Text); //} aCCPrePayableStatementDetailEntity.CreateDate = System.DateTime.Now; if (txtDueDateLV.Text.Trim().IsNotNullOrEmpty()) { aCCPrePayableStatementDetailEntity.DueDate = MiscUtil.ParseToDateTime(txtDueDateLV.Text); } if (txtPlannedDateLV.Text.Trim().IsNotNullOrEmpty()) { aCCPrePayableStatementDetailEntity.PlannedDate = MiscUtil.ParseToDateTime(txtPlannedDateLV.Text); } else { aCCPrePayableStatementDetailEntity.PlannedDate = null; } // aCCPrePayableStatementDetailEntity.AdditionalRemarks = txtAdditionalRemarksLV.Text.Trim(); if (ddlACCPayablePaymentStatusIDLV.Items.Count > 0) { if (ddlACCPayablePaymentStatusIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.ACCPayablePaymentStatusID = Int64.Parse(ddlACCPayablePaymentStatusIDLV.SelectedValue); } } if (ddlACCPayableApprovalStatusIDLV.Items.Count > 0) { if (ddlACCPayableApprovalStatusIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.ACCPayableApprovalStatusID = Int64.Parse(ddlACCPayableApprovalStatusIDLV.SelectedValue); } } if (ddlAccountPaybleStatementDetailCategoryIDLV.Items.Count > 0) { if (ddlAccountPaybleStatementDetailCategoryIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.AccountPaybleStatementDetailCategoryID = Int64.Parse(ddlAccountPaybleStatementDetailCategoryIDLV.SelectedValue); } } if (ddlPayableClassificationIDLV.Items.Count > 0) { if (ddlPayableClassificationIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.PayableClassificationID = Int64.Parse(ddlPayableClassificationIDLV.SelectedValue); } } aCCPrePayableStatementDetailEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); aCCPrePayableStatementDetailEntity.IPAddress = MiscUtil.GetLocalIP(); aCCPrePayableStatementDetailEntity.IsRemoved = false; aCCPrePayableStatementDetailEntity.IsLocked = false; String fe_member = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementDetailEntity.FLD_NAME_PostPayableStatementDetailID, _postPayableStatementDetailID.ToString(), SQLMatchType.Equal); FCCACCPostPayableStatementDetail.GetFacadeCreate().Update(aCCPrePayableStatementDetailEntity, fe_member, DatabaseOperationType.Update, TransactionRequired.No); } PrepareInitialView(); MiscUtil.ShowMessage(lblMessage, "Accounts Payable Information has been saved successfully.", false); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "Failed to Save Accounts Payable Information.", true); } }
private ACCPostPayableStatementDetailEntity BuildACCPostPayableStatementDetailEntity() { ACCPostPayableStatementDetailEntity aCCPrePayableStatementDetailEntity = CurrentACCPostPayableStatementDetailEntity; IList <ListViewDataItem> list = lvACCPrePayableStatementDetail.Items; Int32 tempDataItemIndex = 0; foreach (ListViewDataItem lvdi in list) { DataKey currentDataKey = lvACCPrePayableStatementDetail.DataKeys[tempDataItemIndex++]; Int64 _postPayableStatementDetailID = (Int64)currentDataKey["PostPayableStatementDetailID"]; //ACCPostPayableStatementDetailEntity aCCPrePayableStatementDetailEntity = FCCACCPostPayableStatementDetail.GetFacadeCreate().GetByID(_postPayableStatementDetailID); DropDownList ddlACCPayableApprovalStatusIDLV = (DropDownList)lvdi.FindControl("ddlACCPayableApprovalStatusIDLV"); DropDownList ddlACCPayablePaymentStatusIDLV = (DropDownList)lvdi.FindControl("ddlACCPayablePaymentStatusIDLV"); DropDownList ddlAccountPaybleStatementDetailCategoryIDLV = (DropDownList)lvdi.FindControl("ddlAccountPaybleStatementDetailCategoryIDLV"); DropDownList ddlPayableClassificationIDLV = (DropDownList)lvdi.FindControl("ddlPayableClassificationIDLV"); CheckBox chkPartyReconcileLV = (CheckBox)lvdi.FindControl("chkPartyReconcileLV"); TextBox txtPayableAgainstWorkOrderLV = (TextBox)lvdi.FindControl("txtPayableAgainstWorkOrderLV"); TextBox txtNetPayableConsideringBillAndSecurityLV = (TextBox)lvdi.FindControl("txtNetPayableConsideringBillAndSecurityLV"); TextBox txtDueDateLV = (TextBox)lvdi.FindControl("txtDueDateLV"); TextBox txtPlannedDateLV = (TextBox)lvdi.FindControl("txtPlannedDateLV"); TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV"); if (!txtPayableAgainstWorkOrderLV.Text.Trim().IsNullOrEmpty()) { aCCPrePayableStatementDetailEntity.PayableAgainstWorkOrder = Decimal.Parse(txtPayableAgainstWorkOrderLV.Text.Trim()); } else { aCCPrePayableStatementDetailEntity.PayableAgainstWorkOrder = null; } if (!txtNetPayableConsideringBillAndSecurityLV.Text.Trim().IsNullOrEmpty()) { aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = Decimal.Parse(txtNetPayableConsideringBillAndSecurityLV.Text.Trim()); } else { aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = null; } aCCPrePayableStatementDetailEntity.PartyReconcile = chkPartyReconcileLV.Checked; aCCPrePayableStatementDetailEntity.Remarks = txtRemarksLV.Text.Trim(); aCCPrePayableStatementDetailEntity.CreateDate = System.DateTime.Now; if (txtDueDateLV.Text.Trim().IsNotNullOrEmpty()) { aCCPrePayableStatementDetailEntity.DueDate = MiscUtil.ParseToDateTime(txtDueDateLV.Text); } if (txtPlannedDateLV.Text.Trim().IsNotNullOrEmpty()) { aCCPrePayableStatementDetailEntity.PlannedDate = MiscUtil.ParseToDateTime(txtPlannedDateLV.Text); } else { aCCPrePayableStatementDetailEntity.PlannedDate = null; } if (ddlACCPayablePaymentStatusIDLV.Items.Count > 0) { if (ddlACCPayablePaymentStatusIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.ACCPayablePaymentStatusID = Int64.Parse(ddlACCPayablePaymentStatusIDLV.SelectedValue); } } if (ddlACCPayableApprovalStatusIDLV.Items.Count > 0) { if (ddlACCPayableApprovalStatusIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.ACCPayableApprovalStatusID = Int64.Parse(ddlACCPayableApprovalStatusIDLV.SelectedValue); } } if (ddlAccountPaybleStatementDetailCategoryIDLV.Items.Count > 0) { if (ddlAccountPaybleStatementDetailCategoryIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.AccountPaybleStatementDetailCategoryID = Int64.Parse(ddlAccountPaybleStatementDetailCategoryIDLV.SelectedValue); } } if (ddlPayableClassificationIDLV.Items.Count > 0) { if (ddlPayableClassificationIDLV.SelectedValue == "0") { } else { aCCPrePayableStatementDetailEntity.PayableClassificationID = Int64.Parse(ddlPayableClassificationIDLV.SelectedValue); } } aCCPrePayableStatementDetailEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); aCCPrePayableStatementDetailEntity.IPAddress = MiscUtil.GetLocalIP(); aCCPrePayableStatementDetailEntity.IsRemoved = false; aCCPrePayableStatementDetailEntity.IsLocked = false; } return(aCCPrePayableStatementDetailEntity); }
private Int64 Add(ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACCPostPayableStatementDetail_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddNullPrimaryKeyParameter(cmd, "PostPayableStatementDetailID"); Database.AddInParameter(cmd, "@PostPayableStatementID", DbType.Int64, aCCPostPayableStatementDetailEntity.PostPayableStatementID); Database.AddInParameter(cmd, "@PrePayableStatementDetailID", DbType.Int64, aCCPostPayableStatementDetailEntity.PrePayableStatementDetailID); Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, aCCPostPayableStatementDetailEntity.ProjectID); Database.AddInParameter(cmd, "@ProjectCode", DbType.String, aCCPostPayableStatementDetailEntity.ProjectCode); Database.AddInParameter(cmd, "@WorkOrderID", DbType.Int64, aCCPostPayableStatementDetailEntity.WorkOrderID); Database.AddInParameter(cmd, "@WorkOrderNo", DbType.String, aCCPostPayableStatementDetailEntity.WorkOrderNo); Database.AddInParameter(cmd, "@WorkOrderAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.WorkOrderAmount); Database.AddInParameter(cmd, "@WorkOrderDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.WorkOrderDate); Database.AddInParameter(cmd, "@PaidAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.PaidAmount); Database.AddInParameter(cmd, "@SecurityMoney", DbType.Decimal, aCCPostPayableStatementDetailEntity.SecurityMoney); Database.AddInParameter(cmd, "@TDSAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.TDSAmount); Database.AddInParameter(cmd, "@PayableAgainstWorkOrder", DbType.Decimal, aCCPostPayableStatementDetailEntity.PayableAgainstWorkOrder); Database.AddInParameter(cmd, "@ApprovedBillAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.ApprovedBillAmount); Database.AddInParameter(cmd, "@NetPayableConsideringBillAndSecurity", DbType.Decimal, aCCPostPayableStatementDetailEntity.NetPayableConsideringBillAndSecurity); Database.AddInParameter(cmd, "@PartyReconcile", DbType.Boolean, aCCPostPayableStatementDetailEntity.PartyReconcile); Database.AddInParameter(cmd, "@RequisitionID", DbType.Int64, aCCPostPayableStatementDetailEntity.RequisitionID); Database.AddInParameter(cmd, "@RequisitionNo", DbType.String, aCCPostPayableStatementDetailEntity.RequisitionNo); Database.AddInParameter(cmd, "@RequisitionDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.RequisitionDate); Database.AddInParameter(cmd, "@BillID", DbType.Int64, aCCPostPayableStatementDetailEntity.BillID); Database.AddInParameter(cmd, "@BillNo", DbType.String, aCCPostPayableStatementDetailEntity.BillNo); Database.AddInParameter(cmd, "@BillDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.BillDate); Database.AddInParameter(cmd, "@Remarks", DbType.String, aCCPostPayableStatementDetailEntity.Remarks); Database.AddInParameter(cmd, "@Ref", DbType.String, aCCPostPayableStatementDetailEntity.Ref); Database.AddInParameter(cmd, "@VendorCategoryID", DbType.Int64, aCCPostPayableStatementDetailEntity.VendorCategoryID); Database.AddInParameter(cmd, "@FromVendorID", DbType.Int64, aCCPostPayableStatementDetailEntity.FromVendorID); Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.CreateDate); Database.AddInParameter(cmd, "@DueDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.DueDate); Database.AddInParameter(cmd, "@PlannedDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.PlannedDate); Database.AddInParameter(cmd, "@AdditionalRemarks", DbType.String, aCCPostPayableStatementDetailEntity.AdditionalRemarks); Database.AddInParameter(cmd, "@ACCPayablePaymentStatusID", DbType.Int64, aCCPostPayableStatementDetailEntity.ACCPayablePaymentStatusID); Database.AddInParameter(cmd, "@ACCPayableApprovalStatusID", DbType.Int64, aCCPostPayableStatementDetailEntity.ACCPayableApprovalStatusID); Database.AddInParameter(cmd, "@AccountPaybleStatementDetailCategoryID", DbType.Int64, aCCPostPayableStatementDetailEntity.AccountPaybleStatementDetailCategoryID); Database.AddInParameter(cmd, "@PayableClassificationID", DbType.Int64, aCCPostPayableStatementDetailEntity.PayableClassificationID); Database.AddInParameter(cmd, "@CreateByEmployeeID", DbType.Int64, aCCPostPayableStatementDetailEntity.CreateByEmployeeID); Database.AddInParameter(cmd, "@APPanelID", DbType.Int64, aCCPostPayableStatementDetailEntity.APPanelID); Database.AddInParameter(cmd, "@IPAddress", DbType.String, aCCPostPayableStatementDetailEntity.IPAddress); Database.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, aCCPostPayableStatementDetailEntity.IsRemoved); Database.AddInParameter(cmd, "@IsLocked", DbType.Boolean, aCCPostPayableStatementDetailEntity.IsLocked); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("ACCPostPayableStatementDetailEntity already exists. Please specify another ACCPostPayableStatementDetailEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("ACCPostPayableStatementDetailEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("ACCPostPayableStatementDetailEntity already exists. Please specify another ACCPostPayableStatementDetailEntity."); } } } } return(returnCode); }
private Int64 UpdateTran(ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.ACCPostPayableStatementDetail_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, "@PostPayableStatementDetailID", DbType.Int64, aCCPostPayableStatementDetailEntity.PostPayableStatementDetailID); db.AddInParameter(cmd, "@PostPayableStatementID", DbType.Int64, aCCPostPayableStatementDetailEntity.PostPayableStatementID); db.AddInParameter(cmd, "@PrePayableStatementDetailID", DbType.Int64, aCCPostPayableStatementDetailEntity.PrePayableStatementDetailID); db.AddInParameter(cmd, "@ProjectID", DbType.Int64, aCCPostPayableStatementDetailEntity.ProjectID); db.AddInParameter(cmd, "@ProjectCode", DbType.String, aCCPostPayableStatementDetailEntity.ProjectCode); db.AddInParameter(cmd, "@WorkOrderID", DbType.Int64, aCCPostPayableStatementDetailEntity.WorkOrderID); db.AddInParameter(cmd, "@WorkOrderNo", DbType.String, aCCPostPayableStatementDetailEntity.WorkOrderNo); db.AddInParameter(cmd, "@WorkOrderAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.WorkOrderAmount); db.AddInParameter(cmd, "@WorkOrderDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.WorkOrderDate); db.AddInParameter(cmd, "@PaidAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.PaidAmount); db.AddInParameter(cmd, "@SecurityMoney", DbType.Decimal, aCCPostPayableStatementDetailEntity.SecurityMoney); db.AddInParameter(cmd, "@TDSAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.TDSAmount); db.AddInParameter(cmd, "@PayableAgainstWorkOrder", DbType.Decimal, aCCPostPayableStatementDetailEntity.PayableAgainstWorkOrder); db.AddInParameter(cmd, "@ApprovedBillAmount", DbType.Decimal, aCCPostPayableStatementDetailEntity.ApprovedBillAmount); db.AddInParameter(cmd, "@NetPayableConsideringBillAndSecurity", DbType.Decimal, aCCPostPayableStatementDetailEntity.NetPayableConsideringBillAndSecurity); db.AddInParameter(cmd, "@PartyReconcile", DbType.Boolean, aCCPostPayableStatementDetailEntity.PartyReconcile); db.AddInParameter(cmd, "@RequisitionID", DbType.Int64, aCCPostPayableStatementDetailEntity.RequisitionID); db.AddInParameter(cmd, "@RequisitionNo", DbType.String, aCCPostPayableStatementDetailEntity.RequisitionNo); db.AddInParameter(cmd, "@RequisitionDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.RequisitionDate); db.AddInParameter(cmd, "@BillID", DbType.Int64, aCCPostPayableStatementDetailEntity.BillID); db.AddInParameter(cmd, "@BillNo", DbType.String, aCCPostPayableStatementDetailEntity.BillNo); db.AddInParameter(cmd, "@BillDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.BillDate); db.AddInParameter(cmd, "@Remarks", DbType.String, aCCPostPayableStatementDetailEntity.Remarks); db.AddInParameter(cmd, "@Ref", DbType.String, aCCPostPayableStatementDetailEntity.Ref); db.AddInParameter(cmd, "@VendorCategoryID", DbType.Int64, aCCPostPayableStatementDetailEntity.VendorCategoryID); db.AddInParameter(cmd, "@FromVendorID", DbType.Int64, aCCPostPayableStatementDetailEntity.FromVendorID); db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.CreateDate); db.AddInParameter(cmd, "@DueDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.DueDate); db.AddInParameter(cmd, "@PlannedDate", DbType.DateTime, aCCPostPayableStatementDetailEntity.PlannedDate); db.AddInParameter(cmd, "@AdditionalRemarks", DbType.String, aCCPostPayableStatementDetailEntity.AdditionalRemarks); db.AddInParameter(cmd, "@ACCPayablePaymentStatusID", DbType.Int64, aCCPostPayableStatementDetailEntity.ACCPayablePaymentStatusID); db.AddInParameter(cmd, "@ACCPayableApprovalStatusID", DbType.Int64, aCCPostPayableStatementDetailEntity.ACCPayableApprovalStatusID); db.AddInParameter(cmd, "@AccountPaybleStatementDetailCategoryID", DbType.Int64, aCCPostPayableStatementDetailEntity.AccountPaybleStatementDetailCategoryID); db.AddInParameter(cmd, "@PayableClassificationID", DbType.Int64, aCCPostPayableStatementDetailEntity.PayableClassificationID); db.AddInParameter(cmd, "@CreateByEmployeeID", DbType.Int64, aCCPostPayableStatementDetailEntity.CreateByEmployeeID); db.AddInParameter(cmd, "@APPanelID", DbType.Int64, aCCPostPayableStatementDetailEntity.APPanelID); db.AddInParameter(cmd, "@IPAddress", DbType.String, aCCPostPayableStatementDetailEntity.IPAddress); db.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, aCCPostPayableStatementDetailEntity.IsRemoved); db.AddInParameter(cmd, "@IsLocked", DbType.Boolean, aCCPostPayableStatementDetailEntity.IsLocked); 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 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(); }
protected void btnAddNew_Click(object sender, EventArgs e) { _PostPayableStatementDetailID = 0; _ACCPostPayableStatementDetailEntity = new ACCPostPayableStatementDetailEntity(); PrepareInitialView(); }