public int uspINS_SOLPED(BE_SOLPED oBE)
{
try
{
return(new DA_SOLPED().uspINS_SOLPED(oBE));
}
catch (Exception ex)
{
throw ex;
}
}
public int uspINS_SOLPED(BE_SOLPED oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_SOLPED, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_USUARIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FILE_SOLPED, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FILE_RUTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.COMENTARIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IPCENTRO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CODIGO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CODIGO_SI, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.SOLICITANTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.TIPO_SOLICITUD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_EMPRESA, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_SOLPED", Parametros)));
}
protected void btnviar_Click(object sender, EventArgs e)
{
string cleanMessage = string.Empty;
if (txtFecha.Text.Trim() == string.Empty)
{
cleanMessage = "Ingresar fecha de solicitud";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else if (txtCodigo.Text.Trim() == string.Empty)
{
cleanMessage = "Ingresar codigo";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else if (ddlTipo.SelectedIndex == 0)
{
cleanMessage = "Falta indicar tipo de solicitud";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else if (ddlPersonal.SelectedValue == string.Empty)
{
cleanMessage = "Falta indicar personal solicitante";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
else
{
// Si el directorio no existe, crearlo
if (!Directory.Exists(Server.MapPath(FolderSOLPED)))
{
Directory.CreateDirectory(FolderSOLPED);
}
String fileExtension = string.Empty;
Boolean fileOK = false;
string fileArchivo = string.Empty;
if (FileUpload1.HasFile)
{
string fileName = FileUpload1.FileName.ToString();
int length = FileUpload1.PostedFile.ContentLength;
fileExtension = Path.GetExtension(FileUpload1.FileName);
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg", ".pdf", ".doc", ".docx", ".xls", ".xlsx", ".ppt", ".pptx", ".txt" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension.ToUpper() == allowedExtensions[i].ToUpper())
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
// Se carga la ruta física de la carpeta temp del sitio
string ruta = Server.MapPath(FolderSOLPED);
string rutaBackups = FolderSOLPEDBackups;
// Si el directorio no existe, crearlo
if (!Directory.Exists(ruta))
{
Directory.CreateDirectory(ruta);
}
string archivo = String.Format("{0}\\{1}", ruta, FileUpload1.PostedFile.FileName);
// Verificar que el archivo no exista
if (File.Exists(archivo))
{
fileArchivo = ddlcentro.SelectedValue.ToString() + "_" + txtCodigo.Text.Trim() + "_" + DateTime.UtcNow.ToFileTimeUtc() + Path.GetExtension(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(ruta + fileArchivo);
FileUpload1.SaveAs(rutaBackups + fileArchivo);
}
else
{
fileArchivo = ddlcentro.SelectedValue.ToString() + "_" + txtCodigo.Text.Trim() + "_" + Path.GetFileName(FileUpload1.FileName);
//FileUpload1.SaveAs(archivo);
FileUpload1.SaveAs(ruta + fileArchivo);
FileUpload1.SaveAs(rutaBackups + fileArchivo);
}
BE_SOLPED oBESol = new BE_SOLPED();
oBESol.IDE_SOLPED = Convert.ToInt32(string.IsNullOrEmpty(lblCodigo.Text) ? "0" : lblCodigo.Text);
oBESol.FECHA = txtFecha.Text.Trim();
oBESol.IDE_USUARIO = Session["IDE_USUARIO"].ToString();
oBESol.FILE_SOLPED = fileArchivo;
oBESol.FILE_RUTA = FolderSOLPED;
oBESol.COMENTARIOS = txtcomentarios.Text.ToString();
oBESol.IPCENTRO = ddlcentro.SelectedValue.ToString(); //BL_Session.IP_CENTRO.ToString();
oBESol.CODIGO = txtCodigo.Text.Trim();
oBESol.CODIGO_SI = txtSI.Text.Trim();
oBESol.SOLICITANTE = ddlPersonal.SelectedValue.ToString();
oBESol.TIPO_SOLICITUD = ddlTipo.SelectedValue.ToString();
oBESol.IDE_EMPRESA = ddlEmpresa.SelectedValue.ToString();
int dtrpta = 0;
dtrpta = new BL_SOLPED().uspINS_SOLPED(oBESol);
if (dtrpta > 0)
{
Listar();
BL_SOLPED objCorreo = new BL_SOLPED();
objCorreo.SP_ENVIARCORREO_SOLPED(dtrpta, Session["IDE_USUARIO"].ToString());
cleanMessage = "Registro exitoso.";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
lblCodigo.Text = string.Empty;
txtCodigo.Text = string.Empty;
txtcomentarios.Text = string.Empty;
txtSI.Text = string.Empty;
ddlPersonal.Text = string.Empty;
//CheckSI.Checked = false;
}
else
{
cleanMessage = "Advertencia: Codigo ingresado ya se encuentra registrado.";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
}
catch (Exception ex)
{
cleanMessage = "Archivo no puedo ser cargado";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
}
else
{
cleanMessage = "Falta cargar archivo de solicitud";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
}
}
