public List <ContingencyFund> GetTop() { List <ContingencyFund> contingencyFunds = new List <ContingencyFund>(); NpgsqlDataReader reader = null; try { string query = "SELECT * FROM contingency_funds ORDER BY id"; dal.OpenConnection(); reader = dal.ExecuteDataReader(query); while (reader.Read()) { ContingencyFund contingencyFund = new ContingencyFund(); contingencyFund.Id = Convert.ToInt64(reader["id"]); contingencyFund.Name = reader["name"].ToString(); contingencyFunds.Add(contingencyFund); } reader.Close(); } finally { if (reader != null) { reader.Close(); } this.dal.CloseConection(); } return(contingencyFunds); }
/* * Parte relacionada a adição dos códigos de Depto ao contrato */ //private void btnAddDept_Click(object sender, EventArgs e) //{ // string dptCode = this.txtDptCode.Text; // Department dept = _facade.GetDepartmentByCode(dptCode); // if (dept == null) // { // if (DialogResult.Yes == MessageBox.Show("Departamento não encontrado na base de dados, deseja adicioná-lo?", "Adicionar Departamento Novo", // MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)) // { // FrmAddDepartment frmAddDepartment = new FrmAddDepartment(dptCode); // frmAddDepartment.FormClosed += new FormClosedEventHandler(_FormAddDeptClosed); // frmAddDepartment.ShowDialog(); // } // } // else // { // _TryAddingDept(dept); // } //} //private void _TryAddingDept(Department dept) //{ // if (this.allDeptCodes.Add(dept)) // { // ListViewItem item; // item = new ListViewItem(); // item.Text = dept.Code; // item.SubItems.Add(dept.Name); // this.listDepts.Items.Add(item); // this.txtDptCode.Text = ""; // } //} //private void _FormAddDeptClosed (object sender, FormClosedEventArgs e) //{ // FrmAddDepartment frmAddDepartment = (FrmAddDepartment)sender; // _TryAddingDept(frmAddDepartment.Department); //} /* * Parte relacionada a adição das alíquotas ao contrato */ private void btnAddAliquot_Click(object sender, EventArgs e) { try { if (Regex.IsMatch(this.txtAliquotValue.Text, aliqPattern)) { double aliqValue = Convert.ToDouble(this.txtAliquotValue.Text); ContingencyFund cf = this.cbContigencyFunds.SelectedItem as ContingencyFund; ContingencyAliquot contAliq = new ContingencyAliquot(aliqValue, cf); _TryAddingContingencyAliquot(contAliq); } else { MessageBox.Show("A taxa de alíquota inserida deve conter dois dígitos decimais e duas casas decimais separadas por vírgula, exemplo: 10,30%", "Erro de Conversão de Taxa", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (FormatException) { MessageBox.Show("A taxa de alíquota inserida deve ser válida, exemplo: 10,30% ou 8,00%", "Erro de Conversão de Taxa", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OverflowException) { MessageBox.Show("A taxa inserida deve ser entre 00,00 e 99,99%", "Erro de Conversão de Taxa", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Update(ContingencyFund contingencyFund) { try { string rowCount = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_COUNT, contingencyFund.OptionId, contingencyFund.PlannerId)); DataBase.DBService.BeginTransaction(); if (rowCount == "0") { DataBase.DBService.ExecuteCommandString(string.Format(INSERT_CONTINGENCYFUND, contingencyFund.PlannerId, contingencyFund.OptionId, contingencyFund.Amount), true); } else { DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_CONTINGENCYFUND, contingencyFund.Amount, contingencyFund.OptionId, contingencyFund.PlannerId), true); } Activity.ActivitiesService.Add(ActivityType.UpdateCurrentStatusToGoal, EntryStatus.Success, Source.Server, contingencyFund.UpdatedByUserName, "CurrentStatusToGoal", contingencyFund.MachineName); DataBase.DBService.CommitTransaction(); } catch (Exception ex) { DataBase.DBService.RollbackTransaction(); StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); throw ex; } }
public int Insert(ContingencyFund contingencyFund) { //int rowsAffected = -1; object obj = null; int idReturned = -1; try { string cmdInsert = "INSERT INTO contingency_funds(name) VALUES (:name) RETURNING id"; NpgsqlCommand cmd = new NpgsqlCommand(cmdInsert); cmd.Parameters.Add(new NpgsqlParameter("name", NpgsqlTypes.NpgsqlDbType.Text)); cmd.Parameters[0].Value = contingencyFund.Name; dal.OpenConnection(); obj = dal.ExecuteScalar(cmd); if (obj != null) { idReturned = (int)obj; } } finally { this.dal.CloseConection(); } return(idReturned); }
private void btnSaveContingencyFunds_Click(object sender, EventArgs e) { ContingencyFund cf = new ContingencyFund(); if (!String.IsNullOrEmpty(txtContingencyFunds.Text)) { cf.Name = txtContingencyFunds.Text; } try { int retId = _facade.InsertContigencyFund(cf); if (retId > 0) { cf.Id = retId; ListViewItem item; this.contingencyFunds.Add(cf); item = new ListViewItem(); item.Text = cf.Id.ToString(); item.SubItems.Add(cf.Name); this.listContingencyFunds.Items.Add(item); MessageBox.Show("Verba de Contingenciamento " + cf.Name + " cadastrada com sucesso.", "Cadastro de Verbas de Contingenciamento", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Verba de Contingenciamento " + cf.Name + " não retornou um ID de cadastro válido!", "Cadastro de Verbas de Contingenciamento", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("Ocorreu o seguinte erro: " + ex.Message, "Erro no Cadastro da Verba de Contingenciamento", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ContingencyFund Get <K>(K id) { ContingencyFund contingencyFund = new ContingencyFund(); NpgsqlDataReader reader = null; try { string cmdSelect = "SELECT * FROM contingency_funds WHERE id = " + id + " ORDER BY id"; dal.OpenConnection(); reader = dal.ExecuteDataReader(cmdSelect); if (reader.Read()) { contingencyFund.Id = Convert.ToInt64(reader["id"]); contingencyFund.Name = reader["name"].ToString(); } reader.Close(); } finally { if (reader != null) { reader.Close(); } this.dal.CloseConection(); } return(contingencyFund); }
public List <ContingencyAliquot> GetByContract(Contract ct) { List <ContingencyAliquot> contingencyAliquots = new List <ContingencyAliquot>(); NpgsqlDataReader reader = null; try { string selectCMD = "SELECT ca.id as ca_id, ca.value as ca_value, " + "cf.id as cf_id, cf.name as cf_name, ctt.id as ctt_id, ctt.name as ctt_name " + "FROM (contingency_aliquot ca INNER JOIN contingency_funds cf ON (ca.contingency_fund_id = cf.id)) " + "INNER JOIN contracts ctt ON (ca.contract_id = ctt.id) " + "WHERE ca.contract_id = :ctID ORDER BY ca.id"; NpgsqlCommand cmd = new NpgsqlCommand(selectCMD); cmd.Parameters.Add(new NpgsqlParameter("ctID", NpgsqlTypes.NpgsqlDbType.Bigint)); cmd.Parameters[0].Value = ct.Id; Contract contract; ContingencyFund contingencyFund; ContingencyAliquot contingencyAliquot; dal.OpenConnection(); reader = dal.ExecuteDataReader(cmd); while (reader.Read()) { contingencyAliquot = new ContingencyAliquot(); contingencyAliquot.Id = Convert.ToInt64(reader["ca_id"]); contingencyAliquot.Value = Convert.ToDouble(reader["ca_value"]); contract = new Contract(Convert.ToInt64(reader["ctt_id"]), reader["ctt_name"].ToString()); contingencyAliquot.Contract = contract; contingencyFund = new ContingencyFund(Convert.ToInt64(reader["cf_id"]), reader["cf_name"].ToString()); contingencyAliquot.ContingencyFund = contingencyFund; contingencyAliquots.Add(contingencyAliquot); } reader.Close(); } finally { if (reader != null) { reader.Close(); } this.dal.CloseConection(); } return(contingencyAliquots); }
public Result Update(ContingencyFund contingencyFund) { var result = new Result(); try { ContingencyFundSesrvice contingencyFundSesrvice = new ContingencyFundSesrvice(); contingencyFundSesrvice.Update(contingencyFund); result.IsSuccess = true; } catch (Exception exception) { result.IsSuccess = false; result.ExceptionInfo = exception; } return(result); }
public ContingencyFund GetContingencyFund(int operationId, int plannerId) { ContingencyFund contingency = new ContingencyFund(); Logger.LogInfo("Get: Contingency fund process start"); DataTable dtFund = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ID, operationId, plannerId)); foreach (DataRow dr in dtFund.Rows) { contingency.Amount = double.Parse(dr["Amount"].ToString()); contingency.OptionId = dr.Field <int>("OID"); contingency.PlannerId = dr.Field <int>("PID"); contingency.Amount = double.Parse(dr["Amount"].ToString()); } Logger.LogInfo("Get: Contingency fund allocation process completed"); return(contingency); }
public void Update <K>(K id, ContingencyFund contingencyFund) { int rowsAffected = -1; try { NpgsqlCommand cmd = new NpgsqlCommand("UPDATE contingency_funds SET \"name\" = :name" + " WHERE \"id\" = '" + id + "' ;"); cmd.Parameters.Add(new NpgsqlParameter("name", NpgsqlTypes.NpgsqlDbType.Text)); cmd.Parameters[0].Value = contingencyFund.Name; dal.OpenConnection(); rowsAffected = dal.ExecuteNonQuery(cmd); } finally { this.dal.CloseConection(); } }
public HashSet <ContingencyPast> GetContingencyPastsByEmployeeHistoryList(List <EmployeeHistory> employeeHistories, ContingencyFund cf) { HashSet <ContingencyPast> ehContPasts = new HashSet <ContingencyPast>(new ContingencyPastComparer()); NpgsqlDataReader reader = null; try { string selectCMD = "SELECT cp.id as cp_id, cp.monetary_fund_name as cp_monetary_fund_name, cp.calculated_value as cp_calculated_value, " + "eh.id as eh_id, eh.epoch as eh_epoch, eh.base_salary as eh_base_salary, eh.net_salary as eh_net_salary, " + "eh.total_earnings as eh_total_earnings, eh.in_vacation as eh_in_vacation, eh.start_vacation_taken as eh_start_vacation_taken, " + "eh.end_vacation_taken as eh_end_vacation_taken, eh.hazard_additional as eh_hazard_additional, " + "eh.dangerousness_additional as eh_dangerousness_additional, eh.thirteenth_salary as eh_thirteenth_salary, " + "eh.thirteenth_proportional_salary as eh_thirteenth_proportional_salary, eh.vacation_pay as eh_vacation_pay, " + "eh.vacation_proportional_pay as eh_vacation_proportional_pay, eh.penalty_rescission as eh_penalty_rescission, " + "eh.contract_id as eh_contract_id, eh.processed as eh_processed, emp.id as emp_id, emp.name as emp_name, " + "emp.matriculation as emp_matriculation, emp.admission_date as emp_admission_date, emp.birthday as emp_birthday, " + "emp.pis as emp_pis, emp.cpf as emp_cpf, emp.demission_date as emp_demission_date, " + "rol.id as rol_id, rol.name as rol_name, dep.id as dep_id, dep.name as dep_name, dep.code as dep_code, " + "ca.id as ca_id, ca.start_date as ca_start_date, ca.end_date as ca_end_date, ca.value as ca_value, " + "cf.id as cf_id, cf.name as cf_name " + "FROM (contingency_past cp INNER JOIN employee_history eh ON(cp.employee_history_id = eh.id)) " + "INNER JOIN contingency_aliquot ca ON (cp.contingency_aliquot_id = ca.id) " + "INNER JOIN contingency_funds cf ON (ca.contingency_fund_id = cf.id) " + "INNER JOIN employees emp ON (eh.employee_id = emp.id) " + "LEFT JOIN roles rol ON (emp.role_id = rol.id) " + "LEFT JOIN departments dep ON (eh.department_id = dep.id) " + "WHERE eh.employee_id IN "; string empIds = ""; int count = 0; foreach (EmployeeHistory eh in employeeHistories) { empIds += (count == 0) ? eh.Employee.Id.ToString() : "," + eh.Employee.Id.ToString(); count++; } if (String.IsNullOrEmpty(cf.Name)) { selectCMD += "(" + empIds + ") ORDER BY emp.name ASC, eh.epoch;"; } else { selectCMD += "(" + empIds + ") AND cf.name LIKE '" + cf.Name + "' ORDER BY emp.name ASC, eh.epoch;"; } NpgsqlCommand cmd = new NpgsqlCommand(selectCMD); ContingencyPast contingencyPast; dal.OpenConnection(); reader = dal.ExecuteDataReader(cmd); while (reader.Read()) { contingencyPast = new ContingencyPast(); contingencyPast.Id = Convert.ToInt64(reader["cp_id"]); contingencyPast.MonetaryFundName = reader["cp_monetary_fund_name"].ToString(); contingencyPast.EmployeeHistory = new EmployeeHistory(Convert.ToInt64(reader["eh_id"])); if (ehContPasts.Add(contingencyPast)) { contingencyPast.ContingencyAliquots.Add(new ContingencyAliquot(Convert.ToInt64(reader["ca_id"]), Convert.ToDouble(reader["ca_value"]), new ContingencyFund(Convert.ToInt64(reader["cf_id"]), reader["cf_name"].ToString()), Convert.ToDouble(reader["cp_calculated_value"]))); contingencyPast.EmployeeHistory.Epoch = Convert.ToDateTime(reader["eh_epoch"]); contingencyPast.EmployeeHistory.StartVacationTaken = Convert.ToDateTime(reader["eh_start_vacation_taken"]); contingencyPast.EmployeeHistory.EndVacationTaken = Convert.ToDateTime(reader["eh_end_vacation_taken"]); contingencyPast.EmployeeHistory.InVacation = Convert.ToBoolean(reader["eh_in_vacation"]); contingencyPast.EmployeeHistory.BaseSalary = Convert.ToDouble(reader["eh_base_salary"]); contingencyPast.EmployeeHistory.NetSalary = Convert.ToDouble(reader["eh_net_salary"]); contingencyPast.EmployeeHistory.TotalEarnings = Convert.ToDouble(reader["eh_total_earnings"]); contingencyPast.EmployeeHistory.HazardAdditional = Convert.ToDouble(reader["eh_hazard_additional"]); contingencyPast.EmployeeHistory.DangerousnessAdditional = Convert.ToDouble(reader["eh_dangerousness_additional"]); contingencyPast.EmployeeHistory.ThirteenthSalary = Convert.ToDouble(reader["eh_thirteenth_salary"]); contingencyPast.EmployeeHistory.ThirteenthProportionalSalary = Convert.ToDouble(reader["eh_thirteenth_proportional_salary"]); contingencyPast.EmployeeHistory.VacationPay = Convert.ToDouble(reader["eh_vacation_pay"]); contingencyPast.EmployeeHistory.VacationProportionalPay = Convert.ToDouble(reader["eh_vacation_proportional_pay"]); contingencyPast.EmployeeHistory.PenaltyRescission = Convert.ToDouble(reader["eh_penalty_rescission"]); contingencyPast.EmployeeHistory.Processed = Convert.ToBoolean(reader["eh_processed"]); if (!(reader["emp_id"] is DBNull)) { Employee employee = new Employee(); employee.Id = Convert.ToInt64(reader["emp_id"]); employee.Name = reader["emp_name"].ToString(); employee.Matriculation = reader["emp_matriculation"].ToString(); employee.Birthday = Convert.ToDateTime(reader["emp_birthday"]); employee.CurrentAdmissionDate = Convert.ToDateTime(reader["emp_admission_date"]); employee.CurrentDemissionDate = Convert.ToDateTime(reader["emp_demission_date"]); employee.PIS = reader["emp_pis"].ToString(); employee.CPF = reader["emp_cpf"].ToString(); if (!(reader["rol_id"] is DBNull)) { Role role = new Role(); role.Id = Convert.ToInt64(reader["rol_id"]); role.Name = reader["rol_name"].ToString(); employee.Role = role; } contingencyPast.EmployeeHistory.Employee = employee; } if (!(reader["dep_id"] is DBNull)) { Department department = new Department(); department.Id = Convert.ToInt64(reader["dep_id"]); department.Name = reader["dep_name"].ToString(); department.Code = reader["dep_code"].ToString(); contingencyPast.EmployeeHistory.Department = department; } } else { foreach (ContingencyPast cp in ehContPasts) { if (cp.EmployeeHistory.Id == contingencyPast.EmployeeHistory.Id) { cp.ContingencyAliquots.Add(new ContingencyAliquot(Convert.ToInt64(reader["ca_id"]), Convert.ToDouble(reader["ca_value"]), new ContingencyFund(Convert.ToInt64(reader["cf_id"]), reader["cf_name"].ToString()), Convert.ToDouble(reader["cp_calculated_value"]))); } } } } reader.Close(); } finally { if (reader != null) { reader.Close(); } this.dal.CloseConection(); } return(ehContPasts); }
public HashSet <ContingencyPast> GetContingencyPastsByEmployeeHistoryList(List <EmployeeHistory> employeeHistories, ContingencyFund cf) { HashSet <ContingencyPast> allContingencyPasts = this._contingencyPastDAO.GetContingencyPastsByEmployeeHistoryList(employeeHistories, cf); HashSet <ContingencyPast> hsContingencyPasts = new HashSet <ContingencyPast>(); DateTime dtEpoch; int value1; int value2; foreach (ContingencyPast cp in allContingencyPasts) { dtEpoch = cp.EmployeeHistory.Epoch; foreach (EmployeeHistory eh in employeeHistories) { if (cp.EmployeeHistory.Employee.Id == eh.Employee.Id) { value1 = DateTime.Compare(dtEpoch, eh.StartVacationTaken); value2 = DateTime.Compare(dtEpoch, eh.EndVacationTaken); if (value1 >= 0 && value2 <= 0) { hsContingencyPasts.Add(cp); } } } } // List<ContingencyPast> hsContingencyPastsCopy = new List<ContingencyPast>(hsContingencyPasts); HashSet <ContingencyPast> toRemove = new HashSet <ContingencyPast>(); foreach (ContingencyPast contPast in hsContingencyPasts) { foreach (ContingencyPast contPast2 in hsContingencyPasts) { if (contPast.EmployeeHistory.Employee.Id == contPast2.EmployeeHistory.Employee.Id) { if (contPast.EmployeeHistory.Epoch.CompareTo(contPast2.EmployeeHistory.Epoch) == 0) { if (contPast.EmployeeHistory.InVacation != contPast.EmployeeHistory.InVacation) { bool had = false; foreach (ContingencyPast cpR in toRemove) { if (contPast.EmployeeHistory.Employee.Id == cpR.EmployeeHistory.Id && contPast.EmployeeHistory.Epoch.CompareTo(cpR.EmployeeHistory.Epoch) == 0) { had = true; break; } } if (!had) { toRemove.Add(contPast); } } } } } } foreach (ContingencyPast cp in toRemove) { hsContingencyPasts.Remove(cp); } return(hsContingencyPasts); }
//public Contract GetByName<K>(K name) //{ // Contract contract = new Contract(); // NpgsqlDataReader reader = null; // try // { // string SELECTCMD = "SELECT * FROM contracts WHERE matricula = '" + name + "'"; // dal.OpenConnection(); // reader = dal.ExecuteDataReader(SELECTCMD); // if (reader.Read()) // { // contract.Id = Convert.ToInt64(reader["id"]); // contract.Name = reader["name"].ToString(); // contract.Matriculation = reader["matriculation"].ToString(); // contract.Birthday = Convert.ToDateTime(reader["birthday"]); // contract.CurrentStartDate = Convert.ToDateTime(reader["start_date"]); // contract.CurrentEndDate = Convert.ToDateTime(reader["end_date"]); // contract.PIS = reader["pis"].ToString(); // contract.CPF = reader["cpf"].ToString(); // } // reader.Close(); // } // finally // { // if (reader != null) // { // reader.Close(); // } // this.dal.CloseConection(); // } // return contract; //} public List <Contract> GetTop() { List <Contract> contracts = new List <Contract>(); Contract contract = null; //List<Department> departments = new List<Department>(); HashSet <MonetaryFund> monetaryFunds = new HashSet <MonetaryFund>(new MonetaryFundComparer()); List <ContingencyAliquot> contingencyAliquots = new List <ContingencyAliquot>(); NpgsqlDataReader reader = null; try { NpgsqlCommand cmd; string selectCMD = "SELECT * FROM contracts"; cmd = new NpgsqlCommand(selectCMD); dal.OpenConnection(); reader = dal.ExecuteDataReader(cmd); while (reader.Read()) { contract = new Contract(); contract.Id = Convert.ToInt64(reader["id"]); contract.Name = reader["name"].ToString(); contract.Description = reader["description"].ToString(); contract.Balance = Convert.ToDouble(reader["balance"]); if (reader["start_date"] is DBNull) { contract.StartDate = DateTime.MinValue; } else { contract.StartDate = Convert.ToDateTime(reader["start_date"]); } if (reader["end_date"] is DBNull) { contract.EndDate = DateTime.MinValue; } else { contract.EndDate = Convert.ToDateTime(reader["end_date"]); } contracts.Add(contract); } reader.Close(); //Department department; MonetaryFund monetaryFund; ExtraFund extraFund; ContingencyAliquot contingencyAliquot; ContingencyFund contingencyFund; string selectMonetaryFundsCMD = "SELECT c.id as c_id, c.name as c_name, c.start_date as c_start_date, c.end_date as c_end_date, " + "cmf.id as cmf_id, cmf.contract_id as cmf_contract_id, cmf.monetary_fund_id as cmf_monetary_fund_id, " + "mf.id as mf_id, mf.name as mf_name, mf.primal as mf_primal, " + "ef.id as ef_id, ef.name as ef_name " + "FROM (contracts c INNER JOIN contract_monetary_funds cmf ON " + "(c.id = cmf.contract_id)) " + "INNER JOIN monetary_funds mf ON (cmf.monetary_fund_id = mf.id) " + "LEFT JOIN extra_funds ef ON (cmf.extra_fund_id = ef.id) " + "WHERE c.id = :passedId ORDER BY c.id"; string selectContAliquotCMD = "SELECT c.id as c_id, c.name as c_name, c.start_date as c_start_date, c.end_date as c_end_date, " + "ca.id as ca_id, ca.start_date as ca_start_date, ca.end_date as ca_end_date, ca.value as ca_value, " + "cf.id as cf_id, cf.name as cf_name FROM (contracts c INNER JOIN contingency_aliquot ca ON " + "(c.id = ca.contract_id)) " + "LEFT JOIN contingency_funds cf ON (ca.contingency_fund_id = cf.id) " + "WHERE c.id = :passedId ORDER BY c.id"; cmd.Parameters.Add(new NpgsqlParameter("passedId", NpgsqlTypes.NpgsqlDbType.Bigint)); foreach (Contract ct in contracts) { //Consultar as verbas monetárias do contrato cmd.CommandText = selectMonetaryFundsCMD; cmd.Parameters[0].Value = ct.Id; monetaryFunds = new HashSet <MonetaryFund>(new MonetaryFundComparer()); contingencyAliquots = new List <ContingencyAliquot>(); reader = dal.ExecuteDataReader(cmd); long currentMFId = 0; while (reader.Read()) { currentMFId = Convert.ToInt64(reader["mf_id"]); if (reader["ef_id"] is DBNull && reader["ef_name"] is DBNull) { monetaryFund = new MonetaryFund(Convert.ToInt64(reader["mf_id"]), reader["mf_name"].ToString()); monetaryFunds.Add(monetaryFund); } else { extraFund = new ExtraFund(Convert.ToInt64(reader["ef_id"]), reader["ef_name"].ToString()); monetaryFund = new MonetaryFund(Convert.ToInt64(reader["mf_id"]), reader["mf_name"].ToString()); if (monetaryFunds.Add(monetaryFund)) { monetaryFund.ExtraFunds.Add(extraFund); } else { foreach (MonetaryFund mf in monetaryFunds) { if (mf.Id == currentMFId) { mf.ExtraFunds.Add(extraFund); } } } } } reader.Close(); ct.MonetaryFunds = new List <MonetaryFund>(monetaryFunds); //Consultar as alíquotas do contrato cmd.CommandText = selectContAliquotCMD; reader = dal.ExecuteDataReader(cmd); while (reader.Read()) { contingencyFund = new ContingencyFund(Convert.ToInt64(reader["cf_id"]), reader["cf_name"].ToString()); contingencyAliquot = new ContingencyAliquot(Convert.ToInt64(reader["ca_id"]), Convert.ToDouble(reader["ca_value"]), Convert.ToDateTime(reader["ca_start_date"]), Convert.ToDateTime(reader["ca_end_date"]), contingencyFund); contingencyAliquots.Add(contingencyAliquot); } reader.Close(); ct.ContingencyAliquot = contingencyAliquots; } } finally { if (reader != null) { reader.Close(); } this.dal.CloseConection(); } return(contracts); }
public int InsertContigencyFund(ContingencyFund contingencyFund) { return(this._contingencyFundDAO.Insert(contingencyFund)); }
public void UpdateContigencyFund(int id, ContingencyFund contingencyFund) { this._contingencyFundDAO.Update <int>(id, contingencyFund); }