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); } }