/// <summary>
/// DbversionGet
/// </summary>
/// <param name="">pLngDbversionID</param>
/// <returns>Dbversion</returns>
///
public Dbversion DbversionGet(long pLngDbversionID)
{
Dbversion dbversion = new Dbversion()
{
DbversionID = pLngDbversionID
};
bool bConn = false;
SqlConnection conn = getDBConnection();
if (conn != null)
{
BusDbversion busDbversion = null;
busDbversion = new BusDbversion(conn);
busDbversion.Load(dbversion);
// close the db connection
bConn = CloseConnection(conn);
_hasError = busDbversion.HasError;
if (busDbversion.HasError)
{
// error
ErrorCode error = new ErrorCode();
}
}
return(dbversion);
}
/// <summary>
/// Modify Dbversion object to database
/// <param name="o">Dbversion to be modified.</param>
/// <retvalue>void</retvalue>
/// </summary>
public void Delete(Dbversion o)
{
if (o != null)
{
o.Delete(_conn);
if (o.HasError)
{
_hasError = true;
}
}
}
/// <summary>
/// Modify Dbversion object to database
/// <param name="o">Dbversion to be modified.</param>
/// <retvalue>void</retvalue>
/// </summary>
public void Load(Dbversion o)
{
if (o != null)
{
o.Load(_conn);
if (o.HasError)
{
_hasError = true;
}
}
}
public void Insert(string Name,DateTime Createdon,DateTime? Appliedon)
{
Dbversion item = new Dbversion();
item.Name = Name;
item.Createdon = Createdon;
item.Appliedon = Appliedon;
item.Save(UserName);
}
/// <summary>
/// Exist Dbversion object to database
/// <param name="o">Dbversion to be modified.</param>
/// <retvalue>void</retvalue>
/// </summary>
public bool Exist(Dbversion o)
{
bool bExist = false;
if (o != null)
{
bExist = o.Exist(_conn);
if (o.HasError)
{
_hasError = true;
}
}
return(bExist);
}
/// <summary>
/// DbversionRemove
/// </summary>
/// <param name="">pDbversionID</param>
/// <returns>void</returns>
///
public void DbversionRemove(long pDbversionID)
{
bool bConn = false;
SqlConnection conn = getDBConnection();
if (conn != null)
{
Dbversion dbversion = new Dbversion();
dbversion.DbversionID = pDbversionID;
BusDbversion bus = null;
bus = new BusDbversion(conn);
bus.Delete(dbversion);
// close the db connection
bConn = CloseConnection(conn);
_hasError = bus.HasError;
if (bus.HasError)
{
// error
ErrorCode error = new ErrorCode();
}
}
}
/*********************** CUSTOM END *********************/
//------------------------------------------
/// <summary>
/// DbversionCreateOrModify
/// </summary>
/// <param name="">pDbversion</param>
/// <returns>long</returns>
///
public long DbversionCreateOrModify(Dbversion pDbversion)
{
long lID = 0;
bool bConn = false;
SqlConnection conn = getDBConnection();
if (conn != null)
{
BusDbversion busDbversion = null;
busDbversion = new BusDbversion(conn);
busDbversion.Save(pDbversion);
// close the db connection
bConn = CloseConnection(conn);
lID = pDbversion.DbversionID;
_hasError = busDbversion.HasError;
if (busDbversion.HasError)
{
// error
ErrorCode error = new ErrorCode();
}
}
return(lID);
}
/// <summary>
/// Checks to make sure all values are valid
/// <remarks>
/// Calls "IsValid" method for each property in ocject
/// </remarks>
/// <retvalue>true if object has valid entries, false otherwise</retvalue>
/// </summary>
public bool IsValid(Dbversion pRefDbversion)
{
bool isValid = true;
bool isValidTmp = true;
_arrlstColumnErrors = null;
_arrlstColumnErrors = new ArrayList();
isValidTmp = IsValidDbversionID(pRefDbversion.DbversionID);
if (!isValidTmp)
{
isValid = false;
}
isValidTmp = IsValidDateCreated(pRefDbversion.DateCreated);
if (!isValidTmp)
{
isValid = false;
}
isValidTmp = IsValidMajorNum(pRefDbversion.MajorNum);
if (!isValidTmp)
{
isValid = false;
}
isValidTmp = IsValidMinorNum(pRefDbversion.MinorNum);
if (!isValidTmp)
{
isValid = false;
}
isValidTmp = IsValidNotes(pRefDbversion.Notes);
if (!isValidTmp && pRefDbversion.Notes != null)
{
isValid = false;
}
return(isValid);
}
/// <summary>
/// Gets all Dbversion objects
/// <remarks>
/// Returns Dbversion objects in an array list
/// using the given criteria
/// </remarks>
/// <retvalue>ArrayList containing Dbversion object</retvalue>
/// </summary>
public ArrayList Get(long pLngDbversionID, DateTime pDtBeginDateCreated, DateTime pDtEndDateCreated, long pLngMajorNum, long pLngMinorNum, string pStrNotes)
{
Dbversion data = null;
_arrlstEntities = new ArrayList();
EnumDbversion enumDbversion = new EnumDbversion(_conn);
enumDbversion.SP_ENUM_NAME = (!string.IsNullOrEmpty(SP_ENUM_NAME)) ? SP_ENUM_NAME : enumDbversion.SP_ENUM_NAME;
enumDbversion.DbversionID = pLngDbversionID;
enumDbversion.BeginDateCreated = pDtBeginDateCreated;
enumDbversion.EndDateCreated = pDtEndDateCreated;
enumDbversion.MajorNum = pLngMajorNum;
enumDbversion.MinorNum = pLngMinorNum;
enumDbversion.Notes = pStrNotes;
enumDbversion.EnumData();
while (enumDbversion.hasMoreElements())
{
data = (Dbversion)enumDbversion.nextElement();
_arrlstEntities.Add(data);
}
enumDbversion = null;
ArrayList.ReadOnly(_arrlstEntities);
return(_arrlstEntities);
}
/// <summary>
/// Gets all Dbversion objects
/// <remarks>
/// Returns ArrayList containing object passed in
/// </remarks>
/// <param name="o">Dbversion to be returned</param>
/// <retvalue>ArrayList containing Dbversion object</retvalue>
/// </summary>
public ArrayList Get(Dbversion o)
{
return(Get(o.DbversionID, o.DateCreated, o.DateCreated, o.MajorNum, o.MinorNum, o.Notes));
}
public void Update(int Id,string Name,DateTime Createdon,DateTime? Appliedon)
{
Dbversion item = new Dbversion();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.Name = Name;
item.Createdon = Createdon;
item.Appliedon = Appliedon;
item.Save(UserName);
}
