public async Task <List <EnterpriseFTPDatos> > ListarFTP(SqlConnection cn, EnterpriseFTPDatos objEnterpriseFTP)
{
List <EnterpriseFTPDatos> lEnterprise = null;
SqlCommand cmd = new SqlCommand
{
CommandText = "SP_LST_ENTERPRISEFTP",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
cmd.Parameters.AddWithValue("@PK_Enterprise", objEnterpriseFTP.PK_Enterprise);
using (SqlDataReader dtr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult))
{
lEnterprise = new List <EnterpriseFTPDatos>();
while (await dtr.ReadAsync())
{
lEnterprise.Add(new EnterpriseFTPDatos
{
PK_ftp = Convert.ToInt32(dtr["PK_ftp"]),
PK_Enterprise = Convert.ToInt32(dtr["PK_Enterprise"]),
Name = Convert.ToString(dtr["Name"]),
Server = Convert.ToString(dtr["Server"]),
Port = Convert.ToString(dtr["Port"]),
Folder = Convert.ToString(dtr["Folder"]),
Username = Convert.ToString(dtr["Username"]),
Password = Convert.ToString(dtr["Password"])
});
}
}
return(lEnterprise);
}
//public List<Enterprise> Listar(SqlConnection Cn)
//{
// List<Enterprise> lEnterprise = null;
// SqlCommand cmd = new SqlCommand
// {
// CommandText = "uspEnterprise",
// CommandType = CommandType.StoredProcedure,
// Connection = Cn
// };
// using (SqlDataReader dtr = cmd.ExecuteReader(CommandBehavior.SingleResult))
// {
// lEnterprise = new List<Enterprise>();
// while (dtr.Read())
// {
// lEnterprise.Add(new Enterprise
// {
// PkenterPrise = !dtr.IsDBNull(dtr.GetOrdinal("PK_Enterprise")) ? dtr.GetInt32(dtr.GetOrdinal("PK_Enterprise")) : 0,
// enterPrise = !dtr.IsDBNull(dtr.GetOrdinal("Name")) ? dtr.GetString(dtr.GetOrdinal("Name")) : ""
// });
// }
// }
// return lEnterprise;
//}
public async Task <bool> GuardarFTPAsync(SqlConnection cn, EnterpriseFTPDatos objEnterpriseFTP)
{
try
{
bool resultado = false;
SqlCommand cmd = new SqlCommand
{
CommandText = "SP_INS_ENTERPRISEFTP",
CommandType = CommandType.StoredProcedure,
Connection = cn
};
SqlParameter param1 = cmd.Parameters.AddWithValue("@PK_Enterprise", objEnterpriseFTP.PK_Enterprise);
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = cmd.Parameters.AddWithValue("@Server", objEnterpriseFTP.Server == null ? "" : objEnterpriseFTP.Server);
param2.Direction = ParameterDirection.Input;
SqlParameter param3 = cmd.Parameters.AddWithValue("@Port", objEnterpriseFTP.Port == null ? "" : objEnterpriseFTP.Port);
param3.Direction = ParameterDirection.Input;
SqlParameter param4 = cmd.Parameters.AddWithValue("@Folder", objEnterpriseFTP.Folder == null ? "" : objEnterpriseFTP.Folder);
param4.Direction = ParameterDirection.Input;
SqlParameter param5 = cmd.Parameters.AddWithValue("@Username", objEnterpriseFTP.Username == null ? "" : objEnterpriseFTP.Username);
param5.Direction = ParameterDirection.Input;
SqlParameter param6 = cmd.Parameters.AddWithValue("@Password", objEnterpriseFTP.Password == null ? "" : objEnterpriseFTP.Password);
param6.Direction = ParameterDirection.Input;
int rpta = await cmd.ExecuteNonQueryAsync();
if (rpta > 0)
{
resultado = true;
}
return(resultado);
}
#pragma warning disable CS0168 // The variable 'ex' is declared but never used
catch (Exception ex) {
#pragma warning restore CS0168 // The variable 'ex' is declared but never used
return(false);
}
}