Help please?
namespace Telerik.Web.Examples.Upload.UsingTargetFolder
{
public partial class CriarConteudo : System.Web.UI.Page
{
string targetFolder = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void RadUploadImagem_FileExists(object sender, Telerik.Web.UI.Upload.UploadedFileEventArgs e)
{
UploadedFile imagem = e.UploadedFile;
string targetFolder = Server.MapPath(RadUploadImagem.TargetFolder);
string targetFileName = Path.Combine(targetFolder, imagem.GetNameWithoutExtension() + imagem.GetExtension());
imagem.SaveAs(targetFileName);
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn1 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["lms_bibliotecaConnectionString1"].ConnectionString);
SqlCommand cmd1 = new SqlCommand("SELECT IDTipo FROM NL_LMS_BIB_tipos WHERE NL_LMS_BIB_tipos.Tipo = @Param1", conn1);
cmd1.CommandType = CommandType.Text;
cmd1.Parameters.Add(new SqlParameter("@Param1", RadioBtnListTipo.SelectedValue));
Guid idtipo;
conn1.Open();
cmd1.ExecuteNonQuery();
SqlDataReader objDR;
objDR = cmd1.ExecuteReader();
objDR.Read();
idtipo = (Guid)objDR.GetValue(0);
conn1.Close();
cmd1.Dispose();
conn1.Dispose();
SqlConnection conn2 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["lms_bibliotecaConnectionString1"].ConnectionString);
SqlCommand cmd2 = new SqlCommand("SELECT IDTema FROM NL_LMS_BIB_temas WHERE NL_LMS_BIB_temas.Tema = @Param1", conn2);
cmd2.CommandType = CommandType.Text;
cmd2.Parameters.Add(new SqlParameter("@Param1", RadComboTemas.SelectedValue));
Guid idtema;
conn2.Open();
cmd2.ExecuteNonQuery();
SqlDataReader objDR2;
objDR2 = cmd2.ExecuteReader();
objDR2.Read();
idtema = (Guid)objDR2.GetValue(0);
conn1.Close();
cmd1.Dispose();
conn1.Dispose();
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["lms_bibliotecaConnectionString1"].ConnectionString);
string insertcmd = "INSERT INTO NL_LMS_BIB_conteudos (IDConteudo, Titulo, Resumo, Notas, IDTipo, IDTema, DataPublicacao, Imagem) VALUES (NEWID(), @titulo, @resumo, @notas, @idtipo, @idtema, @datahora, @imagem)";
SqlCommand cmd = new SqlCommand(insertcmd, conn);
cmd.Parameters.Add(new SqlParameter("@titulo", RadTxtBoxTitulo.Text));
cmd.Parameters.Add(new SqlParameter("@resumo", RadTxtBoxResumo.Text));
cmd.Parameters.Add(new SqlParameter("@idtipo", idtipo));
cmd.Parameters.Add(new SqlParameter("@idtema", idtema));
cmd.Parameters.Add(new SqlParameter("@datahora", RadDateTimePicker.SelectedDate));
cmd.Parameters.Add(new SqlParameter("@notas", RadTxtBoxNotas.Text));
cmd.Parameters.Add(new SqlParameter("@imagem", targetFolder));
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
}