public IList <CRMPaymentScheduleEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <CRMPaymentScheduleEntity> cRMPaymentScheduleEntityList = new List <CRMPaymentScheduleEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = CRMPaymentScheduleEntity.FLD_NAME_PaymentScheduleID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; cRMPaymentScheduleEntityList = FCCCRMPaymentSchedule.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (cRMPaymentScheduleEntityList != null && cRMPaymentScheduleEntityList.Count > 0) { totalRowCount = cRMPaymentScheduleEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cRMPaymentScheduleEntityList ?? new List <CRMPaymentScheduleEntity>()); }
private void GetPaymentScheduleSelectedDropdown() { CRMPaymentScheduleEntity entity = FCCCRMPaymentSchedule.GetFacadeCreate().GetByID(Int64.Parse(ddlPaymentScheduleID.SelectedValue)); MiscUtil.PopulateCRMBuyerBasicInfo(ddlBuyerBasicInfoID, false, entity.BuyerBasicInfoID); MiscUtil.PopulateBDProjectByCode(ddlProjectID, false, entity.ProjectCode); MiscUtil.PopulateBDProjectFloorUnitByBuyerBookSpaceID(ddlProjectFloorUnitID, false, entity.BuyerBookSpaceID); }
protected void lvCRMPaymentSchedule_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 PaymentScheduleID; Int64.TryParse(e.CommandArgument.ToString(), out PaymentScheduleID); if (PaymentScheduleID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _PaymentScheduleID = PaymentScheduleID; String url = UrlHelper.BuildSecureUrl("~/CRM/CRMPaymentSchedule.aspx", string.Empty, "do", "Edit", UrlConstants.OVERVIEW_PAYMENT_SCHEDULE_ID, PaymentScheduleID.ToString()).ToString(); Response.Redirect(url); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CRMPaymentScheduleEntity.FLD_NAME_PaymentScheduleID, PaymentScheduleID.ToString(), SQLMatchType.Equal); CRMPaymentScheduleEntity cRMPaymentScheduleEntity = new CRMPaymentScheduleEntity(); result = FCCCRMPaymentSchedule.GetFacadeCreate().Delete(cRMPaymentScheduleEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _PaymentScheduleID = 0; _CRMPaymentScheduleEntity = new CRMPaymentScheduleEntity(); PrepareInitialView(); BindCRMPaymentScheduleList(); MiscUtil.ShowMessage(lblMessage, "Payment Schedule has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Payment Schedule.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <CRMPaymentScheduleEntity> GetData() { IList <CRMPaymentScheduleEntity> cRMPaymentScheduleEntityList = new List <CRMPaymentScheduleEntity>(); try { cRMPaymentScheduleEntityList = FCCCRMPaymentSchedule.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (cRMPaymentScheduleEntityList != null && cRMPaymentScheduleEntityList.Count > 0) { totalRowCount = cRMPaymentScheduleEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cRMPaymentScheduleEntityList ?? new List <CRMPaymentScheduleEntity>()); }