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));
}
