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