protected void Guardar()
{
string cleanMessage = string.Empty;
BE_SOL_ANDAMIOS oBESol = new BE_SOL_ANDAMIOS();
oBESol.IDE_ANDAMIOS = Convert.ToInt32(string.IsNullOrEmpty(lblCodigo.Text) ? "0" : lblCodigo.Text);
oBESol.USUARIO_ATENCION = Session["IDE_USUARIO"].ToString();
oBESol.SUPERVIDOR_DNI = ddlSupervisor.SelectedValue.ToString();
oBESol.SUPERVIDOR = ddlSupervisor.SelectedItem.ToString();
oBESol.CAPATAZ_DNI = ddlCapataz.SelectedValue.ToString();
oBESol.CAPATAZ = ddlCapataz.SelectedItem.ToString();
oBESol.DURACION = Convert.ToInt32(string.IsNullOrEmpty(txtDuracion.Text) ? "0" : txtDuracion.Text);
oBESol.HORAS = Convert.ToDecimal(string.IsNullOrEmpty(txtHoras.Text) ? "0" : txtHoras.Text);
oBESol.FECHA_ENTREGA = txtFecEntrega.Text.ToString();
oBESol.FECHA_TERMINO = txtTermino.Text.ToString();
oBESol.FECHA_DESMONTAJE = txtDesmontaje.Text.ToString();
oBESol.OBSERVACIONES = txtObservacion.Text;
oBESol.ESTADO = Convert.ToInt32(ddlEstados.SelectedValue.ToString());
int dtrpta = 0;
dtrpta = new BL_SOL_ANDAMIOS().uspUPD_SOL_ANDAMIOS(oBESol);
if (dtrpta > 0)
{
int estado = Convert.ToInt32(ddlEstados.SelectedValue.ToString());
if (estado == 4 || estado == 5)
{
BL_SOL_ANDAMIOS objCorreo = new BL_SOL_ANDAMIOS();
objCorreo.SP_ENVIARCORREO_SOL_ANDAMIOS_RPTA(Convert.ToInt32(lblCodigo.Text));
}
Listar();
cleanMessage = "Registro exitoso.";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
}
public int uspUPD_SOL_ANDAMIOS(BE_SOL_ANDAMIOS oBE)
{
try
{
return(new DA_SOL_ANDAMIOS().uspUPD_SOL_ANDAMIOS(oBE));
}
catch (Exception ex)
{
throw ex;
}
}
public int uspUPD_SOL_ANDAMIOS(BE_SOL_ANDAMIOS oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_ANDAMIOS, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.USUARIO_ATENCION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.SUPERVIDOR_DNI, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.SUPERVIDOR, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CAPATAZ_DNI, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.CAPATAZ, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.DURACION, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.HORAS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA_ENTREGA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA_TERMINO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA_DESMONTAJE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.OBSERVACIONES, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.ESTADO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspUPD_SOL_ANDAMIOS", Parametros)));
}
public int uspINS_SOL_ANDAMIOS(BE_SOL_ANDAMIOS oBE)
{
object[] Parametros = new[] {
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_ANDAMIOS, tgSQLFieldType.NUMERIC),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.ANDAMIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IDE_USUARIO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.SOLICITANTE, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FILE_ANDAMIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FILE_RUTA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.COMENTARIOS, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.ESPECIALIDAD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.AREA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.SOLICITUD, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.TIPO, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.FECHA_REQUERIDA, tgSQLFieldType.TEXT),
(object)UC_FormWeb.mSQLFieldOrNull(oBE.IPCENTRO, tgSQLFieldType.TEXT),
};
return(Convert.ToInt32(new Utilitarios().ExecuteScalar("uspINS_SOL_ANDAMIOS", Parametros)));
}
protected void btnviar_Click(object sender, EventArgs e)
{
string cleanMessage = string.Empty;
CECOS_GESTOR = Request.QueryString["CECOS_GESTOR"].ToString();
if (txtrequerida.Text.Trim() == string.Empty)
{
cleanMessage = "Ingresar fecha de requerimiento";
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(FolderANDAMIOS)))
{
Directory.CreateDirectory(FolderANDAMIOS);
}
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 == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
// Se carga la ruta física de la carpeta temp del sitio
string ruta = Server.MapPath(FolderANDAMIOS);
// 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 = "AND_" + CECOS_GESTOR + "_" + DateTime.UtcNow.ToFileTimeUtc() + Path.GetExtension(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(ruta + fileArchivo);
}
else
{
fileArchivo = "AND_" + CECOS_GESTOR + "_" + Path.GetFileName(FileUpload1.FileName);
//FileUpload1.SaveAs(archivo);
FileUpload1.SaveAs(ruta + fileArchivo);
}
}
catch (Exception ex)
{
cleanMessage = "Archivo no puedo ser cargado";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
}
BE_SOL_ANDAMIOS oBESol = new BE_SOL_ANDAMIOS();
oBESol.IDE_ANDAMIOS = Convert.ToInt32(string.IsNullOrEmpty(lblCodigo.Text) ? "0" : lblCodigo.Text);
oBESol.ANDAMIOS = txtCodAndamio.Text.Trim();
oBESol.FECHA = string.Empty;
oBESol.IDE_USUARIO = Session["IDE_USUARIO"].ToString();
oBESol.SOLICITANTE = ddlPersonal.SelectedValue.ToString();
oBESol.FILE_ANDAMIOS = fileArchivo;
oBESol.FILE_RUTA = FolderANDAMIOS;
oBESol.COMENTARIOS = txtcomentarios.Text.ToString();
oBESol.ESPECIALIDAD = ddlespecialidad.SelectedValue;
oBESol.AREA = ddlarea.SelectedValue;
oBESol.SOLICITUD = ddlSolicitud.SelectedValue;
oBESol.TIPO = ddlTipo.SelectedValue;
oBESol.FECHA_REQUERIDA = txtrequerida.Text;
oBESol.IPCENTRO = CECOS_GESTOR; //BL_Session.IP_CENTRO.ToString();
int dtrpta = 0;
dtrpta = new BL_SOL_ANDAMIOS().uspINS_SOL_ANDAMIOS(oBESol);
if (dtrpta > 0)
{
cleanMessage = "Registro exitoso.";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", "doAlert('" + cleanMessage + "');", true);
}
}
}
