public IList <BDProjectAdditionalInfoEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <BDProjectAdditionalInfoEntity> bDProjectAdditionalInfoEntityList = new List <BDProjectAdditionalInfoEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = BDProjectAdditionalInfoEntity.FLD_NAME_ProjectAdditionalInfoID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; bDProjectAdditionalInfoEntityList = FCCBDProjectAdditionalInfo.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (bDProjectAdditionalInfoEntityList != null && bDProjectAdditionalInfoEntityList.Count > 0) { totalRowCount = bDProjectAdditionalInfoEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(bDProjectAdditionalInfoEntityList ?? new List <BDProjectAdditionalInfoEntity>()); }
private void SaveBDProjectAdditionalInfoEntity() { if (IsValid) { try { BDProjectAdditionalInfoEntity bDProjectAdditionalInfoEntity = BuildBDProjectAdditionalInfoEntity(); Int64 result = -1; if (bDProjectAdditionalInfoEntity.IsNew) { result = FCCBDProjectAdditionalInfo.GetFacadeCreate().Add(bDProjectAdditionalInfoEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(BDProjectAdditionalInfoEntity.FLD_NAME_ProjectAdditionalInfoID, bDProjectAdditionalInfoEntity.ProjectAdditionalInfoID.ToString(), SQLMatchType.Equal); result = FCCBDProjectAdditionalInfo.GetFacadeCreate().Update(bDProjectAdditionalInfoEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _ProjectAdditionalInfoID = 0; _BDProjectAdditionalInfoEntity = new BDProjectAdditionalInfoEntity(); PrepareInitialView(); PrepareEditView(); BindBDProjectAdditionalInfoList(); if (bDProjectAdditionalInfoEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Project Additional Info Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Project Additional Info Information has been updated successfully.", false); } } else { if (bDProjectAdditionalInfoEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Project Additional Info Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Project Additional Info Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
public IList <BDProjectAdditionalInfoEntity> GetData() { IList <BDProjectAdditionalInfoEntity> bDProjectAdditionalInfoEntityList = new List <BDProjectAdditionalInfoEntity>(); try { bDProjectAdditionalInfoEntityList = FCCBDProjectAdditionalInfo.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (bDProjectAdditionalInfoEntityList != null && bDProjectAdditionalInfoEntityList.Count > 0) { totalRowCount = bDProjectAdditionalInfoEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(bDProjectAdditionalInfoEntityList ?? new List <BDProjectAdditionalInfoEntity>()); }