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