public List <ContractsFiltersDTO> GetContracts(string pStrContract, string pStrClient, string pStrStatus, string pStrStartDate, string pStrEndDate, string pStrMunicipality)
{
List <ContractsFiltersDTO> lLstContractsFiltersDTO = new List <ContractsFiltersDTO>();
Recordset lObjRecordset = null;
try
{
lObjRecordset = (Recordset)DIApplication.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
Dictionary <string, string> lLstStrParameters = new Dictionary <string, string>();
lLstStrParameters.Add("Contract", pStrContract);
lLstStrParameters.Add("Client", pStrClient);
lLstStrParameters.Add("Status", pStrStatus);
lLstStrParameters.Add("StartDate", pStrStartDate);
lLstStrParameters.Add("EndDate", pStrEndDate);
lLstStrParameters.Add("Municipality", pStrMunicipality);
string lStrQuery = this.GetSQL("SearchRiseContracts").Inject(lLstStrParameters);
lObjRecordset.DoQuery(lStrQuery);
if (lObjRecordset.RecordCount > 0)
{
for (int i = 0; i < lObjRecordset.RecordCount; i++)
{
ContractsFiltersDTO lObjContracts = new ContractsFiltersDTO
{
DocEntry = int.Parse(lObjRecordset.Fields.Item("DocEntry").Value.ToString()),
DocNum = int.Parse(lObjRecordset.Fields.Item("DocNum").Value.ToString()),
CardCode = lObjRecordset.Fields.Item("CardCode").Value.ToString(),
CardName = lObjRecordset.Fields.Item("CardName").Value.ToString(),
HrsFeet = double.Parse(lObjRecordset.Fields.Item("HrsFeet").Value.ToString()),
ExtrasInvoices = int.Parse(lObjRecordset.Fields.Item("ExtrasInv").Value.ToString()),
Import = double.Parse(lObjRecordset.Fields.Item("ImportInv").Value.ToString()),
RealHrs = double.Parse(lObjRecordset.Fields.Item("RealHrs").Value.ToString()),
Difference = double.Parse(lObjRecordset.Fields.Item("Difference").Value.ToString()),
Status = int.Parse(lObjRecordset.Fields.Item("Close").Value.ToString()),
MunicipalityCode = lObjRecordset.Fields.Item("MunicipalityId").Value.ToString(),
Municipality = lObjRecordset.Fields.Item("Municipality").Value.ToString(),
};
lLstContractsFiltersDTO.Add(lObjContracts);
lObjRecordset.MoveNext();
}
}
}
catch (Exception lObjException)
{
LogService.WriteError(string.Format("[ContractsDAO - GetContracts: {0}]", lObjException.Message));
throw new DAOException(lObjException.Message, lObjException);
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
}
return(lLstContractsFiltersDTO);
}
private void AddContract(ContractsFiltersDTO pObjContract)
{
try
{
if (pObjContract == null)
{
return;
}
this.UIAPIRawForm.Freeze(true);
dtContracts.Rows.Add();
dtContracts.SetValue("#", dtContracts.Rows.Count - 1, dtContracts.Rows.Count);
dtContracts.SetValue("DocECont", dtContracts.Rows.Count - 1, pObjContract.DocEntry);
dtContracts.SetValue("DocNCont", dtContracts.Rows.Count - 1, pObjContract.DocNum);
dtContracts.SetValue("Client", dtContracts.Rows.Count - 1, pObjContract.CardName);
dtContracts.SetValue("HrsFt", dtContracts.Rows.Count - 1, pObjContract.HrsFeet);
dtContracts.SetValue("InvExt", dtContracts.Rows.Count - 1, pObjContract.ExtrasInvoices);
dtContracts.SetValue("Import", dtContracts.Rows.Count - 1, pObjContract.Import);
dtContracts.SetValue("RealHrs", dtContracts.Rows.Count - 1, pObjContract.RealHrs);
dtContracts.SetValue("Dif", dtContracts.Rows.Count - 1, pObjContract.Difference);
dtContracts.SetValue("Status", dtContracts.Rows.Count - 1, pObjContract.StatusDescription);
dtContracts.SetValue("MuncpId", dtContracts.Rows.Count - 1, pObjContract.MunicipalityCode);
dtContracts.SetValue("Muncp", dtContracts.Rows.Count - 1, pObjContract.Municipality);
mtxContracts.LoadFromDataSource();
mtxContracts.AutoResizeColumns();
}
catch (Exception lObjException)
{
LogUtility.WriteError(string.Format("[frmRiseSearch - AddContract] Error al agregar el contrato: {0}", lObjException.Message));
throw new Exception(string.Format("Error al agregar el contrato: {0}", lObjException.Message));
}
finally
{
this.UIAPIRawForm.Freeze(false);
}
}
