private void AddRise(RiseFiltersDTO pObjRiseFilter)
{
try
{
if (pObjRiseFilter == null)
{
return;
}
this.UIAPIRawForm.Freeze(true);
dtRise.Rows.Add();
dtRise.SetValue("#", dtRise.Rows.Count - 1, dtRise.Rows.Count);
dtRise.SetValue("DocNmRise", dtRise.Rows.Count - 1, pObjRiseFilter.IdRise);
dtRise.SetValue("HrsFt", dtRise.Rows.Count - 1, pObjRiseFilter.HrsFeet);
//dtRise.SetValue("DocNCont", dtRise.Rows.Count - 1, pObjRiseFilter.ContractDocEntry);
mtxRise.LoadFromDataSource();
mtxRise.AutoResizeColumns();
}
catch (Exception lObjException)
{
LogUtility.WriteError(string.Format("[frmRiseSearch - AddRise] Error al agregar la subida: {0}", lObjException.Message));
throw new Exception(string.Format("Error al agregar la subida: {0}", lObjException.Message));
}
finally
{
this.UIAPIRawForm.Freeze(false);
}
}
public List <RiseFiltersDTO> GetRisesByContractId(string pStrDocEntry)
{
List <RiseFiltersDTO> lLstRiseFilters = new List <RiseFiltersDTO>();
Recordset lObjRecordset = null;
try
{
lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
string lStrQuery = this.GetSQL("GetRisesByContractId").InjectSingleValue("ContractDocEntry", pStrDocEntry);
lObjRecordset.DoQuery(lStrQuery);
if (lObjRecordset.RecordCount > 0)
{
for (int i = 0; i < lObjRecordset.RecordCount; i++)
{
RiseFiltersDTO lObjRiseFilters = new RiseFiltersDTO
{
IdRise = int.Parse(lObjRecordset.Fields.Item("IdRise").Value.ToString()),
ContractDocEntry = 0, //int.Parse(lObjRecordset.Fields.Item("ContractDocEntry").Value.ToString()),
HrsFeet = double.Parse(lObjRecordset.Fields.Item("HrFeet").Value.ToString()),
};
lLstRiseFilters.Add(lObjRiseFilters);
lObjRecordset.MoveNext();
}
}
}
catch (Exception lObjException)
{
LogService.WriteError(string.Format("[RiseDAO - GetRisesByContractId: {0}]", lObjException.Message));
throw new DAOException(lObjException.Message, lObjException);
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
}
return(lLstRiseFilters);
}
