public bool Update(UserJoinToEventDto dto)
{
con.Open();
SqlCommand cmd = new SqlCommand("Update tblUserJoinToEvent set userID=@userID, eventID=@eventID where id=@id;", con);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = dto.Id;
cmd.Parameters.Add("@userID", SqlDbType.VarChar).Value = dto.UserID;
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = dto.EventID;
int count = cmd.ExecuteNonQuery();
con.Close();
return(count == 1);
}
public bool Create(UserJoinToEventDto dto)
{
con.Open();
SqlCommand cmd = new SqlCommand("Insert Into tblUserJoinToEvent(id,userID,eventID) VALUES(@id,@userID,@eventID);", con);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = dto.Id;
cmd.Parameters.Add("@userID", SqlDbType.VarChar).Value = dto.UserID;
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = dto.EventID;
int count = cmd.ExecuteNonQuery();
con.Close();
return(count == 1);
}
