public static ContaDAO ObterInstancia()
{
if (instancia == null)
{
instancia = new ContaDAO();
}
return(instancia);
}
public static ContaDAO ObterInstancia()
{
if (instancia == null)
{
instancia = new ContaDAO();
}
return instancia;
}
public int ExcluirFabrica(int IdFabrica)
{
SqlParameter parametroSaida;
//String procNome = "sp_GerenciaFabrica";
String procNome = "DELETE FROM fabricas WHERE " + cp_IdFabrica + "=" + prm_IdFabrica + ";";
int status = 0;
status = ContaDAO.ObterInstancia().ExcluirContasPorFabrica(IdFabrica);
if (status == 1)
{
using (con = ConexaoBD.ObterConexao())
{
cmd = new SqlCommand(procNome, con);
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandType = System.Data.CommandType.Text;
//cmd.Parameters.AddWithValue("@FUNCAO", "4");
cmd.Parameters.Add(prm_IdFabrica, SqlDbType.Int).Value = IdFabrica;
//parametroSaida = new SqlParameter();
//parametroSaida.ParameterName = "@STATUS";
//parametroSaida.SqlDbType = System.Data.SqlDbType.Int;
//parametroSaida.Direction = System.Data.ParameterDirection.Output;
//cmd.Parameters.Add(parametroSaida);
try {
con.Open();
cmd.ExecuteNonQuery();
status = 1;
//status = Convert.ToInt32(parametroSaida.Value);
}
catch { status = 0; }
}
}
return(status);
}
