public int CompareTo(ProcurementDetailsData d2, ProcurementDetailsDataComparer.CompareType field)
{
switch (field)
{
case ProcurementDetailsDataComparer.CompareType.DateOfProcurement:
return(this.DateOfProcurement.CompareTo(d2.DateOfProcurement));
default:
return(this.PageId.CompareTo(d2.PageId));
}
}
public ProcurementDetailsData fetchProcurementDetails(CmsPage page, int identifier, CmsLanguage lang, bool createIfNotExist)
{
if (page.Id < 0 || identifier < 0)
{
return(new ProcurementDetailsData(page, identifier, lang));
}
StringBuilder sql = new StringBuilder("SELECT DateOfProcurement FROM ");
sql.Append(TableNameDetails);
sql.Append(" WHERE PageId=" + page.Id.ToString());
sql.Append(" AND Identifier=" + identifier.ToString());
sql.Append(" AND LangCode='" + lang.shortCode + "'");
sql.Append(" AND Deleted is null;");
ProcurementDetailsData entity = new ProcurementDetailsData(page, identifier, lang);
DataSet ds = this.RunSelectQuery(sql.ToString());
if (this.hasSingleRow(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
entity.DateOfProcurement = Convert.ToDateTime(dr["DateOfProcurement"]);
}
else
{
if (createIfNotExist)
{
if (addProcurementDetails(page, entity) == false)
{
throw new Exception("fetchProcurementDetails() database error: Error creating new placeholder");
}
}
else
{
throw new Exception("fetchProcurementDetails() database error: placeholder does not exist");
}
}
return(entity);
}
public bool addProcurementDetails(CmsPage page, ProcurementDetailsData entity)
{
StringBuilder sql = new StringBuilder("INSERT INTO ");
sql.Append(TableNameDetails);
sql.Append(" (PageId,Identifier,LangCode,DateOfProcurement) VALUES (");
sql.Append(entity.PageId.ToString() + ",");
sql.Append(entity.Identifier.ToString() + ",'");
sql.Append(dbEncode(entity.Lang.shortCode) + "',");
sql.Append(dbEncode(entity.DateOfProcurement) + ");");
int affected = this.RunUpdateQuery(sql.ToString());
if (affected > 0)
{
return(page.setLastUpdatedDateTimeToNow());
}
else
{
return(false);
}
}
public bool updateProcurementDetails(CmsPage page, int identifier, CmsLanguage lang, ProcurementDetailsData entity)
{
StringBuilder sql = new StringBuilder("UPDATE ");
sql.Append(TableNameDetails);
sql.Append(" SET DateOfProcurement = " + dbEncode(entity.DateOfProcurement));
sql.Append(" WHERE PageId=" + page.Id.ToString());
sql.Append(" AND Identifier=" + identifier.ToString());
sql.Append(" AND LangCode='" + lang.shortCode + "';");
int affected = this.RunUpdateQuery(sql.ToString());
return(affected > 0);
}
