public int SaveRows(DbTransaction pTran, RequestTypeList RequestTypeList, bool CreateTransaction) { int intRows = 0; DbTransaction objTran = pTran; Exception exception = null; try { if (pTran == null && CreateTransaction == true) { objTran = RequestTypeData.CreateTransaction(); } intRows = RequestTypeData.SaveRows(objTran, RequestTypeList); if (pTran == null && objTran != null && CreateTransaction == true) { RequestTypeData.CommitTransaction(objTran, true); objTran = null; } } catch (Exception EX) { exception = EX; if (pTran == null && objTran != null && CreateTransaction == true) { RequestTypeData.RollbackTransaction(objTran, true); objTran = null; } } finally { } return(intRows); }
private List <RequestType> fillRequestTypeList() { RequestTypeBusiness _RequestTypeBusiness = new RequestTypeBusiness(); RequestTypeList _RequestTypeList = _RequestTypeBusiness.SelectRows(null, null, null); return(_RequestTypeList); }
public RequestTypeList SelectRows(DbTransaction pTran, System.Int32?Id, System.String name, System.String nameAr) { RequestTypeList RequestTypeList = new RequestTypeList(); 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].[SelectRequestType]", Parameters); try { if (Dr != null) { while (Dr.Read()) { RequestType RequestType = new RequestType(); if (Dr["Id"] != DBNull.Value) { RequestType.Id = (System.Int32)Dr["Id"]; } if (Dr["name"] != DBNull.Value) { RequestType.name = (System.String)Dr["name"]; } if (Dr["nameAr"] != DBNull.Value) { RequestType.nameAr = (System.String)Dr["nameAr"]; } RequestTypeList.FillRow(RequestType); RequestType = null; } } } catch (Exception Ex) { exception = Ex; } finally { if (Dr != null) { if (Dr.IsClosed == false) { Dr.Close(); } Dr = null; } } return(RequestTypeList); }
public int SaveRows(DbTransaction pTran, RequestTypeList RequestTypeList) { int intRows = 0; for (int i = 0; i < RequestTypeList.Count; i++) { switch (RequestTypeList[i].CommonState) { case CommonState.Added: intRows += InsertRow(pTran, RequestTypeList[i]); break; case CommonState.Modified: intRows += UpdateRow(pTran, RequestTypeList[i]); break; case CommonState.Deleted: intRows += DeleteRow(pTran, RequestTypeList[i]); break; } } return(intRows); }
public int SaveRows(RequestTypeList RequestTypeList) { DbTransaction Tran = null; return(SaveRows(Tran, RequestTypeList)); }
public int SaveRows(DbTransaction pTran, RequestTypeList RequestTypeList) { return(SaveRows(pTran, RequestTypeList, true)); }