public bool Inserir(Regiao regiao) { _bd.Comando.Parameters.Clear(); _bd.Comando.CommandText = @"SELEXT MAX(REGIONID) AS MAX FROM REGION"; object maxCod = _bd.ExecutarComandoScalar(); if (maxCod != DBNull.Value) maxCod = Convert.ToInt32(maxCod) + 1; else maxCod = 1; _bd.Comando.CommandText = @"INSERT INTO REGION (REGIONID, REGIONDESCRIPTION) VALUES(@REGIONID, @REGIONDESCRIPTION)"; _bd.Comando.Parameters.AddWithValue("@REGIONID", regiao.Id); _bd.Comando.Parameters.AddWithValue("@REGIONDESCRIPTION", regiao.Descricao); if (_bd.ExecutarComandoNonQuery() > 0) { regiao.Id = Convert.ToInt32(maxCod); return true; } else return false; }
public bool Alterar(Regiao regiao) { _bd.Comando.Parameters.Clear(); _bd.Comando.CommandText = @"UPDATE REGION SET REGIONDESCRIPTION = @REGIONDESCRIPTION WHERE REGIONID = @REGIONID)"; _bd.Comando.Parameters.AddWithValue("@REGIONDESCRIPTION", regiao.Descricao); _bd.Comando.Parameters.AddWithValue("@REGIONID", regiao.Id); if (_bd.ExecutarComandoNonQuery() > 0) return true; else return false; }
public bool Recuperar(int id, Regiao regiao) { _bd.Comando.Parameters.Clear(); _bd.Comando.CommandText = "select REGIONID, REGIONDESCRIPTION from REGION where REGIONID = @REGIONID"; _bd.Comando.Parameters.AddWithValue("@REGIONID", id); DataTable dt = _bd.ExecutarComando(); if (dt.Rows.Count == 1) { regiao.Id = Convert.ToInt32(dt.Rows[0]["REGIONID"]); regiao.Descricao = dt.Rows[0]["REGIONDESCRIPTION"].ToString(); return true; } else return false; }
public List<Territorio> RetornarTerritorios(string descricao) { SqlServer bd = new SqlServer(); bd.Comando.CommandText = @"SELECT * FROM TERRITORIES WHERE TERRITORYDESCRIPTION LIKE @DESCR"; bd.Comando.Parameters.AddWithValue("@DESCR", descricao + "%"); DataTable dt = bd.ExecutarComando(); List<Territorio> list = new List<Territorio>(); foreach (DataRow row in dt.Rows) { Regiao r = new Regiao(Convert.ToInt32(row["REGIONID"].ToString())); Territorio t = new Territorio(Convert.ToInt32(row["TERRITORYID"]), row["TERRITORYDESCRIPTION"].ToString(), r); list.Add(t); } return list; }
public Territorio(int id, string description, Regiao regiao) { _id = id; _description = description; _regiao = regiao; }
public Territorio() { _id = 0; _description = ""; _regiao = new Regiao(); }