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