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