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 Orcamento(string titulo, DateTime inicial, DateTime final, Predio p, string Descricao = "", int id = -1) { this.Titulo = titulo; this.inicial = inicial; this.final = final; this.p = p; if (!string.IsNullOrEmpty(Descricao)) { this.Descricao = Descricao; } if (id != -1) { this.ID = id; } }
public static List <Predio> get_All_Buildings() { List <Predio> p = new List <Predio>(); SqlCommand cmd = new SqlCommand("SELECT * FROM getAllBuildings();", Database_Connection.cn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Predio P = new Predio(); // These four values can't be null P.ID = Int32.Parse(reader["ID"].ToString()); P.Nome = reader["Nome"].ToString(); P.Latitude = double.Parse(reader["Latitude"].ToString()); P.Longitude = double.Parse(reader["Longitude"].ToString()); // These four attributes can be null if (reader["Morada"] != DBNull.Value) { P.Morada = reader["Morada"].ToString(); } if (reader["Area"] != DBNull.Value) { P.Area = double.Parse(reader["Area"].ToString()); } if (reader["Cidade"] != DBNull.Value) { P.Cidade = reader["Cidade"].ToString(); } if (reader["Codigo_Postal"] != DBNull.Value) { P.Codigo_Postal = reader["Codigo_Postal"].ToString(); } p.Add(P); } reader.Close(); Database_Connection.cn.Close(); return(p); }
public static List <Fracao> getFracoesOfCondomino(Condomino c, Predio p) { List <Fracao> fracoes = new List <Fracao>(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM getFractionsOfCondomino(@CC, @ID_Predio);", Database_Connection.cn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@CC", c.CC); cmd.Parameters.AddWithValue("@ID_Predio", p.ID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Fracao F = new Fracao(); // These values can't be null F.ID = int.Parse(reader["ID"].ToString()); F.Area = double.Parse(reader["Area"].ToString()); F.Tipo = reader["Tipo"].ToString(); F.IDPredio = int.Parse(reader["ID_Predio"].ToString()); F.Piso = int.Parse(reader["Piso"].ToString()); // These values can be null if (reader["Zona"] != DBNull.Value) { F.Zona = reader["Zona"].ToString(); } if (reader["Quota"] != DBNull.Value) { F.Quota = double.Parse(reader["Quota"].ToString()); } fracoes.Add(F); } reader.Close(); Database_Connection.cn.Close(); return(fracoes); }
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 Manutencao(Predio p, DateTime data, string titulo, string Descricao = "", int id = 0, string tipo = "", Outros_Pagamentos op = null) : base(p.ID, data, titulo, Descricao, id) { this.p = p; this.tipo = tipo; this.op = op; }
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); }
public static List <Orcamento> get_Orcamentos(int IDPredio, DateTime final, DateTime initial, Predio p) { List <Orcamento> Orcamentos = new List <Orcamento>(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM getOrcamentoFromBuilding(@ID_Predio, @InitialDate, @FinalDate);", Database_Connection.cn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID_Predio", IDPredio); cmd.Parameters.AddWithValue("@InitialDate", initial); cmd.Parameters.AddWithValue("@FinalDate", final); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DateTime dt_inicial = DateTime.Parse(reader["Data_Inicial"].ToString()); DateTime dt_final = DateTime.Parse(reader["Data_Final"].ToString()); string titulo = reader["Titulo"].ToString(); string desc = ""; if (DBNull.Value != reader["Descricao"]) { desc = reader["Descricao"].ToString(); } int id = int.Parse(reader["ID"].ToString()); Orcamentos.Add(new Orcamento(titulo, dt_inicial, dt_final, p, desc, id)); } reader.Close(); Database_Connection.cn.Close(); return(Orcamentos); }
public static List <QuotaView> getAllQuotas(Predio p, int year) { List <QuotaView> Qvs = new List <QuotaView>(); DateTime dtstart = new DateTime(year, 1, 1); DateTime dtend = new DateTime(year, 12, 31); SqlCommand cmd = new SqlCommand(@"SELECT * FROM getAllQuotasWithinYear(@Predio_ID, @dtstart, @dtend);", Database_Connection.cn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Predio_ID", p.ID); cmd.Parameters.AddWithValue("@dtstart", dtstart); cmd.Parameters.AddWithValue("@dtend", dtend); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { // Check if it already exists. If not, create one. QuotaView search = Qvs.Find(Qv => Qv.Fracao_Id == int.Parse(reader["ID"].ToString())); if (search == null) { Fracao F = new Fracao(); F.ID = int.Parse(reader["ID"].ToString()); F.Area = double.Parse(reader["Area"].ToString()); F.Tipo = reader["Tipo"].ToString(); F.Zona = reader["Zona"].ToString(); F.IDPredio = int.Parse(reader["ID_Predio"].ToString()); F.Piso = int.Parse(reader["Piso"].ToString()); // These values can be null if (reader["Zona"] != DBNull.Value) { F.Zona = reader["Zona"].ToString(); } if (reader["Quota"] != DBNull.Value) { F.Quota = double.Parse(reader["Quota"].ToString()); } search = new QuotaView("", F.ID, F.Piso, F.Zona, F.Tipo, F.Quota); if (reader["Data_Compra"] != DBNull.Value) { search.DateCompra = DateTime.Parse(reader["Data_Compra"].ToString()); } if (reader["Data_Venda"] != DBNull.Value) { search.DateVenda = DateTime.Parse(reader["Data_Venda"].ToString()); } } /* Set the month as payed */ if (DBNull.Value != reader["Mes"]) { if (DateTime.Parse(reader["Mes"].ToString()).Month == 1) { search.Janeiro = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 2) { search.Fevereiro = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 3) { search.Marco = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 4) { search.Abril = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 5) { search.Maio = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 6) { search.Junho = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 7) { search.Julho = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 8) { search.Agosto = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 9) { search.Setembro = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 10) { search.Outubro = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 11) { search.Novembro = true; } else if (DateTime.Parse(reader["Mes"].ToString()).Month == 12) { search.Dezembro = true; } } // Set Condomin to fraction if it exists. if (reader["Nome"] != DBNull.Value) { if (!search.Nome.Contains(reader["Nome"].ToString())) { if (search.Nome == "") { search.Nome = reader["Nome"].ToString(); } else { search.Nome += "/" + reader["Nome"].ToString(); } } } if (Qvs.Find(Qv => Qv.Fracao_Id == int.Parse(reader["ID"].ToString())) == null) { Qvs.Add(search); } } reader.Close(); Database_Connection.cn.Close(); return(Qvs); }