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