public int UpdateRow(DbTransaction pTran, CardValidity CardValidity, bool CreateTransaction)
{
int intRow = 0;
DbTransaction objTran = pTran;
Exception exception = null;
try
{
if (pTran == null && CreateTransaction == true)
{
objTran = CardValidityData.CreateTransaction();
}
intRow = CardValidityData.UpdateRow(objTran, CardValidity);
if (pTran == null && objTran != null && CreateTransaction == true)
{
CardValidityData.CommitTransaction(objTran, true);
objTran = null;
}
}
catch (Exception EX)
{
exception = EX;
if (pTran == null && objTran != null && CreateTransaction == true)
{
CardValidityData.RollbackTransaction(objTran, true);
objTran = null;
}
}
finally
{
}
return(intRow);
}
public int DeleteRow(DbTransaction pTran, CardValidity CardValidity)
{
int intRows = 0;
DbParameter[] Parameters = new DbParameter[1];
Parameters[0] = _getIdParameter(CardValidity.Id, ParameterDirection.Input);
intRows = ExecuteNonQuery(pTran, "[Lookups].[DeleteCardValidity]", Parameters);
return(intRows);
}
public CardValidityList SelectRows(DbTransaction pTran, System.Int32?Id, System.String name, System.String nameAr)
{
CardValidityList CardValidityList = new CardValidityList();
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].[SelectCardValidity]", Parameters);
try
{
if (Dr != null)
{
while (Dr.Read())
{
CardValidity CardValidity = new CardValidity();
if (Dr["Id"] != DBNull.Value)
{
CardValidity.Id = (System.Int32)Dr["Id"];
}
if (Dr["name"] != DBNull.Value)
{
CardValidity.name = (System.String)Dr["name"];
}
if (Dr["nameAr"] != DBNull.Value)
{
CardValidity.nameAr = (System.String)Dr["nameAr"];
}
CardValidityList.FillRow(CardValidity);
CardValidity = null;
}
}
}
catch (Exception Ex)
{
exception = Ex;
}
finally
{
if (Dr != null)
{
if (Dr.IsClosed == false)
{
Dr.Close();
}
Dr = null;
}
}
return(CardValidityList);
}
public int InsertRow(DbTransaction pTran, CardValidity CardValidity)
{
int intRows = 0;
DbParameter[] Parameters = new DbParameter[3];
Parameters[0] = _getIdParameter(CardValidity.Id, ParameterDirection.Output);
Parameters[1] = _getnameParameter(CardValidity.name, ParameterDirection.Input);
Parameters[2] = _getnameArParameter(CardValidity.nameAr, ParameterDirection.Input);
intRows = ExecuteNonQuery(pTran, "[Lookups].[InsertCardValidity]", Parameters);
if (Parameters[0].Value != DBNull.Value)
{
CardValidity.Id = (System.Int32)Parameters[0].Value;
}
return(intRows);
}
public int DeleteRow(CardValidity CardValidity)
{
DbTransaction Tran = null;
return(DeleteRow(Tran, CardValidity));
}
public int UpdateRow(CardValidity CardValidity)
{
DbTransaction Tran = null;
return(UpdateRow(Tran, CardValidity));
}
public int InsertRow(CardValidity CardValidity)
{
DbTransaction Tran = null;
return(InsertRow(Tran, CardValidity));
}
public int UpdateRow(DbTransaction pTran, CardValidity CardValidity)
{
return(UpdateRow(pTran, CardValidity, false));
}
public int InsertRow(DbTransaction pTran, CardValidity CardValidity)
{
return(InsertRow(pTran, CardValidity, false));
}
public int DeleteRow(DbTransaction pTran, CardValidity CardValidity)
{
return(DeleteRow(pTran, CardValidity, false));
}
