public Outros_Pagamentos(DateTime dt, double balanco, Predio p, Sujeito_Fiscal sf, string desc = "", int ID = -1) : base(dt, balanco, ID, sf.nome, desc) { this.p = p; this.sf = sf; if (!string.IsNullOrEmpty(desc)) { this.descricao = desc; } }
public static List <Outros_Pagamentos> get_OutrosPagamentos(Predio P, DateTime final, DateTime initial) { List <Outros_Pagamentos> Ts = new List <Outros_Pagamentos>(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM getOutrosPagamentos(@ID_Predio, @InitialDate, @FinalDate);", Database_Connection.cn); cmd.Parameters.AddWithValue("@ID_Predio", P.ID); cmd.Parameters.AddWithValue("@InitialDate", initial); cmd.Parameters.AddWithValue("@FinalDate", final); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string NIF = reader["NIF"].ToString(); string nome = reader["Nome"].ToString(); string e_mail = ""; string morada = ""; if (reader["E_mail"] != DBNull.Value) { e_mail = reader["E_mail"].ToString(); } if (reader["Morada"] != DBNull.Value) { morada = reader["Morada"].ToString(); } Sujeito_Fiscal suj = new Sujeito_Fiscal(NIF, nome, e_mail, morada); int ID = int.Parse(reader["OID"].ToString()); DateTime dt = DateTime.Parse(reader["Data"].ToString()); double Balanco = double.Parse(reader["Balanco"].ToString()); string desc = reader["descricao"].ToString(); Ts.Add(new Outros_Pagamentos(dt, Balanco, P, suj, desc, ID)); } reader.Close(); Database_Connection.cn.Close(); return(Ts); }
public static List <Manutencao> get_Manutencoes(Predio p, DateTime final, DateTime initial) { List <Manutencao> Rs = new List <Manutencao>(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM getAllManutencoesAndPaymentsOfBuilding(@ID_Predio, @InitialDate, @FinalDate);", Database_Connection.cn); cmd.Parameters.AddWithValue("@ID_Predio", p.ID); cmd.Parameters.AddWithValue("@InitialDate", initial); cmd.Parameters.AddWithValue("@FinalDate", final); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Sujeito_Fiscal sj; Outros_Pagamentos op = null; if (DBNull.Value != reader["Id_Outros_Pagamentos"]) { string Morada = ""; string Email = ""; string NIF = reader["NIF"].ToString(); string Nome = reader["Nome"].ToString(); if (reader["Morada"] != DBNull.Value) { Morada = reader["Morada"].ToString(); } if (reader["e_mail"] != DBNull.Value) { Email = reader["e_mail"].ToString(); } sj = new Sujeito_Fiscal(NIF, Nome, Email, Morada); int id_outros_pag = int.Parse(reader["Id_Outros_Pagamentos"].ToString()); DateTime OData = DateTime.Parse(reader["OData"].ToString()); double balanco = double.Parse(reader["Balanco"].ToString()); string ODescricao = ""; if (DBNull.Value != reader["ODescricao"]) { ODescricao = reader["ODescricao"].ToString(); } op = new Outros_Pagamentos(OData, balanco, p, sj, ODescricao, id_outros_pag); } DateTime dt = DateTime.Parse(reader["MData"].ToString()); string titulo = reader["Titulo"].ToString(); string desc = ""; string tipo = ""; if (DBNull.Value != reader["MDescricao"]) { desc = reader["MDescricao"].ToString(); } if (DBNull.Value != reader["Tipo"]) { tipo = reader["Tipo"].ToString(); } int id = int.Parse(reader["MID"].ToString()); Rs.Add(new Manutencao(p, dt, titulo, desc, id, tipo, op)); } reader.Close(); Database_Connection.cn.Close(); return(Rs); }