public static TipoContratoModel DetalhesContrato(int id)
{
using (SqlConnection cnn = Conexoes.ConexaoSQL())
{
SqlCommand cmd = new SqlCommand();
cnn.Open();
cmd.Connection = cnn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT " +
"c.id_tipocontrato," +
"c.string_tipocontrato " +
"FROM " +
"tipos_contrato c " +
"WHERE " +
"c.id_tipocontrato = @id";
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
TipoContratoModel _TipoContrato = new TipoContratoModel();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
_TipoContrato.TipoContratoID = Convert.ToInt32(dr["id_tipocontrato"]);
_TipoContrato.TipoContratoString = dr["string_tipocontrato"].ToString();
}
}
dr.Close();
return(_TipoContrato);
}
}
public static List <TipoContratoModel> TodosContratos()
{
List <TipoContratoModel> listSaida = new List <TipoContratoModel>();
using (SqlConnection cnn = Conexoes.ConexaoSQL())
{
SqlCommand cmd = new SqlCommand();
cnn.Open();
cmd.Connection = cnn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select c.id_tipocontrato, c.string_tipocontrato FROM tipos_contrato c";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
TipoContratoModel _Contrato = new TipoContratoModel();
_Contrato.TipoContratoID = Convert.ToInt32(dr["id_tipocontrato"]);
_Contrato.TipoContratoString = dr["string_tipocontrato"].ToString();
listSaida.Add(_Contrato);
}
}
return(listSaida);
}
}
public static bool CadastrarContrato(TipoContratoModel _TipoContrato)
{
using (SqlConnection cnn = Conexoes.ConexaoSQL())
{
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO " +
"tipos_contrato" +
"(" +
"string_tipocontrato" +
")" +
"VALUES " +
"(" +
"@string_tipocontrato" +
") " +
"SELECT SCOPE_IDENTITY() AS ID";
cmd.Parameters.Add("@string_tipocontrato", SqlDbType.VarChar).Value = _TipoContrato.TipoContratoString;
try
{
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
