public Compra(Fracao f, Condomino c, DateTime Data_Compra, DateTime Data_Venda) { this.f = f; this.c = c; this._Data_Compra = Data_Compra; this._Data_Venda = Data_Venda; }
public static Fracao getFracaoByID(int ID) { SqlCommand cmd = new SqlCommand("Select * FROM getFractionByID(@ID);", Database_Connection.cn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID", ID); SqlDataReader reader = cmd.ExecuteReader(); Fracao F = new Fracao(); while (reader.Read()) { // 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.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()); } } reader.Close(); Database_Connection.cn.Close(); return(F); }
public CondominoQuotaView(Fracao f, Condomino c, bool pay, DateTime compra) { this.c = c; this.pay = pay; this.f = f; this.compra = compra; }
public Compra(int ID, Fracao f, Condomino c, DateTime Data_Compra) { this.ID = ID; this.f = f; this.c = c; this._Data_Compra = Data_Compra; this._Data_Venda = DateTime.MaxValue; }
public static List<Pagamentos_Quota> get_Quotas(int IDPredio, DateTime final, DateTime initial) { List<Pagamentos_Quota> Ts = new List<Pagamentos_Quota>(); List<Fracao> fr = new List<Fracao>(); SqlCommand cmd = new SqlCommand(@" SELECT * FROM getQuotasOfBuilding(@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()) { Fracao F = new Fracao(); // These values can't be null F.ID = int.Parse(reader["ID_Fracao"].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()); DateTime dt = DateTime.Parse(reader["Data"].ToString()); double Balanco = double.Parse(reader["Balanco"].ToString()); int id = int.Parse(reader["PID"].ToString()); DateTime mes = DateTime.Parse(reader["Mes"].ToString()); fr.Add(F); Ts.Add(new Pagamentos_Quota(dt, Balanco, F, mes, id)); } reader.Close(); Database_Connection.cn.Close(); for(int i=0; i<Ts.Count; i++) { if(fr[i].CurrentCondomino!=null) Ts[i].Entidade = fr[i].CurrentCondomino.Nome; } return Ts; }
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 Pagamentos_Quota(DateTime dt, double balanco, Fracao f, DateTime mes, int ID=-1) : base(dt, balanco, ID, "", "Quota "+mes.ToString("MM/yy")) { this.f = f; this.mes = mes; }
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); }
public static List <CondominoQuotaView> get_All_Current_Condominos(int IDPredio) { DateTime dtstart = new DateTime(DateTime.Now.Year, DateTime.Now.AddMonths(-1).Month, 1); DateTime dtend = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 30); List <CondominoQuotaView> condominos = new List <CondominoQuotaView>(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM getCurrentCondominosQuotasAndFracoes(@ID_Predio, @dtstart, @dtend);", Database_Connection.cn); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID_Predio", IDPredio); cmd.Parameters.AddWithValue("@dtstart", dtstart); cmd.Parameters.AddWithValue("@dtend", dtend); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Fracao F = new Fracao(); DateTime compra; compra = DateTime.Parse(reader["Data_Compra"].ToString()); // 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()); } Condomino c = new Condomino(); // These values can't be null c.Nome = reader["Nome"].ToString(); c.CC = reader["CC"].ToString(); c.NIF = reader["NIF"].ToString(); // These values can be null if (reader["E_mail"] != DBNull.Value) { c.Email = reader["E_mail"].ToString(); } bool payed = !string.IsNullOrEmpty(reader["Mes"].ToString()); condominos.Add(new CondominoQuotaView(F, c, payed, compra)); } reader.Close(); Database_Connection.cn.Close(); return(condominos); }