private List <RequestPriority> fillRequestPriorityList() { RequestPriorityBusiness _RequestPriorityBusiness = new RequestPriorityBusiness(); RequestPriorityList _RequestPriorityList = _RequestPriorityBusiness.SelectRows(null, null, null); return(_RequestPriorityList); }
public int SaveRows(DbTransaction pTran, RequestPriorityList RequestPriorityList, bool CreateTransaction) { int intRows = 0; DbTransaction objTran = pTran; Exception exception = null; try { if (pTran == null && CreateTransaction == true) { objTran = RequestPriorityData.CreateTransaction(); } intRows = RequestPriorityData.SaveRows(objTran, RequestPriorityList); if (pTran == null && objTran != null && CreateTransaction == true) { RequestPriorityData.CommitTransaction(objTran, true); objTran = null; } } catch (Exception EX) { exception = EX; if (pTran == null && objTran != null && CreateTransaction == true) { RequestPriorityData.RollbackTransaction(objTran, true); objTran = null; } } finally { } return(intRows); }
public RequestPriorityList SelectRows(DbTransaction pTran, System.Int32?Id, System.String name, System.String nameAr) { RequestPriorityList RequestPriorityList = new RequestPriorityList(); Exception exception = null; DbParameter[] Parameters = new DbParameter[3]; Parameters[0] = _getIdParameter(Id, ParameterDirection.Input); Parameters[1] = _getnameParameter(name, ParameterDirection.Input); Parameters[2] = _getnameArParameter(nameAr, ParameterDirection.Input); DbDataReader Dr = ExecuteReader(pTran, "[Lookups].[SelectRequestPriority]", Parameters); try { if (Dr != null) { while (Dr.Read()) { RequestPriority RequestPriority = new RequestPriority(); if (Dr["Id"] != DBNull.Value) { RequestPriority.Id = (System.Int32)Dr["Id"]; } if (Dr["name"] != DBNull.Value) { RequestPriority.name = (System.String)Dr["name"]; } if (Dr["nameAr"] != DBNull.Value) { RequestPriority.nameAr = (System.String)Dr["nameAr"]; } RequestPriorityList.FillRow(RequestPriority); RequestPriority = null; } } } catch (Exception Ex) { exception = Ex; } finally { if (Dr != null) { if (Dr.IsClosed == false) { Dr.Close(); } Dr = null; } } return(RequestPriorityList); }
public int SaveRows(DbTransaction pTran, RequestPriorityList RequestPriorityList) { int intRows = 0; for (int i = 0; i < RequestPriorityList.Count; i++) { switch (RequestPriorityList[i].CommonState) { case CommonState.Added: intRows += InsertRow(pTran, RequestPriorityList[i]); break; case CommonState.Modified: intRows += UpdateRow(pTran, RequestPriorityList[i]); break; case CommonState.Deleted: intRows += DeleteRow(pTran, RequestPriorityList[i]); break; } } return(intRows); }
public int SaveRows(RequestPriorityList RequestPriorityList) { DbTransaction Tran = null; return(SaveRows(Tran, RequestPriorityList)); }
public int SaveRows(DbTransaction pTran, RequestPriorityList RequestPriorityList) { return(SaveRows(pTran, RequestPriorityList, true)); }