public void ActualizarFileGuia(SCE_FILE_GUIA_MASIVA_BE BE)
{
try
{
using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin)))
{
cn.Open();
string sqlGuia = "SP_SCE_FILE_GUIA_MASIVA_UPD";
using (SqlCommand cmd = new SqlCommand(sqlGuia, cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_FILE", BE.ID_FILE);
cmd.Parameters.AddWithValue("@NOM_FILE", BE.NOM_FILE);
cmd.Parameters.AddWithValue("@ESTADO", BE.ESTADO);
cmd.Parameters.AddWithValue("@USER_MOD", BE.USER_MOD);
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void CargarFileGuia(string nomFile,
string Usuario)
{
try
{
BE = new SCE_FILE_GUIA_MASIVA_BE();
BE.NOM_FILE = nomFile;
BE.USER_CRE = Usuario;
DA.SCE_FILE_GUIA_MASIVA_DA DA = new DA.SCE_FILE_GUIA_MASIVA_DA(usrLogin);
DA.CargarFileGuia(BE);
}
catch (Exception ex)
{
throw ex;
}
}
public List <SCE_FILE_GUIA_MASIVA_BE> ListarFilesGuia()
{
List <SCE_FILE_GUIA_MASIVA_BE> lstBE = new List <SCE_FILE_GUIA_MASIVA_BE>();
SCE_FILE_GUIA_MASIVA_BE BE = null;
try
{
using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin)))
{
cn.Open();
string sql = "SP_SCE_FILE_GUIA_MASIVA_LISTAR";
using (SqlCommand cmd = new SqlCommand(sql, cn))
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BE = new SCE_FILE_GUIA_MASIVA_BE();
BE.ID_FILE = Convert.ToInt32(reader["ID_FILE"]);
BE.NOM_FILE = Convert.ToString(reader["NOM_FILE"]);
BE.FECHA_MOD = Convert.ToDateTime(reader["FECHA_MOD"]);
BE.USER_MOD = Convert.ToString(reader["USER_MOD"]);
BE.ESTADO = Convert.ToString(reader["ESTADO_FILE"]);
lstBE.Add(BE);
}
return(lstBE);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public SCE_FILE_GUIA_MASIVA_BE ObtenerFileGuia(int Id)
{
SCE_FILE_GUIA_MASIVA_BE BE = null;
try
{
using (SqlConnection cn = new SqlConnection(SCE_SQLCONEXION.GetCadConexion(usrLogin)))
{
cn.Open();
string sql = "SP_SCE_FILE_GUIA_MASIVA_GET";
using (SqlCommand cmd = new SqlCommand(sql, cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_FILE", Id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
BE = new SCE_FILE_GUIA_MASIVA_BE();
BE.ID_FILE = Convert.ToInt32(reader["ID_FILE"]);
BE.NOM_FILE = Convert.ToString(reader["NOM_FILE"]);
BE.FECHA_MOD = Convert.ToDateTime(reader["FECHA_MOD"]);
BE.USER_MOD = Convert.ToString(reader["USER_MOD"]);
BE.ESTADO = Convert.ToString(reader["ESTADO_FILE"]);
}
return(BE);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void ActualizarFileGuia(int IdFile,
string nomFile,
string Estado,
string Usuario,
string nomFileOrig)
{
try
{
BE = new SCE_FILE_GUIA_MASIVA_BE();
BE.ID_FILE = IdFile;
BE.NOM_FILE = nomFile;
BE.ESTADO = Estado;
BE.USER_MOD = Usuario;
DA.SCE_FILE_GUIA_MASIVA_DA DA = new DA.SCE_FILE_GUIA_MASIVA_DA(usrLogin);
//EliminarFileGuia(nomFileOrig);
DA.ActualizarFileGuia(BE);
}
catch (Exception ex)
{
throw ex;
}
}
