public static TicketConvite getTicketConvite(int ticket_ID)
{
SqlConnection conn = new SqlConnection(DBHelper.ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = "getTicketConvite";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("ticket_ID", ticket_ID));
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
conn.Open();
int count = da.Fill(ds);
conn.Close();
if (count == 0)
return null;
TicketConvite returnValue = new TicketConvite();
returnValue.NomesProprio = Convert.ToString(ds.Tables[0].Rows[0]["NomesProprio"]);
returnValue.Apelidos = Convert.ToString(ds.Tables[0].Rows[0]["Apelidos"]);
returnValue.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]);
returnValue.status = Convert.IsDBNull(ds.Tables[0].Rows[0]["status"]) ? null : Convert.ToString(ds.Tables[0].Rows[0]["status"]);
returnValue.dtEnvio = Convert.IsDBNull(ds.Tables[0].Rows[0]["dtEnvio"]) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["dtEnvio"]);
returnValue.dtResposta = Convert.IsDBNull(ds.Tables[0].Rows[0]["dtResposta"]) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["dtResposta"]);
returnValue.ticket_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ticket_id"]);
returnValue.Avaliado_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["Avaliado_ID"]);
returnValue.projecto_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["projecto_ID"]);
returnValue.Estatuto = Convert.ToString(ds.Tables[0].Rows[0]["Estatuto"]);
returnValue.Empresa = Convert.IsDBNull(ds.Tables[0].Rows[0]["Empresa"]) ? null : Convert.ToString(ds.Tables[0].Rows[0]["Empresa"]);
returnValue.Funcao = Convert.IsDBNull(ds.Tables[0].Rows[0]["Funcao"]) ? null : Convert.ToString(ds.Tables[0].Rows[0]["Funcao"]);
returnValue.counter = Convert.ToInt32(ds.Tables[0].Rows[0]["counter"]);
returnValue.Genero = Convert.IsDBNull(ds.Tables[0].Rows[0]["Genero"]) ? null : Convert.ToString(ds.Tables[0].Rows[0]["Genero"]);
return returnValue;
}
protected void Page_Load(object sender, EventArgs e)
{
// language settings
if (Context.Session["Dicionario"] != null)
{
dic = (Dicionario)Context.Session["Dicionario"];
}
else
{
Response.Redirect("FO_DICERROR.aspx"); // TODO
}
getTicketList();
getProjectInfo();
setupStyle();
if (!IsPostBack)
{
mView.ActiveViewIndex = 0;
}
if (Request["TicketID"] == null)
Response.Redirect("ticketError.aspx?Error=InvalidTicket");
oConvite = TicketConvite.getTicketConvite(int.Parse(Request["TicketID"]));
theTicket = Ticket.getTicketByID(oConvite.ticket_ID, projecto.owner);
if (DateTime.Now.Date > projecto.DataFim)
Response.Redirect("ticketError.aspx?Error=Closed");
Page.Title = projecto.Nome;
if (!IsPostBack)
{
/* setup localization */
lblApelidoInput.Text = dic.getResource(152);
lblApelidos.Text = dic.getResource(152);
lblApelidosConf.Text = dic.getResource(152);
lblBigTitle.Text = dic.getResource(180);
lblConfirmacao.Text = dic.getResource(160);
lblEmail.Text = dic.getResource(153);
lblEmailConf.Text = dic.getResource(153);
lblEmailInput.Text = dic.getResource(153);
lblEmpresaInput.Text = dic.getResource(155);
lblErroConf.Text = dic.getResource(161);
lblErrorMessage.Text = dic.getResource(162);
lblFuncaoInput.Text = dic.getResource(156);
lblGeneroConf.Text = dic.getResource(154);
lblGeneroInput.Text = dic.getResource(154);
lblMensagem.Text = dic.getResource(158);
lblMensagemConf.Text = dic.getResource(158);
lblMensagemInput.Text = dic.getResource(158);
lblNomes.Text = dic.getResource(151);
lblNomesInput.Text = dic.getResource(151);
lblNomesPropriosConf.Text = dic.getResource(151);
lblNotasSobreSexo.Text = dic.getResource(157);
lblNotasSobreTextoMensagem.Text = dic.getResource(183);
lblTextoMensagem.Text = dic.getResource(158);
lblDadosIdentConvidado.Text = dic.getResource(164);
botCancel.Text = dic.getResource(2);
botCancel0.Text = dic.getResource(2);
botCancel1.Text = dic.getResource(2);
botNext.Text = dic.getResource(3);
botSend.Text = dic.getResource(163);
botconfirmar.Text = dic.getResource(173);
botEdit.Text = dic.getResource(172);
botEdit2.Text = dic.getResource(172);
DDSexo.Items.Clear();
DDSexo.Items.Add(new ListItem(dic.getResource(165), "M"));
DDSexo.Items.Add(new ListItem(dic.getResource(166), "F"));
InitDataForm();
}
ScriptManager.RegisterStartupScript(this, typeof(string), "hide", "showHide(0);", true);
MsgToSend = txtMensagem.Text;
}
public static List<TicketConvite> getTicketsConvites(int Avaliado_ID, int projecto_ID)
{
SqlConnection conn = new SqlConnection(DBHelper.ConnectionString);
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = "getTicketConviteProjecto";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("Avaliado_ID", Avaliado_ID));
command.Parameters.Add(new SqlParameter("Projecto_ID", projecto_ID));
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
List<TicketConvite> returnValue = new List<TicketConvite>() ;
TicketConvite tick;
foreach (DataRow dr in ds.Tables[0].Rows)
{
tick = new TicketConvite();
tick.NomesProprio = Convert.ToString(dr["NomesProprio"]);
tick.Apelidos = Convert.ToString(dr["Apelidos"]);
tick.email = Convert.ToString(dr["email"]);
tick.status = Convert.IsDBNull(dr["status"]) ? null : Convert.ToString(dr["status"]);
tick.dtEnvio = Convert.IsDBNull(dr["dtEnvio"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dtEnvio"]);
tick.dtResposta = Convert.IsDBNull(dr["dtResposta"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dtResposta"]);
tick.ticket_ID = Convert.ToInt32(dr["ticket_id"]);
tick.Avaliado_ID = Convert.ToInt32(dr["Avaliado_ID"]);
tick.Estatuto = Convert.ToString(dr["Estatuto"]);
tick.counter = Convert.ToInt32(dr["counter"]);
tick.Empresa = Convert.IsDBNull(dr["Empresa"]) ? null : Convert.ToString(dr["Empresa"]);
tick.Funcao = Convert.IsDBNull(dr["Funcao"]) ? null : Convert.ToString(dr["Funcao"]);
tick.Genero = Convert.IsDBNull(ds.Tables[0].Rows[0]["Genero"]) ? null : Convert.ToString(ds.Tables[0].Rows[0]["Genero"]);
returnValue.Add(tick);
}
return returnValue;
}
protected void sendMessage()
{
if (valido())
{
if (sendEmail(txtMensagem.Text))
{
theTicket.Convite = "Enviado"; // isto não é para traduzir
theTicket.updateDBTicket();
// guarda a informação sobre o convidado
TicketConvite convite = new TicketConvite(
projecto.ProjectoID,
theTicket.Proprio.PessoaID,
theTicket.ticketID,
txtNomes.Text,
txtApelidos.Text,
txtEmail.Text,
"Enviado", theTicket.Qualidade, CurrSexo);
if (txtEmpresa.Text.Trim() != "")
convite.Empresa = txtEmpresa.Text;
if (txtFuncao.Text.Trim() != "")
convite.Funcao = txtFuncao.Text;
convite.insertDBTicketConvite();
Response.Redirect("FO_DashBoard.aspx?Ticket=" + myTicket.Chave + "&Cover=False&Refresh=True");
}
else
{
Response.Redirect("genericError.aspx");
}
}
else
{
mView.ActiveViewIndex = 3;
}
}
