public static Guilda UpDate(Guilda obj)
{
Guilda ObjTemp = _SelectByID(obj);
SqlConnection conexao = new SqlConnection();
SqlCommand command = new SqlCommand();
conexao.ConnectionString = BLO.Conexao.ObterStringConexao2();
StringBuilder select = new StringBuilder();
select.AppendLine("SET DATEFORMAT dmy;");
select.AppendLine("update dbo.Guilda set Nome = @Nome where ID = @ID ");
command.Parameters.Add(new SqlParameter("@Nome", System.Data.SqlDbType.VarChar));
command.Parameters["@Nome"].Value = obj.Nome;
command.Parameters.Add(new SqlParameter("@ID", System.Data.SqlDbType.BigInt));
command.Parameters["@ID"].Value = obj.Id;
command.CommandText = select.ToString();
command.CommandType = System.Data.CommandType.Text;
conexao.Open();
command.Connection = conexao;
command.ExecuteNonQuery();
conexao.Close();
conexao.Dispose();
ObjTemp.Nome = obj.Nome;
return(ObjTemp);
}
public static Guilda Insert(Guilda obj)
{
SqlConnection conexao = new SqlConnection();
SqlCommand command = new SqlCommand();
conexao.ConnectionString = BLO.Conexao.ObterStringConexao2();
StringBuilder select = new StringBuilder();
select.AppendLine("insert into dbo.Guilda (ID,Nome) ");
select.AppendLine("values (@ID, @Nome)");
command.Parameters.Add(new SqlParameter("@ID", System.Data.SqlDbType.BigInt));
command.Parameters["@ID"].Value = obj.Id;
command.Parameters.Add(new SqlParameter("@Nome", System.Data.SqlDbType.VarChar));
command.Parameters["@Nome"].Value = obj.Nome;
command.CommandText = select.ToString();
command.CommandType = System.Data.CommandType.Text;
conexao.Open();
command.Connection = conexao;
command.ExecuteNonQuery();
conexao.Close();
conexao.Dispose();
return(obj);
}
public Guilda Insert(Guilda _obj)
{
if (DAO.DAO_Guilda._SelectByID(_obj) == null)
{
return(DAO.DAO_Guilda.Insert(_obj));
}
else
{
return(DAO.DAO_Guilda.UpDate(_obj));
}
}
public static Guilda _SelectByID(Guilda obj)
{
SqlConnection conexao = new SqlConnection();
SqlCommand command = new SqlCommand();
conexao.ConnectionString = BLO.Conexao.ObterStringConexao2();
StringBuilder select = new StringBuilder();
select.AppendLine("SET DATEFORMAT dmy;");
select.AppendLine("select ID,Nome from dbo.Guilda ");
select.AppendLine("where id = @id");
command.Parameters.Add(new SqlParameter("@id", System.Data.SqlDbType.BigInt));
command.Parameters["@id"].Value = obj.Id;
command.CommandText = select.ToString();
command.CommandType = System.Data.CommandType.Text;
Guilda objGuilda = null;
conexao.Open();
command.Connection = conexao;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
objGuilda = new Guilda();
objGuilda.Id = long.Parse(reader["ID"].ToString());
objGuilda.Nome = reader["Nome"].ToString();
}
conexao.Close();
conexao.Dispose();
return(objGuilda);
}
