protected void LoadAnimals(UInt32 ClientID)
{
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT * FROM dbo.ANIMAL WHERE IDCLIENTE='{0}'", ClientID);
DataTable temp;
DataTable temp2;
String photoPath = null;
temp = db.GetDataTable(query);
if (temp.Rows.Count < 1)
{
Response.Write("<div class='col-md-4'>");
Response.Write("<h2>Não existem animais</h2>");
Response.Write("<p>Pretende <a href='NewAnimal'>adicionar</a> um novo animal ?</p>");
Response.Write("</div>");
return;
}
foreach (DataRow r in temp.Rows)
{
query = String.Format("SELECT * FROM dbo.FOTOS WHERE IDANIMAL='{0}'", r["IDANIMAL"].ToString());
temp2 = db.GetDataTable(query);
foreach (DataRow x in temp2.Rows)
{
photoPath = x["URL"].ToString();
break;
}
Animal.DrawAnimal(Response, photoPath, r["NOME"].ToString(), r["RACA"].ToString(), Convert.ToUInt32(r["IDADE"].ToString()), Convert.ToUInt32(r["IDANIMAL"].ToString()));
}
}
public static String RegisterConsult(String data, UInt32 idAnimal, UInt32 urgencia, String morada, UInt32 idCliente, String obs = "")
{
db = new SQLDatabaseManager();
String query = String.Format("SELECT * FROM dbo.MARCACAO WHERE DATA = '{0}'", data);
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count > 0)
{
return("Já existe uma marcação nessa hora.");
}
Dictionary <String, String> InsertData = new Dictionary <String, String>()
{
{ "DATA", data },
{ "LOCAL", morada },
{ "URGENCIA", Convert.ToString(urgencia) },
{ "IDCLIENTE", Convert.ToString(idCliente) },
{ "IDANIMAL", Convert.ToString(idAnimal) },
{ "ESTADO", "0" },
{ "OBSERVACOES", obs }
};
if (db.Insert("dbo.MARCACAO", InsertData))
{
return("Marcação efectuada com sucesso.");
}
else
{
return("Erro ao efectuar marcação.");
}
}
public static void FillPaymentFields(String PaymentID, TextBox Data, TextBox Metodo, TextBox Montante, TextBox Movimentacao, TextBox Estado)
{
db = new SQLDatabaseManager();
String query = String.Format("UPDATE dbo.PAGAMENTO SET ESTADO='1'WHERE IDPAGAMENTO='{0}'", PaymentID);
db.ExecuteNonQuery(query);
query = String.Format("UPDATE dbo.MARCACAO SET ESTADO='4' WHERE IDPAGAMENTO='{0}'", PaymentID);
db.ExecuteNonQuery(query);
query = String.Format("SELECT * FROM dbo.PAGAMENTO WHERE IDPAGAMENTO='{0}'", PaymentID);
DataTable temp;
temp = db.GetDataTable(query);
foreach (DataRow r in temp.Rows)
{
Data.Text = r["DATA_LIMITE"].ToString();
Metodo.Text = r["METODO"].ToString();
Movimentacao.Text = r["NUMEROMOVIMENTACAO"].ToString();
Montante.Text = r["MONTANTE"].ToString();
if (r["ESTADO"].ToString() == "0")
{
Estado.Text = "Falta pagar";
}
else
{
Estado.Text = "Pago";
}
break;
}
}
public static void LoadAnimals(DropDownList AnimalList, UInt32 ClientID)
{
db = new SQLDatabaseManager();
DataTable temp;
temp = db.GetDataTable("SELECT IDANIMAL, NOME FROM dbo.ANIMAL WHERE IDCLIENTE='" + ClientID + "'");
AnimalList.DataSource = temp;
AnimalList.DataTextField = temp.Columns["NOME"].ToString();
AnimalList.DataValueField = temp.Columns["IDANIMAL"].ToString();
AnimalList.DataBind();
}
public Boolean checkValid()
{
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT Status, IDVoluntario FROM VOluntario WHERE UserId='{0}'", userID);
DataTable dt;
dt = db.GetDataTable(query);
if (dt.Rows[0]["Status"].ToString().Equals("Aguarda") || dt.Rows[0]["Status"].ToString().Equals("Rejeitado"))
{
return(false);
}
return(true);
}
public int getIDVolunt()
{
int id;
SQLDatabaseManager db = new SQLDatabaseManager();
DataTable dt;
String query = String.Format("SELECT IDVoluntario FROM Voluntario WHERE UserId='{0}'", userID);
dt = db.GetDataTable(query);
id = Convert.ToInt32(dt.Rows[0]["IDVoluntario"].ToString());
return(id);
}
public int getIDIdoso(int idc, String nome)
{
int id;
SQLDatabaseManager db = new SQLDatabaseManager();
DataTable dt;
String query = String.Format("SELECT IDIdoso FROM Idoso WHERE (IDCliente='{0}' AND Nome='{1}')", idc, nome);
dt = db.GetDataTable(query);
id = Convert.ToInt32(dt.Rows[0]["IDIdoso"].ToString());
return(id);
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT [Nome], [Morada], [Email], [DataNasc], [Contactos], [Disponibilidade], [Status], [Habilitacoes] FROM [Voluntario] WHERE UserId='{0}'", user.ProviderUserKey.ToString());
DataTable temp;
temp = db.GetDataTable(query);
FormView1.DataSource = temp;
FormView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT [Email], [Morada], [Nome], [Contacto], [UserId] FROM [Admin] WHERE UserId='{0}'", user.ProviderUserKey.ToString());
DataTable temp;
temp = db.GetDataTable(query);
FormView1.DataSource = temp;
FormView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT I.Nome, I.Morada, I.Contacto, S.Servico, S.Notas, S.Horario, S.Status, V.Nome AS Vnome, V.Contactos From Idoso I, Servico S, Voluntario V WHERE S.IDCliente=I.IDCliente AND V.IDVoluntario=S.IDVoluntario AND I.IDIdoso=S.IDIdoso AND S.IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
GridView1.DataSource = temp;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT Nome, Morada, Contacto, DataNasc, Condicoes FROM Idoso WHERE IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
GridView1.DataSource = temp;
GridView1.DataBind();
}
public static void LoadConsultas(UInt32 IDClient, HttpResponse Response)
{
db = new SQLDatabaseManager();
String query = String.Format("SELECT * FROM dbo.MARCACAO WHERE IDCLIENTE='{0}' AND ESTADO<>'2'", IDClient);
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count == 0)
{
Response.Write("Não existem consultas agendadas.");
return;
}
}
public static Boolean isValidOwner(WebsiteUser obj, UInt32 AnimalID)
{
db = new SQLDatabaseManager();
String query = "SELECT * FROM dbo.ANIMAL WHERE IDCLIENTE='" + obj.ClientID + "' AND IDANIMAL='" + AnimalID + "'";
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static Boolean Exists(UInt32 AnimalID)
{
db = new SQLDatabaseManager();
String query = "SELECT NOME FROM dbo.ANIMAL WHERE IDANIMAL='" + AnimalID + "'";
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static Boolean PaymentExists(String PaymentID)
{
db = new SQLDatabaseManager();
String query = "SELECT IDPAGAMENTO FROM dbo.PAGAMENTO WHERE IDPAGAMENTO='" + PaymentID + "'";
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static void LoadPayments(WebsiteUser Obj, HttpResponse Response)
{
String query = String.Format("SELECT * FROM dbo.PAGAMENTO WHERE IDCLIENTE='{0}'", Obj.ClientID);
DataTable temp;
temp = db.GetDataTable(query);
foreach (DataRow r in temp.Rows)
{
Response.Write("<div class='col-md-4'>");
Response.Write("<h4><u>Data: </u> " + r["DATA_LIMITE"].ToString().Remove(11) + "</h4>");
Response.Write("<p><a class='btn btn-default' href='\\Account\\Payments\\Payment?PaymentID=" + r["IDPAGAMENTO"].ToString() + "'>Detalhes »</a></p>");
Response.Write("</div>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT IDVoluntario, Nome, Status From Voluntario WHERE IDVoluntario<>15 AND Status='Aguarda'");
DataTable temp;
temp = db.GetDataTable(query);
DropDownList1.DataValueField = "IDVoluntario";
DropDownList1.DataTextField = "Nome";
DropDownList1.DataSource = temp;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Escolha um Voluntário.");
}
}
public static String Id2Name(UInt32 AnimalID)
{
db = new SQLDatabaseManager();
String query = "SELECT NOME FROM dbo.ANIMAL WHERE IDANIMAL='" + AnimalID + "'";
DataTable temp;
temp = db.GetDataTable(query);
foreach (DataRow r in temp.Rows)
{
return(r["NOME"].ToString());
}
return(null);
}
public static UInt32 Add(Animal obj)
{
db = new SQLDatabaseManager();
Dictionary <String, String> Data = new Dictionary <String, String>
{
{ "NOME", obj.Name },
{ "ESPECIE", obj.Species },
{ "RACA", obj.Race },
{ "IDADE", Convert.ToString(obj.Age) },
{ "PESO", Convert.ToString(obj.Weight) },
{ "TEMPERATURA", Convert.ToString(obj.Temperature) },
{ "IDCLIENTE", Convert.ToString(obj.OwnerID) },
{ "TIPO", Convert.ToString(obj.Type) }
};
if (db.Insert("dbo.ANIMAL", Data))
{
String query = String.Format("SELECT IDANIMAL FROM dbo.ANIMAL WHERE NOME='{0}' AND ESPECIE='{1}' AND RACA='{2}' AND IDADE='{3}' AND PESO='{4}' AND TEMPERATURA='{5}' AND IDCLIENTE='{6}'",
obj.Name, obj.Species, obj.Race, obj.Age, obj.Weight, obj.Temperature, obj.OwnerID);
DataTable temp;
temp = db.GetDataTable(query);
String LastInsertID = null;
foreach (DataRow r in temp.Rows)
{
LastInsertID = r["IDANIMAL"].ToString();
break;
}
Data = new Dictionary <String, String>
{
{ "URL", obj._photopath },
{ "IDANIMAL", LastInsertID }
};
if (db.Insert("dbo.FOTOS", Data))
{
return(2);
}
return(1);
}
return(0);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT Nome, Morada, DataNasc, Email, Contactos FROM Cliente WHERE UserID='{0}'", user.ProviderUserKey.ToString());
DataTable temp;
temp = db.GetDataTable(query);
tnome.Text = temp.Rows[0]["Nome"].ToString();
tmorada.Text = temp.Rows[0]["Morada"].ToString();
tdata.Text = temp.Rows[0]["DataNasc"].ToString();
temail.Text = temp.Rows[0]["Email"].ToString();
tcontactos.Text = temp.Rows[0]["Contactos"].ToString();
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Confirm.Enabled = true;
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT Nome, Morada, DataNasc, Contacto, Condicoes FROM Idoso WHERE IDIdoso='{0}'", DropDownList1.SelectedValue);
DataTable temp;
temp = db.GetDataTable(query);
tnome.Text = temp.Rows[0]["Nome"].ToString();
tmorada.Text = temp.Rows[0]["Morada"].ToString();
tdata.Text = temp.Rows[0]["DataNasc"].ToString();
tcondicoes.Text = temp.Rows[0]["condicoes"].ToString();
tcontacto.Text = temp.Rows[0]["Contacto"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT IDIdoso, Nome From Idoso WHERE IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
DropDownList1.DataValueField = "IDIdoso";
DropDownList1.DataTextField = "Nome";
DropDownList1.DataSource = temp;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Escolha um idoso.");
}
}
public static String UseVehicle(UInt32 idMarcacao, UInt32 idVet, ref GridViewUpdateEventArgs e)
{
db = new SQLDatabaseManager();
String query = String.Format("SELECT * FROM dbo.VEICULOS WHERE EMUSO = '0'");
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count == 0)
{
e.Cancel = true;
return("Não existem veículos disponíveis.");
}
UInt32 avaiableCar = 0;
foreach (DataRow r in temp.Rows)
{
avaiableCar = Convert.ToUInt32(r["IDVEICULO"].ToString());
break;
}
query = String.Format("UPDATE dbo.VEICULOS SET EMUSO='{0}' WHERE IDVEICULO='{1}'", idMarcacao, avaiableCar);
if (db.ExecuteNonQuery(query) < 1)
{
e.Cancel = true;
return("Erro Desconhecido");
}
query = String.Format("UPDATE dbo.MARCACAO SET IDVEICULO='{0}', IDVETERINARIO='{1}' WHERE IDMARCACAO='{2}'", avaiableCar, idVet, idMarcacao);
if (db.ExecuteNonQuery(query) < 1)
{
e.Cancel = true;
return("Erro Desconhecido");
}
return("Foi atribuido com sucesso à consulta Nº " + idMarcacao);
}
public static void LoadSimpleList(UInt32 OwnerID, HttpResponse Response)
{
db = new SQLDatabaseManager();
String query = "SELECT * FROM dbo.ANIMAL WHERE IDCLIENTE='" + OwnerID + "'";
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count < 1)
{
return;
}
foreach (DataRow r in temp.Rows)
{
Response.Write("<p> » <a href='\\Animal\\Animal?AnimalID=" + r["IDANIMAL"].ToString() + "'>" + r["NOME"].ToString() + "</a></p>");
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedIndex.Equals(0))
{
FormView1.DataSource = null;
FormView1.DataBind();
}
else
{
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT [Nome], [Morada], [Email], [DataNasc], [Contactos], [Disponibilidade], [Status], [Habilitacoes] FROM [Voluntario] WHERE IDVoluntario='{0}'", DropDownList1.SelectedValue);
DataTable temp;
temp = db.GetDataTable(query);
FormView1.DataSource = temp;
FormView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT S.IDServico, S.Servico, I.Nome From Servico S, Idoso I WHERE I.IDIdoso=S.IDIdoso AND S.IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
temp.Columns.Add("NomeServico", typeof(string), "Nome + ' - ' + Servico");
DropDownList1.DataValueField = "IDServico";
DropDownList1.DataTextField = "NomeServico";
DropDownList1.DataSource = temp;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Escolha o serviço a remover.");
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string value = e.Row.Cells[1].Text;
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT NOME FROM dbo.MEDICAMENTOS WHERE IDMEDICAMENTO='{0}'", value);
DataTable temp;
temp = db.GetDataTable(query);
foreach (DataRow r in temp.Rows)
{
e.Row.Cells[1].Text = r["NOME"].ToString();
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
if (!c.checkValid())
{
Response.Redirect("~/Volunts/Offlimits.aspx");
}
int id = c.getIDVolunt();
String query = String.Format("Select I.Nome, I.Morada, I.Contacto, I.Condicoes, S.Servico, S.Notas, S.Horario, S.Status, S.IDServico, S.IDVoluntario FROM Idoso I, Servico S, Voluntario V WHERE S.IDIdoso=I.IDIdoso AND S.IDVoluntario=V.IDVoluntario AND (S.IDVoluntario='15' OR S.IDVoluntario='{0}')", id);
DataTable temp;
temp = db.GetDataTable(query);
GridView1.DataSource = temp;
GridView1.DataBind();
}
}
public static Boolean LoadAnimalsInProgress(DropDownList AnimalList)
{
db = new SQLDatabaseManager();
String query = String.Format("SELECT dbo.ANIMAL.NOME, dbo.ANIMAL.IDANIMAL FROM dbo.ANIMAL, dbo.MARCACAO WHERE dbo.MARCACAO.ESTADO='3' AND dbo.MARCACAO.IDANIMAL=dbo.ANIMAL.IDANIMAL");
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count == 0)
{
return(false);
}
AnimalList.DataSource = temp;
AnimalList.DataTextField = temp.Columns["NOME"].ToString();
AnimalList.DataValueField = temp.Columns["IDANIMAL"].ToString();
AnimalList.DataBind();
return(true);
}
public static Boolean LoadDrugs(DropDownList DrugsList)
{
db = new SQLDatabaseManager();
String query = String.Format("SELECT NOME, IDMEDICAMENTO FROM dbo.MEDICAMENTOS WHERE DOSE>0");
DataTable temp;
temp = db.GetDataTable(query);
if (temp.Rows.Count == 0)
{
return(false);
}
DrugsList.DataSource = temp;
DrugsList.DataTextField = temp.Columns["NOME"].ToString();
DrugsList.DataValueField = temp.Columns["IDMEDICAMENTO"].ToString();
DrugsList.Items.Add("Nenhum medicamento");
DrugsList.DataBind();
return(true);
}
