public IList <REQRequisitionUploadInfoEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <REQRequisitionUploadInfoEntity> rEQRequisitionUploadInfoEntityList = new List <REQRequisitionUploadInfoEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = REQRequisitionUploadInfoEntity.FLD_NAME_RequisitionUploadInfoID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; rEQRequisitionUploadInfoEntityList = FCCREQRequisitionUploadInfo.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (rEQRequisitionUploadInfoEntityList != null && rEQRequisitionUploadInfoEntityList.Count > 0) { totalRowCount = rEQRequisitionUploadInfoEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(rEQRequisitionUploadInfoEntityList ?? new List <REQRequisitionUploadInfoEntity>()); }
private void SaveREQRequisitionUploadInfoEntity() { if (IsValid) { try { REQRequisitionUploadInfoEntity rEQRequisitionUploadInfoEntity = BuildREQRequisitionUploadInfoEntity(); Int64 result = -1; if (rEQRequisitionUploadInfoEntity.IsNew) { result = FCCREQRequisitionUploadInfo.GetFacadeCreate().Add(rEQRequisitionUploadInfoEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionUploadInfoEntity.FLD_NAME_RequisitionUploadInfoID, rEQRequisitionUploadInfoEntity.RequisitionUploadInfoID.ToString(), SQLMatchType.Equal); result = FCCREQRequisitionUploadInfo.GetFacadeCreate().Update(rEQRequisitionUploadInfoEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _RequisitionUploadInfoID = 0; _REQRequisitionUploadInfoEntity = new REQRequisitionUploadInfoEntity(); PrepareInitialView(); BindREQRequisitionUploadInfoList(); if (rEQRequisitionUploadInfoEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "R EQRequisition Upload Info Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "R EQRequisition Upload Info Information has been updated successfully.", false); } } else { if (rEQRequisitionUploadInfoEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add R EQRequisition Upload Info Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update R EQRequisition Upload Info Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvREQRequisitionUploadInfo_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 RequisitionUploadInfoID; Int64.TryParse(e.CommandArgument.ToString(), out RequisitionUploadInfoID); if (RequisitionUploadInfoID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _RequisitionUploadInfoID = RequisitionUploadInfoID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionUploadInfoEntity.FLD_NAME_RequisitionUploadInfoID, RequisitionUploadInfoID.ToString(), SQLMatchType.Equal); REQRequisitionUploadInfoEntity rEQRequisitionUploadInfoEntity = new REQRequisitionUploadInfoEntity(); result = FCCREQRequisitionUploadInfo.GetFacadeCreate().Delete(rEQRequisitionUploadInfoEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _RequisitionUploadInfoID = 0; _REQRequisitionUploadInfoEntity = new REQRequisitionUploadInfoEntity(); PrepareInitialView(); BindREQRequisitionUploadInfoList(); MiscUtil.ShowMessage(lblMessage, "Requisition Upload Info has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete R EQRequisition Upload Info.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <REQRequisitionUploadInfoEntity> GetData() { IList <REQRequisitionUploadInfoEntity> rEQRequisitionUploadInfoEntityList = new List <REQRequisitionUploadInfoEntity>(); try { rEQRequisitionUploadInfoEntityList = FCCREQRequisitionUploadInfo.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (rEQRequisitionUploadInfoEntityList != null && rEQRequisitionUploadInfoEntityList.Count > 0) { totalRowCount = rEQRequisitionUploadInfoEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(rEQRequisitionUploadInfoEntityList ?? new List <REQRequisitionUploadInfoEntity>()); }